index

Package gb_fgac_user_rule_rules

This package provides support subprograms for the FGAC USER RULE API, gb_fgac_user_rule.
These subprograms, p_register_entity and p_validate, are where the record validation is handled.

Program units
f_parent_exists   Checks to see if a parent record exists.
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  gorfgus.gorfgus_fgac_code%TYPE,
                         p_fdmn_code  gorfgus.gorfgus_fdmn_code%TYPE,
                         p_fprd_seqno gorfgus.gorfgus_fprd_seqno%TYPE)
  RETURN VARCHAR2

Checks to see if a parent record exists.

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          gorfgus.gorfgus_fgac_code%TYPE,
                            p_fdmn_code          gorfgus.gorfgus_fdmn_code%TYPE,
                            p_fprd_seqno         gorfgus.gorfgus_fprd_seqno%TYPE,
                            p_fgac_user_id       gorfgus.gorfgus_fgac_user_id%TYPE,
                            p_select_ind         gorfgus.gorfgus_select_ind%TYPE,
                            p_insert_ind         gorfgus.gorfgus_insert_ind%TYPE,
                            p_update_ind         gorfgus.gorfgus_update_ind%TYPE,
                            p_delete_ind         gorfgus.gorfgus_delete_ind%TYPE,
                            p_user_id            gorfgus.gorfgus_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 all the parameters.

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_fgac_user_id   Banner ID of the user who is being assigned to the FGAC group and domain.
p_select_ind   Indicates if the FGAC user has select access.
p_insert_ind   Indicates if the FGAC user has insert access.
p_update_ind   Indicates if the FGAC user has update access.
p_delete_ind   Indicates if the FGAC user has 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    gorfgus.gorfgus_fgac_code%TYPE,
                     p_fdmn_code    gorfgus.gorfgus_fdmn_code%TYPE,
                     p_fprd_seqno   gorfgus.gorfgus_fprd_seqno%TYPE,
                     p_fgac_user_id gorfgus.gorfgus_fgac_user_id%TYPE,
                     p_select_ind   gorfgus.gorfgus_select_ind%TYPE,
                     p_insert_ind   gorfgus.gorfgus_insert_ind%TYPE,
                     p_update_ind   gorfgus.gorfgus_update_ind%TYPE,
                     p_delete_ind   gorfgus.gorfgus_delete_ind%TYPE,
                     p_user_id      gorfgus.gorfgus_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
Foreign keys are checked for group code and domain code pairs.
Indicators must have values of 'Y' or 'N'.
The FGAC User ID must be found in the ALL_USERS table.

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_fgac_user_id   Banner ID of the user who is being assigned to the FGAC group and domain.
p_select_ind   Indicates if the FGAC user has select access.
p_insert_ind   Indicates if the FGAC user has insert access.
p_update_ind   Indicates if the FGAC user has update access.
p_delete_ind   Indicates if the FGAC user has delete access.
p_user_id   The Oracle ID of the user who created or last updated the record.