aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_endday_export_register_cards
Parameters
Name
Type
Mode
user_name
text
IN
status
text
INOUT
msg
text
INOUT
Definition
DECLARE v_report_date date := public.fn_system_date(); v_enabled boolean; BEGIN v_enabled := lower(COALESCE( public.fn_prop_config('ENDDAY_EXPORT_REGISTER_CARD_ENABLED', 'false'), 'false' )) IN ('true', 't', '1', 'yes', 'on'); IF NOT v_enabled THEN status := 'success'; msg := 'Register card export is disabled'; RETURN; END IF; CALL public.sp_export_register_cards(v_report_date, user_name, status, msg); END