Search Results ota_ent_del




Overview
Explore in AI Chat

Overview

The APPS.OTA_ENT_DEL package is a delivery-side utility within the Oracle E-Business Suite (EBS) Learning Management / Training Administration (OTRM) product family. Its name follows Oracle's convention for a "delete" helper package: OTA_ENT_ indicates an entity maintenance routine belonging to the OTA schema domain, and the DEL suffix denotes deletion processing. The package is owned by the APPS schema and holds a VALID status in both Release 12.1.1 and 12.2.2. The ETRM metadata classifies it with an API classification of OTHER, meaning it is an internal helper rather than a published, externally supported public API.

Broadly, this package serves the housekeeping function of removing or purging training event definition records — specifically the translatable, language-dependent content held in the OTA_EVENTS_TL table. Because Oracle maintains multilingual (translation-level) rows separately from the base entity rows, a dedicated routine is required to clean these up safely during event deletion.

Key Procedures and Functions

The documented metadata lists a single program unit for this package:

  • DEL_TL — A procedure that performs the translation-layer deletion for a training event. Its name reflects the "_TL" suffix convention, indicating it operates on the translation table rather than the base entity table. Because the ETRM record does not publish a parameter list, the precise signature is not reproduced here; the procedure exists to remove the language-specific event rows associated with a given event.

This minimal footprint confirms the package is a narrow, single-purpose utility rather than a broad functional module.

Tables Accessed

The documented table reference for OTA_ENT_DEL is:

  • OTA_EVENTS_TL — the translation table that stores language-dependent textual attributes of a training event, such as its name and description per installed language. The DEL_TL procedure accesses this table to remove those translation rows as part of event cleanup.

Access is performed via the APPS synonyms that resolve to the underlying base tables.

Usage Notes

Per the dependency metadata, APPS.OTA_ENT_DEL is referenced by two other packages: OTA_EVENT_API and OTA_PMM_API. This indicates it is not intended for direct invocation by end users, but is called internally by higher-level event and competency-management APIs during their own deletion logic. It should therefore be treated as an internal dependency.

Typical invocation scenarios include:

  • Called within the event deletion path of the OTA_EVENT_API when a training event is removed.
  • Invoked through OTA_PMM_API processing that purges event-related records.
  • Not typically surfaced through a standalone concurrent program or Oracle Forms screen, as no dedicated UI or scheduled request references it in the documented dependencies.

Because the package is classified as OTHER and exposes only one undocumented-signature procedure, Oracle support does not guarantee a stable interface. Custom code should avoid calling OTA_ENT_DEL directly and instead use the documented public APIs that invoke it. Its dependency on SYS.STANDARD is the ordinary PL/SQL built-in package every stored unit relies upon, not a meaningful external dependency.