Search Results igs_ps_usec_lim_wlst_s

Overview

The APPS.IGS_PS_USEC_LIM_WLST_PKG package body is a component of the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of the Oracle Higher Education stack) that supports the management of unit offering option waitlists and their associated usec (unit section) enrollment limits. The package name is derived from its two principal data domains: IGS_PS_USEC_LIM_WLST (usage limit waitlist) and the unit offering option construct. In the context of Oracle EBS 12.1.1 and 12.2.2, this package functions as an internal DML utility package generated in the PL/SQL API layer pattern characteristic of the IGS (Institution of Graduate Studies / Student System) schema family. Its primary business purpose is to enforce row-level integrity, primary key, unique key, and foreign key constraints while providing locked, validated insert, update, and delete operations against the waitlist usec-limit entity and its child table.

Key Procedures and Functions

The package body exposes ten documented procedures and functions, organized around a consistent DML discipline:

• INSERT_ROW — Inserts a new row into the base waitlist usec-limit table, applying defaulting and validation logic.
• LOCK_ROW — Obtains a pessimistic row lock (SELECT ... FOR UPDATE) on the target record to serialize concurrent DML.
• UPDATE_ROW — Updates an existing row after lock and validation.
• ADD_ROW — A composite routine that combines locking, key validation, constraint checking, and insertion in a single call.
• DELETE_ROW — Removes a row, typically after verifying referential dependencies.
• GET_PK_FOR_VALIDATION — Retrieves the primary key value for a record for use in constraint validation.
• GET_UK_FOR_VALIDATION — Retrieves the unique key value used to detect duplicate records.
• GET_UFK_IGS_PS_UNIT_OFR_OPT — Returns the unique foreign key linking the waitlist record to the IGS_PS_UNIT_OFR_OPT_ALL entity.
• CHECK_CONSTRAINTS — Central validation routine verifying PK, UK, and FK rules before commits.
• BEFORE_DML — A pre-DML trigger-style routine that sets audit columns (created_by, creation_date, last_updated_by, last_update_date) via FND_GLOBAL.

Tables Accessed

The package references the following tables through APPS synonyms:

• IGS_PS_USEC_LIM_WLST — Primary entity table storing waitlist usec-limit records.
• IGS_PS_USEC_LIM_WLST_S — Child/sequence table (matches the user's search string) holding dependent detail rows.
• IGS_PS_UNIT_OFR_OPT_ALL — Unit offering option master, providing the parent foreign key validated by GET_UFK_IGS_PS_UNIT_OFR_OPT.
• IGS_PS_UNIT_VER_ALL — Unit version table used to resolve version context for the offering option.
• DUAL — Used for scalar queries, sequence fetches, and sysdate retrieval.

Supporting packages and utilities referenced include APP_EXCEPTION, FND_MESSAGE, IGS_GE_MSG_STACK, and IGS_PS_UNIT_OFR_OPT_PKG for error handling and message stack management.

Usage Notes

This package is typically invoked indirectly by Oracle Forms-based maintenance screens in the Student System responsibility, or by higher-level student enrollment APIs such as IGS_PS_UNIT_OFR_OPT_PKG. It is not referenced by any database object per ETRM, but it is referenced by three other packages, indicating it acts as a supporting DML layer for those callers. Because it is classified as OTHER (not a public API), it should not be called directly from custom code without understanding the caller contract. Concurrent programs that purge, reconcile, or validate waitlist usec limits may route through this package to enforce consistency. Exception conditions (e.g., APP_EXCEPTION and message-stack entries via IGS_GE_MSG_STACK) surface validation failures to the calling form for user notification. Customers upgrading between 12.1.1 and 12.2.2 should note the package remains VALID in APPS and is dependent on the IGS product family directory object, so it must be preserved during patching.