|
Package ab_adv_individual_rules This package provides the messaging support and field validation for the Advancement Individual API (ab_adv_individual).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. Regardless, the API will always run the validation checks. |
| 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 VARCHAR2)
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 apbcons.apbcons_pidm%TYPE,
p_pref_last_name apbcons.apbcons_pref_last_name%TYPE,
p_pref_first_name apbcons.apbcons_pref_first_name%TYPE,
p_pref_mi apbcons.apbcons_pref_mi%TYPE,
p_nickname apbcons.apbcons_nickname%TYPE,
p_grad_name apbcons.apbcons_grad_name%TYPE,
p_parents_name apbcons.apbcons_parents_name%TYPE,
p_maiden_last_name apbcons.apbcons_maiden_last_name%TYPE,
p_pref_clas apbcons.apbcons_pref_clas%TYPE,
p_coll_code_pref apbcons.apbcons_coll_code_pref%TYPE,
p_home_city apbcons.apbcons_home_city%TYPE,
p_stat_code_home apbcons.apbcons_stat_code_home%TYPE,
p_natn_code_home apbcons.apbcons_natn_code_home%TYPE,
p_cm_name apbcons.apbcons_cm_name%TYPE,
p_atyp_code_cm apbcons.apbcons_atyp_code_cm%TYPE,
p_dott_code apbcons.apbcons_dott_code%TYPE,
p_incm_code apbcons.apbcons_incm_code%TYPE,
p_atyp_code_pref apbcons.apbcons_atyp_code_pref%TYPE,
p_addr_name apbcons.apbcons_addr_name%TYPE,
p_atyp_code_geor apbcons.apbcons_atyp_code_geor%TYPE,
p_society_name apbcons.apbcons_society_name%TYPE,
p_data_origin apbcons.apbcons_data_origin%TYPE,
p_user_id apbcons.apbcons_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_surname_prefix apbcons.apbcons_surname_prefix%TYPE,
p_internal_record_id VARCHAR2)
Registers the attribute/value pairs to the message cache.
This signature registers all parameters.
| Parameters |
| p_pidm |
Internal system-generated identification number of the Advancement Individual. NUMBER(8) Required Key | |
| p_pref_last_name |
Preferred last name of the Advancement Individual. VARCHAR2(25) | |
| p_pref_first_name |
Preferred first name of the Advancement Individual. VARCHAR2(15) | |
| p_pref_mi |
Preferred middle initial of the Advancement Individual. VARCHAR2(1) | |
| p_surname_prefix |
Surname prefix of the Advancement Individual. VARCHAR2(10) | |
| p_nickname |
Nickname used by the Advancement Individual. VARCHAR2(40) | |
| p_grad_name |
Advancement Individual's name at the time of college graduation. VARCHAR2(60) | |
| p_parents_name |
Name of the Advancement Individual's parents. VARCHAR2(50) | |
| p_maiden_last_name |
Advancement Individual's maiden name. VARCHAR2(25) | |
| p_pref_clas |
Year in which the Advancement Individual received the first degree or the year of expected graduation if the first degree has not yet been earned. VARCHAR2(4) Required | |
| p_coll_code_pref |
College within the institution with which the Advancement Individual prefers to be associated. VARCHAR2(2) | |
| p_home_city |
Advancement Individual's hometown. VARCHAR2(20) | |
| p_stat_code_home |
State of the Advancement Individual's hometown. VARCHAR2(3) | |
| p_natn_code_home |
Country of the Advancement Individual's hometown. VARCHAR2(5) | |
| p_cm_name |
Combined mailing name for the Advancement Individual. VARCHAR2(50) | |
| p_atyp_code_cm |
Address type to be used for the combined mailing. VARCHA R2(2) | |
| p_dott_code |
Advancement Individual's occupational title. VARCHAR2(4) | |
| p_incm_code |
Advancement Individual's income level. VARCHAR2(2) | |
| p_atyp_code_pref |
Advancement Individual's preferred address for solicitations and acknowledgements. VARCHAR2(2) | |
| p_addr_name |
Name to be used with the preferred address type. VARCHAR2(35) | |
| p_atyp_code_geor |
Address type of the address to be used as the preferred geographic region address. VARCHAR2(2) | |
| p_society_name |
Gift Society name. Defaults to gift societies when they memberships are created. The name may be modified on the society form. VARCHAR2(60) | |
| p_data_origin |
Source system that generated or updated the data. VARCHAR2(30) | |
| p_user_id |
User who inserted or last updated the data. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) |
p_validate
Procedure p_validate(p_pidm apbcons.apbcons_pidm%TYPE,
p_pref_last_name apbcons.apbcons_pref_last_name%TYPE DEFAULT NULL,
p_pref_first_name apbcons.apbcons_pref_first_name%TYPE DEFAULT NULL,
p_pref_mi apbcons.apbcons_pref_mi%TYPE DEFAULT NULL,
p_nickname apbcons.apbcons_nickname%TYPE DEFAULT NULL,
p_grad_name apbcons.apbcons_grad_name%TYPE DEFAULT NULL,
p_parents_name apbcons.apbcons_parents_name%TYPE DEFAULT NULL,
p_maiden_last_name apbcons.apbcons_maiden_last_name%TYPE DEFAULT NULL,
p_pref_clas apbcons.apbcons_pref_clas%TYPE,
p_coll_code_pref apbcons.apbcons_coll_code_pref%TYPE DEFAULT NULL,
p_home_city apbcons.apbcons_home_city%TYPE DEFAULT NULL,
p_stat_code_home apbcons.apbcons_stat_code_home%TYPE DEFAULT NULL,
p_natn_code_home apbcons.apbcons_natn_code_home%TYPE DEFAULT NULL,
p_cm_name apbcons.apbcons_cm_name%TYPE DEFAULT NULL,
p_atyp_code_cm apbcons.apbcons_atyp_code_cm%TYPE DEFAULT NULL,
p_dott_code apbcons.apbcons_dott_code%TYPE DEFAULT NULL,
p_incm_code apbcons.apbcons_incm_code%TYPE DEFAULT NULL,
p_atyp_code_pref apbcons.apbcons_atyp_code_pref%TYPE DEFAULT NULL,
p_addr_name apbcons.apbcons_addr_name%TYPE DEFAULT NULL,
p_atyp_code_geor apbcons.apbcons_atyp_code_geor%TYPE DEFAULT NULL,
p_society_name apbcons.apbcons_society_name%TYPE DEFAULT NULL,
p_data_origin apbcons.apbcons_data_origin%TYPE DEFAULT NULL,
-- Begin Defect 70-0157
p_user_id apbcons.apbcons_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_donr_code aprcatg.aprcatg_donr_code%TYPE DEFAULT NULL,
p_surname_prefix apbcons.apbcons_surname_prefix%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_pidm |
Internal system-generated identification number of the Advancement Individual. NUMBER(8) Required Key | |
| p_pref_last_name |
Preferred last name of the Advancement Individual. VARCHAR2(25) | |
| p_pref_first_name |
Preferred first name of the Advancement Individual. VARCHAR2(15) | |
| p_pref_mi |
Preferred middle initial of the Advancement Individual. VARCHAR2(1) | |
| p_surname_prefix |
Surname prefix of the Advancement Individual. VARCHAR2(10) | |
| p_nickname |
Nickname used by the Advancement Individual. VARCHAR2(40) | |
| p_grad_name |
Advancement Individual's name at the time of college graduation. VARCHAR2(60) | |
| p_parents_name |
Name of the Advancement Individual's parents. VARCHAR2(50) | |
| p_maiden_last_name |
Advancement Individual's maiden name. VARCHAR2(25) | |
| p_pref_clas |
Year in which the Advancement Individual received the first degree or the year of expected graduation if the first degree has not yet been earned. VARCHAR2(4) Required | |
| p_coll_code_pref |
College within the institution with which the Advancement Individual prefers to be associated. VARCHAR2(2) | |
| p_home_city |
Advancement Individual's hometown. VARCHAR2(20) | |
| p_stat_code_home |
State of the Advancement Individual's hometown. VARCHAR2(3) | |
| p_natn_code_home |
Country of the Advancement Individual's hometown. VARCHAR2(5) | |
| p_cm_name |
Combined mailing name for the Advancement Individual. VARCHAR2(50) | |
| p_atyp_code_cm |
Address type to be used for the combined mailing. VARCHA R2(2) | |
| p_dott_code |
Advancement Individual's occupational title. VARCHAR2(4) | |
| p_incm_code |
Advancement Individual's income level. VARCHAR2(2) | |
| p_atyp_code_pref |
Advancement Individual's preferred address for solicitations and acknowledgements. VARCHAR2(2) | |
| p_addr_name |
Name to be used with the preferred address type. VARCHAR2(35) | |
| p_atyp_code_geor |
Address type of the address to be used as the preferred geographic region address. VARCHAR2(2) | |
| p_society_name |
Gift Society name. Defaults to gift societies when they memberships are created. The name may be modified on the society form. VARCHAR2(60) | |
| p_data_origin |
Source system that generated or updated the data. VARCHAR2(30) | |
| p_user_id |
User who inserted or last updated the data. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) |