Search Results igs_lookups_view_pkg




Overview
Explore in AI Chat

Overview

IGS_LOOKUPS_VIEW_PKG is a seeded Oracle E-Business Suite PL/SQL package owned by the APPS schema and belonging to the Oracle Student System (IGS) product family, which provides the higher-education data model in EBS 12.1.1 and 12.2.2. The package encapsulates the DML and validation logic required to maintain the IGS_LOOKUPS_VAL entity, a student-system lookups validation table that governs the code values used throughout enrollment, records, transcripts and fee assessment processing. The presence of the AUTHID CURRENT_USER clause indicates the package executes with the privileges of the invoking schema rather than as definer, which is consistent with its role as a support layer beneath the Oracle Forms–based student administration modules. Its header stamp ($Header: IGSMI14S.pls 115.6 2003/05/09) shows that the source has been shipped essentially unchanged since the early 11i lineage, with no functional redesign across 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented program units, all of which operate on a single IGS_LOOKUPS_VAL row identified by the combination of lookup type and lookup code.

  • LOCK_ROW — Acquires a row-level lock on the target IGS_LOOKUPS_VAL record and performs the standard optimistic-locking comparison. It accepts the rowid along with the full set of denormalized column values (closed indicator, security flag, step type restriction, unit outcome flag, display name and order, transcript and completion indicators, fee assessment flag, step group type, final result flag, system generated flag, transaction category, encumbrance level, enrollment and calculation flags, default display sequence and available transcript display options). If any value differs from the current database row, the procedure raises the standard "record has been modified by another user" exception, protecting concurrent maintenance of shared lookup definitions.
  • UPDATE_ROW — Performs the actual update of the IGS_LOOKUPS_VAL row. Its parameter list mirrors LOCK_ROW and adds a trailing x_mode parameter defaulting to 'R', which distinguishes update (R/U) semantics from other handling modes. This is the routine invoked after a successful lock when a user saves changes to a lookup record in the maintenance form.
  • GET_PK_FOR_VALIDATION — A function that returns the primary key for a given lookup type and lookup code pair. It is used by the generic validation infrastructure and by dependent packages to confirm that a supplied lookup value exists before it is referenced elsewhere in the student model.

Tables Accessed

The only documented table referenced is IGS_LOOKUPS_VAL, accessed through its APPS synonym. All three program units target this single entity: LOCK_ROW and UPDATE_ROW read, lock and modify existing lookup rows, while GET_PK_FOR_VALIDATION performs a lookup-only read of the primary key columns. No inserts are documented, so record creation is handled elsewhere in the IGS stack.

Usage Notes

This package is a server-side support layer rather than an end-user-facing API. The ETRM metadata records that it is referenced by 133 other packages, making it one of the more widely depended-upon utilities in the IGS schema. It is typically invoked from the Oracle Forms lookup maintenance screens, where the form's pre-update logic calls LOCK_ROW before applying changes and UPDATE_ROW on save. Other IGS packages call GET_PK_FOR_VALIDATION as a lightweight existence check. Because the package is not classified as a public API, customizations should generally avoid calling UPDATE_ROW directly; extensions should instead honour the same validation and concurrency conventions the package enforces. The AUTHID CURRENT_USER clause means invoking users require direct object privileges on IGS_LOOKUPS_VAL, a consideration when grants are migrated between environments in 12.2.2.