Search Results create_class

Overview

OTA_EVENT_API is a public application programming interface within the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 environment, owned by the APPS schema and classified by the E-Business Suite Technical Reference Manual (ETRM) as an API. The package encapsulates the business logic required to create, maintain, and remove OTA "class" records, which represent scheduled and self-paced learning events within the Oracle Training Administration (OTA) module of Oracle Learning Management. By exposing a controlled, server-side interface over the underlying OTA_EVENTS, OTA_CHATS, and OTA_TESTS data model, the package ensures that validation, timezone handling, chat session synchronization, and object versioning conventions are applied consistently regardless of the calling channel. It also insulates callers from direct Data Manipulation Language (DML) against the base tables, which is essential for maintaining data integrity across the shared OTA schema. The source header indicates a last shipped revision of 120.5.12020000.2, dated 29 June 2012, confirming the package is part of the shipped 12.2 code line.

Key Procedures and Functions

The ETRM documents four public procedures and functions for this package body. Their purposes are as follows:

• CREATE_CLASS — Inserts a new class (event) record and its associated detail rows, applying the standard OTA validation and defaults required before the class can be scheduled.
• UPDATE_CLASS — Modifies the attributes of an existing class record, performing the same validation checks as creation while preserving the identity of the parent event. This routine is also invoked internally by the private update path described in the body source.
• DELETE_CLASS — Removes a class and any dependent child records so that orphaned detail rows do not remain in the OTA tables, respecting the referential relationships enforced by the schema.
• ADD_EVALUATION — Associates an evaluation definition with a class so that learners attending the event can be assessed through the standard evaluation mechanism.

In addition to these documented public entries, the package body contains private helpers not exposed in the ETRM listing, including a timezone-change detection function and a chat-session update routine used to propagate timezone changes to related chats and child sessions.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• OTA_EVENTS — The principal class/event table; holds the class definition, timezone, parent event identifier, and object version number. It is queried to detect timezone changes and to locate child sessions.
• OTA_CHATS_B and OTA_CHATS_TL — Base and translation tables for chat sessions linked to a class, updated so chat timezones and descriptive text remain consistent with the parent event.
• OTA_CHAT_OBJ_INCLUSIONS — The inclusion table that links chats to an event object; joined to identify which chats belong to the class being changed.
• OTA_TESTS — Test definitions that may be attached to the class as part of its content structure.
• OTA_EVALUATIONS — Evaluation records written by ADD_EVALUATION to associate assessment instruments with the class.

Usage Notes

OTA_EVENT_API is a server-side API and is not intended for direct invocation from SQL*Plus or ad hoc scripts without an appropriate initialization of the FND_GLOBAL session context. It is typically called from the Oracle Learning Management forms and from concurrent programs that create or maintain classes in bulk, as well as from custom PL/SQL integrations that must respect the OTA business rules. The package is referenced by five other OTA packages, indicating it participates in a wider dependency chain; callers should therefore honor the documented object version number parameters to avoid concurrent update conflicts. Because the routines perform validation and cascading maintenance of chat and evaluation data, direct DML against the underlying tables should be avoided in favor of this API.