Search Results check_event_is_valid

Overview

APPS.OTA_EVT_SHD is the shadow (public wrapper) package body for the Oracle E-Business Suite event management API family, belonging to the OTA (Oracle Training Administration) product. In Oracle EBS 12.1.1 and 12.2.2, the "_SHD" suffix denotes a shadow package whose primary responsibility is to expose a stable, validated public interface while delegating insert, update, and delete operations to the underlying private API package, typically via the concurrent manager or a synchronous call. The header comment ($Header: otevt01t.pkb 120.13.12010000.2) confirms this is a 12.1-family body that remained current through 12.2 releases. Within the context of the user search "check_programme_members," this package contains the CHECK_PROGRAMME_MEMBERS procedure, which validates programme membership rules associated with training events. The API is classified as OTHER, meaning it is a supporting/internal API rather than a mandated business object API, and it is referenced by 17 other packages, indicating broad internal dependency across the OTA schema.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. Their purposes are:

• RETURN_API_DML_STATUS — Returns the boolean flag indicating whether the last API operation performed a DML action, driven by the internal g_api_dml global.
• CONSTRAINT_ERROR — Maps Oracle integrity constraint violations to user-facing FND messages (for example, OTA_EVENTS_FK1 and OTA_EVENTS_FK2), raising a localized error.
• API_UPDATING — Internal helper signaling that an update is in progress and setting the DML status flag.
• LCK — Performs row-level locking on the target event record to serialize concurrent modifications.
• CONVERT_ARGS — Translates the shadow package's public arguments into the argument structure expected by the private API.
• FETCH_EVENT_DETAILS — Retrieves and populates working records (G_FETCHED_REC) with event information.
• CHECK_PROGRAMME_MEMBERS — Validates programme membership records related to an event, ensuring delegate/programme associations are consistent before DML is committed.
• GET_EVENT_DETAILS — Returns event attributes to callers for display or downstream processing.
• GET_COURSE_DATES — Retrieves the relevant course dates associated with an event.
• CHECK_EVENT_IS_VALID — Confirms an event exists and is in a state valid for the requested operation.
• RESOURCE_BOOKING_FLAG — Determines whether resource booking applies to the event.
• PUBLIC_EVENT_FLAG — Determines whether the event is designated as a public event.
• INVOICED_AMOUNT_TOTAL — Calculates the total invoiced amount associated with the event's finance lines.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• OTA_EVENTS — The primary event entity; the target of validation, locking, and DML.
• OTA_PROGRAM_MEMBERSHIPS — Consulted by CHECK_PROGRAMME_MEMBERS to validate programme membership.
• OTA_EVENT_ASSOCIATIONS — Links events to related entities.
• OTA_DELEGATE_BOOKINGS — Delegate-level bookings tied to events.
• OTA_RESOURCE_BOOKINGS — Resource reservations supporting the booking flag logic.
• OTA_FINANCE_LINES — Source data for INVOICED_AMOUNT_TOTAL.
• OE_ORDER_LINES_ALL — Order line reference for financial reconciliation.

Usage Notes

OTA_EVT_SHD is invoked indirectly through Oracle Training Administration forms and concurrent programs, and by the 17 dependent packages that reference it. Custom code should call the shadow procedures rather than the private package, since the shadow layer enforces argument conversion and error mapping. Because CHECK_PROGRAMME_MEMBERS raises standard FND messages on failure, callers should anticipate and handle raised errors in a WHEN OTHERS block. Direct DML against the underlying tables is discouraged; all maintenance should flow through this API to preserve validation, locking, and audit behavior.