REMOVE_BK_PSA_REFSΒΆ

Remove specified GPR-BK PSA Refs record(s).

Table: REDGPR.GPR_BK_PSA_REFS (This table maps business keys to PSA master columns)

Parameter Name

Properties

Parameter Description

p_gpr_config_id

(PK)(NN)

Foreign key to the GPR_CONFIG table

p_bk_schema_name

(PK)(NN)

Name of the schema where the business key table is stored

p_bk_table_name

(PK)(NN)

Name of the business key table

p_bk_join_column

(PK)(NN)

Name of the business key column

Example

EXECUTE SCRIPT api_redgpr.remove_bk_psa_refs
            ( 0                 -- p_gpr_config_id
            , 'XXX'             -- p_bk_schema_name
            , 'XXX'             -- p_bk_table_name
            , 'XXX'             -- p_bk_join_column
            );