index

Package gp_gpbprxy

Common Business interface for the GPBPRXY API (gp_gpbprxy).

Program units
f_api_version   Returns the API version number.
f_exists   Checks if a record exists.
f_isequal   Compares two records for equality.
f_query_all   Selects all records for the entity.
f_query_one   Selects one record using key.
f_query_one_by_email  
f_query_one_by_pidm  
f_query_by_rowid   Selects one record using ROWID.
f_query_one_lock   Selects one record and locks it.
p_create   * Creates a record.
p_delete   Deletes a record.
p_lock   Locks a record.
p_update   * Updates a record.

Types
gpbprxy_rec   Business Entity record type
gpbprxy_ref   Entity cursor variable type
gpbprxy_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity Name
M_BASE_TABLE_NAME   Base table name

M_ENTITY_NAME 

M_ENTITY_NAME        CONSTANT VARCHAR2(7) := 'GPBPRXY';

Business Entity Name

M_BASE_TABLE_NAME 

M_BASE_TABLE_NAME    CONSTANT VARCHAR2(7) := 'GPBPRXY';

Base table name

gpbprxy_rec 

TYPE gpbprxy_rec IS RECORD (
  r_proxy_idm               gpbprxy.gpbprxy_proxy_idm%TYPE,
  r_email_address           gpbprxy.gpbprxy_email_address%TYPE,
  r_last_name               gpbprxy.gpbprxy_last_name%TYPE,
  r_proxy_pidm              gpbprxy.gpbprxy_proxy_pidm%TYPE,
  r_email_ver_date          gpbprxy.gpbprxy_email_ver_date%TYPE,
  r_first_name              gpbprxy.gpbprxy_first_name%TYPE,
  r_pin                     gpbprxy.gpbprxy_pin%TYPE,
  r_pin_disabled_ind        gpbprxy.gpbprxy_pin_disabled_ind%TYPE,
  r_pin_exp_date            gpbprxy.gpbprxy_pin_exp_date%TYPE,
  r_last_login_date         gpbprxy.gpbprxy_last_login_date%TYPE,
  r_inv_login_cnt           gpbprxy.gpbprxy_inv_login_cnt%TYPE,
  r_salt                    gpbprxy.gpbprxy_salt%TYPE,
  r_create_user             gpbprxy.gpbprxy_create_user%TYPE,
  r_create_date             gpbprxy.gpbprxy_create_date%TYPE,
  r_user_id                 gpbprxy.gpbprxy_user_id%TYPE,
  r_opt_out_adv_date        gpbprxy.gpbprxy_opt_out_adv_date%TYPE,
  r_entity_cde              gpbprxy.gpbprxy_entity_cde%TYPE,
  r_mi                      gpbprxy.gpbprxy_mi%TYPE,
  r_id                      gpbprxy.gpbprxy_id%TYPE,
  r_street_line1            gpbprxy.gpbprxy_street_line1%TYPE,
  r_street_line2            gpbprxy.gpbprxy_street_line2%TYPE,
  r_street_line3            gpbprxy.gpbprxy_street_line3%TYPE,
  r_street_line4            gpbprxy.gpbprxy_street_line4%TYPE,
  r_city                    gpbprxy.gpbprxy_city%TYPE,
  r_stat_code               gpbprxy.gpbprxy_stat_code%TYPE,
  r_zip                     gpbprxy.gpbprxy_zip%TYPE,
  r_natn_code               gpbprxy.gpbprxy_natn_code%TYPE,
  r_cnty_code               gpbprxy.gpbprxy_cnty_code%TYPE,
  r_ssn                     gpbprxy.gpbprxy_ssn%TYPE,
  r_birth_date              gpbprxy.gpbprxy_birth_date%TYPE,
  r_sex                     gpbprxy.gpbprxy_sex%TYPE,
  r_atyp_code               gpbprxy.gpbprxy_atyp_code%TYPE,
  r_tele_code               gpbprxy.gpbprxy_tele_code%TYPE,
  r_emal_code               gpbprxy.gpbprxy_emal_code%TYPE,
  r_asrc_code               gpbprxy.gpbprxy_asrc_code%TYPE,
  r_house_number            gpbprxy.gpbprxy_house_number%TYPE,
  r_surname_prefix          gpbprxy.gpbprxy_surname_prefix%TYPE,
  r_phone_area              gpbprxy.gpbprxy_phone_area%TYPE,
  r_phone_number            gpbprxy.gpbprxy_phone_number%TYPE,
  r_phone_ext               gpbprxy.gpbprxy_phone_ext%TYPE,
  r_ctry_code_phone         gpbprxy.gpbprxy_ctry_code_phone%TYPE,
  r_name_prefix             gpbprxy.gpbprxy_name_prefix%TYPE,
  r_name_suffix             gpbprxy.gpbprxy_name_suffix%TYPE,
  r_pref_first_name         gpbprxy.gpbprxy_pref_first_name%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

gpbprxy_ref 

TYPE gpbprxy_ref IS REF CURSOR RETURN gpbprxy_rec;

Entity cursor variable type

gpbprxy_tab 

TYPE gpbprxy_tab IS TABLE OF gpbprxy_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version 

FUNCTION f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns
Version of the API signature. Changes only when the signature changes.

f_exists 

FUNCTION f_exists(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE,
                  p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks if a record exists.

Parameters
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
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
Y if found, otherwise N.

f_isequal 

FUNCTION f_isequal(rec_one gpbprxy_rec,
                   rec_two gpbprxy_rec) RETURN VARCHAR2

Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.

Parameters
rec_one   The first record to compare. Type gpbprxy_rec Required
rec_two   The second record to compare. Type gpbprxy_rec Required

Returns
Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_query_all 

FUNCTION f_query_all(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE)
  RETURN gpbprxy_ref

Selects all records for the entity.

Parameters
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

Returns
A cursor variable that will fetch a set of records.

f_query_one 

FUNCTION f_query_one(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE)
  RETURN gpbprxy_ref

Selects one record using key.

Parameters
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

Returns
A cursor variable that will fetch exactly one record.

f_query_one_by_email 

FUNCTION f_query_one_by_email(p_email_address gpbprxy.gpbprxy_email_address%TYPE)
  RETURN gpbprxy_ref

f_query_one_by_pidm 

FUNCTION f_query_one_by_pidm(p_proxy_pidm gpbprxy.gpbprxy_proxy_pidm%TYPE)
  RETURN gpbprxy_ref

f_query_by_rowid 

FUNCTION f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
  RETURN gpbprxy_ref

Selects one record using ROWID.

Parameters
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18) Required

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

FUNCTION f_query_one_lock(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE,
                          p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN gpbprxy_ref

Selects one record and locks it.

Parameters
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
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18)

Returns
A cursor variable for one record, locking the record.

p_create 

PROCEDURE p_create(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,
                   p_rowid_out        OUT gb_common.internal_record_id_type)

* Creates a 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)
 Required
* @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_rowid_out Database ROWID of the record to be created. VARCHAR2(18) Required

p_delete 

PROCEDURE p_delete(p_proxy_idm gpbprxy.gpbprxy_proxy_idm%TYPE,
                   p_rowid     gb_common.internal_record_id_type DEFAULT NULL)

Deletes a record.

Parameters
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
p_rowid   Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock 

PROCEDURE p_lock(p_proxy_idm   gpbprxy.gpbprxy_proxy_idm%TYPE,
                 p_rowid_inout IN OUT NOCOPY gb_common.internal_record_id_type)

Locks a record.
If ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout

Parameters
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
p_rowid_inout   Database ROWID of the record to be locked. VARCHAR2(18) Required

p_update 

PROCEDURE p_update(p_proxy_idm        gpbprxy.gpbprxy_proxy_idm%TYPE,
                   p_email_address    gpbprxy.gpbprxy_email_address%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_last_name        gpbprxy.gpbprxy_last_name%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_proxy_pidm       gpbprxy.gpbprxy_proxy_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_email_ver_date   gpbprxy.gpbprxy_email_ver_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_first_name       gpbprxy.gpbprxy_first_name%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pin              gpbprxy.gpbprxy_pin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pin_disabled_ind gpbprxy.gpbprxy_pin_disabled_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pin_exp_date     gpbprxy.gpbprxy_pin_exp_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_last_login_date  gpbprxy.gpbprxy_last_login_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_inv_login_cnt    gpbprxy.gpbprxy_inv_login_cnt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_salt             gpbprxy.gpbprxy_salt%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_create_user      gpbprxy.gpbprxy_create_user%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_create_date      gpbprxy.gpbprxy_create_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   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 dml_common.f_unspecified_date,
                   p_entity_cde       gpbprxy.gpbprxy_entity_cde%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_mi               gpbprxy.gpbprxy_mi%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_id               gpbprxy.gpbprxy_id%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_street_line1     gpbprxy.gpbprxy_street_line1%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_street_line2     gpbprxy.gpbprxy_street_line2%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_street_line3     gpbprxy.gpbprxy_street_line3%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_street_line4     gpbprxy.gpbprxy_street_line4%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_city             gpbprxy.gpbprxy_city%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_stat_code        gpbprxy.gpbprxy_stat_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_zip              gpbprxy.gpbprxy_zip%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_natn_code        gpbprxy.gpbprxy_natn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_cnty_code        gpbprxy.gpbprxy_cnty_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ssn              gpbprxy.gpbprxy_ssn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_birth_date       gpbprxy.gpbprxy_birth_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_sex              gpbprxy.gpbprxy_sex%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_atyp_code        gpbprxy.gpbprxy_atyp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_tele_code        gpbprxy.gpbprxy_tele_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_emal_code        gpbprxy.gpbprxy_emal_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_asrc_code        gpbprxy.gpbprxy_asrc_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_house_number     gpbprxy.gpbprxy_house_number%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_surname_prefix   gpbprxy.gpbprxy_surname_prefix%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_phone_area       gpbprxy.gpbprxy_phone_area%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_phone_number     gpbprxy.gpbprxy_phone_number%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_phone_ext        gpbprxy.gpbprxy_phone_ext%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ctry_code_phone  gpbprxy.gpbprxy_ctry_code_phone%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_name_prefix      gpbprxy.gpbprxy_name_prefix%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_name_suffix      gpbprxy.gpbprxy_name_suffix%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_pref_first_name  gpbprxy.gpbprxy_pref_first_name%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rowid            gb_common.internal_record_id_type DEFAULT NULL)

* Updates a 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)
 Required
* @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_rowid Database ROWID of the record to be updated. VARCHAR2(18)