Search Results igs_he_poous_all_pkg




Overview
Explore in AI Chat

Overview

IGS_HE_POOUS_ALL_PKG is the generated PL/SQL package body that provides the transactional data-access layer for the IGS_HE_POOUS_ALL entity within the Oracle E-Business Suite higher-education data model. The IGS_HE_POOUS_ALL table stores the "program of study / offering option unit set" association records belonging to the Student Systems (IGS) product family, which underpins academic structure, program enrollment, and unit-set management in Oracle Student System. The package encapsulates the insert, update, delete, and locking logic for that entity, and centralizes referential-integrity validation against related offering-option, unit-set, and funding-source entities. It is classified as an OTHER API object rather than a public business-facing API, indicating it is intended primarily for internal consumption by forms, concurrent programs, and other IGS packages. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema, is documented as VALID, and is delivered as a standard component of the IGS schema install.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions, which fall into four functional groups.

  • Transaction maintenance: INSERT_ROW, UPDATE_ROW, and DELETE_ROW perform the core data manipulation against the entity, while ADD_ROW provides the consolidated create operation typically used by form logic. LOCK_ROW obtains a row-level lock to guard against concurrent modification during an update or delete cycle.
  • Key and validation helpers: GET_PK_FOR_VALIDATION and GET_UK_FOR_VALIDATION resolve the primary and unique key values needed by validation routines, allowing callers to confirm row identity before persistence.
  • Foreign-key lookups: GET_FK_IGS_PS_OFR_OPT_ALL, GET_FK_IGS_EN_UNIT_SET_ALL, and GET_FK_IGS_PS_OFR_UNIT_SET retrieve the descriptive attributes of the referenced offering-option, unit-set, and offering-option unit-set records so that denormalized values and validation errors can be presented to the user.
  • Pre-DML hook: BEFORE_DML executes the standard pre-insert/pre-update logic, including WHO-column population and message-stack handling.

Parameter lists are not reproduced here; callers should reference the packaged specification IGS_HE_POOUS_ALL_PKG for the current signature of each routine.

Tables Accessed

The package reads and writes the base table IGS_HE_POOUS_ALL through its APPS synonym, and accesses the shadow table IGS_HE_POOUS_ALL_S, which holds the translated or "_S" (secondary/attribute) columns associated with the base entity. DUAL is referenced for trivial single-row evaluations such as sequence and constant lookups. Additional dependencies documented by ETRM include IGS_EN_STDNT_PS_ATT and IGS_PS_OFR_OPT_UNIT_SET_V, together with supporting packages IGS_EN_UNIT_SET_PKG, IGS_FI_FUND_SRC_PKG, IGS_PS_OFR_OPT_PKG, IGS_GE_GEN_003, and IGS_GE_MSG_STACK. These are used for foreign-key derivation, validation, and error messaging rather than direct ownership of the entity's data.

Usage Notes

IGS_HE_POOUS_ALL_PKG is invoked indirectly. Oracle Forms built on the IGS_HE_POOUS_ALL block call ADD_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW through the standard form-to-package integration, while BEFORE_DML fires automatically during those DML operations. Concurrent programs and custom PL/SQL that need to create or amend program-offering-unit-set associations should call the package rather than issuing direct DML, because the package enforces the FK validation, WHO-column auditing, and message-stack conventions required by the IGS data model. The package is documented as referenced by three other database objects, and it references IGS_HE_POOUS_ALL_PKG itself, confirming the standard specification/body pairing. Because it is not designated a public API, Oracle may change it between patch levels; implementers should treat it as internal and prefer documented IGS public APIs where available.