Search Results ota_om_tdb_waitlist_api




Overview
Explore in AI Chat

Overview

The APPS.OTA_OM_TDB_WAITLIST_API package is a PL/SQL API within the Oracle E-Business Suite (EBS) Training and Events Management (OTA) module. Its name reflects its role within the online training and booking domain: "OM" denotes order/online management context, "TDB" denotes the training database layer, and "WAITLIST" identifies the business object it services. The package provides the programmatic interface for managing training enrollment waitlists, most notably the transition of a learner from a waitlisted state into a confirmed enrollment when capacity becomes available.

The object is owned by the APPS schema and holds a status of VALID in ETRM 12.1.1 and 12.2.2. It is classified as an API object, indicating it is intended for controlled programmatic invocation rather than end-user direct access. Dependency metadata confirms it references only the SYS STANDARD package and is itself referenced by OTA_CANCEL_API, OTA_ILEARNING, and its own package body, establishing it as a component within the broader OTA enrollment processing chain.

Key Procedures and Functions

The documented interface exposes a single public program unit:

  • AUTO_ENROLL_FROM_WAITLIST — The principal routine of the package. It evaluates learners currently held on a training event waitlist and automatically converts them into confirmed bookings when capacity or eligibility conditions are satisfied. This supports the business requirement that participants are enrolled in queue order without manual intervention once a seat is released or a new offering is opened. The ETRM metadata does not publish a parameter list for this routine, so invocation signatures should be confirmed against the deployed package specification in the target instance before use. No other documented procedures or functions are attributed to this package.

Tables Accessed

The package operates across a set of core OTA tables, resolved through APPS synonyms:

  • OTA_BOOKING_STATUS_TYPES — Provides the valid booking status codes used to distinguish waitlisted records from confirmed enrollments, enabling the API to select and update the correct status transitions.
  • OTA_DELEGATE_BOOKINGS — The principal booking record store for delegates; waitlist entries are read from and updated in this table as enrollment is confirmed.
  • OTA_EVENTS — Supplies event definitions, including scheduling and capacity attributes that determine whether a waitlisted delegate can be enrolled.
  • OTA_FINANCE_LINES — Represents the financial impact of enrollment changes, supporting the creation or adjustment of financial lines when a waitlist entry converts to a booking.
  • PLITBLM — A standard EBS PL/SQL table-of-rows structure used for in-memory record handling during bulk processing.

Usage Notes

This API is typically invoked by other OTA components rather than by end users directly. Documented dependencies show OTA_ILEARNING and OTA_CANCEL_API calling into it, which indicates it is triggered during cancellation processing — when a seat is freed — and during iLearning enrollment flows that must promote waitlisted learners. Customizations and extensions should call AUTO_ENROLL_FROM_WAITLIST within the standard OTA transaction and error-handling framework rather than embedding equivalent logic, so that booking statuses, financial lines, and event capacity remain consistent. Because the metadata lists no public parameters, developers must inspect the package specification on the target instance prior to coding a call. As with all EBS APIs, changes to OTA enrollment data should be committed only after the API returns successfully.