|
Package sb_mass_entry_column_rules Support subprograms for the Mass Entry Column API (sb_mass_entry_column). |
| Program units |
| f_parent_exists | |
| 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 record. |
f_parent_exists
Function f_parent_exists(p_form_name sormecl.sormecl_form_name%TYPE,
p_add_user_id sormecl.sormecl_add_user_id%TYPE,
p_add_date sormecl.sormecl_add_date%TYPE)
RETURN VARCHAR2
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_internal_record_id 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 NUMBER,
p_add_user_id sormecl.sormecl_add_user_id%TYPE,
p_add_date sormecl.sormecl_add_date%TYPE,
p_form_name sormecl.sormecl_form_name%TYPE,
p_data_origin sormecl.sormecl_data_origin%TYPE,
p_user_id sormecl.sormecl_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_mecl_code sormecl.sormecl_mecl_code%TYPE,
p_search_update_cde sormecl.sormecl_search_update_cde%TYPE,
p_value sormecl.sormecl_value%TYPE,
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_add_user_id |
ID of the user who initiated the mass entry. VARCHAR2(30) Required Key | |
| p_add_date |
Date and timestamp the mass entry was initiated. DATE Required Key | |
| p_form_name |
Mass entry form name. VARCHAR2(30) Required Key | |
| p_data_origin |
Data origin of the insert or update to the record. VARCHAR2(30) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_mecl_code |
Column used in the mass entry search and update processing. VARCHAR2(30) Required Key | |
| p_search_update_cde |
A code value that defines if the column is being used for search (S) or will be part of the update(U). VARCHAR2(1) Required Key | |
| p_value |
VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_add_user_id sormecl.sormecl_add_user_id%TYPE,
p_add_date sormecl.sormecl_add_date%TYPE,
p_form_name sormecl.sormecl_form_name%TYPE,
p_data_origin sormecl.sormecl_data_origin%TYPE,
p_user_id sormecl.sormecl_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_mecl_code sormecl.sormecl_mecl_code%TYPE,
p_search_update_cde sormecl.sormecl_search_update_cde%TYPE,
p_value sormecl.sormecl_value%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_add_user_id |
ID of the user who initiated the mass entry. VARCHAR2(30) Required Key | |
| p_add_date |
Date and timestamp the mass entry was initiated. DATE Required Key | |
| p_form_name |
Mass entry form name. VARCHAR2(30) Required Key | |
| p_data_origin |
Data origin of the insert or update to the record. VARCHAR2(30) Required | |
| p_user_id |
Most recent user to create or update the record. VARCHAR2(30) Required | |
| p_mecl_code |
Column used in the mass entry search and update processing. VARCHAR2(30) Required Key | |
| p_search_update_cde |
A code value that defines if the column is being used for search (S) or will be part of the update(U). VARCHAR2(1) Required Key | |
| p_value |
VARCHAR2(30) |