Search Results igs_ps_fac_wl_s

Overview

IGS_PS_FAC_WL_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the maintenance of facility waiting list records within the Student Systems / Higher Education product family (IGS = Information Group for Students). The package operates against the IGS_PS_FAC_WL base table and its associated IGS_PS_FAC_WL_S translation/security table, which store waiting list entries that link a person (student, applicant, or prospective student) to a facility or facility offering when capacity is unavailable. In EBS 12.1.1 and 12.2.2, this package is one of a family of FAC (facility) related packages that provide the DML layer behind the facility assignment, override, and waiting list maintenance forms.

The ETRM entry classifies the package as an "OTHER" API, meaning it is not a fully public, developer-facing API such as an Oracle PL/SQL API designated for external integrations but is instead an internal, form-supporting package. It encapsulates row-level insert, update, delete, locking, and validation logic so that the facility waiting list forms and any dependent packages do not perform direct DML against the underlying tables. A key characteristic is the generation of surrogate and natural key validation queries used by Oracle Forms-based block processing.

Key Procedures and Functions

• INSERT_ROW — Inserts a new waiting list row into the base table, applying the defaulted primary key and audit columns.
• LOCK_ROW — Issues a SELECT ... FOR UPDATE against the identified waiting list row so that the form can detect concurrent modification before update or delete.
• UPDATE_ROW — Modifies an existing waiting list row with the values supplied by the calling block.
• ADD_ROW — Higher-level wrapper that performs the necessary DML when a new waiting list record is created, typically combining key generation with INSERT_ROW.
• DELETE_ROW — Removes a waiting list row from the base table.
• GET_PK_FOR_VALIDATION — Returns the primary key value(s) required for row validation in the form, ensuring the block operates on a uniquely identified record.
• GET_UK_FOR_VALIDATION — Returns the unique key value(s) used to validate a waiting list row, commonly exposing the IGS_PS_FAC_WL_S identifier used by the search the user performed ("igs_ps_fac_wl_s").
• GET_FK_IGS_CA_INST — Retrieves the foreign key value relating the waiting list row to the IGS_CA_INST calendar instance, used for validation of the associated institution/calendar context.
• BEFORE_DML — Central pre-DML handler that enforces referential integrity, populates audit columns (WHO columns via FND_GLOBAL), and raises application errors through FND_MESSAGE and IGS_GE_MSG_STACK when validation fails.

Tables Accessed

• IGS_PS_FAC_WL — The base waiting list table; the principal target of INSERT_ROW, UPDATE_ROW, ADD_ROW and DELETE_ROW.
• IGS_PS_FAC_WL_S — The associated _S table, accessed through GET_UK_FOR_VALIDATION and related validation logic; this is the object referenced by the user's search term "igs_ps_fac_wl_s".
• HZ_PARTIES — Read to validate the person associated with the waiting list entry, confirming the TCA party record exists.
• DUAL — Used for single-row selection and sequence/date retrieval.

The package also depends on APP_EXCEPTION, FND_GLOBAL, FND_MESSAGE, IGS_CA_INST_PKG, IGS_GE_MSG_STACK, IGS_PS_FAC_ASG_TASK_PKG and IGS_PS_FAC_OVR_WL_PKG, confirming that it sits within a tightly integrated facility waiting list sub-module.

Usage Notes

IGS_PS_FAC_WL_PKG is invoked primarily from the Oracle Forms-based facility waiting list maintenance screens, where block-level triggers call LOCK_ROW, UPDATE_ROW, ADD_ROW and DELETE_ROW. It is referenced by four other database objects, which suggests that dependent packages (such as the facility assignment task and override waiting list packages) reuse its locking and validation routines rather than duplicating DML. In EBS 12.2.2 the package is installed under the APPS schema with the customary editioning and synonym treatment used for the E-Business Suite database tier; it is not a public web service API and should not be called directly by custom code unless the calling routine first satisfies the same validation and locking contract the forms observe. Because the package is marked VALID and not referenced by any object that would trigger its recompilation, it functions as a stable internal building block for the facility waiting list feature set.