Search Results igs_ps_exp_wl_pkg

Overview

IGS_PS_EXP_WL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM documentation as an "OTHER" API type. It belongs to the Oracle Student System (IGS) product family, specifically the Academic Program and Student Records modules. Its name suggests a relationship to the "WL" (Wait List) entity, likely functioning as a table handler for the IGS_PS_EXP_WL table (the "PS_EXP" segment likely refers to Program Enrolment / Expression offering configuration). The package encapsulates the standard Oracle Forms DML processing routines generated for a base table, providing insert, lock, update, delete, and pre-DML hooks. Because it is registered in the ETRM repository as VALID, it is a currently supported database object in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents seven procedures/functions in IGS_PS_EXP_WL_PKG:

• INSERT_ROW — Inserts a single row into the IGS_PS_EXP_WL table, populating the standard WHO columns and applying any default logic.
• LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) on the target row to enforce concurrency control before an update or delete.
• UPDATE_ROW — Modifies an existing IGS_PS_EXP_WL row based on the primary key, updating the auditable WHO columns.
• ADD_ROW — Creates a new row with generated primary key or sequence-derived values, typically used by inbound interfaces or batch loads.
• DELETE_ROW — Physically removes a row from IGS_PS_EXP_WL after validating referential integrity.
• GET_PK_FOR_VALIDATION — Returns primary key values used by the Forms framework to validate unique/non-null constraints before committing.
• BEFORE_DML — A pre-DML trigger routine that executes business-rule validation, derived value calculation, and WHO column stamping prior to insert, update, or delete.

No parameter lists are documented in the ETRM record, so signatures should be confirmed against the deployed package source before direct invocation.

Tables Accessed

The only documented table referenced is IGS_PS_EXP_WL. This is a student-record waitlist table used by the waitlist management feature. The package performs all of its CRUD operations against this single table via the APPS synonym. No other dependencies on application tables are documented; the only external references recorded are to SYS.STANDARD (the PL/SQL root package) and self-references to IGS_PS_EXP_WL_PKG.

Usage Notes

This is a supporting (non-user-facing) API. It is typically invoked by the Oracle Forms UI for the corresponding waitlist maintenance screen, and it is referenced by one other package, IGS_PS_EMP_CATS_WL_PKG, which wraps it for category-based waitlist processing. Customers and integrators generally should not call these procedures directly, because BEFORE_DML and the row-level routines require the Forms framework's item state (WHO columns, PK values, and lock context). Custom code that must manipulate waitlist data should prefer the supported public APIs or the underlying table via registered concurrent programs. In EBS 12.1.1 and 12.2.2 the package ships as VALID in the APPS schema; any migration of waitlist logic should reference IGS_PS_EXP_WL_PKG only through its dependent wrappers to preserve validation and auditing behavior.