Results for “check_rsrv_exist”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GME_MOBILE_RSRV is an Oracle EBS PL/SQL package owned by the APPS schema that supports the Java-based GME Mobile Application. Its stated purpose, as recorded in the package header, is to contain the PL/SQL cursors used by the mobile reservation transactions. In practice the package exposes the server-side reservation logic that a wireless or handheld client invokes when a shop-floor operator reserves material against a batch during process manufacturing execution.

The package is declared with AUTHID CURRENT_USER, so all unqualified object references are resolved against the privileges of the calling session rather than those of the APPS owner. This is significant in a mobile deployment because the calling user must therefore hold direct privileges on the underlying GME and MTL objects, or execute the package under an appropriately privileged connection. Within the Oracle Process Manufacturing (OPM/GME) flow, the package sits between the mobile reservation user interface and the core inventory reservation tables, providing both read access to existing reservations and the create, update, and quantity-derivation logic required to build new ones.

The header identifies the original author and date (Eddie Oumerretane, 26-Apr-05) and shows the file revision history, with the shipped version dated 25-Jul-2008. The only documented functional enhancement is the addition of GET_MATERIAL_DTL_RESERVATIONS, introduced under Bug 5663458, which indicates that the detail-level reservation retrieval path was added after the initial release to support finer-grained reservation lookups.

Key Procedures and Functions

The ETRM metadata records eleven documented procedures. The following describes their purpose as documented or as implied by their names within the reservation workflow:

  • GET_MATERIAL_RESERVATIONS — Returns a cursor of existing material reservations for the supplied context. It accepts organization, batch, material detail, subinventory, locator, and lot identifiers, and returns a generic REF CURSOR (t_genref) along with a return status and error message.
  • GET_MATERIAL_DTL_RESERVATIONS — Added under Bug 5663458, this procedure returns reservation detail using additional control flags for locator control, lot control, and revision control, allowing the mobile client to drive retrieval based on the item's actual inventory attribute configuration.
  • CHECK_RSRV_EXIST — Determines whether a reservation already exists for the specified organization, batch, material detail, subinventory, locator, and lot, with an option to exclude a given reservation identifier.
  • GET_STACKED_MESSAGES — Retrieves accumulated (stacked) error or warning messages generated during reservation processing, allowing the mobile client to present a consolidated message list.
  • CREATE_RESERVATION — Creates a new material reservation for the mobile transaction.
  • UPDATE_RESERVATION — Modifies an existing reservation, typically to change quantity or allocation details.
  • GET_AVAILABLE_QTIES — Calculates available quantities for the item and location under consideration, supporting the operator's choice of reservation quantity.
  • CHECK_UOM_CONV_DEVIATION — Tests whether a unit-of-measure conversion falls outside the acceptable tolerance, guarding against erroneous reservations entered in a non-primary UOM.
  • UPDATE_QTY_TREE_FOR_RSRV — Maintains the quantity tree/on-hand quantity structures when a reservation is added or changed.
  • FETCH_ATR_QTY — Fetches attribute-level quantities associated with the reservation context.
  • FETCH_LOT_RESERVATIONS — Retrieves reservation information specific to lot-controlled material.

Tables Accessed

The package references three documented tables via APPS synonyms: GME_MATERIAL_DETAILS, the GME table holding batch material detail lines against which reservations are placed; MTL_MATERIAL_TRANSACTIONS_TEMP, the Oracle Inventory interface table used for pending transaction staging; and MTL_RESERVATIONS, the core Inventory reservation table that stores the reservation records themselves. Read operations target the material detail and reservation tables to enumerate existing allocations, while create and update operations write the reservation and related quantity data through MTL_RESERVATIONS and the temporary transaction interface.

Usage Notes

The package is not referenced by any other documented PL/SQL package, confirming that it is a top-level entry point consumed directly by the GME Mobile Application rather than a reusable library for other server code. It is invoked from the Java mobile layer, and may also be called by custom concurrent programs or client extensions that need to reproduce mobile reservation behaviour. Because the procedures return status and error message out parameters and populate a generic REF CURSOR, callers are expected to iterate the returned cursor and inspect the return status before committing. Any custom code invoking this package should verify that the executing schema holds privileges on the underlying GME and MTL objects, given the AUTHID CURRENT_USER declaration.