|
Package gb_emergency_contact_rules Support subprograms for the EMERGENCY CONTACT API(EMERGENCY_CONTACT). |
| Program units |
| p_address_rule | Populates an Emergency Contact Address if only ATYP_CODE is specified. |
| 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_address_rule
PROCEDURE p_address_rule(p_rec IN OUT spremrg%ROWTYPE)
Populates an Emergency Contact Address if only ATYP_CODE is specified.
| Parameters |
| p_rec |
An emergency contact 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 signature uses the rowid only, for the delete operations.
| Parameters |
| p_internal_record_id |
Database ROWID |
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER,
p_pidm spremrg.spremrg_pidm%TYPE,
p_priority spremrg.spremrg_priority%TYPE,
p_last_name spremrg.spremrg_last_name%TYPE,
p_first_name spremrg.spremrg_first_name%TYPE,
p_mi spremrg.spremrg_mi%TYPE,
p_street_line1 spremrg.spremrg_street_line1%TYPE,
p_street_line2 spremrg.spremrg_street_line2%TYPE,
p_street_line3 spremrg.spremrg_street_line3%TYPE,
p_city spremrg.spremrg_city%TYPE,
p_stat_code spremrg.spremrg_stat_code%TYPE,
p_natn_code spremrg.spremrg_natn_code%TYPE,
p_zip spremrg.spremrg_zip%TYPE,
p_phone_area spremrg.spremrg_phone_area%TYPE,
p_phone_number spremrg.spremrg_phone_number%TYPE,
p_phone_ext spremrg.spremrg_phone_ext%TYPE,
p_relt_code spremrg.spremrg_relt_code%TYPE,
p_atyp_code spremrg.spremrg_atyp_code%TYPE,
p_data_origin spremrg.spremrg_data_origin%TYPE,
p_user_id spremrg.spremrg_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_surname_prefix spremrg.spremrg_surname_prefix%TYPE,
p_ctry_code_phone spremrg.spremrg_ctry_code_phone%TYPE,
p_house_number spremrg.spremrg_house_number%TYPE,
p_street_line4 spremrg.spremrg_street_line4%TYPE,
p_internal_record_id gb_common.internal_record_id_type)
Registers the attribute/value pairs to the message cache.
This signature registers the all parameters
| Parameters |
| p_pidm |
Internal identification number of the person. NUMBER(8) Required Key | |
| p_priority |
Indicates the order of importance of this emergency contact. VARCHAR2(1) Required Key | |
| p_last_name |
Last name of the person associated with the emergency address information. VARCHAR2(60) Required | |
| p_first_name |
First name of the person associated with the emergency address information. VARCHAR2(60) Required | |
| p_mi |
Middle name of the person associated with the emergency address information. VARCHAR2(60) | |
| p_street_line1 |
Line one of the emergency adddress. VARCHAR2(75) | |
| p_street_line2 |
Line two of the emergency address. VARCHAR2(75) | |
| p_street_line3 |
Line three of the emergency address. VARCHAR2(75) | |
| p_city |
City associated with the emergency address. VARCHAR2(50) | |
| p_stat_code |
State associated with the emergency address. VARCHAR2(3) | |
| p_natn_code |
Nation/Country associated with the emergency address. VARCHAR2(5) | |
| p_zip |
Zip code associated with the emergency address. VARCHAR2(30) | |
| p_phone_area |
Area code of the phone number associated with the emergency address. VARCHAR2(6) | |
| p_phone_number |
Phone number associated with the emergency address. VARCHAR2(12) | |
| p_phone_ext |
Extension of the phone number associated with the emergency address. VARCHAR2(10) | |
| p_relt_code |
Relationship between the emergency contact person and the person. VARCHAR2(1) | |
| p_atyp_code |
The address type associated with the emergency address. VARCHAR2(2) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_user_id |
Oracle User ID of the person who inserted or last updated the data. VARCHAR2(30) | |
| p_surname_prefix |
Name tag preceding the last name or surname. (Van, Von, Mac, etc.) VARCHAR2(60) | |
| p_ctry_code_phone |
Telephone code that designates the region and country. VARCHAR2(40) | |
| p_house_number |
Building or lot number on a street or in an area. VARCHAR2(10) | |
| p_street_line4 |
Line four of emergency address. VARCHAR2(75) | |
| p_internal_record_id |
Database ROWID |
p_validate
PROCEDURE p_validate(p_pidm spremrg.spremrg_pidm%TYPE,
p_priority spremrg.spremrg_priority%TYPE,
p_last_name spremrg.spremrg_last_name%TYPE,
p_first_name spremrg.spremrg_first_name%TYPE,
p_mi spremrg.spremrg_mi%TYPE DEFAULT NULL,
p_street_line1 spremrg.spremrg_street_line1%TYPE DEFAULT NULL,
p_street_line2 spremrg.spremrg_street_line2%TYPE DEFAULT NULL,
p_street_line3 spremrg.spremrg_street_line3%TYPE DEFAULT NULL,
p_city spremrg.spremrg_city%TYPE DEFAULT NULL,
p_stat_code spremrg.spremrg_stat_code%TYPE DEFAULT NULL,
p_natn_code spremrg.spremrg_natn_code%TYPE DEFAULT NULL,
p_zip spremrg.spremrg_zip%TYPE DEFAULT NULL,
p_phone_area spremrg.spremrg_phone_area%TYPE DEFAULT NULL,
p_phone_number spremrg.spremrg_phone_number%TYPE DEFAULT NULL,
p_phone_ext spremrg.spremrg_phone_ext%TYPE DEFAULT NULL,
p_relt_code spremrg.spremrg_relt_code%TYPE DEFAULT NULL,
p_atyp_code spremrg.spremrg_atyp_code%TYPE DEFAULT NULL,
p_data_origin spremrg.spremrg_data_origin%TYPE DEFAULT NULL,
p_user_id spremrg.spremrg_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_surname_prefix spremrg.spremrg_surname_prefix%TYPE DEFAULT NULL,
p_ctry_code_phone spremrg.spremrg_ctry_code_phone%TYPE DEFAULT NULL,
p_house_number spremrg.spremrg_house_number%TYPE DEFAULT NULL,
p_street_line4 spremrg.spremrg_street_line4%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_pidm |
Internal identification number of the person. NUMBER(8) Required Key | |
| p_priority |
Indicates the order of importance of this emergency contact. VARCHAR2(1) Required Key | |
| p_last_name |
Last name of the person associated with the emergency address information. VARCHAR2(60) Required | |
| p_first_name |
First name of the person associated with the emergency address information. VARCHAR2(60) Required | |
| p_mi |
Middle name of the person associated with the emergency address information. VARCHAR2(60) | |
| p_street_line1 |
Line one of the emergency adddress. VARCHAR2(75) | |
| p_street_line2 |
Line two of the emergency address. VARCHAR2(75) | |
| p_street_line3 |
Line three of the emergency address. VARCHAR2(75) | |
| p_city |
City associated with the emergency address. VARCHAR2(50) | |
| p_stat_code |
State associated with the emergency address. VARCHAR2(3) | |
| p_natn_code |
Nation/Country associated with the emergency address. VARCHAR2(5) | |
| p_zip |
Zip code associated with the emergency address. VARCHAR2(30) | |
| p_phone_area |
Area code of the phone number associated with the emergency address. VARCHAR2(6) | |
| p_phone_number |
Phone number associated with the emergency address. VARCHAR2(12) | |
| p_phone_ext |
Extension of the phone number associated with the emergency address. VARCHAR2(10) | |
| p_relt_code |
Relationship between the emergency contact person and the person. VARCHAR2(1) | |
| p_atyp_code |
The address type associated with the emergency address. VARCHAR2(2) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_user_id |
Oracle User ID of the person who inserted or last updated the data. VARCHAR2(30) | |
| p_surname_prefix |
Name tag preceding the last name or surname. (Van, Von, Mac, etc.) VARCHAR2(60) | |
| p_ctry_code_phone |
Telephone code that designates the region and country. VARCHAR2(40) | |
| p_house_number |
Building or lot number on a street or in an area. VARCHAR2(10) | |
| p_street_line4 |
Line four of emergency address. VARCHAR2(75) |