MODIFY_APP_ACT_EXP_SFTP

Modify an action which sends a file via sFTP

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_sftp_name	yes	SFTP name (must exist in APP_ACT_EXP_SFTP)
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.modify_app_act_exp_sftp
            ( 'XXX'                  -- p_app_name
            , 'XXX'                  -- p_action_name
            , 'XXX'                  -- p_description
            , 'LOADED'               -- p_finished_type
            , 'XXX'                  -- p_exp_name
            , 'XXX'                  -- p_sftp_name
            , '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
            );