Search Results ota_adt_del




Overview
Explore in AI Chat

Overview

OTA_ADT_DEL is an Oracle Applications (APPS) PL/SQL package body classified under the Oracle E-Business Suite Training (OTA) module. Its functional scope centers on the deletion of translated activity definition records maintained by the Oracle Learning Management (OLM) application. The package is validated (VALID status) in both the 12.1.1 and 12.2.2 releases and is owned by the APPS schema, which is the standard convention for EBS seeded database objects.

The naming convention "ADT" denotes Activity Definition translations, and the "_DEL" suffix confirms the package's role as the delete-operation counterpart to the ADT family. Within OLM, activity definitions are the catalog entities describing courses, offerings, and other learning objects, and their descriptive (translated) text is stored in the OTA_ACTIVITY_DEFINITIONS_TL table. The package exists to provide a controlled, API-based mechanism for removing translated rows while enforcing the referential and business-rule integrity managed by the surrounding OTA ADT infrastructure. The ETRM metadata classifies the API as "OTHER," meaning it is an internal utility package rather than a public, externally-documented integration interface; nevertheless, it participates fully in the OLM data model and its dependencies indicate it is tightly coupled to the ADT business logic layer.

Key Procedures and Functions

The documented interface consists of a single procedure, DEL_TL. Consistent with Oracle's translation-table maintenance pattern, this procedure is responsible for the deletion of translation-layer (TL) records associated with activity definitions. Typical usage involves purging the language-specific descriptive rows for a given activity definition identifier, either as part of a broader delete cascade or during correction of mistranslated/populated data. The procedure encapsulates the delete logic so that callers do not manipulate OTA_ACTIVITY_DEFINITIONS_TL directly, preserving consistency with the OTA ADT business rules. No parameter list is documented in the ETRM extract, and none should be assumed; integrators must inspect the package specification in the target environment to determine the exact signature.

Tables Accessed

The single documented table reference — via an APPS synonym — is OTA_ACTIVITY_DEFINITIONS_TL. This is the translation table holding the language-dependent attributes (such as name and description) for activity definitions across installed languages. DEL_TL performs its deletion work against this table, removing rows for the target activity definition. Because it is a TL table, FOREIGN KEY-style relationships are maintained through the base table (OTA_ACTIVITY_DEFINITIONS_B) and language conventions; the package's dependency list reflects that it also relies on the ADT business package and the shared OTA ADT shadow/record-key packages (OTA_ADT_BUS, OTA_ADT_RKD, OTA_ADT_SHD) that enforce the OLM audit and referential-integrity framework.

Usage Notes

OTA_ADT_DEL is an internal package and is not referenced by any other database object according to the dependency data, meaning it is not called by dependent PL/SQL units such as concurrent program wrappers. Instead it is invoked directly by the Oracle Learning Management forms and by the OLM business logic (notably OTA_ADT_BUS) that orchestrates activity definition maintenance. In practice, it executes when an administrator deletes a translated activity definition through the OLM user interface, or when maintenance utilities purge obsolete translation rows. It should not typically be called directly by custom code; instead, customizations should invoke the higher-level OLM APIs, which in turn call this delete routine. Dependencies on HR_API, HR_MULTI_MESSAGE, and HR_UTILITY confirm that errors are raised and messaged through the standard HR/OLM message framework, and that standard Oracle error-handling conventions apply.