Search Results igs_or_unit_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_OR_UNIT_PKG package body is a component of the Oracle E-Business Suite (EBS) Student Systems / Higher Education product family, operating within the APPS schema. Its identity within the IGS_OR_* namespace associates it with the Oracle Student System "Organization" (OR) module, which manages organizational units such as academic departments, faculties, schools, and administrative bodies. The package is classified as OTHER rather than a public or private API, indicating it is an internal utility package principally intended for use by other EBS packages rather than by external integrators. As a VALID package body at release levels 12.1.1 and 12.2.2, it provides reusable validation and lookup logic against the IGS_OR_UNIT entity, centralizing the resolution of primary keys and foreign keys so that calling code remains consistent and free of duplicated query logic. The strong web of inbound references—the metadata records that IGS_OR_UNIT_PKG is referenced by 36 other packages—confirms its role as a foundational utility object within the Student System data model.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures and functions in this package:

  • GET_PK_FOR_VALIDATION — Resolves the primary key of an organizational unit for validation purposes. It allows callers to confirm that a supplied unit reference corresponds to a valid record before proceeding with dependent processing.
  • GET_PK_FOR_STR_VALIDATION — Performs the equivalent primary-key resolution when the validation input is supplied in string form, accommodating callers that hold unit identifiers as character data requiring conversion before lookup.
  • GET_FK_IGS_OR_INSTITUTION — Returns the foreign-key value linking an organizational unit to its owning institution record, enabling callers to determine the institution context of a given unit.
  • GET_FK_IGS_OR_STATUS — Returns the foreign-key value that identifies the current status of an organizational unit, allowing callers to evaluate whether a unit is active, inactive, or otherwise qualified.

Consistent with the OTHER API classification, these routines expose narrow, single-purpose accessors rather than full transactional APIs with insert, update, and delete operations. Parameter signatures are not enumerated in the ETRM metadata and should be confirmed against the deployed source before extension.

Tables Accessed

The documented base table read by this package is IGS_OR_UNIT, the entity that stores organizational unit definitions within the Student System. The package also depends upon APPS.IGS_OR_UNIT_PKG itself (the specification), establishing the standard package body-to-specification relationship. Supporting dependencies include APP_EXCEPTION for raising application errors, FND_MESSAGE and IGS_GE_MSG_STACK for message retrieval and error-stack management, and STANDARD from the SYS schema. The access pattern is read-only against IGS_OR_UNIT; the package retrieves key and status values but does not itself maintain the unit records. Notably, the metadata records no tables referenced via APPS synonyms, so all access is direct.

Usage Notes

This package is typically invoked indirectly. Forms, concurrent programs, and other Student System packages call its validation and lookup routines when they must confirm the existence, institution, or status of an organizational unit prior to committing dependent data. Because it is referenced by 36 database objects but references no other packages beyond its documented dependencies, it functions as a low-level leaf utility in the dependency hierarchy. Custom code should use the package's public functions for validation rather than querying IGS_OR_UNIT directly, ensuring message handling through FND_MESSAGE and IGS_GE_MSG_STACK remains consistent with Oracle's error-reporting conventions. Callers should confirm exact parameter lists against the installed source, as the ETRM excerpt does not document them.