Search Results ota_evt_bus2




Overview
Explore in AI Chat

Overview

OTA_EVT_BUS2 is a business-layer PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Training Administration (OTA) product family, which supports the administration of training events, delegate enrollments, resource bookings, and financial tracking. The package encapsulates core business rules governing training event capacity, event status transitions, and integrity checks that surround event locking and enrollment. It is classified as OTHER in the ETRM metadata, indicating that it is not a formally published open interface but rather an internal business API consumed by other OTA components.

Functionally, OTA_EVT_BUS2 is the enforcement point for constraints on attendance limits, waiting list handling, mandatory associations, and resource or finance commitments attached to an event. It abstracts these rules so that calling code does not manipulate the underlying OTA tables directly. The ETRM documentation records ten documented procedures and functions and confirms that the package is referenced by ten other packages, underscoring its role as a shared internal service within the OTA module.

Key Procedures and Functions

  • LOCK_EVENT — Locks the specified event record, providing the mechanism by which concurrent activity against an event is serialized.
  • GET_TOTAL_PLACES — Returns the total number of placed delegates for an event, with a parameter that distinguishes between all delegates and internal delegates.
  • CHECK_PLACES — Validates the maximum attendee and maximum internal attendee values when they are updated, ensuring configured limits remain consistent.
  • RESET_EVENT_STATUS — Resets the status of an event, including when the event has reached full capacity; it also manages the object version number for optimistic locking.
  • RESOURCE_BOOKING_EXISTS — Determines whether resource bookings exist for the event.
  • FINANCE_LINE_EXISTS — Determines whether finance lines exist for the event.
  • GET_VACANCIES — Derives the number of remaining available places for the event.
  • WAIT_LIST_REQUIRED — Indicates whether a delegate should be placed on the waiting list.
  • CHECK_MANDATORY_ASSOCIATIONS — Validates mandatory associations configured for the event.
  • MANDATORY_ASSOCIATIONS_EXISTS — Tests whether mandatory associations are present for the event.

Tables Accessed

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

  • OTA_EVENTS — the primary event record, updated during locking, status reset, and capacity checks.
  • OTA_DELEGATE_BOOKINGS — supplies the delegate counts used by GET_TOTAL_PLACES and vacancy calculations.
  • OTA_BOOKING_STATUS_TYPES — provides status classifications used when counting placed delegates.
  • OTA_RESOURCE_BOOKINGS — queried by RESOURCE_BOOKING_EXISTS to detect existing resource commitments.
  • OTA_FINANCE_LINES — queried by FINANCE_LINE_EXISTS to detect existing financial entries.
  • OTA_EVENT_ASSOCIATIONS — used by the mandatory association checks to validate configured relationships.

Usage Notes

OTA_EVT_BUS2 is invoked by the OTA forms and by other OTA business packages rather than being called directly by end users. Capacity validation and event locking are typically triggered from the event and delegate booking maintenance forms, while the existence checks (resource bookings, finance lines, mandatory associations) support validation before delete, update, or status change operations. The documented reference by ten other packages confirms that it is a dependency for higher-level OTA processing. Custom code should invoke these procedures and functions through APPS synonyms, observing the documented signature and the optimistic locking behavior of RESET_EVENT_STATUS. The LOCK_EVENT procedure should precede modifications where concurrent changes to event capacity are possible.