Package gb_third_party_access

Package gb_third_party_access_rules

This package provides the rules for the Third Party Access API.

Program units

p_register_entity	Registers 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 the data in the Third Party Access record.
p_validate_pinrules	Validates the PIN according to the rules established on GUBPPRF.

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 for delete operations.
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               gobtpac.gobtpac_pidm%TYPE,
                            p_pin_disabled_ind   gobtpac.gobtpac_pin_disabled_ind%TYPE,
                            p_usage_accept_ind   gobtpac.gobtpac_usage_accept_ind%TYPE,
                            p_user               gobtpac.gobtpac_user%TYPE,
                            p_pin                gobtpac.gobtpac_pin%TYPE,
                            p_pin_exp_date       gobtpac.gobtpac_pin_exp_date%TYPE,
                            p_external_user      gobtpac.gobtpac_external_user%TYPE,
                            p_question           gobtpac.gobtpac_question%TYPE,
                            p_response           gobtpac.gobtpac_response%TYPE,
                            p_insert_source      gobtpac.gobtpac_insert_source%TYPE,
                            p_ldap_user          gobtpac.gobtpac_ldap_user%TYPE,
                            p_data_origin        gobtpac.gobtpac_data_origin%TYPE,
                            p_salt               gobtpac.gobtpac_salt%TYPE,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers the all parameters

Parameters

p_pidm

Banner PIDM. NUMBER(8) Required Key

p_pin_disabled_ind

PIN disabled indicator. VARCHAR2(1)

	Y	Access to SCT Third Party Access products (Self-Service, VR, Kiosk) is denied.
	N	Access to SCT Third Party Access products (Self-Service, VR, Kiosk) is allowed.

p_usage_accept_ind

Terms of Usage accepted indicator. VARCHAR2(1)

	Y	The Terms of Usage page does not displays upon login to for the Self-Service products
	N	The Terms of Usage page displays upon login to for the Self-Service products

p_user

Oracle User ID of the last user who created or last modified the record. VARCHAR2(30)

p_pin

Personal Identification Number. It is used together with the Login ID to access SunGard Third Party products and other partner systems. It can be numeric or alphanumeric with a length between 1 and 99, depending on the institution's preference as defined on the Enterprise PIN Preferences table (GUBPPRF) VARCHAR2(255)

p_pin_exp_date

PIN expiration date. When it has a value and the date is in the past, a user attempting to access a Third Party product will be required to change their PIN. DATE

p_external_user

Unique internal ID which may be passed to the partner systems as a login ID and/or e-mail ID. Third party ID should be lowercase letters, numbers, periods, hyphens, and underscores. VARCHAR2(30)

p_question

Free-form question entered by a Web User to be used as a hint when trying to get their PIN reset. VARCHAR2(90)

p_response

Free-form response entered by a Web user to be used as an answer to the hint question when trying to get their PIN reset. VARCHAR2(30)

p_insert_source

Identifies the method used to create or update Third Party Access table. VARCHAR2(8)

	SELF	User changed the PIN record
	ADMIN	Administrator changed the PIN record
	SYSTEM	Record was changed by the logic in a process
	NULL	(default)

p_ldap_user

This will optionally store a non-LUMINIS LDAP user mapping for Banner. VARCHAR2(255)

p_data_origin

Source system that created or last updated the row. VARCHAR2(30)

p_salt

The salt value used for PIN encryption. VARCHAR2(128)

p_internal_record_id

Database ROWID.

p_validate

PROCEDURE p_validate(p_pidm             gobtpac.gobtpac_pidm%TYPE,
                     p_pin_disabled_ind gobtpac.gobtpac_pin_disabled_ind%TYPE DEFAULT NULL,
                     p_usage_accept_ind gobtpac.gobtpac_usage_accept_ind%TYPE DEFAULT NULL,
                     p_user             gobtpac.gobtpac_user%TYPE DEFAULT NULL,
                     p_pin              gobtpac.gobtpac_pin%TYPE DEFAULT NULL,
                     p_pin_exp_date     gobtpac.gobtpac_pin_exp_date%TYPE DEFAULT NULL,
                     p_external_user    gobtpac.gobtpac_external_user%TYPE DEFAULT NULL,
                     p_question         gobtpac.gobtpac_question%TYPE DEFAULT NULL,
                     p_response         gobtpac.gobtpac_response%TYPE DEFAULT NULL,
                     p_insert_source    gobtpac.gobtpac_insert_source%TYPE DEFAULT NULL,
                     p_ldap_user        gobtpac.gobtpac_ldap_user%TYPE DEFAULT NULL,
                     p_data_origin      gobtpac.gobtpac_data_origin%TYPE DEFAULT NULL,
                     p_salt             gobtpac.gobtpac_salt%TYPE DEFAULT NULL,
                     p_validate_pin     VARCHAR2,
                     p_pin_reusechk_ind VARCHAR2)

Validates all the data in the Third Party Access record.
The following edits are performed. All failed edit messages are appended and issued in a single application exception.

p_pidm, p_user cannot be null.
p_pin_disabled_ind, p_usage_accept_ind must be 'N' or 'Y'.
p_pin must be numeric if gubpprf_format is set to 'N' in GUBPPRF table.
p_pin must be between 1 and 99 characters long depending upon GUBPPRF.
p_pin must contain numeric characters if GUBPPRF_NUM_IND = 'Y'.
p_pin must contain alpha characters if GUBPPRF_CHAR_IND = 'Y'.
p_pin may not contain trailing spaces.
p_pin may not have been used within the past number of days as specified by gubpprf_reuse_days if p_pin_reusechk_ind = 'Y'.
p_external_user must be lowercase letters, numbers, periods, hyphens, and underscores.
p_external_user should be unique.

Parameters

p_pidm

Banner PIDM. NUMBER(8) Required Key

p_pin_disabled_ind

PIN disabled indicator. VARCHAR2(1)

	Y	Access to SCT Third Party Access products (Self-Service, VR, Kiosk) is denied.
	N	Access to SCT Third Party Access products (Self-Service, VR, Kiosk) is allowed.

p_usage_accept_ind

Terms of Usage accepted indicator. VARCHAR2(1)

	Y	The Terms of Usage page does not display upon login to for the Self-Service products
	N	The Terms of Usage page displays upon login to the Self-Service products

p_user

Oracle User ID of the last user who created or last modified the Third Party Access record. VARCHAR2(30)

p_pin

p_pin_exp_date

PIN expiration date. When it contains a value and that date is in the past, a user attempting to access a Third Party product will be required to change their PIN. DATE

p_external_user

Unique internal ID which may be passed to the partner systems as a login ID and/or e-mail ID. Third party ID should be lowercase letters, numbers, periods, hyphens, and underscores. VARCHAR2(30)

p_question

Free-form question entered by a Web User to be used as a hint when the user requests a PIN reset. VARCHAR2(90)

p_response

Free-form response entered by a Web user to be used as an answer to the hint question when the user requests PIN reset. VARCHAR2(30)

p_insert_source

Identifies the method used to create or update Third Party Access table. VARCHAR2(8)

	SELF	User changed the PIN record
	ADMIN	Administrator changed the PIN record
	SYSTEM	Record was changed by the logic in a process
	NULL	(default)

p_ldap_user

This will optionally store a non-LUMINIS LDAP user mapping for Banner. VARCHAR2(255)

p_data_origin

Source system that created or last updated the row. VARCHAR2(30)

p_salt

The salt value used for PIN encryption. VARCHAR2(128)

p_validate_pin

A value of 'Y' will check to make sure that the new PIN passes the validation rules as specified on GUBPPRF for character / numeric requirements, length, and reuse. VARCHAR2(01)

p_pin_reusechk_ind

A value of 'Y' will check to make sure that the new PIN has not been used within the past number of days as specified by gubpprf_reuse_days. VARCHAR2(01)

p_validate_pinrules

PROCEDURE p_validate_pinrules(p_pidm             gobtpac.gobtpac_pidm%TYPE,
                              p_pin              gobtpac.gobtpac_pin%TYPE DEFAULT NULL,
                              p_pin_reusechk_ind VARCHAR2,
                              error_message      OUT gb_common.err_type)

Validates the PIN according to the rules established on GUBPPRF.
The following edits are performed. All failed edit messages are appended and issued in a single application exception.

p_pin must be numeric if gubpprf_format is set to 'N' in GUBPPRF table.
p_pin must be between 1 and 99 characters long depending upon GUBPPRF.
p_pin must contain numeric characters if GUBPPRF_NUM_IND = 'Y'.
p_pin must contain alpha characters if GUBPPRF_CHAR_IND = 'Y'.
p_pin may not contain trailing spaces.
p_pin may not have been used within the past number of days as specified by GUBPPRF_REUSE_DAYS if p_pin_reusechk_ind = 'Y'.

Parameters

	p_pidm	Banner PIDM. NUMBER(8) Required Key
	p_pin	Personal Identification Number. It is used together with the Login ID to access SunGard Third Party products and other partner systems. It can be numeric or alphanumeric with a length between 1 and 99, depending on the institution's preference as defined on the Enterprise PIN Preferences table (GUBPPRF) VARCHAR2(255)
	p_pin_reusechk_ind	A value of 'Y' will check to make sure that the new PIN has not been used within the past number of days as specified by gubpprf_reuse_days. VARCHAR2(01)
	error_message	Any error messages generated during the validation will be returned. GB_COMMON.ERR_TYPE