index

Package gb_group_rules_rules

This package provides support subprograms for the GROUP RULES API, gb_group_rules.
These subprograms, p_register_entity and p_validate, perform record validation.

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_fgac_code          gobfgac.gobfgac_fgac_code%TYPE,
                            p_active_ind         gobfgac.gobfgac_active_ind%TYPE,
                            p_eff_date           gobfgac.gobfgac_eff_date%TYPE,
                            p_user_id            gobfgac.gobfgac_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_fgac_code   FGAC group code.
p_active_ind   Indicates if the FGAC rule is active.  Valid values are 'Y' - Active and 'N' - Inactive.
p_eff_date   Date when the FGAC rule becomes effective.
p_user_id   The Oracle User ID, as returned by the gb_common.f_sct_user function, of the user who created or last updated the record.
p_internal_record_id   Database ROWID.

p_validate 

PROCEDURE p_validate(p_fgac_code  gobfgac.gobfgac_fgac_code%TYPE,
                     p_active_ind gobfgac.gobfgac_active_ind%TYPE,
                     p_eff_date   gobfgac.gobfgac_eff_date%TYPE,
                     p_user_id    gobfgac.gobfgac_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
 
FGAC Code must exist in GTVFGAC, and the Active indicator must be Y or N.

Parameters
p_fgac_code   FGAC group code.
p_active_ind   Indicates if the FGAC rule is active.  Valid values are 'Y' - Active and 'N' - Inactive.
p_eff_date   Date when the FGAC rule is active.
p_user_id   The Oracle User ID, as returned by the gb_common.f_sct_user function, of the user who created or last updated the record.