index

Package gb_vbs_tables_rules

This package provides support subprograms for the Value Based Security Tables VBS TABLES API, gb_vbs_tables.
The subprograms are p_register_entity and p_validate.  This is where the record validation is handled.

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 operations.

Parameters
p_internal_record_id   Database ROWID.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_fdmn_code          gorfdpl.gorfdpl_fdmn_code%TYPE,
                            p_table_name         gorfdpl.gorfdpl_table_name%TYPE,
                            p_sys_req_ind        gorfdpl.gorfdpl_sys_req_ind%TYPE,
                            p_active_ind         gorfdpl.gorfdpl_active_ind%TYPE,
                            p_user_id            gorfdpl.gorfdpl_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_driver_sql         gorfdpl.gorfdpl_driver_sql%TYPE,
                            p_internal_record_id VARCHAR2)

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

Parameters
p_fdmn_code   FGAC Domain code.
p_table_name   Table name that the policy covers.
p_sys_req_ind   Indicates whether or not this domain is system required.
p_active_ind   Indicates whether or not this domain is active.
p_user_id   The Oracle ID of the user who created or last updated the record.
p_driver_sql   SQL statement that links the table to the FDMN driver table.
p_internal_record_id   Database ROWID.

p_validate 

PROCEDURE p_validate(p_fdmn_code   gorfdpl.gorfdpl_fdmn_code%TYPE,
                     p_table_name  gorfdpl.gorfdpl_table_name%TYPE,
                     p_sys_req_ind gorfdpl.gorfdpl_sys_req_ind%TYPE,
                     p_active_ind  gorfdpl.gorfdpl_active_ind%TYPE,
                     p_user_id     gorfdpl.gorfdpl_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_driver_sql  gorfdpl.gorfdpl_driver_sql%TYPE DEFAULT NULL)

Validates all the data in the record.
 
All parameters except the driver SQL statement are required.
Domain Code must exist in GTVFDMN.
Table Name is validated against ALL_TABLES or ALL_VIEWS.
System Required and Active indicators must be 'Y' or 'N'.

Parameters
p_fdmn_code   FGAC Domain code.  Required.
p_table_name   Table name that the policy covers.  Required.
p_sys_req_ind   Indicates whether or not this domain is system required ('Y') or optional ('N').  Required.
p_active_ind   Indicates whether or not this domain is active.  Required.
p_user_id   The Oracle ID of the user who created or last updated the record.  Optional.
p_driver_sql   SQL statement that links the table to the FDMN driver table.  Optional.