ADD_CDCG_CLEARANCE_SETTINGΒΆ

Add CDCG clearance setting for manual triggers.

Parameter Name

Required

DefaultValue

Description

p_cdc_group

yes

name of CDC group

p_bdomain

yes

bdomain of CDC group

p_requestor_id

yes

requestor ID (e.g. Email address)

p_requestor_description

no

requestor description

p_bdate_offset

yes

offset for BDATE validation (null for no restriction)

p_cal_name

yes

calendar name for BDATE validation (null for no restriction)

p_cal_key

yes

calendar key for BDATE validation (null for no restriction)

Example

EXECUTE SCRIPT api_dbiadm.add_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
            );