aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_check_endday_process
Parameters
Name
Type
Mode
Definition
BEGIN --IF EXISTS(select * from endday where endday_date = fn_system_date() and status = 'P') THEN IF fn_sys_param('ENDDAY_RUNNING', FALSE) AND fn_get_session('ENDDAY_USER') IS NULL THEN RAISE EXCEPTION SQLSTATE '99999' USING detail = fn_result_error('90001', 'End-day process in progress'); END IF; END;