Search Results ota_tdb_shd




Overview
Explore in AI Chat

Overview

OTA_TDB_SHD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Training Administration (OTA) module, specifically the functionality surrounding delegate bookings, which underpins the Oracle Learning Management (OLM) subsystem. The "_SHD" suffix denotes a "shadow" package: a lightweight, auxiliary unit that supports a primary business object by encapsulating low-level housekeeping routines such as concurrency locking, DML state tracking, and argument conversion. Rather than exposing a full public business API, OTA_TDB_SHD provides internal services consumed by the delegate booking infrastructure.

The package is classified as OTHER in the ETRM 12.2.2 catalogue, indicating that it is an internal support unit rather than a public, documented API. Its documented status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents five procedures or functions within this package body:

  • RETURN_API_DML_STATUS — Returns the Data Manipulation Language status of the current API operation, allowing the calling program to determine whether inserts, updates, or deletes were performed during the invocation.
  • CONSTRAINT_ERROR — Handles constraint violations encountered during processing, providing a controlled mechanism for raising or reporting integrity errors rather than allowing raw Oracle exceptions to propagate.
  • API_UPDATING — Indicates whether the API is currently in an updating state, supporting state management across nested or sequential API calls.
  • LCK — Manages record locking, ensuring that concurrent sessions cannot simultaneously modify the same delegate booking data.
  • CONVERT_ARGS — Converts or normalises argument values passed into the package, supporting consistent data types and formats across API entry points.

Tables Accessed

The only table documented as referenced through APPS synonyms is OTA_DELEGATE_BOOKINGS. This table stores delegate booking records associated with training events and course enrolments. Because the package supplies locking and DML-status services, it interacts with OTA_DELEGATE_BOOKINGS primarily to enforce concurrency control and to track the effect of modifications made by higher-level APIs.

The dependency metadata also identifies references to FND_MESSAGE, HR_API, HR_UTILITY, and the STANDARD package. FND_MESSAGE is used for message retrieval and error reporting, while HR_API and HR_UTILITY supply shared Oracle HRMS utilities for data validation and common processing. The STANDARD package reference covers built-in PL/SQL constructs.

Usage Notes

OTA_TDB_SHD is not referenced by any database object according to the dependency metadata, and it is not itself a public API. It is invoked indirectly by other OTA packages that manage delegate bookings, which rely on its locking, DML status, and argument-conversion services to maintain consistency. The 12.2.2 metadata records twelve dependent packages, confirming that the unit is consumed by a cluster of internal OTA modules.

Because the package is an internal support unit, direct invocation from forms, concurrent programs, or custom extensions is not appropriate. Customisations that require delegate booking manipulation should use the supported public APIs, which will in turn exercise the internal routines housed within OTA_TDB_SHD. Any investigation of these routines is best performed through the dependency trail linking the twelve referencing packages to their ultimate form or concurrent program entry points.