ADD_APP_ACT_MAT

Add an action which materializes a group of views in a single transaction

Parameter Name	Required	Description
p_app_name	yes	Name of the application
p_action_name	yes	Name of the action
p_description	no	Description of the action
p_finished_type	yes	Status triggering the action (LOADED, PRELIM, FINAL)
p_mat_group	yes	Name of the materialization group
p_valid_from_bdate	yes	Action’s initial execution date
p_active	yes	Action execution condition (true/false)
p_run_once	yes	Execute action only once per day? (true/false)
p_run_delay	yes	Delay time after condition met (seconds)
p_bdate_retention	yes	Trigger period for application actions in number of days into the past
p_cal_name	no	Calendar name to check schedule for action run - referrencing RED_CALENDAR_DEFINITIONS
p_cal_key	no	Calendar key to check schedule for action run - referrencing RED_CALENDAR_KEYS
p_bdate_retention_future	yes	Trigger period for application actions in number of days into the past

Example

EXECUTE SCRIPT api_redadm.add_app_act_mat
            ( 'XXX'         -- p_app_name
            , 'XXX'         -- p_action_name
            , 'XXX'         -- p_description
            , 'LOADED'      -- p_finished_type
            , 'XXX'         -- p_mat_group
            , '2025-01-01'  -- p_valid_from_bdate
            , TRUE          -- p_active
            , TRUE          -- p_run_once
            , 60            -- p_run_delay
            , 10            -- p_bdate_retention
            , 'AT'          -- p_cal_name
            , 'BD'          -- p_cal_key
            , 0             -- p_bdate_retention_future
            );