Search Results ota_adt_shd




Overview
Explore in AI Chat

Overview

OTA_ADT_SHD is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its name follows the naming convention used for Oracle iLearning and Oracle Learning Management (OTM) "shadow" or private implementation packages. In EBS 12.1.1 and 12.2.2 the OTA_% family supports the activity and content-authoring structures of the learning application, and the _SHD suffix typically denotes an internal, non-public package that exposes utility entry points and versioned upgrade routines rather than a published business API. The ETRM classification for this object is OTHER, confirming that it is not documented as an external integration API. The package is registered as VALID in the APPS schema and is depended upon by four other packages, indicating that it acts as a supporting layer for higher-level learning modules. Its principal responsibilities are internal housekeeping: language installation for translatable activity data, argument conversion for the calling application, concurrency control, and the constraint and error handling that surrounds updates to activity definitions.

Key Procedures and Functions

The ETRM metadata documents five program units within this package body:

  • CONSTRAINT_ERROR — Handles constraint violation conditions raised while activity definition records are being processed, translating Oracle constraint failures into application-level error reporting.
  • API_UPDATING — Provides a flag or guard that indicates the package (or the surrounding API stack) is currently performing an update, allowing callers to suppress conflicting logic while a write operation is in progress.
  • LCK — Implements locking for the records under manipulation, ensuring that concurrent sessions do not corrupt activity definition data.
  • ADD_LANGUAGE — Inserts the language rows required for the translatable activity definition tables, working in conjunction with FND_LANGUAGES.
  • CONVERT_ARGS — Standardizes or transforms the arguments passed by the caller before they are consumed by the underlying DML, a pattern common to shadow packages that sit beneath a public API.

Parameter lists are not disclosed in the documented metadata and should be verified directly against the package specification before any custom invocation.

Tables Accessed

Dependencies show the package working with OTA_ACTIVITY_DEFINITIONS and its translation table OTA_ACTIVITY_DEFINITIONS_TL, which hold the base and language-specific definitions of learning activities. FND_LANGUAGES and FND_MESSAGE are used to resolve installed languages and to produce user-facing messages, while ALL_CONSTRAINTS is queried to identify constraint definitions relevant to the error-handling logic. HR_API and HR_UTILITY supply standard Oracle HRMS utility calls, and the SYS STANDARD package is referenced for the built-in PL/SQL runtime.

Usage Notes

Because OTA_ADT_SHD is referenced by four other packages and is not a published API, it should be treated as an internal component of the learning application. It is normally invoked indirectly through the higher-level learning packages and their forms or concurrent programs, not called directly from customer extensions. Where a custom program must call it, dependencies on HR_API and HR_UTILITY mean it must execute in a session with the standard HR security context and APPS initialization, and any direct call must respect the locking behavior of LCK and the state maintained by API_UPDATING. The package is language-aware and should be re-run only as part of legitimate language installation or upgrade procedures. Any modification should be avoided, as Oracle maintains it as a private implementation object and patches may replace it without notice.