index

Package gb_domains_rules

This package provides support subprograms for the DOMAINS API, gb_domains.

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_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_fdmn_code          gobfdmn.gobfdmn_fdmn_code%TYPE,
                            p_table_name         gobfdmn.gobfdmn_table_name%TYPE,
                            p_fdtp_code          gobfdmn.gobfdmn_fdtp_code%TYPE,
                            p_sys_req_ind        gobfdmn.gobfdmn_sys_req_ind%TYPE,
                            p_enable_pii_ind     gobfdmn.gobfdmn_enable_pii_ind%TYPE,
                            p_user_id            gobfdmn.gobfdmn_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_pii_column_name    gobfdmn.gobfdmn_pii_column_name%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_fdmn_code   FGAC Domain code. Required Key
p_table_name   Table name that is the driver for the FGAC domain. Required
p_fdtp_code   FGAC Domain type code. Required
p_sys_req_ind   System required indicator: VARCHAR2(1) Required
Y   Data is system required
N   Data is not system required

p_enable_pii_ind   Enable the PII domain indicator: VARCHAR2(1) Required
Y   Enable the PII domain
N   Do not enable the PII domain

p_user_id   Oracle ID of the user who created or last updated a record. Optional
p_pii_column_name   Column name the PII process will use to match PIDM values to the driver table. VARCHAR2(30). Optional
p_internal_record_id   Database ROWID. Optional

p_validate 

PROCEDURE p_validate(p_fdmn_code       gobfdmn.gobfdmn_fdmn_code%TYPE,
                     p_table_name      gobfdmn.gobfdmn_table_name%TYPE,
                     p_fdtp_code       gobfdmn.gobfdmn_fdtp_code%TYPE,
                     p_sys_req_ind     gobfdmn.gobfdmn_sys_req_ind%TYPE,
                     p_enable_pii_ind  gobfdmn.gobfdmn_enable_pii_ind%TYPE,
                     p_user_id         gobfdmn.gobfdmn_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_pii_column_name gobfdmn.gobfdmn_pii_column_name%TYPE DEFAULT NULL)

Validates all the data in the record.

Parameters
p_fdmn_code   FGAC Domain code. Required Key
p_table_name   Table name that is the driver for the FGAC domain. Required
p_fdtp_code   FGAC Domain type code. Required
p_sys_req_ind   System required indicator: VARCHAR2(1). Required
Y   Data is system required
N   Data is not system required

p_enable_pii_ind   Enable the PII domain indicator: VARCHAR2(1). Required
Y   Enable the PII domain
N   Do not enable the PII domain

p_user_id   Oracle ID of the user who created or last updated a record. Optional
p_pii_column_name   Column name the PII process will use to match PIDM values to the driver table. VARCHAR2(30). Optional