index

Package gb_bus_prof_rule_rules

This package provides support subprograms for the BUSINESS PROFILE RULES API, gb_bus_prof_rule.
The subprograms, p_register_entity and p_validate, handle the record validation.

Program units
f_parent_exists   Checks for the existence of a parent record.
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.

f_parent_exists 

FUNCTION f_parent_exists(p_fgac_code  gorfgbp.gorfgbp_fgac_code%TYPE,
                         p_fdmn_code  gorfgbp.gorfgbp_fdmn_code%TYPE,
                         p_fprd_seqno gorfgbp.gorfgbp_fprd_seqno%TYPE)
  RETURN VARCHAR2

Checks for the existence of a parent record.

Parameters
p_fgac_code   FGAC group code.
p_fdmn_code   FGAC domain code.
p_fprd_seqno   One-up number per predicate and domain combination to allow multiple predicates per domain.

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 only the ROWID 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          gorfgbp.gorfgbp_fgac_code%TYPE,
                            p_fdmn_code          gorfgbp.gorfgbp_fdmn_code%TYPE,
                            p_fprd_seqno         gorfgbp.gorfgbp_fprd_seqno%TYPE,
                            p_fbpr_code          gorfgbp.gorfgbp_fbpr_code%TYPE,
                            p_select_ind         gorfgbp.gorfgbp_select_ind%TYPE,
                            p_insert_ind         gorfgbp.gorfgbp_insert_ind%TYPE,
                            p_update_ind         gorfgbp.gorfgbp_update_ind%TYPE,
                            p_delete_ind         gorfgbp.gorfgbp_delete_ind%TYPE,
                            p_user_id            gorfgbp.gorfgbp_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. Valid values are on GTVFGAC.
p_fdmn_code   FGAC domain code. Valid values are on GTVFDMN.
p_fprd_seqno   One-up number per predicate and domain combination to allow multiple predicates per domain.
p_fbpr_code   FGAC business profile code.  Valid values are on GTVFBPR.
p_select_ind   Indicates if the business profile is for select access.
p_insert_ind   Indicates if the business profile is for insert access.
p_update_ind   Indicates if the business profile is for update access.
p_delete_ind   Indicates if the business profile is for delete access.
p_user_id   The Oracle ID of the user who created or last updated the record.
p_internal_record_id   Database ROWID.

p_validate 

PROCEDURE p_validate(p_fgac_code  gorfgbp.gorfgbp_fgac_code%TYPE,
                     p_fdmn_code  gorfgbp.gorfgbp_fdmn_code%TYPE,
                     p_fprd_seqno gorfgbp.gorfgbp_fprd_seqno%TYPE,
                     p_fbpr_code  gorfgbp.gorfgbp_fbpr_code%TYPE,
                     p_select_ind gorfgbp.gorfgbp_select_ind%TYPE,
                     p_insert_ind gorfgbp.gorfgbp_insert_ind%TYPE,
                     p_update_ind gorfgbp.gorfgbp_update_ind%TYPE,
                     p_delete_ind gorfgbp.gorfgbp_delete_ind%TYPE,
                     p_user_id    gorfgbp.gorfgbp_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
Valid values for indicators are 'Y' or 'N'.
Valid values for the sequence number are 1 to 9999.
The primary key must exist in table GORFPRD to be entered here.
Foreign keys are checked for the group, domain and business profile code.

Parameters
p_fgac_code   FGAC group code.
p_fdmn_code   FGAC domain code.
p_fprd_seqno   One-up number per predicate and domain combination to allow multiple predicates per domain.
p_fbpr_code   FGAC business profile code.
p_select_ind   Indicates if the business profile is for select access.
p_insert_ind   Indicates if the business profile is for insert access.
p_update_ind   Indicates if the business profile is for update access.
p_delete_ind   Indicates if the business profile is for delete access.
p_user_id   The Oracle ID of the user who created or last updated the record.