Search Results pending_reservations_exist

Overview

APPS.GME_RESERVATIONS_PVT is a private (PVT) PL/SQL package within the Oracle EBS Process Manufacturing (OPM) suite. It serves as the internal reservation engine for batch and material reservation processing, underpinning the public reservation APIs used by Oracle Manufacturing Execution System (MES), Oracle Process Manufacturing, and material control forms. The package header declares AUTHID CURRENT_USER, indicating it executes with the privileges of the calling schema rather than the definer, which is consistent with its role as an internal engine invoked only by trusted application code.

Its principal business function is to create, query, update, relieve, and delete inventory reservations against material detail lines belonging to process batches. In OPM, material detail lines represent the specific ingredients and quantities planned for a batch. Reservation records tie these planned quantities to on-hand inventory in a specific organization, subinventory, and locator. This package mediates all of those interactions against the Oracle Inventory reservation tables.

The header carries a version string dated 2008/07/25 and is marked as a shipped, internal component. A reference cursor type g_msca_resvns is declared for returning reservation result sets.

Key Procedures and Functions

• GET_RESERVATIONS_MSCA — Returns batch reservations for a given organization, batch, material detail, subinventory, locator, and lot combination via a REF CURSOR. Used by MSCA (Mobile Supply Chain Applications) style callers.
• CREATE_BATCH_RESERVATIONS — Creates reservations for all applicable material detail lines of a batch, honoring an optional time fence value.
• CREATE_MATERIAL_RESERVATION — Creates a single reservation for one material detail record, with optional reservation quantity, secondary quantity, unit of measure, subinventory, locator, and lot overrides.
• GET_MATERIAL_RESERVATIONS — Returns material reservations into a collection type shared with GME_COMMON_PVT, with a dispense indicator to filter dispensing-related records.
• GET_MATERIAL_RES / GET_RESERVATION_DTL_QTY / GET_RESERVED_QTY — Retrieval helpers returning reservation detail quantities and total reserved quantities for callers.
• RESERVATION_FULLY_SPECIFIED — A function that evaluates whether a reservation record meets locator and location control requirements, returning a numeric indicator.
• CONVERT_PARTIAL_TO_DLR — Converts a partially specified reservation into a detailed-locator reservation, optionally performing a quantity check.
• CONVERT_DTL_RESERVATION — Performs conversion of reservations into detailed reservation records.
• DELETE_BATCH_RESERVATIONS, DELETE_MATERIAL_RESERVATIONS, DELETE_RESERVATION — Handle deletion at batch, material detail, and individual reservation granularity.
• UPDATE_RESERVATION, RELIEVE_RESERVATION, QUERY_RESERVATION — Maintain and interrogate reservation records during batch execution and dispensing.
• PENDING_RESERVATIONS_EXIST — Boolean-style check for outstanding reservations before a batch proceeds.
• AUTO_DETAIL_LINE, AUTO_DETAIL_BATCH — Automatically generate detailed reservation lines at line or batch scope.
• VALIDATE_MTL_FOR_RESERVATION — Validates that material and item attributes permit reservation.

Tables Accessed

The package references these objects through APPS synonyms:

• GME_BATCH_HEADER — Batch definition driving reservation scope.
• GME_MATERIAL_DETAILS — Material requirement lines being reserved.
• MTL_RESERVATIONS — The core Inventory reservation table read, inserted, updated, and deleted.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV — Item attributes including location and locator control settings.
• MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TRANSACTION_LOTS_TEMP — Staging for lot-controlled transaction creation.
• MTL_TXN_REQUEST_HEADERS, MTL_TXN_REQUEST_LINES — Move order references associated with reservations.
• DUAL and PLITBLM — Utility references for scalar evaluation and PL/SQL table handling.

Usage Notes

GME_RESERVATIONS_PVT is an internal API and is referenced by 19 other packages; it is not intended for direct invocation by end users or by external integrations. Standard callers include the public OPM batch and material APIs, Mobile Supply Chain Applications, and dispense processing logic. Reservations are typically triggered from batch release activity, material management forms, and concurrent programs that pre-reserve inventory ahead of production. Custom code should rely on the corresponding public API surface rather than calling this private package directly, since its signature may change between releases.