Package gb_np_name_trans

Package gb_np_name_trans_rules

Provides the messaging support and field validation for NP_NAME_TRANS.

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	Register the attribute value pairs to the message cache.
p_register_entity	Register the attribute/value pairs to the message cache.
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)

Register the attribute value pairs to the message cache.
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_name               gornpnm.gornpnm_name%TYPE,
                            p_alias              gornpnm.gornpnm_alias%TYPE,
                            p_user_id            gornpnm.gornpnm_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        gornpnm.gornpnm_data_origin%TYPE,
                            p_internal_record_id VARCHAR2)

Parameters

	p_name	Given name of non-person. VARCHAR2(60) Required Key
	p_alias	Alias or nickname associated with name. VARCHAR2(60) Required Key
	p_user_id	User ID of the User who created or last updated the record. VARCHAR2(30) Required
	p_data_origin	Source system that created or updated the data. VARCHAR2(30)
	p_internal_record_id	Database ROWID

p_validate

PROCEDURE p_validate(p_name        gornpnm.gornpnm_name%TYPE,
                     p_alias       gornpnm.gornpnm_alias%TYPE,
                     p_user_id     gornpnm.gornpnm_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin gornpnm.gornpnm_data_origin%TYPE DEFAULT NULL)

Validates all the data in the record.
This signature uses all fields for the create operation

The following edits are performed. All failed edit messages are appended and issued in a single application exception.

p_name cannot be null.
p_alias cannot be null.

Parameters

	p_name	Given name of non-person. VARCHAR2(60) Required Key
	p_alias	Alias or nickname associated with name. VARCHAR2(60) Required Key
	p_user_id	User ID of the User who created or last updated the record. VARCHAR2(30) Required
	p_data_origin	Source system that created or updated the data. VARCHAR2(30)