|
Package gp_gpbprxy_rules Support subprograms for the GPBPRXY (gp_gpbprxy). |
| 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_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE,
p_email_address gpbprxy.gpbprxy_email_address%TYPE,
p_last_name gpbprxy.gpbprxy_last_name%TYPE,
p_proxy_pidm gpbprxy.gpbprxy_proxy_pidm%TYPE,
p_email_ver_date gpbprxy.gpbprxy_email_ver_date%TYPE,
p_first_name gpbprxy.gpbprxy_first_name%TYPE,
p_pin gpbprxy.gpbprxy_pin%TYPE,
p_pin_disabled_ind gpbprxy.gpbprxy_pin_disabled_ind%TYPE,
p_pin_exp_date gpbprxy.gpbprxy_pin_exp_date%TYPE,
p_last_login_date gpbprxy.gpbprxy_last_login_date%TYPE,
p_inv_login_cnt gpbprxy.gpbprxy_inv_login_cnt%TYPE,
p_salt gpbprxy.gpbprxy_salt%TYPE,
p_create_user gpbprxy.gpbprxy_create_user%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gpbprxy.gpbprxy_create_date%TYPE,
p_user_id gpbprxy.gpbprxy_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_opt_out_adv_date gpbprxy.gpbprxy_opt_out_adv_date%TYPE,
p_entity_cde gpbprxy.gpbprxy_entity_cde%TYPE,
p_mi gpbprxy.gpbprxy_mi%TYPE,
p_id gpbprxy.gpbprxy_id%TYPE,
p_street_line1 gpbprxy.gpbprxy_street_line1%TYPE,
p_street_line2 gpbprxy.gpbprxy_street_line2%TYPE,
p_street_line3 gpbprxy.gpbprxy_street_line3%TYPE,
p_street_line4 gpbprxy.gpbprxy_street_line4%TYPE,
p_city gpbprxy.gpbprxy_city%TYPE,
p_stat_code gpbprxy.gpbprxy_stat_code%TYPE,
p_zip gpbprxy.gpbprxy_zip%TYPE,
p_natn_code gpbprxy.gpbprxy_natn_code%TYPE,
p_cnty_code gpbprxy.gpbprxy_cnty_code%TYPE,
p_ssn gpbprxy.gpbprxy_ssn%TYPE,
p_birth_date gpbprxy.gpbprxy_birth_date%TYPE,
p_sex gpbprxy.gpbprxy_sex%TYPE,
p_atyp_code gpbprxy.gpbprxy_atyp_code%TYPE,
p_tele_code gpbprxy.gpbprxy_tele_code%TYPE,
p_emal_code gpbprxy.gpbprxy_emal_code%TYPE,
p_asrc_code gpbprxy.gpbprxy_asrc_code%TYPE,
p_house_number gpbprxy.gpbprxy_house_number%TYPE,
p_surname_prefix gpbprxy.gpbprxy_surname_prefix%TYPE,
p_phone_area gpbprxy.gpbprxy_phone_area%TYPE,
p_phone_number gpbprxy.gpbprxy_phone_number%TYPE,
p_phone_ext gpbprxy.gpbprxy_phone_ext%TYPE,
p_ctry_code_phone gpbprxy.gpbprxy_ctry_code_phone%TYPE,
p_name_prefix gpbprxy.gpbprxy_name_prefix%TYPE,
p_name_suffix gpbprxy.gpbprxy_name_suffix%TYPE,
p_pref_first_name gpbprxy.gpbprxy_pref_first_name%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.
* @param p_operation_type Type of DML operation: create,update,delete. NUMBER Required
* @param p_proxy_idm The proxy ID master is a negative sequential number unique to a proxy created when a person adds a new proxy with a unique email address (doesn"t already exist in GPBPRXY). A negative sequence is used so that it is impossible to
conflict with an existing PIDM or AIDM. See WEB4PROXY_SEQ. If a subsequent person cross-references an existing proxy email address then the existing PROXY_IDM is reused. NUMBER(8) Required Key
* @param p_email_address This is an email address unique to the proxy. Format is user@domain and is always stored in lower case. The email address is "verified" by sending an email message containing a URL that links to the email verification
procedure. The email address is used for proxy login. This differentiates proxy login from normal BSS login with Banner ID or LDAP username. A person can add a unique proxy email address but only a proxy can update their email address. VARCHAR2(128)
Require
d
* @param p_last_name Last name of proxy used for correspondence. Initial value may come from SPRIDEN_LAST_NAME if proxy is created from existing Banner data i.e. PROXY_PIDM is not NULL. VARCHAR2(60) Required
* @param p_proxy_pidm This is the Banner General Person PIDM. If the initial proxy record is created from existing Banner data then this will contain the PIDM from General Person (SPRIDEN_PIDM). The PIDM value may also be determined by a subsequent
common matching process. NUMBER(8)
* @param p_email_ver_date This date is recorded when the proxy browses to the email verification procedure from the verification email message after initial creation or email address update. The verification email message has this date encoded in the
URL. It must match else the URL is invalid. DATE
* @param p_first_name First name of proxy used for correspondence. Initial value may come from SPRIDEN_FIRST_NAME if proxy is created from existing Banner data i.e. PROXY_PIDM is not NULL. VARCHAR2(60) Required
* @param p_pin Login authentication credentials. This can be a numeric PIN, alpha-numeric password or passphrase. It is stored as an encrypted value. A PIN reset process is available from the login page. The initial PIN is entered during email
address verification. VARCHAR2(256)
* @param p_pin_disabled_ind Set to "Y" after three successive login failures. VARCHAR2(1) Required
* @param p_pin_exp_date This is the date at which the proxy PIN will need to be changed. New proxy PINs are pre-expired and must be changed during first login (email verification) or after a PIN reset. The expiration date is calculated using a rule
parameter (default is 365 days from last PIN update). The PIN reset email message will have this date encoded in the URL. It must match else the URL is invalid. DATE
* @param p_last_login_date This is the date of last last login attempt. (DATE)
* @param p_inv_login_cnt This is the number of invalid login attempts since the last succesful login. This value is reset when the disabled indicator is updated. NUMBER(3)
* @param p_salt This is used to encrypt the PIN. VARCHAR2(128)
* @param p_create_user Username responsible for initial creation. VARCHAR2(30)
* @param p_create_date Date when the record was initially created. DATE
* @param p_user_id The ID for the user that most recently updated the record. VARCHAR2(30)
* @param p_opt_out_adv_date This is the most recent date the proxy opted out of having her/his data pushed into advancement. DATE
* @param p_entity_cde Identifies whether record is person or non-person to be created. It does not display on the form. Valid values P = person, C = non-person. VARCHAR2(1)
* @param p_mi The middle name of the person to be created. VARCHAR2(60)
* @param p_id Identification Number for the person or non-person record to be created. VARCHAR2(9)
* @param p_street_line1 The first line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line2 The second line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line3 The third line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line4 The fourth line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_city The city associated with the address of the person/non-person to be created. VARCHAR2(50)
* @param p_stat_code The state or province code associated with the address of the person/non-person to be created. VARCHAR2(3)
* @param p_zip The zip or postal code associated with the address of the person/non-person to be created. VARCHAR2(30)
* @param p_natn_code The nation or country associated with the address of the person/non-person to be created. VARCHAR2(5)
* @param p_cnty_code The county associated with the address of the person/non-person to be created. VARCHAR2(5)
* @param p_ssn The Social Security Number, Social Insurance Number, or the Tax File Number associated with the person/non-person to be created. VARCHAR2(15)
* @param p_birth_date The date of the person birthday to be created. DATE
* @param p_sex The gender of the person to be created. VARCHAR2(1)
* @param p_atyp_code The address type to associate with the address. VARCHAR2(2)
* @param p_tele_code The telephone type to associate with the telephone number. VARCHAR2(4)
* @param p_emal_code The e-mail type to associate with the e-mail address. VARCHAR2(4)
* @param p_asrc_code The address entry method. For example, Tapeload, World Wide Web, Self report. VARCHAR2(4)
* @param p_house_number Building or lot number on a street or in an area. VARCHAR2(10)
* @param p_surname_prefix Name tag preceding the last name or surname. (Van, Von, Mac, etc.). VARCHAR2(60)
* @param p_phone_area The telephone area code VARCHAR2(06)
* @param p_phone_number The telephone number VARCHAR2(12)
* @param p_phone_extension The telephone extension VARCHAR2(10)
* @param p_ctry_code_phone The telephone country code VARCHAR2(04)
* @param p_name_prefix Prefix (Mr, Mrs, etc) used before the person name. VARCHAR2(20)
* @param p_name_suffix Suffix (Jr, Sr, etc) used after the person name. VARCHAR2(20)
* @param p_pref_first_name Preferred first name associated with the person. VARCHAR2(60)
* @param p_internal_record_id Database ROWID VARCHAR2(18) required
p_validate
PROCEDURE p_validate(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE,
p_email_address gpbprxy.gpbprxy_email_address%TYPE,
p_last_name gpbprxy.gpbprxy_last_name%TYPE,
p_proxy_pidm gpbprxy.gpbprxy_proxy_pidm%TYPE DEFAULT NULL,
p_email_ver_date gpbprxy.gpbprxy_email_ver_date%TYPE DEFAULT NULL,
p_first_name gpbprxy.gpbprxy_first_name%TYPE,
p_pin gpbprxy.gpbprxy_pin%TYPE DEFAULT NULL,
p_pin_disabled_ind gpbprxy.gpbprxy_pin_disabled_ind%TYPE,
p_pin_exp_date gpbprxy.gpbprxy_pin_exp_date%TYPE DEFAULT NULL,
p_last_login_date gpbprxy.gpbprxy_last_login_date%TYPE DEFAULT NULL,
p_inv_login_cnt gpbprxy.gpbprxy_inv_login_cnt%TYPE DEFAULT NULL,
p_salt gpbprxy.gpbprxy_salt%TYPE DEFAULT NULL,
p_create_user gpbprxy.gpbprxy_create_user%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gpbprxy.gpbprxy_create_date%TYPE DEFAULT NULL,
p_user_id gpbprxy.gpbprxy_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_opt_out_adv_date gpbprxy.gpbprxy_opt_out_adv_date%TYPE DEFAULT NULL,
p_entity_cde gpbprxy.gpbprxy_entity_cde%TYPE DEFAULT NULL,
p_mi gpbprxy.gpbprxy_mi%TYPE DEFAULT NULL,
p_id gpbprxy.gpbprxy_id%TYPE DEFAULT NULL,
p_street_line1 gpbprxy.gpbprxy_street_line1%TYPE DEFAULT NULL,
p_street_line2 gpbprxy.gpbprxy_street_line2%TYPE DEFAULT NULL,
p_street_line3 gpbprxy.gpbprxy_street_line3%TYPE DEFAULT NULL,
p_street_line4 gpbprxy.gpbprxy_street_line4%TYPE DEFAULT NULL,
p_city gpbprxy.gpbprxy_city%TYPE DEFAULT NULL,
p_stat_code gpbprxy.gpbprxy_stat_code%TYPE DEFAULT NULL,
p_zip gpbprxy.gpbprxy_zip%TYPE DEFAULT NULL,
p_natn_code gpbprxy.gpbprxy_natn_code%TYPE DEFAULT NULL,
p_cnty_code gpbprxy.gpbprxy_cnty_code%TYPE DEFAULT NULL,
p_ssn gpbprxy.gpbprxy_ssn%TYPE DEFAULT NULL,
p_birth_date gpbprxy.gpbprxy_birth_date%TYPE DEFAULT NULL,
p_sex gpbprxy.gpbprxy_sex%TYPE DEFAULT NULL,
p_atyp_code gpbprxy.gpbprxy_atyp_code%TYPE DEFAULT NULL,
p_tele_code gpbprxy.gpbprxy_tele_code%TYPE DEFAULT NULL,
p_emal_code gpbprxy.gpbprxy_emal_code%TYPE DEFAULT NULL,
p_asrc_code gpbprxy.gpbprxy_asrc_code%TYPE DEFAULT NULL,
p_house_number gpbprxy.gpbprxy_house_number%TYPE DEFAULT NULL,
p_surname_prefix gpbprxy.gpbprxy_surname_prefix%TYPE DEFAULT NULL,
p_phone_area gpbprxy.gpbprxy_phone_area%TYPE DEFAULT NULL,
p_phone_number gpbprxy.gpbprxy_phone_number%TYPE DEFAULT NULL,
p_phone_ext gpbprxy.gpbprxy_phone_ext%TYPE DEFAULT NULL,
p_ctry_code_phone gpbprxy.gpbprxy_ctry_code_phone%TYPE DEFAULT NULL,
p_name_prefix gpbprxy.gpbprxy_name_prefix%TYPE DEFAULT NULL,
p_name_suffix gpbprxy.gpbprxy_name_suffix%TYPE DEFAULT NULL,
p_pref_first_name gpbprxy.gpbprxy_pref_first_name%TYPE DEFAULT NULL)
* Validates all data in the record.
* @param p_proxy_idm The proxy ID master is a negative sequential number unique to a proxy created when a person adds a new proxy with a unique email address (doesn"t already exist in GPBPRXY). A negative sequence is used so that it is impossible to
conflict with an existing PIDM or AIDM. See WEB4PROXY_SEQ. If a subsequent person cross-references an existing proxy email address then the existing PROXY_IDM is reused. NUMBER(8) Required Key
* @param p_email_address This is an email address unique to the proxy. Format is user@domain and is always stored in lower case. The email address is "verified" by sending an email message containing a URL that links to the email verification
procedure. The email address is used for proxy login. This differentiates proxy login from normal BSS login with Banner ID or LDAP username. A person can add a unique proxy email address but only a proxy can update their email address. VARCHAR2(128)
Require
d
* @param p_last_name Last name of proxy used for correspondence. Initial value may come from SPRIDEN_LAST_NAME if proxy is created from existing Banner data i.e. PROXY_PIDM is not NULL. VARCHAR2(60) Required
* @param p_proxy_pidm This is the Banner General Person PIDM. If the initial proxy record is created from existing Banner data then this will contain the PIDM from General Person (SPRIDEN_PIDM). The PIDM value may also be determined by a subsequent
common matching process. NUMBER(8)
* @param p_email_ver_date This date is recorded when the proxy browses to the email verification procedure from the verification email message after initial creation or email address update. The verification email message has this date encoded in the
URL. It must match else the URL is invalid. DATE
* @param p_first_name First name of proxy used for correspondence. Initial value may come from SPRIDEN_FIRST_NAME if proxy is created from existing Banner data i.e. PROXY_PIDM is not NULL. VARCHAR2(60) Required
* @param p_pin Login authentication credentials. This can be a numeric PIN, alpha-numeric password or passphrase. It is stored as an encrypted value. A PIN reset process is available from the login page. The initial PIN is entered during email
address verification. VARCHAR2(256)
* @param p_pin_disabled_ind Set to "Y" after three successive login failures. VARCHAR2(1) Required
* @param p_pin_exp_date This is the date at which the proxy PIN will need to be changed. New proxy PINs are pre-expired and must be changed during first login (email verification) or after a PIN reset. The expiration date is calculated using a rule
parameter (default is 365 days from last PIN update). The PIN reset email message will have this date encoded in the URL. It must match else the URL is invalid. DATE
* @param p_last_login_date This is the date of last last login attempt. (DATE)
* @param p_inv_login_cnt This is the number of invalid login attempts since the last succesful login. This value is reset when the disabled indicator is updated. NUMBER(3)
* @param p_salt This is used to encrypt the PIN. VARCHAR2(128)
* @param p_create_user Username responsible for initial creation. VARCHAR2(30)
* @param p_create_date Date when the record was initially created. DATE
* @param p_user_id The ID for the user that most recently updated the record. VARCHAR2(30)
* @param p_opt_out_adv_date This is the most recent date the proxy opted out of having her/his data pushed into advancement. DATE
* @param p_entity_cde Identifies whether record is person or non-person to be created. It does not display on the form. Valid values P = person, C = non-person. VARCHAR2(1)
* @param p_mi The middle name of the person to be created. VARCHAR2(60)
* @param p_id Identification Number for the person or non-person record to be created. VARCHAR2(9)
* @param p_street_line1 The first line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line2 The second line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line3 The third line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_street_line4 The fourth line of the address of the person/non-person to be created. VARCHAR2(75)
* @param p_city The city associated with the address of the person/non-person to be created. VARCHAR2(50)
* @param p_stat_code The state or province code associated with the address of the person/non-person to be created. VARCHAR2(3)
* @param p_zip The zip or postal code associated with the address of the person/non-person to be created. VARCHAR2(30)
* @param p_natn_code The nation or country associated with the address of the person/non-person to be created. VARCHAR2(5)
* @param p_cnty_code The county associated with the address of the person/non-person to be created. VARCHAR2(5)
* @param p_ssn The Social Security Number, Social Insurance Number, or the Tax File Number associated with the person/non-person to be created. VARCHAR2(15)
* @param p_birth_date The date of the person birthday to be created. DATE
* @param p_sex The gender of the person to be created. VARCHAR2(1)
* @param p_atyp_code The address type to associate with the address. VARCHAR2(2)
* @param p_tele_code The telephone type to associate with the telephone number. VARCHAR2(4)
* @param p_emal_code The e-mail type to associate with the e-mail address. VARCHAR2(4)
* @param p_asrc_code The address entry method. For example, Tapeload, World Wide Web, Self report. VARCHAR2(4)
* @param p_house_number Building or lot number on a street or in an area. VARCHAR2(10)
* @param p_surname_prefix Name tag preceding the last name or surname. (Van, Von, Mac, etc.). VARCHAR2(60)
* @param p_phone_area The telephone area code VARCHAR2(06)
* @param p_phone_number The telephone number VARCHAR2(12)
* @param p_phone_extension The telephone extension VARCHAR2(10)
* @param p_ctry_code_phone The telephone country code VARCHAR2(04)
* @param p_name_prefix Prefix (Mr, Mrs, etc) used before the person name. VARCHAR2(20)
* @param p_name_suffix Suffix (Jr, Sr, etc) used after the person name. VARCHAR2(20)
* @param p_pref_first_name Preferred first name associated with the person. VARCHAR2(60)