REMOVE_GPR_PSA_REFSΒΆ

Remove specified GPR-PSAGPR-Join record(s).

Table: REDGPR.GPR_GPR_PSA_REFS (This table maps PSA and GPR table, if GPR data is not a fix value, but used from GPR table)

Parameter Name

Properties

Parameter Description

p_gpr_config_id

(PK)(NN)

Foreign key to the GPR_CONFIG table

p_psa_table_id

(PK)(NN)

Reference to the GPR_PSA_TABLES

p_gpr_table_id

(PK)(NN)

Reference to the GPR_GPR_TABLES

p_psa_join_column

(PK)(NN)

Name of the join column in PSA object

Example

EXECUTE SCRIPT api_redgpr.remove_gpr_psa_refs
            ( 0          -- p_gpr_config_id
            , 0          -- p_psa_table_id
            , 0          -- p_gpr_table_id
            , 'XXX'      -- p_psa_join_column
            );