Package gb_cm_data_dictionary

Package gb_cm_data_dictionary_rules

This package provides support subprograms for the Common Matching Data Dictionary CM_DATA_DICTIONARY

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
p_validate	Validates all the data in the record

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_table                gorcmdd.gorcmdd_table%TYPE,
                            p_column_name          gorcmdd.gorcmdd_column_name%TYPE,
                            p_element              gorcmdd.gorcmdd_element%TYPE,
                            p_max_length           gorcmdd.gorcmdd_max_length%TYPE,
                            p_override_length_ind  gorcmdd.gorcmdd_override_length_ind%TYPE,
                            p_allow_neg_length_ind gorcmdd.gorcmdd_allow_neg_length_ind%TYPE,
                            p_online_match_ind     gorcmdd.gorcmdd_online_match_ind%TYPE,
                            p_sys_req_ind          gorcmdd.gorcmdd_sys_req_ind%TYPE,
                            p_element_req_ind      gorcmdd.gorcmdd_element_req_ind%TYPE,
                            p_user_id              gorcmdd.gorcmdd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin          gorcmdd.gorcmdd_data_origin%TYPE,
                            p_internal_record_id   VARCHAR2)

p_validate

PROCEDURE p_validate(p_table                gorcmdd.gorcmdd_table%TYPE,
                     p_column_name          gorcmdd.gorcmdd_column_name%TYPE,
                     p_element              gorcmdd.gorcmdd_element%TYPE,
                     p_max_length           gorcmdd.gorcmdd_max_length%TYPE,
                     p_override_length_ind  gorcmdd.gorcmdd_override_length_ind%TYPE,
                     p_allow_neg_length_ind gorcmdd.gorcmdd_allow_neg_length_ind%TYPE,
                     p_online_match_ind     gorcmdd.gorcmdd_online_match_ind%TYPE,
                     p_sys_req_ind          gorcmdd.gorcmdd_sys_req_ind%TYPE,
                     p_element_req_ind      gorcmdd.gorcmdd_element_req_ind%TYPE,
                     p_user_id              gorcmdd.gorcmdd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin          gorcmdd.gorcmdd_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_table, p_column_name, p_element, p_max_length, p_override_length_ind p_allow_neg_length_ind, p_online_match_ind, p_sys_req_ind, p_element_req_ind, p_user_id cannot be null.
p_max_length must be between 1 and 999
p_override_length_ind, p_allow_neg_length_ind, p_online_match_ind, p_sys_req_ind,p_element_req_ind must be either 'N' or 'Y'

Parameters

p_table

Database table associated with column name and element.

p_column_name

Column name associated with element to be used by Common Matching Rules.

p_element

Element to be used by Common Matching Rules.

p_max_length

Maximum length of data for associated element.

p_override_length_ind

Indicator will denote whether to allow update to the number of characters being used in matching.

p_allow_neg_length_ind

Negative length indicator.

	Y	Allows a negative length to be used for this data element, causing the character string to be compared for length specified starting from the last character.
	N	Disallow negative length.

p_online_match_ind

Online match indicator

	Y	Element is available for online Common Matching.
	N	Element is not available for online Common Matching.

p_sys_req_ind

System required indicator

	Y	Element is required data that was delivered by SCT and should not be removed or changed.
	N	Element may be modified or removed.

p_element_req_ind

Element required indicator.

	Y	Element is required data for all Common Matching rules.
	N	Element is not required data for all Common Matching rules.

p_user_id

User ID of the User who created or last updated the record.

p_data_origin

Application source for this database row.