Search Results ota_delegate_booking_api




Overview
Explore in AI Chat

Overview

APPS.OTA_DELEGATE_BOOKING_API is a PL/SQL application programming interface package within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It belongs to the Oracle Training Administration (OTA) module, which is a component of Oracle Learning Management (OLM), itself part of the Oracle Human Resources family of products. The package encapsulates the core business logic required to manage delegate bookings, which represent the enrollment of a learner (delegate) into a scheduled training event or course offering.

The package serves as the primary programmatic entry point for creating, modifying, and removing delegate bookings, as well as for managing associated finance headers and waitlist state transitions. By centralizing this logic within a single API, Oracle ensures that booking operations are executed consistently, regardless of whether they originate from the standard OLM forms, concurrent programs, or external integrations. The package is owned by the APPS schema and is currently in a VALID state, confirming its integrity within the EBS data dictionary.

Key Procedures and Functions

The package exposes six documented procedures and functions that cover the delegate booking lifecycle:

  • CREATE_DELEGATE_BOOKING — Establishes a new booking record linking a delegate to a training event. This is the primary entry point for enrolling learners and typically triggers downstream validation and finance processing.
  • UPDATE_DELEGATE_BOOKING — Modifies an existing booking record, allowing changes to booking attributes such as status or associated details.
  • DELETE_DELEGATE_BOOKING — Removes a delegate booking, reversing the enrollment and handling any dependent records.
  • UPDATE_WAITLISTED — Manages the transition of a delegate from a waitlisted state, typically when capacity becomes available or the booking is confirmed.
  • CHK_MANDATORY_PREREQS — Validates that mandatory prerequisites for the booking have been satisfied before enrollment proceeds.
  • CREATE_FINANCE_HEADER — Generates the finance header record required to associate financial tracking with a delegate booking.

Tables Accessed

The package reads from and writes to a range of OTA and shared EBS tables through APPS synonyms, including but not limited to OTA_DELEGATE_BOOKINGS, OTA_ATTEMPTS, OTA_EVALUATIONS, OTA_EVENTS, OTA_EVENTS_TL, OTA_ACTIVITY_VERSIONS, OTA_BOOKING_STATUS_HISTORIES, OTA_BOOKING_STATUS_TYPES, OTA_CATEGORY_USAGES, and OTA_FINANCE_LINES. It also references foundational EBS entities such as FND_USER, HR_ALL_ORGANIZATION_UNITS, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, and HZ_RELATIONSHIPS, reflecting the integration of learning records with HR and Trading Community Architecture (TCA) data.

Usage Notes

OTA_DELEGATE_BOOKING_API is typically invoked from OLM booking forms, concurrent programs, and custom extensions that require programmatic enrollment. It is referenced by four other packages, including OTA_DELEGATE_BOOKING_SWI, OTA_TDB_API_INS2, OTA_TDB_API_UPD2, and PQP_RIW_ENROLL_WRAPPER, indicating its role as a shared utility. The package depends on HR_API and STANDARD, and developers should invoke it rather than manipulating underlying tables directly to preserve data integrity and business rules.