|
Package gp_geniden_rules Support subprograms for the GENIDEN (gp_geniden). |
| Program units |
| p_register_entity | Register 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 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)
Register the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only, for delete operations.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER,
p_gidm geniden.geniden_gidm%TYPE,
p_syst_code geniden.geniden_syst_code%TYPE,
p_entity_code geniden.geniden_entity_code%TYPE,
p_id geniden.geniden_id%TYPE,
p_last_name geniden.geniden_last_name%TYPE,
p_first_name geniden.geniden_first_name%TYPE,
p_mi geniden.geniden_mi%TYPE,
p_house_number geniden.geniden_house_number%TYPE,
p_street_line1 geniden.geniden_street_line1%TYPE,
p_street_line2 geniden.geniden_street_line2%TYPE,
p_street_line3 geniden.geniden_street_line3%TYPE,
p_street_line4 geniden.geniden_street_line4%TYPE,
p_city geniden.geniden_city%TYPE,
p_stat_code geniden.geniden_stat_code%TYPE,
p_zip geniden.geniden_zip%TYPE,
p_natn_code geniden.geniden_natn_code%TYPE,
p_phone_area geniden.geniden_phone_area%TYPE,
p_phone_number geniden.geniden_phone_number%TYPE,
p_phone_ext geniden.geniden_phone_ext%TYPE,
p_ctry_code_phone geniden.geniden_ctry_code_phone%TYPE,
p_ssn geniden.geniden_ssn%TYPE,
p_birth_date geniden.geniden_birth_date%TYPE,
p_sex geniden.geniden_sex%TYPE,
p_email_address geniden.geniden_email_address%TYPE,
p_atyp_code geniden.geniden_atyp_code%TYPE,
p_tele_code geniden.geniden_tele_code%TYPE,
p_emal_code geniden.geniden_emal_code%TYPE,
p_asrc_code geniden.geniden_asrc_code%TYPE,
p_surname_prefix geniden.geniden_surname_prefix%TYPE,
p_pidm geniden.geniden_pidm%TYPE,
p_match_status geniden.geniden_match_status%TYPE,
p_match_date geniden.geniden_match_date%TYPE,
p_load_status geniden.geniden_load_status%TYPE,
p_load_date geniden.geniden_load_date%TYPE,
p_user_id geniden.geniden_user_id%TYPE,
p_name_prefix geniden.geniden_name_prefix%TYPE,
p_name_suffix geniden.geniden_name_suffix%TYPE,
p_pref_first_name geniden.geniden_pref_first_name%TYPE,
p_cnty_code geniden.geniden_cnty_code%TYPE,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers all parameters.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_gidm |
Unique ID of General Matching Person. NUMBER(8) Required Key | |
| p_syst_code |
Specifies what system will be using this person (e.g. Web4Proxy). VARCHAR2(30) Required | |
| p_entity_code |
Identifies whether record is person or non-person to be created. Valid values P = person, C = non-person. VARCHAR2(1) Required | |
| p_id |
Identification number used to access person on-line. VARCHAR2(9) Required | |
| p_last_name |
Last name of person. VARCHAR2(60) | |
| p_first_name |
First name of person. VARCHAR2(60) | |
| p_mi |
Middle name of person. VARCHAR2(60) | |
| p_house_number |
Building or lot number on a street or in an area. VARCHAR2(10) | |
| p_street_line1 |
First line of the address associated with the person. VARCHAR2(75) | |
| p_street_line2 |
Second line of the address associated with the person. VARCHAR2(75) | |
| p_street_line3 |
Third line of the address associated with the person. VARCHAR2(75) | |
| p_street_line4 |
Fourth line of the address associated with the person. VARCHAR2(75) | |
| p_city |
City associated with the address of the person. VARCHAR2(50) | |
| p_stat_code |
State associated with the address of the person. VARCHAR2(3) | |
| p_zip |
Postal code associated with the address of the person. VARCHAR2(30) | |
| p_natn_code |
Nation/country associated with the address of the person. VARCHAR2(5) | |
| p_phone_area |
Telephone number area code. VARCHAR2(6) | |
| p_phone_number |
Telephone number. VARCHAR2(12) | |
| p_phone_ext |
Telephone number extension. VARCHAR2(10) | |
| p_ctry_code_phone |
Telephone code that designates the region and country. VARCHAR2(4) | |
| p_ssn |
National ID number of the person. VARCHAR2(15) | |
| p_birth_date |
Person birth date. DATE | |
| p_sex |
Gender of the person. Valid values are M (male), F (female), N (unknown). VARCHAR2(1) | |
| p_email_address |
Email address used for the person for matching purposes. VARCHAR2(128) | |
| p_atyp_code |
Default address type code for the person for matching purposes. VARCHAR2(2) | |
| p_tele_code |
Default telephone type code for the person for matching purposes. VARCHAR2(4) | |
| p_emal_code |
Default email type code for the person for matching purposes. VARCHAR2(4) | |
| p_asrc_code |
Default address source code for the person for matching purposes. VARCHAR2(4) | |
| p_surname_prefix |
Name tag preceding the last name or surname. (Van, Von, Mac, etc.). VARCHAR2(60) | |
| p_pidm |
SPRIDEN_PIDM for matched proxy record. This value is filled in once the general person is matched or migrated to SPRIDEN. NUMBER(8) | |
| p_match_status |
The status code of the match to an existing person in SPRIDEN. Valid values are (N)new, (M)matched. A blank value is unprocessed. VARCHAR2(1) | |
| p_match_date |
The date the match to SPRIDEN took place. DATE | |
| p_load_status |
Status to indicate if person was matched to Banner or new to Banner. VARCHAR2(1) | |
| p_load_date |
Date person record was migrated to Production Banner tables. DATE | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_name_prefix |
Prefix (Mr, Mrs, etc) used before the person name. VARCHAR2(20) | |
| p_name_suffix |
Suffix (Jr, Sr, etc) used after the person name. VARCHAR2(20) | |
| p_pref_first_name |
Preferred first name associated with the person. VARCHAR2(60) | |
| p_cnty_code |
The county associated with the address of the person/non-person to be created. VARCHAR2(5) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_gidm geniden.geniden_gidm%TYPE,
p_syst_code geniden.geniden_syst_code%TYPE,
p_entity_code geniden.geniden_entity_code%TYPE,
p_id geniden.geniden_id%TYPE,
p_last_name geniden.geniden_last_name%TYPE DEFAULT NULL,
p_first_name geniden.geniden_first_name%TYPE DEFAULT NULL,
p_mi geniden.geniden_mi%TYPE DEFAULT NULL,
p_house_number geniden.geniden_house_number%TYPE DEFAULT NULL,
p_street_line1 geniden.geniden_street_line1%TYPE DEFAULT NULL,
p_street_line2 geniden.geniden_street_line2%TYPE DEFAULT NULL,
p_street_line3 geniden.geniden_street_line3%TYPE DEFAULT NULL,
p_street_line4 geniden.geniden_street_line4%TYPE DEFAULT NULL,
p_city geniden.geniden_city%TYPE DEFAULT NULL,
p_stat_code geniden.geniden_stat_code%TYPE DEFAULT NULL,
p_zip geniden.geniden_zip%TYPE DEFAULT NULL,
p_natn_code geniden.geniden_natn_code%TYPE DEFAULT NULL,
p_phone_area geniden.geniden_phone_area%TYPE DEFAULT NULL,
p_phone_number geniden.geniden_phone_number%TYPE DEFAULT NULL,
p_phone_ext geniden.geniden_phone_ext%TYPE DEFAULT NULL,
p_ctry_code_phone geniden.geniden_ctry_code_phone%TYPE DEFAULT NULL,
p_ssn geniden.geniden_ssn%TYPE DEFAULT NULL,
p_birth_date geniden.geniden_birth_date%TYPE DEFAULT NULL,
p_sex geniden.geniden_sex%TYPE DEFAULT NULL,
p_email_address geniden.geniden_email_address%TYPE DEFAULT NULL,
p_atyp_code geniden.geniden_atyp_code%TYPE DEFAULT NULL,
p_tele_code geniden.geniden_tele_code%TYPE DEFAULT NULL,
p_emal_code geniden.geniden_emal_code%TYPE DEFAULT NULL,
p_asrc_code geniden.geniden_asrc_code%TYPE DEFAULT NULL,
p_surname_prefix geniden.geniden_surname_prefix%TYPE DEFAULT NULL,
p_pidm geniden.geniden_pidm%TYPE DEFAULT NULL,
p_match_status geniden.geniden_match_status%TYPE DEFAULT NULL,
p_match_date geniden.geniden_match_date%TYPE DEFAULT NULL,
p_load_status geniden.geniden_load_status%TYPE DEFAULT NULL,
p_load_date geniden.geniden_load_date%TYPE DEFAULT NULL,
p_user_id geniden.geniden_user_id%TYPE DEFAULT NULL,
p_name_prefix geniden.geniden_name_prefix%TYPE DEFAULT NULL,
p_name_suffix geniden.geniden_name_suffix%TYPE DEFAULT NULL,
p_pref_first_name geniden.geniden_pref_first_name%TYPE DEFAULT NULL,
p_cnty_code geniden.geniden_cnty_code%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_gidm |
Unique ID of General Matching Person. NUMBER(8) Required Key | |
| p_syst_code |
Specifies what system will be using this person (e.g. Web4Proxy). VARCHAR2(30) Required | |
| p_entity_code |
Identifies whether record is person or non-person to be created. Valid values P = person, C = non-person. VARCHAR2(1) Required | |
| p_id |
Identification number used to access person on-line. VARCHAR2(9) Required | |
| p_last_name |
Last name of person. VARCHAR2(60) | |
| p_first_name |
First name of person. VARCHAR2(60) | |
| p_mi |
Middle name of person. VARCHAR2(60) | |
| p_house_number |
Building or lot number on a street or in an area. VARCHAR2(10) | |
| p_street_line1 |
First line of the address associated with the person. VARCHAR2(75) | |
| p_street_line2 |
Second line of the address associated with the person. VARCHAR2(75) | |
| p_street_line3 |
Third line of the address associated with the person. VARCHAR2(75) | |
| p_street_line4 |
Fourth line of the address associated with the person. VARCHAR2(75) | |
| p_city |
City associated with the address of the person. VARCHAR2(50) | |
| p_stat_code |
State associated with the address of the person. VARCHAR2(3) | |
| p_zip |
Postal code associated with the address of the person. VARCHAR2(30) | |
| p_natn_code |
Nation/country associated with the address of the person. VARCHAR2(5) | |
| p_phone_area |
Telephone number area code. VARCHAR2(6) | |
| p_phone_number |
Telephone number. VARCHAR2(12) | |
| p_phone_ext |
Telephone number extension. VARCHAR2(10) | |
| p_ctry_code_phone |
Telephone code that designates the region and country. VARCHAR2(4) | |
| p_ssn |
National ID number of the person. VARCHAR2(15) | |
| p_birth_date |
Person birth date. DATE | |
| p_sex |
Gender of the person. Valid values are M (male), F (female), N (unknown). VARCHAR2(1) | |
| p_email_address |
Email address used for the person for matching purposes. VARCHAR2(128) | |
| p_atyp_code |
Default address type code for the person for matching purposes. VARCHAR2(2) | |
| p_tele_code |
Default telephone type code for the person for matching purposes. VARCHAR2(4) | |
| p_emal_code |
Default email type code for the person for matching purposes. VARCHAR2(4) | |
| p_asrc_code |
Default address source code for the person for matching purposes. VARCHAR2(4) | |
| p_surname_prefix |
Name tag preceding the last name or surname. (Van, Von, Mac, etc.). VARCHAR2(60) | |
| p_pidm |
SPRIDEN_PIDM for matched proxy record. This value is filled in once the general person is matched or migrated to SPRIDEN. NUMBER(8) | |
| p_match_status |
The status code of the match to an existing person in SPRIDEN. Valid values are (N)new, (M)matched. A blank value is unprocessed. VARCHAR2(1) | |
| p_match_date |
The date the match to SPRIDEN took place. DATE | |
| p_load_status |
Status to indicate if person was matched to Banner or new to Banner. VARCHAR2(1) | |
| p_load_date |
Date person record was migrated to Production Banner tables. DATE | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_name_prefix |
Prefix (Mr, Mrs, etc) used before the person name. VARCHAR2(20) | |
| p_name_suffix |
Suffix (Jr, Sr, etc) used after the person name. VARCHAR2(20) | |
| p_pref_first_name |
Preferred first name associated with the person. VARCHAR2(60) | |
| p_cnty_code |
The county associated with the address of the person/non-person to be created. VARCHAR2(5) |