index

Package gb_cm_user_procedure_rules

This package provides support subprograms for Common Matching User Procedure (CM_USER_PROCEDURE)
 
The validation procedure is called by the API, but may be called directly by an application if data validation is needed prior to calling the API.
The API will always run the validation checks regardless.

Program units
p_register_entity   Registers the attribute value pairs to the message cache for delete operations.
p_register_entity   Register the attribute/value pairs to the message cache for create and update operations.
p_validate   Validates all the data in the record The following edits are performed.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Registers the attribute value pairs to the message cache for delete operations.
This procedure passes the operation type and a set of constant strings and data values to the messaging system. The constants represent the name of each data element and are defined in the DML package specification.
The procedure is overloaded so the API p_delete has a signature to call that only requires operation and ROWID.
This signature uses the ROWID only, for the delete operations.

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_internal_record_id   Database ROWID

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_cmsc_code          gorcmup.gorcmup_cmsc_code%TYPE,
                            p_priority_no        gorcmup.gorcmup_priority_no%TYPE,
                            p_seq_no             gorcmup.gorcmup_seq_no%TYPE,
                            p_procedure_name     gorcmup.gorcmup_procedure_name%TYPE,
                            p_user_id            gorcmup.gorcmup_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        gorcmup.gorcmup_data_origin%TYPE,
                            p_internal_record_id VARCHAR2)

Register the attribute/value pairs to the message cache for create and update operations.
This signature registers the all parameters for the create and update operations

Parameters
p_operation_type   Type of DML operation: create,update,delete. NUMBER Required
p_cmsc_code   Common Matching Source Code associated with user procedure.
p_priority_no   Priority number associated with the user procedure.
p_seq_no   The order in which to execute the user procedure.
p_procedure_name   Procedure name assicated with rules to be used for Common Matching.
p_user_id   Oracle user ID of the User who created or last updated the record.
p_data_origin   Application source for this database row.
p_internal_record_id   Database ROWID

p_validate 

PROCEDURE p_validate(p_cmsc_code      gorcmup.gorcmup_cmsc_code%TYPE,
                     p_priority_no    gorcmup.gorcmup_priority_no%TYPE,
                     p_seq_no         gorcmup.gorcmup_seq_no%TYPE,
                     p_procedure_name gorcmup.gorcmup_procedure_name%TYPE,
                     p_user_id        gorcmup.gorcmup_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin    gorcmup.gorcmup_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record The following edits are performed. All failed edit messages are appended and issued in a single application exception.


Parameters
p_cmsc_code   Common Matching Source Code associated with user procedure.
p_priority_no   Priority number associated with the user procedure.
p_seq_no   The order in which to execute the user procedure.
p_procedure_name   Procedure name associated with rules to be used for Common Matching.
p_user_id   Oracle user ID of the User who created or last updated the record.
p_data_origin   Application source for this database row.