MODIFY_CDCG_CLEARANCE_SETTING¶

Modify specified CDCG Clearance Setting record.

Table: DBIADM.DBI_CDCG_CLEARANCE_SETTINGS (settings for manual DBI loader triggers (e.g. via e-mail))

Parameter Name	Properties	Parameter Description
p_cdc_group	(PK)(NN)	CDC group name
p_bdomain	(PK)(NN)	CDC group BDOMAIN
p_requestor_id	(PK)(NN)	requestor ID (e.g. e-mail adress)
p_requestor_description		requestor description
p_bdate_offset		maximum offset between BDate and sysdate in days for validation of the BDate provided
p_cal_name		calender name to validate BDATE
p_cal_key		calendar key to validate BDATE (must match the key)

Example

EXECUTE SCRIPT api_dbiadm.modify_cdcg_clearance_setting
            ( 'XXX'      -- p_cdc_group
            , 'XXX'      -- p_bdomain
            , 'XXX'      -- p_requestor_id
            , 'XXX'      -- p_requestor_description
            , 0          -- p_bdate_offset
            , 'XXX'      -- p_cal_name
            , 'XXX'      -- p_cal_key
            );