Search Results cancel_enrollment

Overview

APPS.OTA_CANCEL_API is a PL/SQL application programming interface package within the Oracle E-Business Suite (EBS) Oracle Training Administration (OTA) module. Its primary business function is to manage the cancellation of training enrollment records, including the removal of associated booking lines and the reconciliation of dependent financial and attendee data. The package is classified as an API and is owned by the APPS schema, with a status of VALID in both EBS 12.1.1 and 12.2.2. In the training administration lifecycle, enrollments in events or classes frequently need to be reversed for reasons such as learner withdrawal, scheduling conflicts, or administrative error correction. OTA_CANCEL_API provides the programmatic entry point for performing these cancellations in a controlled, consistent manner, ensuring that booking statuses, finance records, and attendee counts are updated together rather than through ad hoc direct table manipulation. The package is documented in the ETRM repository and is referenced by the OTA_WF workflow package, indicating its role in workflow-driven cancellation and notification scenarios. It exposes four documented procedures and functions for external invocation.

Key Procedures and Functions

• CANCEL_ENROLLMENT — The principal procedure for cancelling an existing enrollment. It orchestrates the cancellation across the relevant booking and finance structures, serving as the primary business entry point for enrollment reversal.
• INITIAL_CANCEL_ENROLLMENT — Performs the initial setup or preparatory steps required before a cancellation is processed. It likely validates prerequisites and establishes the cancellation context for subsequent processing by CANCEL_ENROLLMENT.
• DELETE_CANCEL_LINE — Removes a specific cancellation line, allowing cancellation records or booking lines to be deleted as part of cleanup or correction of a cancellation transaction.
• UPD_MAX_ATTENDEE — Updates the maximum attendee count associated with an event or class. This supports capacity reconciliation so that a cancellation correctly restores or adjusts available seating figures.

No parameter lists are documented in the available metadata; the procedures should be treated as documented above by name and purpose only.

Tables Accessed

• OTA_BOOKING_STATUS_TYPES, OTA_BOOKING_STATUS_TYPES_TL — Reference the booking status definitions (and translations) used to assign the correct cancellation status to an enrollment.
• OTA_DELEGATE_BOOKINGS — Stores the delegate-to-booking relationships that must be maintained or removed when a learner's enrollment is cancelled.
• OTA_EVENTS, OTA_EVENTS_TL — Provide event and class details (and translations) needed to identify the training offering affected by the cancellation and to update attendance capacity.
• OTA_FINANCE_HEADERS, OTA_FINANCE_LINES — Hold the financial header and line records that are adjusted or reversed so that cancellation is reflected in training finance data.
• PER_ALL_PEOPLE_F — Supplies the person (learner) record associated with the enrollment being cancelled.
• FND_USER, FND_CONCURRENT_REQUESTS, DUAL — Support audit/context resolution, concurrent program integration, and general PL/SQL processing.

Usage Notes

OTA_CANCEL_API is typically invoked from Oracle Training Administration forms, from concurrent programs that process bulk cancellations, and from custom PL/SQL code or workflows that automate enrollment reversals. Because it is referenced by the OTA_WF package, cancellation events may be triggered as part of workflow-driven business processes. Developers should call the documented API procedures rather than updating the underlying booking, finance, and event tables directly, so that all dependent records and attendee counts remain consistent. As with most EBS APIs, standard commit and error-handling conventions apply, and callers should confirm the appropriate initialization is performed (via INITIAL_CANCEL_ENROLLMENT) before the main cancellation routine.