index

Package gb_vbs_predicate_rules

This package provides support subprograms for the vbs_predicate API.
The subprograms are p_register_entity and p_validate, and they perform record validation.

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

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_internal_record_id VARCHAR2)

Registers the attribute and value pairs to the message cache.
This signature uses the ROWID only for the delete operations.

Parameters
p_internal_record_id   Database ROWID.  Required.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_fgac_code          gorfprd.gorfprd_fgac_code%TYPE,
                            p_fdmn_code          gorfprd.gorfprd_fdmn_code%TYPE,
                            p_seqno              gorfprd.gorfprd_seqno%TYPE,
                            p_user_id            gorfprd.gorfprd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_predicate          gorfprd.gorfprd_predicate%TYPE,
                            p_internal_record_id VARCHAR2)

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

Parameters
p_fgac_code   FGAC group code.  Required.
p_fdmn_code   FGAC domain code.  Required.
p_seqno   One-up number that uniquely identifies each predicate if there are multiple predicates per domain and rule.  Required.
p_user_id   Oracle User ID of the user who created or last updated a record.
p_predicate   SQL statement that will be appended to the originating SQL to restrict row level access. The predicate is processed by ORACLE FGAC and appended appropriately. The driver table for the predicate is the GOBFDMN_TABLE_NAME for the GORFPRD_FDMN_CODE value.  Optional.
p_internal_record_id   Database ROWID.  Required.

p_validate 

PROCEDURE p_validate(p_fgac_code gorfprd.gorfprd_fgac_code%TYPE,
                     p_fdmn_code gorfprd.gorfprd_fdmn_code%TYPE,
                     p_seqno     gorfprd.gorfprd_seqno%TYPE,
                     p_user_id   gorfprd.gorfprd_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_predicate gorfprd.gorfprd_predicate%TYPE DEFAULT NULL)

Validates all the data in the predicate record.
The group code must exist in GTVFGAC.
The domain code must exist in GTVFDMN and its GOBFDMN_FDTP_CODE must equal "VBS".

Parameters
p_fgac_code   FGAC group code.  Required.
p_fdmn_code   FGAC domain code.  Required.
p_seqno   One-up number that uniquely identifies each predicate if there are multiple predicates per domain and rule.  Required.
p_user_id   Oracle User ID of the user who created or last updated a record.  Optional.
p_predicate   SQL statement that will be appended to the originating SQL to restrict row level access. The predicate is processed by ORACLE FGAC and appended appropriately. The driver table for the predicate is the GOBFDMN_TABLE_NAME for the GORFPRD_FDMN_CODE value.  Optional.