|
Package gp_gpbeltr_rules Support subprograms for the GPBELTR (gp_gpbeltr). |
| 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_syst_code gpbeltr.gpbeltr_syst_code%TYPE,
p_ctyp_code gpbeltr.gpbeltr_ctyp_code%TYPE,
p_ctyp_url gpbeltr.gpbeltr_ctyp_url%TYPE,
p_ctyp_exp_date gpbeltr.gpbeltr_ctyp_exp_date%TYPE,
p_ctyp_exe_date gpbeltr.gpbeltr_ctyp_exe_date%TYPE,
p_transmit_date gpbeltr.gpbeltr_transmit_date%TYPE,
p_proxy_idm gpbeltr.gpbeltr_proxy_idm%TYPE,
p_proxy_old_data gpbeltr.gpbeltr_proxy_old_data%TYPE,
p_proxy_new_data gpbeltr.gpbeltr_proxy_new_data%TYPE,
p_person_pidm gpbeltr.gpbeltr_person_pidm%TYPE,
p_user_id gpbeltr.gpbeltr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gpbeltr.gpbeltr_create_date%TYPE,
p_create_user gpbeltr.gpbeltr_create_user%TYPE DEFAULT gb_common.f_sct_user,
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_syst_code |
What system does this belong to. VARCHAR2(30) Required | |
| p_ctyp_code |
Communications type within the system. VARCHAR2(30) Required | |
| p_ctyp_url |
URL to be executed by recipient to complete communication loop. VARCHAR2(256) | |
| p_ctyp_exp_date |
Date after which the CTYP_URL is expired and no longer valid. DATE | |
| p_ctyp_exe_date |
Date on which the CTYP_URL was executed by the recipient making it invalid for reuse. DATE | |
| p_transmit_date |
Date that letter was sent. DATE | |
| p_proxy_idm |
Proxy identifier. NUMBER(8) Required | |
| p_proxy_old_data |
Used to store old e-mail address. VARCHAR2(128) | |
| p_proxy_new_data |
Used to store old e-mail address. VARCHAR2(128) | |
| p_person_pidm |
This will be the pidm of the person initiating the proxy relationship. NUMBER(8) | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_create_date |
This field contains date new record created. DATE | |
| p_create_user |
This field contains Banner User ID which created new record. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
PROCEDURE p_validate(p_syst_code gpbeltr.gpbeltr_syst_code%TYPE,
p_ctyp_code gpbeltr.gpbeltr_ctyp_code%TYPE,
p_ctyp_url gpbeltr.gpbeltr_ctyp_url%TYPE DEFAULT NULL,
p_ctyp_exp_date gpbeltr.gpbeltr_ctyp_exp_date%TYPE DEFAULT NULL,
p_ctyp_exe_date gpbeltr.gpbeltr_ctyp_exe_date%TYPE DEFAULT NULL,
p_transmit_date gpbeltr.gpbeltr_transmit_date%TYPE DEFAULT NULL,
p_proxy_idm gpbeltr.gpbeltr_proxy_idm%TYPE,
p_proxy_old_data gpbeltr.gpbeltr_proxy_old_data%TYPE DEFAULT NULL,
p_proxy_new_data gpbeltr.gpbeltr_proxy_new_data%TYPE DEFAULT NULL,
p_person_pidm gpbeltr.gpbeltr_person_pidm%TYPE DEFAULT NULL,
p_user_id gpbeltr.gpbeltr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gpbeltr.gpbeltr_create_date%TYPE DEFAULT NULL,
p_create_user gpbeltr.gpbeltr_create_user%TYPE DEFAULT gb_common.f_sct_user)
Validates all data in the record.
| Parameters |
| p_syst_code |
What system does this belong to. VARCHAR2(30) Required | |
| p_ctyp_code |
Communications type within the system. VARCHAR2(30) Required | |
| p_ctyp_url |
URL to be executed by recipient to complete communication loop. VARCHAR2(256) | |
| p_ctyp_exp_date |
Date after which the CTYP_URL is expired and no longer valid. DATE | |
| p_ctyp_exe_date |
Date on which the CTYP_URL was executed by the recipient making it invalid for reuse. DATE | |
| p_transmit_date |
Date that letter was sent. DATE | |
| p_proxy_idm |
Proxy identifier. NUMBER(8) Required | |
| p_proxy_old_data |
Used to store old e-mail address. VARCHAR2(128) | |
| p_proxy_new_data |
Used to store old e-mail address. VARCHAR2(128) | |
| p_person_pidm |
This will be the pidm of the person initiating the proxy relationship. NUMBER(8) | |
| p_user_id |
The ID for the user that most recently updated the record. VARCHAR2(30) | |
| p_create_date |
This field contains date new record created. DATE | |
| p_create_user |
This field contains Banner User ID which created new record. VARCHAR2(30) |