Search Results igs_ru_group_pkg




Overview
Explore in AI Chat

Overview

IGS_RU_GROUP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It belongs to the Student Systems / Recruiting and Admissions (RU) product family, where the IGS_RU prefix denotes objects related to admissions rule processing. The package functions as a table-handler and validation layer for the IGS_RU_GROUP entity, which stores grouping definitions used within the admissions rule framework. Rather than exposing a public business API, this package provides the low-level DML, row-locking, uniqueness, and constraint-checking routines required to maintain IGS_RU_GROUP records reliably. Its VALID status in the 12.1.1 and 12.2.2 ETRM data dictionary confirms that it is a supported, compiled production object delivered in the standard APPS schema.

Key Procedures and Functions

The ETRM metadata documents nine procedures or functions exposed by the package's specification:

  • INSERT_ROW — Performs the physical insert of a new row into IGS_RU_GROUP, populating the mandatory columns required for a valid group definition.
  • LOCK_ROW — Acquires a row-level lock on an existing IGS_RU_GROUP record so that concurrent sessions cannot modify the same group during a transaction.
  • UPDATE_ROW — Applies changes to an existing group record, typically after LOCK_ROW has secured the row.
  • ADD_ROW — Higher-level wrapper that combines validation with insertion, adding a new group row in a single call.
  • DELETE_ROW — Removes a group record from IGS_RU_GROUP.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of a group row for use in downstream validation logic.
  • GET_UK1_FOR_VALIDATION — Retrieves the first unique key of a group row, supporting duplicate and uniqueness checks.
  • CHECK_CONSTRAINTS — Evaluates business and referential constraints against the group entity before DML is committed.
  • BEFORE_DML — Centralized pre-DML hook that enforces validation, defaulting, and audit column handling prior to insert, update, or delete.

Tables Accessed

The package references a single documented base table through an APPS synonym: IGS_RU_GROUP. All nine procedures operate against this entity. INSERT_ROW, ADD_ROW, UPDATE_ROW, and DELETE_ROW perform the write operations, LOCK_ROW handles concurrency control, and the GET_*_FOR_VALIDATION, CHECK_CONSTRAINTS, and BEFORE_DML routines read the table to enforce primary key, unique key, and general constraint integrity. No other application tables are documented as direct dependencies, indicating a tightly scoped, single-entity handler.

Usage Notes

IGS_RU_GROUP_PKG is not typically called directly by end users. It is referenced by six other packages: IGS_RU_CALL_PKG, IGS_RU_GROUP_ITEM_PKG, IGS_RU_GROUP_SET_PKG, IGS_RU_NAMED_RULE_GR_PKG, IGS_RU_NAMED_RULE_PKG, and IGS_RU_TURIN_RULE_GR_PKG, as well as by itself. These callers invoke IGS_RU_GROUP_PKG when maintaining the group definitions that underpin admissions rule evaluation. Within Oracle EBS, such table-handler packages are generally invoked from the corresponding Admissions/Recruiting forms, from concurrent programs that build rule structures, or from custom PL/SQL extensions that must create or validate group records. Because the package depends only on SYS.STANDARD and the IGS_RU_GROUP table, it is a stable, reusable building block. Developers extending admissions rules in 12.1.1 or 12.2.2 should route all IGS_RU_GROUP DML through this package to preserve the constraint-checking and locking behavior it centralizes.