Search Results process_reservation

Overview

INV_RSV_DETAIL_STAGE_PVT is a private PL/SQL package in the Oracle EBS Inventory (INV) application, owned by APPS and classified as a PVT (private) API. It provides the internal engine that details and stages material reservations within Oracle Inventory. In Oracle EBS, reservations may be held at the organization level or be fully detailed down to a specific inventory SKU or serial number. This package performs the mechanics of converting or expanding a reservation so that it is applied against a particular item, revision, lot, subinventory, and locator, and optionally "stages" that reservation for subsequent processing such as picking, shipping, or move-order generation. The package header carries a header comment with a version stamp (INVRSDSS.pls 120.0.12010000.1, dated 2010/03/10), and it declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user and relies on the APPS synonym layer for object resolution. As a private package, it is not intended for direct customer invocation; it is called by the public Inventory reservation APIs and related reservation processing logic.

Key Procedures and Functions

The ETRM metadata documents a single procedure, PROCESS_RESERVATION, which is the operational core of the package. Its documented purpose is to detail and stage either an organization-level or a detailed reservation. The procedure accepts an API version number, a flag indicating whether the error message list should be initialized, a reservation record (p_rsv_rec), a serial number collection (p_serial_number), and a reservation status indicator (p_rsv_status). The p_rsv_status parameter controls behavior: when set to 'DETAIL' the reservation is detailed down to the SKU supplied by the caller, and when set to 'STAGE' the reservation is both detailed and then staged. Output is returned through the standard PL/SQL business object API return status (x_return_status) and message count (x_msg_count), using the conventional FND_API return codes for success, expected error, and unexpected error. The package relies on the shared type definitions in INV_RESERVATION_GLOBAL, including mtl_reservation_rec_type and the serial number table type, as noted directly in the package header. The header comment explicitly directs developers to INV_RESERVATION_GLOBAL for the definitions of these types.

Tables Accessed

The package reads and writes against several core Inventory base and control tables through APPS synonyms. MTL_SYSTEM_ITEMS supplies item definition attributes; MTL_ITEM_LOCATIONS and MTL_SECONDARY_INVENTORIES supply the locator and subinventory context used when detailing a reservation. MTL_LOT_NUMBERS validates or resolves lot-controlled material, and MTL_MATERIAL_STATUSES_B provides material status information for the reserved stock. MTL_PARAMETERS supplies organization-level inventory and reservation control settings. PLITBLM is an Oracle Applications internal temporary/index-by table used for bulk PL/SQL processing. Together these tables support validation of the reservation detail, resolution of the item, lot, locator, and status combination, and the writing of the detailed and staged reservation records.

Usage Notes

INV_RSV_DETAIL_STAGE_PVT is a private implementation package and should not be called directly by custom code. It is invoked by one other package, which the metadata identifies as its caller, and is most commonly reached through the public Inventory reservation APIs, the Sales Order and Shipping reservation flows, and internal move-order or pick-release processing. Because the procedure conforms to the PLSQL Business Object API Coding Standard, it returns status and message information through the FND message stack rather than raising unhandled exceptions. Customers investigating the mtl_reservation_rec_type structure should refer to INV_RESERVATION_GLOBAL, not to this package. Any customization that requires detailing or staging a reservation should call the supported public reservation API, which in turn delegates to this private package, preserving upgrade safety across EBS 12.1.1 and 12.2.2.