Search Results igs_ru_group_set_pkg




Overview
Explore in AI Chat

Overview

IGS_RU_GROUP_SET_PKG is a PL/SQL package owned by the APPS schema in Oracle EBS Release 12.1.1 and 12.2.2. It belongs to the Oracle Student System / Student Records family of modules, indicated by the IGS_ prefix (Oracle iGS), and specifically to the Rules (RU) subsystem, indicated by the _RU_ segment. Within the Oracle iGS architecture, "group sets" represent logical collections of related group members and are used to drive validation rules, eligibility checks, and business logic configurations. The package functions as a table handler — that is, a DML wrapper that centralizes insert, update, delete, and validation logic for the underlying IGS_RU_GROUP_SET table.

The package carries an API classification of OTHER, meaning it is not a formally published public API but rather an internal support package invoked by sibling components of the Rules subsystem. The ETRM metadata confirms that it is VALID and that it is referenced by three other packages: IGS_RU_DESCRIPTION_PKG, IGS_RU_GROUP_PKG, and IGS_RU_VAL_RGI. This dependency pattern indicates that group set maintenance is a subordinate operation within the broader group and description management flow.

Key Procedures and Functions

The ETRM lists eight documented procedures/functions. Their names follow Oracle's conventional table handler naming pattern.

  • INSERT_ROW — Inserts a new row into the IGS_RU_GROUP_SET table, setting required audit and surrogate key columns.
  • LOCK_ROW — Selects a row with FOR UPDATE semantics to prevent concurrent modification before an update or delete.
  • DELETE_ROW — Physically removes a row from IGS_RU_GROUP_SET after integrity conditions are satisfied.
  • GET_PK_FOR_VALIDATION — Resolves or validates the primary key of a group set record before a DML operation.
  • GET_FK_IGS_RU_DESCRIPTION — Retrieves the foreign key reference to the associated description record. Description records define the textual context of rule objects.
  • GET_FK_IGS_RU_GROUP — Retrieves the foreign key reference to the parent group record to which the group set belongs.
  • CHECK_CONSTRAINTS — Validates business and referential integrity constraints (e.g., mandatory foreign keys, uniqueness) prior to persistence.
  • BEFORE_DML — A pre-DML hook that orchestrates validation and key resolution before an insert, update, or delete executes.

Tables Accessed

The only documented table referenced via an APPS synonym is IGS_RU_GROUP_SET. This is the transactional table storing group set records, which link groups to descriptions within the Rules subsystem. The package reads and writes this table through its DML procedures. Referential lookups against description and group tables are performed indirectly via the GET_FK_IGS_RU_DESCRIPTION and GET_FK_IGS_RU_GROUP functions. The package's only external dependency in the ETRM dependency list is SYS.STANDARD, confirming it is self-contained beyond the target table and non-row-level triggers or handlers in the calling packages.

Usage Notes

IGS_RU_GROUP_SET_PKG is not an end-user interface component. It is invoked indirectly through the three referencing packages — IGS_RU_DESCRIPTION_PKG, IGS_RU_GROUP_PKG, and IGS_RU_VAL_RGI — which call its procedures during group set creation, modification, and validation rule processing. In practice, maintenance of group sets is triggered from the Oracle Student System setup forms and from concurrent programs that generate or validate group membership rules. Custom extensions should call the public procedures (INSERT_ROW, DELETE_ROW) rather than issuing direct DML against IGS_RU_GROUP_SET, to preserve the CHECK_CONSTRAINTS and BEFORE_DML validation behavior. Because the package is classified as OTHER rather than a formal API, Oracle does not guarantee backward compatibility of its internal signatures across patch levels, and any custom dependency should be documented and retested during upgrades.