Search Results ota_delegate_booking_swi




Overview
Explore in AI Chat

Overview

The APPS.OTA_DELEGATE_BOOKING_SWI package body is a server-side wrapper (SWI) within the Oracle E-Learning Management (OTRM) module of Oracle E-Business Suite. Its role is to provide a simplified, single-entry interface for creating, maintaining, and removing delegate booking records. A delegate booking represents the association between a learner (delegate) and a scheduled offering, capturing enrollment or attendance details generated through Oracle Learning Management. The SWI isolates the caller from the underlying business logic contained in OTA_DELEGATE_BOOKING_API, exposing only the three core DML operations required to manage the lifecycle of a delegate booking. The package is marked VALID in the APPS schema and carries an API classification of OTHER, reflecting its role as a convenience layer rather than a full public API.

Key Procedures and Functions

The package body documents three procedures, each mapping to a standard DML operation against the delegate booking entity:

  • CREATE_DELEGATE_BOOKING — Inserts a new delegate booking, establishing the initial linkage between a learner and a scheduled offering. It delegates the actual insert to the underlying API and infrastructure routines.
  • UPDATE_DELEGATE_BOOKING — Modifies attributes of an existing delegate booking, such as booking status or related learner data. It routes changes through the delegate booking API to preserve validation and business rules.
  • DELETE_DELEGATE_BOOKING — Removes an existing delegate booking record, typically corresponding to a cancellation of an enrollment.

All three procedures rely on the same supporting infrastructure and do not introduce separate processing logic beyond orchestrating the call into OTA_DELEGATE_BOOKING_API.

Tables Accessed

The primary table accessed is OTA_DELEGATE_BOOKINGS, referenced through an APPS synonym. This table stores the delegate booking rows that the three procedures create, update, and delete. Persistent writes to this table are performed indirectly through OTA_DELEGATE_BOOKING_API and, in the case of inserts, through OTA_TDB_INS, which the package body depends on. These dependencies confirm that the SWI does not issue raw DML against the underlying table but instead layers on top of the documented API and table-handler components.

Usage Notes

Because OTA_DELEGATE_BOOKING_SWI is not referenced by any other database object, it functions as a top-of-stack entry point invoked directly by client-side or integration code. Callers typically include Oracle EBS forms within the OTA/OTRM application family, custom PL/SQL routines, and external integrations that require a stable, narrow interface for delegate booking maintenance. The package also depends on shared HR utilities — HR_API, HR_MULTI_MESSAGE, and HR_UTILITY — which indicates that error handling and multi-message reporting follow Oracle HRMS conventions. When invoked in 12.1.1 or 12.2.2, the calling session must operate under a valid APPS context with the appropriate OTA responsibilities so that the underlying API validations and security checks resolve correctly. Because it wraps rather than replaces OTA_DELEGATE_BOOKING_API, direct calls to the API remain possible, but the SWI remains the recommended lightweight entry point for the three documented operations.