MODIFY_BK_PSA_REFSΒΆ

Modify specified GPR-BK PSA Refs record.

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

Parameter Name

Properties

Default Value

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

p_psa_master_col_name

(NN)

Name of the corresponding PSA master column

Example

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