Search Results igs_pr_ru_ou_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PR_RU_OU_PKG package body is a component of the Oracle E-Business Suite (EBS) Student Information System (SIS), specifically within the recruitment and admissions functional area. The name follows the IGS (Integrated Graduate System / Student System) naming convention: "PR" denotes Prospect/Recruitment, "RU" denotes Recruiting Unit, and "OU" denotes Organizational Unit. This package, therefore, encapsulates the business logic that manages the association between recruiting organizational units and prospect records. Its primary role is to provide a stable, integrity-preserving API around the underlying table IGS_PR_RU_OU_ALL, exposing validation, DML, locking, and constraint-checking routines used throughout the prospect recruitment subsystem. The package is classified as OTHER in the ETRM metadata, indicating it is a supporting utility package rather than a standalone user-facing API or a primary entity package.

Key Procedures and Functions

The package body exposes twelve documented subprograms that fall into three logical groups:

Tables Accessed

The package reads and writes the single foundation table IGS_PR_RU_OU_ALL, accessed through its APPS synonym. This table stores the intersection of recruiting organizational units with the prospect recruiting structure, effectively defining which organizational unit owns or drives a prospect's recruiting activity. All DML, locking, and constraint validation operations in the package target this table. The foreign-key accessor functions imply the package also consults related validation views and lookup structures (admission type, org unit type, application, and lookup view) through the dependencies listed below, but the only documented table reference is IGS_PR_RU_OU_ALL.

Usage Notes

Because IGS_PR_RU_OU_PKG is referenced by twelve other database objects, it functions as a shared service within the prospect recruitment layer rather than being invoked directly by end users. It is typically called from:

  • Oracle Forms in the SIS prospect/recruitment module, where it performs row-level validation and drives key and constraint checks during insert and update.
  • Parent IGS packages such as IGS_PR_OU_TYPE_PKG, IGS_PR_OU_FND_PKG, IGS_PR_OU_UNIT_PKG, and IGS_PR_RU_APPL_PKG, which call its validation and DML routines to maintain referential integrity.
  • Concurrent programs and custom extensions that need to load or update recruiting unit-to-org unit associations while respecting the same business rules enforced by the standard UI.

Its dependencies on APP_EXCEPTION, FND_MESSAGE, FND_GLOBAL, IGS_GE_MSG_STACK, and IGS_GE_NUMBER confirm that it uses standard EBS error handling and message stack patterns, raising named exceptions through FND_MESSAGE. Custom code should invoke the packaged DML routines rather than performing direct DML on IGS_PR_RU_OU_ALL, since doing so would bypass the constraint validation, key derivation, and locking logic this package supplies.