Search Results update_resource_booking

Overview

OTA_RESOURCE_BOOKING_API is a public PL/SQL application programming interface that is owned by the APPS schema and shipped as part of the Oracle Learning Management (OLM) module within Oracle E-Business Suite Release 12.1.1 and 12.2.2. In ETRM terms the object is classified as an API, and it exposes a controlled, business-rule-aware surface for creating, maintaining, and removing resource bookings against scheduled training or event offerings.

A "resource booking" represents the commitment of a suppliable resource — such as an instructor, room, or piece of equipment — to a particular event or class. Because such commitments feed downstream scheduling, capacity, and cost calculations, direct DML against the underlying tables is discouraged. This package centralises the required validation and transactional logic, invoking the relevant business rules and maintaining the integrity of the booking records against the associated event and suppliable resource definitions.

Key Procedures and Functions

The documented API surface comprises three public procedures, each handling one lifecycle operation for a resource booking:

• CREATE_RESOURCE_BOOKING — Inserts a new resource booking, associating a suppliable resource with an event for a defined period. It applies the package's validation logic before committing the record through the underlying insert handler.
• UPDATE_RESOURCE_BOOKING — Modifies an existing booking, for example to adjust booking dates or resource assignment details, applying the same business-rule checks used at creation.
• DELETE_RESOURCE_BOOKING — Removes an existing resource booking, maintaining referential and business consistency for the event and resource concerned.

Parameter lists are not reproduced here; callers should obtain the exact signatures from the package specification in the database (for example via ALL_ARGUMENTS) rather than assuming argument names or order.

Tables Accessed

The package operates against the following documented tables, resolved through APPS synonyms:

• OTA_RESOURCE_BOOKINGS — The primary transactional table storing the booking records that are created, updated, and deleted by the API.
• OTA_EVENTS — The event or class definition to which a booking is tied; read to validate the parent event context.
• OTA_SUPPLIABLE_RESOURCES — The definition of the resource being booked; read to confirm the resource is valid and eligible for booking.

The broader dependency list also shows supporting objects such as OTA_RESOURCE_BOOKING_BK1/BK2/BK3 (the underlying DML handlers), OTA_TRB_INS, OTA_TRB_UPD, OTA_TRB_DEL, and OTA_UTILITY, plus HR_API and HR_UTILITY, indicating that HR person data (PER_PEOPLE_F) is consulted during processing.

Usage Notes

This API is the supported entry point for programmatic resource booking. It is typically invoked from OLM scheduling and resource-management forms, from concurrent programs and workflow activities that automate class scheduling, and from custom extensions or integrations that must populate or correct resource bookings within APPS. Because the package is not referenced by any other database object, it is intended for external or UI-level invocation rather than as an internal helper. Custom code should call the documented procedures instead of writing directly to OTA_RESOURCE_BOOKINGS, and should run with the standard EBS API conformance conventions — initialising the environment, passing the correct WHO columns, and handling the API's return status and error messages.