index

Package gb_displaycolumns_rules

This package provides support subprograms for the DISPLAY COLUMNS API, gb_displaycolumns.
 
Forms, Blocks and Columns that Display Mask can be defined.
 
This table includes all items on a Form which the display masks can be defined.

Program units
p_register_entity   Registers the attribute/value pairs to the message cache.
p_register_entity   Registers the attribute/value pairs to the message cache.
p_validate   Validates all the data in the record.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature uses the ROWID only, for the delete operation.

Parameters
p_operation_type   Type of DML operation: create, update, or delete. NUMBER. Required
p_internal_record_id   Database ROWID. Required

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_objs_code          gordmcl.gordmcl_objs_code%TYPE,
                            p_block_name         gordmcl.gordmcl_block_name%TYPE,
                            p_column_name        gordmcl.gordmcl_column_name%TYPE,
                            p_sys_req_ind        gordmcl.gordmcl_sys_req_ind%TYPE,
                            p_data_type_cde      gordmcl.gordmcl_data_type_cde%TYPE,
                            p_data_length        gordmcl.gordmcl_data_length%TYPE,
                            p_user_id            gordmcl.gordmcl_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_query_column       gordmcl.gordmcl_query_column%TYPE,
                            p_numeric_precision  gordmcl.gordmcl_numeric_precision%TYPE,
                            p_internal_record_id VARCHAR2)

Registers the attribute/value pairs to the message cache.
This signature registers the all parameters

Parameters
p_operation_type   Type of DML operation: create, update, or delete. NUMBER. Required
p_objs_code   Object which the display rules will be applied to. VARCHAR2(30). Required Key
p_block_name   Block Name. VARCHAR2(30). Required Key
p_column_name   Column Name. VARCHAR2(30). Required Key
p_sys_req_ind   System required indicator. VARCHAR2(1). Required
Y   Data is required for the system.
N   Data is not required for the system.

p_data_type_cde   Value to indicate the type of data. VARCHAR2(1). Required
C   Character
N   Numeric
D   Date
B   Button

p_data_length   Length of the item. NUMBER(3). Required
p_user_id   Oracle ID of the user who created or last updated a record. VARCHAR2(30). Required
p_query_column   Column name that has the data that will be reformatted. This is used only if the column to be reformatted is a text field. * The format mask procedure will actually replace values and assign the reformatted data to the field specified in gordmsk_column_name. VARCHAR2(30). Optional
p_numeric_precision   Number of digits allowed if the item is a numeric data type. NUMBER(3). Optional
p_internal_record_id   Database ROWID. Optional

p_validate 

PROCEDURE p_validate(p_objs_code         gordmcl.gordmcl_objs_code%TYPE,
                     p_block_name        gordmcl.gordmcl_block_name%TYPE,
                     p_column_name       gordmcl.gordmcl_column_name%TYPE,
                     p_sys_req_ind       gordmcl.gordmcl_sys_req_ind%TYPE,
                     p_data_type_cde     gordmcl.gordmcl_data_type_cde%TYPE,
                     p_data_length       gordmcl.gordmcl_data_length%TYPE,
                     p_user_id           gordmcl.gordmcl_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_query_column      gordmcl.gordmcl_query_column%TYPE DEFAULT NULL,
                     p_numeric_precision gordmcl.gordmcl_numeric_precision%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_objs_code   Object to which the display rules will be applied. VARCHAR2(30). Required Key
p_block_name   Block Name. VARCHAR2(30). Required Key
p_column_name   Column Name. VARCHAR2(30). Required Key
p_sys_req_ind   System required indicator. VARCHAR2(1). Required
Y   Data is required for the system.
N   Data is not required for the system.

p_data_type_cde   Value to indicate the type of data. VARCHAR2(1). Required
C   Character
N   Numeric
D   Date
B   Button

p_data_length   Length of the item. NUMBER(3). Required
p_user_id   Oracle ID of the user who created or last updated a record. VARCHAR2(30). Optional
p_query_column   Column name that has the data that will be reformatted. This is used only if the column to be reformatted is a text field. The format mask procedure will actually replace values and assign the reformatted data to the field specified in gordmsk_column_name. VARCHAR2(30). Optional
p_numeric_precision   Number of digits allowed if the item is a numeric data type. NUMBER(3). Optional