Package nb_ea_group_user_rules This package provides messaging support and field validations for the Electronic Approvals User API. |
Program units |
p_register_entity | Registers 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 Electronic Approvals Group User record. |
p_register_entity
Procedure p_register_entity(p_operation_type IN NUMBER, p_internal_record_id IN gb_common.internal_record_id_type)
Registers 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 IN NUMBER, p_agrp_code IN ntragid.ntragid_agrp_code%TYPE, p_originator_user_id IN ntragid.ntragid_originator_user_id%TYPE, p_user_id IN ntragid.ntragid_user_id%TYPE DEFAULT gb_common.f_sct_user, p_data_origin IN ntragid.ntragid_data_origin%TYPE, p_internal_record_id IN 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_agrp_code |
A group code that identifies a group of approval categories when originating an Electronic Approval transaction. VARCHAR2(8) Required key. | |
p_originator_user_id |
User ID who will be granted access to the Electronic Approval Group Code. VARCHAR2(30) Required key. | |
p_user_id |
The Oracle ID of the person who entered the record. VARCHAR2(30). | |
p_data_origin |
Source system that created or updated the row. VARCHAR2(30). | |
p_internal_record_id |
Database ROWID. VARCHAR2(18) Required. |
p_validate
Procedure p_validate(p_agrp_code IN ntragid.ntragid_agrp_code%TYPE, p_originator_user_id IN ntragid.ntragid_originator_user_id%TYPE, p_user_id IN ntragid.ntragid_user_id%TYPE DEFAULT gb_common.f_sct_user, p_data_origin IN ntragid.ntragid_data_origin%TYPE DEFAULT NULL)
Validates all data in the Electronic Approvals Group User record.
Parameters |
p_agrp_code |
A group code that identifies a group of approval categories when originating an Electronic Approval transaction. VARCHAR2(8) Required key. | |
p_originator_user_id |
User ID who will be granted access to the Electronic Approval Group Code. VARCHAR2(30) Required key. | |
p_user_id |
The Oracle ID of the person who entered the record. VARCHAR2(30). | |
p_data_origin |
Source system that created or updated the row. VARCHAR2(30). |