Search Results ota_event_api




Overview
Explore in AI Chat

Overview

OTA_EVENT_API is a public PL/SQL package in the APPS schema that exposes the business logic for maintaining Oracle iLearning (Oracle Training Administration, OTA) event and class definitions. The package is classified as an API in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2, meaning it forms part of the supported programmatic interface through which external and internal callers create and maintain learning event structures without writing directly against the underlying OTA tables.

The package depends on HR_API and the SYS STANDARD package, confirming that it integrates with the Oracle HRMS foundation layer that underpins OTA. Its status is VALID, and it is registered with both a package specification and a package body, so the documented entry points are callable from any component with execute privilege on APPS.OTA_EVENT_API.

Key Procedures and Functions

ETRM documents four entry points in the package specification. Each is a named API procedure intended to be called rather than extended.

  • CREATE_CLASS — Creates a new class record, establishing the base event/class row and its associated descriptive information so that the offering can subsequently be scheduled, enrolled against, and evaluated.
  • UPDATE_CLASS — Modifies an existing class definition, allowing changes to be applied to previously created class data while preserving referential integrity with dependent OTA entities.
  • DELETE_CLASS — Removes a class definition, reversing the creation performed by CREATE_CLASS and cleaning up the associated rows maintained by this API.
  • ADD_EVALUATION — Associates an evaluation with an event or class, linking the evaluation definition held in OTA_EVALUATIONS to the learning activity so that participants can be assessed.

No parameter lists are reproduced here; callers should obtain the authoritative signatures from the package specification in the target instance, as they may differ between 12.1.1 and 12.2.2.

Tables Accessed

The package operates against the following tables through APPS synonyms, which are owned by the OTA product schema:

  • OTA_CHATS_B and OTA_CHATS_TL — the base and translation tables for class/chat session definitions, providing the language-dependent and language-independent attributes maintained by CREATE_CLASS and UPDATE_CLASS.
  • OTA_CHAT_OBJ_INCLUSIONS — defines which objects are included in a class, supporting the composition of class content.
  • OTA_EVENTS — the event header that a class belongs to, tying class maintenance back to the parent learning event.
  • OTA_EVALUATIONS — the evaluation definitions referenced by ADD_EVALUATION.
  • OTA_TESTS — test definitions associated with events and classes, used to validate learning outcomes.

Usage Notes

OTA_EVENT_API is an internal building block rather than a primary user interface entry point. In the documented dependency graph it is referenced by the OTA_EVENT_SWI switch package, OTA_OFF_UPD, and the PQP_RIW_CLASS_WRAPPER and PQP_RIW_OFFERING_WRAPPER packages. This indicates that it is typically invoked indirectly: the OTA forms layer, concurrent programs, and OTA self-service flows route class and evaluation maintenance through these wrapper and switch packages, which in turn call OTA_EVENT_API.

Custom code should also call the package through the supported API entry points rather than inserting or updating OTA_CHATS_B, OTA_CHATS_TL, OTA_CHAT_OBJ_INCLUSIONS, OTA_EVALUATIONS, OTA_EVENTS, or OTA_TESTS directly, because CREATE_CLASS, UPDATE_CLASS, DELETE_CLASS, and ADD_EVALUATION encapsulate the validation, translation, and cross-table coordination required to keep the OTA data model consistent. Direct DML bypasses these rules and risks orphaned rows in the translation and inclusion tables. When invoking the package from custom PL/SQL, callers must ensure the correct APPS session context is initialised, since the API relies on HR_API and therefore on the HR security model that governs OTA records.