|
Package gp_gprhist_rules Support subprograms for the GPRHIST (gp_gprhist). |
| 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_person_pidm gprhist.gprhist_person_pidm%TYPE,
p_page_name gprhist.gprhist_page_name%TYPE,
p_old_auth_ind gprhist.gprhist_old_auth_ind%TYPE,
p_new_auth_ind gprhist.gprhist_new_auth_ind%TYPE,
p_create_user gprhist.gprhist_create_user%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gprhist.gprhist_create_date%TYPE,
p_user_id gprhist.gprhist_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_proxy_idm gprhist.gprhist_proxy_idm%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.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_person_pidm |
General Person PIDM of person involved in this activity. NUMBER(8) Required | |
| p_page_name |
This is the Banner Self-Service page name in package.procedure format. VARCHAR2(120) Required | |
| p_old_auth_ind |
The value "Y" means the person has authorized the proxy to see the page on their behalf. VARCHAR2(1) | |
| p_new_auth_ind |
The value "N" means the person has revoked authorization. VARCHAR2(1) | |
| p_create_user |
Username responsible for initial creation. VARCHAR2(30) | |
| p_create_date |
Date when the record was initially created. DATE | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_proxy_idm |
See GPBPRXY. NUMBER(8) Required | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_person_pidm gprhist.gprhist_person_pidm%TYPE,
p_page_name gprhist.gprhist_page_name%TYPE,
p_old_auth_ind gprhist.gprhist_old_auth_ind%TYPE DEFAULT NULL,
p_new_auth_ind gprhist.gprhist_new_auth_ind%TYPE DEFAULT NULL,
p_create_user gprhist.gprhist_create_user%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gprhist.gprhist_create_date%TYPE DEFAULT NULL,
p_user_id gprhist.gprhist_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_proxy_idm gprhist.gprhist_proxy_idm%TYPE)
Validates all data in the record.
| Parameters |
| p_person_pidm |
General Person PIDM of person involved in this activity. NUMBER(8) Required | |
| p_page_name |
This is the Banner Self-Service page name in package.procedure format. VARCHAR2(120) Required | |
| p_old_auth_ind |
The value "Y" means the person has authorized the proxy to see the page on their behalf. VARCHAR2(1) | |
| p_new_auth_ind |
The value "N" means the person has revoked authorization. VARCHAR2(1) | |
| p_create_user |
Username responsible for initial creation. VARCHAR2(30) | |
| p_create_date |
Date when the record was initially created. DATE | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_proxy_idm |
See GPBPRXY. NUMBER(8) Required |