Search Results igs_en_enroll_wlst




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_ENROLL_WLST package is a component of the Oracle E-Business Suite (EBS) Student Systems / Student Information (IGS) product family, which supports higher-education enrolment and academic records processing. This package encapsulates the business logic governing the treatment of students who hold a place on a unit (course module) waiting list and, when capacity becomes available, the promotion of those students into a confirmed enrolment. It therefore serves as the bridge between the "wait list" and "enrolled" states within the institution's enrolment lifecycle.

In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema with a status of VALID, and its API classification is recorded as OTHER in the ETRM (Electronic Technical Reference Manual). It exposes nine documented callable units that combine validation, calculation, finalisation, messaging, and wait-list promotion behaviour.

Key Procedures and Functions

  • VALIDATE_UNIT — Performs validation checks against a single unit offering to confirm that the requested enrolment or wait-list action satisfies the configured rules before any data is changed.
  • VALIDATE_PROG — Applies equivalent validation at programme level, checking programme-level constraints that govern whether a student may proceed.
  • VALIDATE_UNIT_STEPS — Validates the sequential step definitions associated with a unit, ensuring prerequisite/step-based waiting-list or enrolment progression is honoured.
  • VALIDATE_COMBINED_UNIT — Validates enrolment or promotion across combined (multi-component) unit offerings, verifying that all constituent parts are consistent.
  • FINALIZE_UNIT — Commits the definitive unit enrolment records once validation and capacity checks have succeeded.
  • ENROLL_FROM_WAITLIST — The core wait-list promotion routine, transferring a student from the waiting list into a confirmed enrolment when a place becomes available.
  • GET_MESSAGE — Retrieves a formatted message (typically text for user or process feedback) associated with a given condition or error.
  • GET_MESSAGE_COUNT — Returns the count of messages applicable to the current context, supporting looping or diagnostic display of multiple notifications.
  • SS_EVAL_MIN_OR_MAX_CP — Self-service helper that evaluates minimum or maximum credit-point thresholds, used to determine wait-list or enrolment eligibility based on credit loads.

Tables Accessed

The package reads and writes through APPS synonyms. Key referenced tables include IGS_EN_INST_WL_STPS (institution wait-list step definitions), IGS_PS_USEC_LIM_WLST (wait-list limit rules for unit offerings), IGS_PS_RSV_EXT (reserved-place records), and IGS_EN_CONFIG_ENR_CP (enrolment configuration). Person identity lookups are performed via HZ_PARTIES and IGS_PE_PERSON_TYPES. Calendar instance data is drawn from IGS_CA_INST_ALL and IGS_CA_TYPE, and unit/credit-point detail from IGS_PS_USEC_CPS and IGS_EN_CAT_PRC_DTL. Error and message text is sourced from FND_NEW_MESSAGES. The package also references the IGS_PS_UNIT_OFR_OPT and IGS_EN_CPD_EXT objects documented in the dependency listing.

Usage Notes

IGS_EN_ENROLL_WLST is not typically invoked directly by end users; it is called from within the Student Systems enrolment forms and concurrent processes. It is referenced by other packages including IGS_EN_GEN_016, IGS_EN_IVR_PUB, IGS_EN_OFR_WLST_OPT, IGS_EN_REINSTATE_PKG, IGS_EN_TRANSFER_APIS, and IGS_SS_EN_WRAPPERS, indicating its role as a shared enrolment utility across batch, self-service, and telephony/IVR channels. Because it manipulates enrolment and wait-list records, any custom integration should invoke the documented procedures rather than writing to the underlying tables directly, thereby preserving the validation and messaging behaviour enforced within the package.