ADD_TSA_LOAD_CYCLE

Add RED_TSA_LOAD_CYCLES Record

Parameter Name	Required	Description
p_tsa_schema	yes	Schema name of the table in TSA layer
p_tsa_table	yes	Table name in the TSA layer
p_load_cycle_cal_name	yes	Name of the calendar
p_load_cycle_cal_key	yes	Calendar key for this calendar
p_load_cycle_from	yes	Begin of calendar validity period
p_load_cycle_to	yes	End of calendar validity period
p_delivery_offset	no	Delivery offset in days
p_alert_1_offset	no	Alert 1 offset in hours
p_alert_2_offset	no	Alert 2 offset in hours

Example

EXECUTE SCRIPT api_redadm.add_tsa_load_cycle
            ( 'XXX'         -- p_tsa_schema
            , 0             -- p_tsa_table
            , 'XXX'         -- p_load_cycle_cal_name
            , 'XXX'         -- p_load_cycle_cal_key
            , '2025-10-01'  -- p_load_cycle_from
            , '9999-12-31'  -- p_load_cycle_to
            , 1             -- p_delivery_offset
            , 2             -- p_alert_1_offset
            , 4             -- p_alert_2_offset
            );