index

Package gb_pii_tables_rules

This package provides support subprograms for the pii_tables API.
These subprograms are p_register_entity and p_validate.  This is where the record validation is handled.

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 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.  VARCHAR(18) Required.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_table_name         gorfdpi.gorfdpi_table_name%TYPE,
                            p_column_name        gorfdpi.gorfdpi_column_name%TYPE,
                            p_sys_req_ind        gorfdpi.gorfdpi_sys_req_ind%TYPE,
                            p_active_ind         gorfdpi.gorfdpi_active_ind%TYPE,
                            p_user_id            gorfdpi.gorfdpi_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_driver_sql         gorfdpi.gorfdpi_driver_sql%TYPE,
                            p_internal_record_id VARCHAR2)

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

Parameters
p_table_name   Table name that the policy covers. VARCHAR2(30) Required Key.
p_column_name   Column name that the policy covers. VARCHAR2(30) Required Key.
p_sys_req_ind   Indicates whether or not this domain is system required. VARCHAR2(1) Required.
p_active_ind   Indicates if the policy is active ('Y') or inactive ('N'). VARCHAR2(1) Required.
p_user_id   The Oracle ID of the user who created or last updated the record. VARCHAR2(30) Required.
p_driver_sql   SQL statement that contains the SQL statement to execute the PII procedure. VARCHAR2(2000).
p_internal_record_id   Database ROWID. VARCHAR(18) Required.

p_validate 

PROCEDURE p_validate(p_table_name  gorfdpi.gorfdpi_table_name%TYPE,
                     p_column_name gorfdpi.gorfdpi_column_name%TYPE,
                     p_sys_req_ind gorfdpi.gorfdpi_sys_req_ind%TYPE,
                     p_active_ind  gorfdpi.gorfdpi_active_ind%TYPE,
                     p_user_id     gorfdpi.gorfdpi_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_driver_sql  gorfdpi.gorfdpi_driver_sql%TYPE DEFAULT NULL)

Validates all the data in the record.
The table name must exist in ALL_TABLES or ALL_VIEWS.
Indicators have valid values of "Y" or "N".

Parameters
p_table_name   Table name that the policy covers. VARCHAR2(30) Required Key.
p_column_name   Column name that the policy covers. VARCHAR2(30) Required Key.
p_sys_req_ind   Indicates whether or not this domain is system required. VARCHAR2(1) Required.
p_active_ind   Indicates if the policy is active ('Y') or inactive ('N'). VARCHAR2(1) Required.
p_user_id   The Oracle ID of the user who created or last updated the record. VARCHAR2(30) Required.
p_driver_sql   SQL statement that contains the SQL statement to execute the PII procedure. VARCHAR2(2000).