index

Package gb_domaintype_rules

This package provides support subprograms for the DOMAIN TYPE API, gb_domaintype.
 
The validation procedure is called by the API, but may also be called directly by an application if data validation is needed prior to calling the API.
 
The API will always run the validation checks again.

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 procedure passes the operation type and a set of constant strings and data values to the messaging system. The constants represent the name of each data element and are defined in the DML package specification.
The procedure is overloaded so the API p_delete has a signature to call that only requires the operation and ROWID.
This signature uses the ROWID only for the delete operations.

Parameters
p_operation_type   Type of DML operation, either create, upate, or delete. NUMBER Required
p_internal_record_id   Database ROWID. Optional

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_fdtp_code          gobfdtp.gobfdtp_fdtp_code%TYPE,
                            p_predicate_ind      gobfdtp.gobfdtp_predicate_ind%TYPE,
                            p_sys_req_ind        gobfdtp.gobfdtp_sys_req_ind%TYPE,
                            p_user_id            gobfdtp.gobfdtp_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            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, either create, upate, or delete. NUMBER Required
p_fdtp_code   FGAC Domain type code. Required Key
p_predicate_ind   Predicate required indicator. Required
Y   Predicate is required for the domain type
N   Predicate is not required for the domain type

p_sys_req_ind   Indicates whether or not this type is system required.  Required
Y   Data is required for the system
N   Data is not required for the system

p_user_id   Oracle ID of the user who created or last update the record. Optional
p_internal_record_id   Database ROWID. Optional

p_validate 

PROCEDURE p_validate(p_fdtp_code     gobfdtp.gobfdtp_fdtp_code%TYPE,
                     p_predicate_ind gobfdtp.gobfdtp_predicate_ind%TYPE,
                     p_sys_req_ind   gobfdtp.gobfdtp_sys_req_ind%TYPE,
                     p_user_id       gobfdtp.gobfdtp_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.

Parameters
p_fdtp_code   FGAC Domain type code. Required Key
p_predicate_ind   Predicate required indicator. Required
Y   Predicate is required for the domain type
N   Predicate is not required for the domain type

p_sys_req_ind   Indicates whether or not this type is system required. Required
Y   Data is required for the system
N   Data is not required for the system

p_user_id   Oracle ID of the user who created or last updated the record. Optional