Search Results relieve_reservation

Overview

APPS.AHL_RSV_RESERVATIONS_PVT is a private PL/SQL package belonging to the Oracle Enterprise Asset Management (eAM) and Complex Maintenance Repair and Overhaul (CMRO) application family, identified by the AHL prefix. Its principal business function is to manage the reservation and relief of serialized material against scheduled maintenance activities. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package acts as the programmatic engine behind reservation processing for visits, work orders, and material requirements generated within the maintenance lifecycle.

The package is classified as a Private (PVT) API, which indicates it is not intended for direct invocation by external or customer-developed code. Instead, it is consumed internally by public APIs and application modules that expose reservation functionality to end users. The header comment "$Header: AHLVRSVS.pls 120.3.12010000.2" confirms the file was last revised in the 12.1 code line and carried forward into 12.2.2, and the embedded annotation "R12 Enhanced reservations code changes" documents the introduction of enhanced reservation handling in Release 12.

Key Procedures and Functions

The package exposes eight documented procedures, each addressing a discrete stage of the reservation lifecycle:

• CREATE_RESERVATION — Reserves serial numbers supplied through a serial number table type against a scheduled material identifier. This procedure embodies the core reservation creation logic.
• UPDATE_RESERVATION — Modifies an existing reservation record, typically to adjust quantities, serial assignments, or reservation attributes.
• DELETE_RESERVATION — Removes a reservation record entirely from the maintenance material schedule.
• RELIEVE_RESERVATION — Relieves, or releases, a previously placed reservation, returning the reserved inventory quantity to an available state. This is the procedure users most commonly associate with the search term "relieve_reservation."
• TRANSFER_RESERVATION — Moves a reservation from one schedule material, visit, or work order context to another.
• UPDATE_VISIT_RESERVATIONS — Performs bulk updates to all reservations associated with a given visit.
• DELETE_VISIT_RESERVATIONS — Removes all reservations linked to a visit, typically during visit cancellation or closure.
• TRNSFR_RSRV_FOR_MATRL_REQR — Transfers reservations in response to material requirement changes, aligning reserved stock with revised demand.

The package defines a serial_number_rec_type record and a corresponding serial_number_tbl_type associative array indexed by BINARY_INTEGER, which carries inventory item and serial number pairs into the reservation procedures. All procedures follow the standard Oracle API conventions, accepting p_api_version, p_init_msg_list, p_commit, p_validation_level, and p_module_type parameters and returning x_return_status, x_msg_count, and x_msg_data.

Tables Accessed

The package interacts with the following tables through APPS synonyms:

• AHL_SCHEDULE_MATERIALS — The primary driver table; reservations are keyed to scheduled material lines.
• AHL_VISITS_B and AHL_VISIT_TASKS_B — Supply the visit and task context for reservations and bulk visit operations.
• AHL_WORKORDERS — Links reservations to the work order that consumes the reserved material.
• CSI_ITEM_INSTANCES — Provides item instance (serialized unit) information for installed base tracking.
• MTL_RESERVATIONS — The Oracle Inventory reservation table where the actual on-hand reservation is recorded or relieved.
• MTL_SERIAL_NUMBERS — Validates and tracks the serial numbers being reserved.
• PLITBLM — A temporary/PL/SQL table used for intermediate processing.

Usage Notes

Because AHL_RSV_RESERVATIONS_PVT is a private API, it is normally invoked indirectly through the eAM/CMRO maintenance forms and public wrapper packages rather than by direct call. It is referenced by nine other packages within the AHL schema, confirming its role as a shared internal service layer. Customers extending reservation behavior should prefer the corresponding public APIs or the Maintenance Workbench and Visit Management forms. Direct invocation from custom code is discouraged, as the private signature may change between patch levels; the RELIEVE_RESERVATION procedure in particular is triggered automatically when a work order material line is completed, cancelled, or when reserved stock is manually released through the user interface.