Package gb_identification

Package gb_identification_rules

Provides the messaging support and field validation for the IDENTIFICATION API (gb_identification).

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.
p_register_entity	Registers 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 gb_common.internal_record_id_type)

Registers 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 the operation and ROWID.
This signature uses the ROWID only for the delete operations.

Parameters

	p_operation_type	Type of DML operation; create, update, or delete. NUMBER Required
	p_internal_record_id	Database ROWID.

p_register_entity

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_id                 spriden.spriden_id%TYPE,
                            p_last_name          spriden.spriden_last_name%TYPE,
                            p_first_name         spriden.spriden_first_name%TYPE,
                            p_mi                 spriden.spriden_mi%TYPE,
                            p_change_ind         spriden.spriden_change_ind%TYPE,
                            p_entity_ind         spriden.spriden_entity_ind%TYPE,
                            p_user               spriden.spriden_user%TYPE DEFAULT gb_common.f_sct_user,
                            p_origin             spriden.spriden_origin%TYPE,
                            p_ntyp_code          spriden.spriden_ntyp_code%TYPE,
                            p_pidm               spriden.spriden_pidm%TYPE,
                            p_data_origin        spriden.spriden_data_origin%TYPE,
                            p_surname_prefix     spriden.spriden_surname_prefix%TYPE,
                            p_internal_record_id gb_common.internal_record_id_type)

Registers the attribute value pairs to the message cache.
This signature uses all fields for the create and update operations

Parameters

p_operation_type

Type of DML operation; create, update, or delete. NUMBER Required

p_id

Identification number used to access the person on-line. VARCHAR2(9) Required Key

p_last_name

Last name of the person. VARCHAR2(60) Required Key

p_first_name

First name of the person. VARCHAR2(15) Key

p_mi

Middle initial of the person. VARCHAR2(15) Key

p_change_ind

The type of change made to the record. VARCHAR2(1) Required Key

	NULL	Current record
	I	ID change
	N	Name change

p_entity_ind

Entity Indicator. VARCHAR2(1)

	P	Person
	C	Non-Person

p_user

The ID for the user that most recently updated the record. VARCHAR2(30)

p_origin

The name of the Banner Object that was used most recently to update the row in the spriden table. VARCHAR2(30)

p_ntyp_code

Name type. VARCHAR2(4) Key

p_pidm

Internal identification number of the person. NUMBER(8) Required Key

p_data_origin

Source system that generated the data. VARCHAR2(30)

p_surname_prefix

Last Name prefix, such as 'von' or 'di'. VARCHAR2(60)

p_internal_record_id

Database ROWID.

p_validate

PROCEDURE p_validate(p_id             spriden.spriden_id%TYPE,
                     p_last_name      spriden.spriden_last_name%TYPE,
                     p_first_name     spriden.spriden_first_name%TYPE,
                     p_change_ind     spriden.spriden_change_ind%TYPE,
                     p_entity_ind     spriden.spriden_entity_ind%TYPE,
                     p_ntyp_code      spriden.spriden_ntyp_code%TYPE,
                     p_surname_prefix spriden.spriden_surname_prefix%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_id,p_last_name, p_entity_ind cannot be null.
p_pidm must be a positive integer.
If p_entity = 'P' then first name cannot be null.
If p_entity = 'C' then first must be null.
p_ntyp_code must exist in gtvntyp.
p_change_ind must be NULL, 'I' or 'N'.
p_entity_ind must be NULL, 'P' or 'C'.

Parameters

p_pidm

Internal identification number of the person. NUMBER(8) Required

p_id

Identification number used to access the person on-line. VARCHAR2(9) Required Key

p_last_name

Last name of the person. VARCHAR2(60) Required Key

p_first_name

First name of the person. VARCHAR2(15) Key

p_change_ind

The type of change made to the record. VARCHAR2(1) Key

	NULL	Current record
	I	ID change
	N	Name change

p_entity_ind

Entity Indicator. VARCHAR2(1)

	P	Person
	C	Non-Person

p_ntyp_code

Type associated with a person's name. VARCHAR2(4) Key