Search Results ota_evt_del




Overview
Explore in AI Chat

Overview

OTA_EVT_DEL is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Training Administration (OTA) product family as an "OTHER" API type. Its name and dependency graph identify it as the deletion-handling component of the Event Management subsystem within Oracle Learning Management and Oracle iLearning. The package encapsulates the business logic required to remove or logically retire event records held in the OTA_EVENTS table while preserving the integrity of dependent scheduling, enrollment, and resource-booking data.

The object carries a status of VALID in both Release 12.1.1 and 12.2.2, indicating that no invalidations were introduced by the Online Patching (ADOP) infrastructure in the later release. The package body is documented with two entries, the principal one being the DEL procedure. Its dependency list shows that it relies on OTA_EVENTS, OTA_EVT_BUS, and OTA_EVT_SHD to perform its work, and on HR_API, HR_MULTI_MESSAGE, HR_UTILITY, and STANDARD for error handling and message propagation through the Oracle HRMS shared libraries.

Key Procedures and Functions

  • DEL — The sole documented procedure in the package. It performs the deletion of an event record, accepting the identifying information for the target event and coordinating the removal of associated milestone and business-event data before the master OTA_EVENTS row is deleted. It is not documented as returning a value; as is standard for OTA deletion APIs, error conditions are surfaced through the HR_MULTI_MESSAGE mechanism rather than through an explicit return code.

No additional procedures or functions are listed in the documented metadata, and no parameter signatures are published in the ETRM extract; the procedure should therefore be treated solely by name and purpose.

Tables Accessed

  • OTA_EVENTS — Referenced through an APPS synonym. This is the master event table holding training event definitions. OTA_EVT_DEL reads and deletes rows here as the primary target of its operation.
  • OTA_EVT_BUS — The event business rules/booking support table, invoked through the OTA_EVT_BUS package dependency, to validate whether an event may legally be removed given existing business constraints.
  • OTA_EVT_SHD — The event shadow table, used to archive or stage the event record prior to physical deletion, supporting audit and recovery requirements.

Usage Notes

OTA_EVT_DEL is not referenced by any other database object according to the ETRM dependency report, which confirms it is a terminal, leaf-level API rather than a shared utility. It is instead referenced by two other packages, which act as its callers.

Typical invocation occurs from the Oracle Learning Management event maintenance forms and from concurrent programs that purge obsolete or cancelled training events. Custom extensions that need to remove events programmatically should call the DEL procedure rather than issuing direct DML against OTA_EVENTS, because the package enforces the archive-to-OTA_EVT_SHD step and the business-rule checks implemented through OTA_EVT_BUS. Because OTA_EVT_DEL is not referenced by any other package, it can be modified with relatively low regression risk, but the two packages that call it must be re-validated after any change to its behavior.