|
Package gp_gercomm_rules Support subprograms for the GERCOMM (gp_gercomm). |
| 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 gercomm.gercomm_syst_code%TYPE,
p_ctyp_code gercomm.gercomm_ctyp_code%TYPE,
p_retp_code gercomm.gercomm_retp_code%TYPE,
p_notify_ind gercomm.gercomm_notify_ind%TYPE,
p_letr_notify_code gercomm.gercomm_letr_notify_code%TYPE,
p_bcc_pxy_ind gercomm.gercomm_bcc_pxy_ind%TYPE,
p_system_req_ind gercomm.gercomm_system_req_ind%TYPE,
p_user_id gercomm.gercomm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gercomm.gercomm_create_date%TYPE,
p_create_user gercomm.gercomm_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_retp_code |
Record type within system (e.g. Parent, Spouse, Employer, etc). VARCHAR2(30) Required Key | |
| p_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_letr_notify_code |
Letter code that will be used to notify the person. VARCHAR2(15) | |
| 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_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 gercomm.gercomm_syst_code%TYPE,
p_ctyp_code gercomm.gercomm_ctyp_code%TYPE,
p_retp_code gercomm.gercomm_retp_code%TYPE,
p_notify_ind gercomm.gercomm_notify_ind%TYPE,
p_letr_notify_code gercomm.gercomm_letr_notify_code%TYPE DEFAULT NULL,
p_bcc_pxy_ind gercomm.gercomm_bcc_pxy_ind%TYPE,
p_system_req_ind gercomm.gercomm_system_req_ind%TYPE DEFAULT NULL,
p_user_id gercomm.gercomm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date gercomm.gercomm_create_date%TYPE DEFAULT NULL,
p_create_user gercomm.gercomm_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_retp_code |
Record type within system (e.g. Parent, Spouse, Employer, etc). VARCHAR2(30) Required Key | |
| p_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_letr_notify_code |
Letter code that will be used to notify the person. VARCHAR2(15) | |
| 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_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) |