|
Package gp_gebcomm_rules Support subprograms for the GEBCOMM (gp_gebcomm). |
| 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 gebcomm.gebcomm_syst_code%TYPE,
p_ctyp_code gebcomm.gebcomm_ctyp_code%TYPE,
p_per_notify_ind gebcomm.gebcomm_per_notify_ind%TYPE,
p_admin_notify_ind gebcomm.gebcomm_admin_notify_ind%TYPE,
p_proxy_notify_ind gebcomm.gebcomm_proxy_notify_ind%TYPE,
p_letr_per_noti_code gebcomm.gebcomm_letr_per_noti_code%TYPE,
p_letr_adm_noti_code gebcomm.gebcomm_letr_adm_noti_code%TYPE,
p_letr_pxy_noti_code gebcomm.gebcomm_letr_pxy_noti_code%TYPE,
p_bcc_per_ind gebcomm.gebcomm_bcc_per_ind%TYPE,
p_bcc_pxy_ind gebcomm.gebcomm_bcc_pxy_ind%TYPE,
p_host_name gebcomm.gebcomm_host_name%TYPE,
p_admin_email gebcomm.gebcomm_admin_email%TYPE,
p_system_req_ind gebcomm.gebcomm_system_req_ind%TYPE,
p_user_id gebcomm.gebcomm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gebcomm.gebcomm_create_date%TYPE,
p_create_user gebcomm.gebcomm_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 |
Base record for a system and communications type. VARCHAR2(30) Required Key | |
| p_ctyp_code |
Communications type within the system. VARCHAR2(30) Required Key | |
| p_per_notify_ind |
Y (yes) means to send the communication to the person involved; N (no) means to not send the communication. VARCHAR2(1) Required | |
| p_admin_notify_ind |
Y (yes) means to send the communication to the administrator; N (no) means to not send the communication. VARCHAR2(1) Required | |
| p_proxy_notify_ind |
Y (yes) means to send the communication to the proxy; N (no) means to not send the communication; this will be only for communications where the GTVCTYP flag = N. VARCHAR2(1) Required | |
| p_letr_per_noti_code |
Letter code that will be used to notify the person. VARCHAR2(15) | |
| p_letr_adm_noti_code |
Letter code that will be used to notify the administrator. VARCHAR2(15) | |
| p_letr_pxy_noti_code |
Letter code that will be used to notify the proxy. VARCHAR2(15) | |
| p_bcc_per_ind |
Y (yes) means the administrator should be bcc on letters sent to the person; N (no) means to not bcc the administrator. VARCHAR2(1) Required | |
| p_bcc_pxy_ind |
Y (yes) means the administrator should be bcc on letters sent to the proxy; N (no) means to not bcc the administrator. VARCHAR2(1) Required | |
| p_host_name |
Host name to be used when an email is sent for this system and communications type. VARCHAR2(30) | |
| p_admin_email |
Email to use for the administrator emails. VARCHAR2(128) | |
| p_system_req_ind |
System required indicator (informational only). VARCHAR2(1) | |
| 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 gebcomm.gebcomm_syst_code%TYPE,
p_ctyp_code gebcomm.gebcomm_ctyp_code%TYPE,
p_per_notify_ind gebcomm.gebcomm_per_notify_ind%TYPE,
p_admin_notify_ind gebcomm.gebcomm_admin_notify_ind%TYPE,
p_proxy_notify_ind gebcomm.gebcomm_proxy_notify_ind%TYPE,
p_letr_per_noti_code gebcomm.gebcomm_letr_per_noti_code%TYPE DEFAULT NULL,
p_letr_adm_noti_code gebcomm.gebcomm_letr_adm_noti_code%TYPE DEFAULT NULL,
p_letr_pxy_noti_code gebcomm.gebcomm_letr_pxy_noti_code%TYPE DEFAULT NULL,
p_bcc_per_ind gebcomm.gebcomm_bcc_per_ind%TYPE,
p_bcc_pxy_ind gebcomm.gebcomm_bcc_pxy_ind%TYPE,
p_host_name gebcomm.gebcomm_host_name%TYPE DEFAULT NULL,
p_admin_email gebcomm.gebcomm_admin_email%TYPE DEFAULT NULL,
p_system_req_ind gebcomm.gebcomm_system_req_ind%TYPE DEFAULT NULL,
p_user_id gebcomm.gebcomm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gebcomm.gebcomm_create_date%TYPE DEFAULT NULL,
p_create_user gebcomm.gebcomm_create_user%TYPE DEFAULT gb_common.f_sct_user)
Validates all data in the record.
| Parameters |
| p_syst_code |
Base record for a system and communications type. VARCHAR2(30) Required Key | |
| p_ctyp_code |
Communications type within the system. VARCHAR2(30) Required Key | |
| p_per_notify_ind |
Y (yes) means to send the communication to the person involved; N (no) means to not send the communication. VARCHAR2(1) Required | |
| p_admin_notify_ind |
Y (yes) means to send the communication to the administrator; N (no) means to not send the communication. VARCHAR2(1) Required | |
| p_proxy_notify_ind |
Y (yes) means to send the communication to the proxy; N (no) means to not send the communication; this will be only for communications where the GTVCTYP flag = N. VARCHAR2(1) Required | |
| p_letr_per_noti_code |
Letter code that will be used to notify the person. VARCHAR2(15) | |
| p_letr_adm_noti_code |
Letter code that will be used to notify the administrator. VARCHAR2(15) | |
| p_letr_pxy_noti_code |
Letter code that will be used to notify the proxy. VARCHAR2(15) | |
| p_bcc_per_ind |
Y (yes) means the administrator should be bcc on letters sent to the person; N (no) means to not bcc the administrator. VARCHAR2(1) Required | |
| p_bcc_pxy_ind |
Y (yes) means the administrator should be bcc on letters sent to the proxy; N (no) means to not bcc the administrator. VARCHAR2(1) Required | |
| p_host_name |
Host name to be used when an email is sent for this system and communications type. VARCHAR2(30) | |
| p_admin_email |
Email to use for the administrator emails. VARCHAR2(128) | |
| p_system_req_ind |
System required indicator (informational only). VARCHAR2(1) | |
| 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) |