aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_check_charge_schedule
Parameters
Name
Type
Mode
register_id
integer
IN
Definition
DECLARE system_date date = fn_system_date(); BEGIN IF EXISTS(SELECT * FROM sp_get_charge_schedule(register_id => $1, posted => false) WHERE charge_date = system_date) THEN PERFORM sp_raise_error('20302', 'Charge schedule not posted.'); END IF; END;