|
Package gp_geropts_rules Support subprograms for the GEROPTS (gp_geropts). |
| 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 geropts.geropts_syst_code%TYPE,
p_retp_code geropts.geropts_retp_code%TYPE,
p_otyp_code geropts.geropts_otyp_code%TYPE,
p_user_field_value geropts.geropts_user_field_value%TYPE,
p_start_date geropts.geropts_start_date%TYPE,
p_end_date geropts.geropts_end_date%TYPE,
p_user_id geropts.geropts_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date geropts.geropts_create_date%TYPE,
p_create_user geropts.geropts_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 |
Systems that are using the general tables (e.g. "Proxy", "event management"). VARCHAR2(30) Required Key | |
| p_retp_code |
Record type within system (e.g. Parent, Spouse, Employer, etc). VARCHAR2(30) Required Key | |
| p_otyp_code |
Option type we will be defining for the system/record type combination. VARCHAR2(30) Required Key | |
| p_user_field_value |
The option value, suitably edited, for this combination. VARCHAR2(60) | |
| p_start_date |
Date that the option starts being in use. DATE | |
| p_end_date |
Date that the option stops being in use. DATE | |
| 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 geropts.geropts_syst_code%TYPE,
p_retp_code geropts.geropts_retp_code%TYPE,
p_otyp_code geropts.geropts_otyp_code%TYPE,
p_user_field_value geropts.geropts_user_field_value%TYPE DEFAULT NULL,
p_start_date geropts.geropts_start_date%TYPE DEFAULT NULL,
p_end_date geropts.geropts_end_date%TYPE DEFAULT NULL,
p_user_id geropts.geropts_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_create_date geropts.geropts_create_date%TYPE DEFAULT NULL,
p_create_user geropts.geropts_create_user%TYPE DEFAULT gb_common.f_sct_user)
Validates all data in the record.
| Parameters |
| p_syst_code |
Systems that are using the general tables (e.g. "Proxy", "event management"). VARCHAR2(30) Required Key | |
| p_retp_code |
Record type within system (e.g. Parent, Spouse, Employer, etc). VARCHAR2(30) Required Key | |
| p_otyp_code |
Option type we will be defining for the system/record type combination. VARCHAR2(30) Required Key | |
| p_user_field_value |
The option value, suitably edited, for this combination. VARCHAR2(60) | |
| p_start_date |
Date that the option starts being in use. DATE | |
| p_end_date |
Date that the option stops being in use. DATE | |
| 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) |