Search Results igs_ru_group_item_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_RU_GROUP_ITEM_PKG package is a PL/SQL database object in the Oracle E-Business Suite (EBS) Releases 12.1.1 and 12.2.2 that belongs to the Student System / Recruiting and Admissions (IGS) product family. The IGS_RU naming prefix associates the package with the "RU" (Recruiting/Registration) functional area, and the "GROUP_ITEM" component indicates it manages the association between a recruiting or admissions group and the individual items that belong to that group. In practical terms, the package encapsulates the create, read, update, and delete (CRUD) logic for the underlying IGS_RU_GROUP_ITEM entity, which supports operations such as assigning applicants, prospects, or related records to a defined group structure used in admissions processing and group-based evaluation workflows.

The package is registered as an OTHER API classification in the ETRM documentation, meaning it is not a public, fully-supported integration API but rather an internal companion package invoked by higher-level forms and concurrent programs. It is a VALID object owned by the APPS schema.

Key Procedures and Functions

The ETRM documentation identifies eight documented procedures and functions within the package:

  • INSERT_ROW — Creates a new group item record in the base table, populating the primary and required attribute columns.
  • LOCK_ROW — Acquires a row-level lock on an existing group item record to ensure concurrency integrity before an update or delete.
  • UPDATE_ROW — Applies changes to an existing group item record after the row has been locked.
  • DELETE_ROW — Removes a group item record from the base table.
  • GET_PK_FOR_VALIDATION — Returns the primary key of the entity being validated, supporting the validation framework used by the surrounding recruiting logic.
  • GET_FK_IGS_RU_GROUP — Retrieves the foreign key reference to the parent IGS_RU_GROUP record, establishing the group-to-item relationship.
  • CHECK_CONSTRAINTS — Performs business and referential integrity checks before allowing DML to proceed.
  • BEFORE_DML — A table-handler hook that fires prior to insert, update, or delete operations, typically enforcing defaults, audit columns, and derivation rules.

Tables Accessed

The package accesses the base table IGS_RU_GROUP_ITEM through its APPS synonym. This table stores the child rows that associate individual group items with a parent recruiting group. All documented procedures operate against this single base entity, with the GET_FK_IGS_RU_GROUP routine reading the foreign key that points to the IGS_RU_GROUP parent table. No additional base tables are documented as directly referenced by the package itself.

Usage Notes

IGS_RU_GROUP_ITEM_PKG is not intended to be invoked directly by end users. It is referenced by three other database objects — IGS_RU_GEN_006, IGS_RU_GROUP_PKG, and IGS_RU_VAL_RGI — indicating that it is called from higher-level package logic and validation routines. Typical invocation occurs through Oracle Forms-based recruiting setup screens, concurrent programs that generate or process group assignments, and custom extensions that manipulate IGS_RU_GROUP_ITEM rows. The presence of BEFORE_DML and CHECK_CONSTRAINTS confirms that the package enforces data integrity centrally, so direct SQL against the base table should be avoided. Customizations should follow the documented sequence of LOCK_ROW, UPDATE_ROW, or DELETE_ROW, and rely on INSERT_ROW for new records. Because the package is classified as OTHER rather than a supported public API, changes to its signature or behavior across patches should be verified against each EBS release.