Package gb_cm_rules

Package gb_cm_rules_rules

This function is obsolete.
Determines if a parent record exists for the current entity

Program units

f_parent_exists
p_register_entity	Registers the attribute/value pairs to the message cache for delete operations.
p_register_entity	Registers the attribute/value pairs to the message cache for create and update operations.
p_validate	Validates all the data in the record

f_parent_exists

FUNCTION f_parent_exists(p_cmsc_code   gorcmsr.gorcmsr_cmsc_code%TYPE,
                         p_priority_no gorcmsr.gorcmsr_priority_no%TYPE)
  RETURN VARCHAR2

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,upate,delete. NUMBER Required
	p_internal_record_id	Database ROWID

p_register_entity

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_cmsc_code          gorcmsr.gorcmsr_cmsc_code%TYPE,
                            p_priority_no        gorcmsr.gorcmsr_priority_no%TYPE,
                            p_column_name        gorcmsr.gorcmsr_column_name%TYPE,
                            p_length             gorcmsr.gorcmsr_length%TYPE,
                            p_data_req_ind       gorcmsr.gorcmsr_data_req_ind%TYPE,
                            p_user_id            gorcmsr.gorcmsr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        gorcmsr.gorcmsr_data_origin%TYPE,
                            p_internal_record_id VARCHAR2)

Registers 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,upate,delete. NUMBER Required

p_cmsc_code

Common Matching Source Code associated with rules.

p_priority_no

Priority number of rule to be processed.

p_column_name

Database column name associated with element used for Common Matching process.

p_length

Number of characters that will be matched in Common Matching process.

p_data_req_ind

Data required indicator.

	R	Indicates this element is required both in database and from input source.
	Y	Indicates data may be null either in database of from input source.

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    gorcmsr.gorcmsr_cmsc_code%TYPE,
                     p_priority_no  gorcmsr.gorcmsr_priority_no%TYPE,
                     p_column_name  gorcmsr.gorcmsr_column_name%TYPE,
                     p_length       gorcmsr.gorcmsr_length%TYPE,
                     p_data_req_ind gorcmsr.gorcmsr_data_req_ind%TYPE,
                     p_user_id      gorcmsr.gorcmsr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin  gorcmsr.gorcmsr_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.

p_cmsc_code, p_priority_no must exist in gorcmsp
p_column_name must exist in gorcmdd
p_cmsc_code, p_priority_no, p_column_name, p_length, p_data_req_ind, p_user_id cannot be null.
p_data_req_ind must be 'R' or 'Y'
p_priority_no must be between 1 and 99
p_cmsc_code must exist in gtvcmsc
for p_column_name if gorcmdd_allow_neg_length_ind = 'N', p_length must be > 0
for p_column_name if gorcmdd_override_length_ind = 'N', p_length must be <= gorcmdd_max_length
p_length must not equal 0
gorcmdd_online_match_ind must equal 'Y' for p_column_name, p_cmsc_code combination

Parameters

p_cmsc_code

Common Matching Source Code associated with rules.

p_priority_no

Priority number of rule to be processed.

p_column_name

Database column name associated with element used for Common Matching process.

p_length

Number of characters that will be matched in Common Matching process.

p_data_req_ind

Data required indicator.

	R	Indicates this element is required both in database and from input source.
	Y	Indicates data may be null either in database of from input source.

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.