Search Results ota_evt_shd




Overview
Explore in AI Chat

Overview

APPS.OTA_EVT_SHD is a shared PL/SQL package in the Oracle E-Business Suite OTA (Oracle Training Administration) product family. It functions as a central library of event-related utility logic consumed by the event transaction APIs, business logic layers, database triggers, and reporting views that make up the OTA event management subsystem. In the OTA data model, an "event" is a scheduled offering of a course or programme to which delegates, resources, and financial lines are attached. Because numerous packages and views require consistent rules for validating events, resolving event details, and enforcing booking constraints, OTA_EVT_SHD consolidates that logic into a single shared ("SHD") package rather than duplicating it across the insert, update, and delete handlers.

The package is classified under the OTHER API category in the ETRM 12.2.2 documentation and carries a VALID status in the APPS schema. Its dependency footprint confirms its role as a foundational shared component: the dependency listing shows it is referenced by seventeen other packages and views, including OTA_EVT_INS, OTA_EVT_UPD, OTA_EVT_DEL, OTA_EVT_BUS, OTA_EVT_BUS2, OTA_EVT_API_UPD2, OTA_TDB_BUS, OTA_TDB_DEL, OTA_DELEGATE_BOOKING_API, and OTA_OM_TDB_WAITLIST_API, along with the OTA_EVENTS_V, OTA_EVENT_SEARCH_V, OTA_EVENT_SEARCH_V2, OTFV_TRAINING_EVENTS, OTFV_CUST_RESTRICTED_EVENTS, and OTFV_HR_RESTRICTED_EVENTS views.

Key Procedures and Functions

The documented interface exposes thirteen procedures and functions. The event retrieval routines CENTRALIZE access to event data: GET_EVENT_DETAILS returns detail for a specified event, while FETCH_EVENT_DETAILS performs the corresponding fetch operation for callers processing event records. GET_COURSE_DATES resolves the course date information associated with an event.

Validation and status routines enforce business rules. CHECK_EVENT_IS_VALID verifies that a given event is in a state permitting the requested operation. CHECK_PROGRAMME_MEMBERS validates membership relationships between events and programmes. RETURN_API_DML_STATUS reports whether a DML operation performed through the API succeeded, and API_UPDATING flags that the package is executing in an API-driven update context, allowing dependent logic to distinguish API writes from other modifications.

Flag and amount helpers supply derived values: RESOURCE_BOOKING_FLAG indicates whether an event requires or carries resource bookings; PUBLIC_EVENT_FLAG indicates whether the event is publicly visible; and INVOICED_AMOUNT_TOTAL returns the aggregated invoiced amount associated with an event. Utility routines include LCK for locking, CONVERT_ARGS for argument conversion, and CONSTRAINT_ERROR, which signals a constraint violation encountered during processing.

Tables Accessed

The package reads and writes through APPS synonyms for several core OTA tables. OTA_EVENTS is the primary event header. OTA_EVENT_ASSOCIATIONS and OTA_PROGRAM_MEMBERSHIPS support event-to-programme and related association checks used by CHECK_PROGRAMME_MEMBERS. OTA_DELEGATE_BOOKINGS underpins delegate booking validation, while OTA_RESOURCE_BOOKINGS supports resource booking flags and availability logic. OTA_FINANCE_LINES provides the financial data aggregated by INVOICED_AMOUNT_TOTAL. OE_ORDER_LINES_ALL is accessed to reconcile training events with order lines created in Order Management, reflecting the integration between OTA and OM for paid training.

Usage Notes

OTA_EVT_SHD is not typically invoked directly from a form. It is called indirectly whenever an event is created, modified, or deleted through the OTA event APIs, when event search views such as OTA_EVENT_SEARCH_V are queried, and when training event reporting views are accessed. Its internal locking, validation, and flag routines therefore execute throughout normal event maintenance, seat and resource booking, delegate enrollment, and financial reconciliation flows. Customizations and extensions that manipulate OTA events should invoke the public OTA event APIs rather than calling OTA_EVT_SHD directly, preserving the shared validation and locking behavior on which the dependent packages rely.