ADD_APP_ACT_EXP_MAIL

Add an action which exports a file via mail

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_exp_name	yes	Export name (must exist in APP_ACT_EXPORTS)
p_mail_template	yes	Mail template (must exist in ADM_MAIL_PARAMS)
p_recipients	yes	Mail recipients
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

Example

EXECUTE SCRIPT api_redadm.add_app_act_exp_mail
            ( 'XXX'                  -- p_app_name
            , 'XXX'                  -- p_action_name
            , 'XXX'                  -- p_description
            , 'LOADED'               -- p_finished_type
            , 'XXX'                  -- p_exp_name
            , 'XXX'                  -- p_mail_template
            , 'XXX'                  -- p_recipients
            , '2025-01-01'           -- p_valid_from_bdate
            , TRUE                   -- p_active
            , TRUE                   -- p_run_once
            , 60                     -- p_run_delay
            , 10                     -- p_bdate_retention
            );