Search Results igs_ps_usec_lim_wlst_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_LIM_WLST_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Student Systems (IGS) product family. Its name resolves to the "Unit Section Limitation White List" functional area, indicating that it manages a white list of allowable usec (unit section) limitation combinations associated with unit offerings. In Oracle EBS 12.1.1 and 12.2.2, packages of this class act as the programmatic backbone behind Academic/Student System forms, enforcing the referential and business rules that govern how unit offering options interact with predefined limitation values.

The package is classified as OTHER in ETRM documentation, meaning it is not exposed as a published public API but instead functions as an internal, form-supporting data access layer. It encapsulates the standard DML and validation operations for its underlying base tables, ensuring that inserts, updates, and deletes are performed consistently and that primary key, unique key, and foreign key integrity are verified before any transaction commits.

Key Procedures and Functions

The documented program units (10 total) follow the conventional Oracle Forms-generated package pattern:

  • INSERT_ROW — Inserts a new white list record into the base table.
  • LOCK_ROW — Acquires a row-level lock on an existing record to prevent concurrent modification.
  • UPDATE_ROW — Applies changes to an existing white list record.
  • ADD_ROW — Adds a row, typically coordinating insert logic with surrounding validation.
  • DELETE_ROW — Removes a white list record from the base table.
  • GET_PK_FOR_VALIDATION — Resolves or validates the primary key value for a row, supporting constraint enforcement.
  • GET_UK_FOR_VALIDATION — Resolves or validates the unique key value for a row.
  • GET_UFK_IGS_PS_UNIT_OFR_OPT — Derives the unique foreign key linking the record to a unit offering option, supporting the parent-child relationship.
  • CHECK_CONSTRAINTS — Performs constraint validation before DML is permitted.
  • BEFORE_DML — A pre-DML trigger-style routine that runs validation and derivation logic ahead of any insert, update, or delete.

No parameter lists are inferred; the above describes documented purpose only.

Tables Accessed

Via APPS synonyms, the package references the following tables:

  • IGS_PS_USEC_LIM_WLST — The primary base table holding white list records.
  • IGS_PS_USEC_LIM_WLST_S — The corresponding secondary/translation-style table in the _S suffix pattern used across IGS.
  • IGS_PS_UNIT_OFR_OPT_ALL — The unit offering option table supplying the parent foreign key context.
  • IGS_PS_UNIT_VER_ALL — The unit version table, referenced for validating the unit to which the offering option belongs.
  • DUAL — Used for scalar lookups and validation probes.

Usage Notes

The package is typically invoked indirectly rather than called by name. It is referenced by three other packages — IGS_PS_GEN_001, IGS_PS_UNIT_LGCY_PKG, and IGS_PS_UNIT_OFR_OPT_PKG — which call into it during unit offering option maintenance. In practice, this means the white list logic is triggered from the Unit Offering Option form and related Academic Structures screens: when a user creates or modifies a unit offering option, the dependent package chain calls INSERT_ROW, UPDATE_ROW, DELETE_ROW, and the validation routines to enforce consistency. Because the package depends only on SYS.STANDARD, it has no external API surface and should not be treated as a public integration point. Customizations that need to manipulate white list data should do so through the documented IGS public APIs on the referencing packages rather than by calling IGS_PS_USEC_LIM_WLST_PKG directly. Its behavior is consistent across 12.1.1 and 12.2.2, as IGS table structures and package signatures were not materially altered between these releases.