Search Results validate_io_lot_quantities

Overview

GML_RCV_DB_COMMON is an Oracle EBS PL/SQL package owned by the APPS schema and classified as OTHER under the ETRM 12.2.2 API classification scheme. It is a process manufacturing (OPM/GML) receiving utility package that provides shared database-layer validation routines for lot-controlled receiving transactions. It supports both the Oracle Inventory (IO) and the Oracle Order Management RMA flows by validating whether the lot and quantity supplied on an inbound receipt or return line are permissible against the receiving document to which they are attached.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which is typical of internal utility code invoked from Forms, public APIs, or integration scripts that already hold the appropriate grants. The header revision identifies the source file as GMLRCVCS.pls (version 120.0), confirming it is a long-standing component of the GML receiving schema. Its scope is narrowly transactional: it returns an allowance flag and an allowed quantity rather than performing the receipt itself.

Key Procedures and Functions

• VALIDATE_IO_LOT_QUANTITIES — Validates lot and transaction quantity information for an Inventory (IO) receiving or return transaction. The caller supplies API control parameters, the OPM item and lot identifiers, the transaction quantity and unit of measure, and one of several receiving document identifiers: an order number, requisition header and line, shipment header and line, and requisition distribution. The procedure returns an allowance indicator, an allowed quantity, and a standard return status. This is the routine associated with the search term "validate_io_lot_quantities".
• VALIDATE_RMA_LOT_QUANTITIES — The RMA counterpart of the IO validation. It accepts the OPM item and lot identifiers, sublot number, order entry header and line identifiers, the transaction quantity and UOM, the RMA lot quantity and UOM, and a line set identifier. As with the IO procedure, it returns an allowed flag, an allowed quantity, and a return status, allowing the caller to determine whether the specified RMA lot quantity may proceed.
• RAISE_QUALITY_EVENT — Accepts a transaction identifier, item identifier, and organization identifier, and raises a quality event in Oracle Quality (or the equivalent GML quality integration point) associated with that receiving transaction. It returns no application-level output parameters but is used to trigger quality-related downstream processing.

All three procedures follow the standard EBS API convention of accepting p_api_version and p_init_msg_list, and of exposing out parameters for status reporting.

Tables Accessed

The package references the following tables through APPS synonyms. The OPM item and lot master tables IC_ITEM_MST, IC_TRAN_PND, and SY_UOMS_MST supply item, unit of measure, and pending-transaction context. Standard Inventory tables MTL_SYSTEM_ITEMS_B, MTL_UNITS_OF_MEASURE, and MTL_PARAMETERS validate item and UOM definitions and organization control settings. RMA validation relies on OE_ORDER_LINES_ALL and OE_LOT_SERIAL_NUMBERS to retrieve the source order line and its lot associations. Receiving history and shipping context are drawn from RCV_TRANSACTIONS, WSH_DELIVERY_DETAILS, and WSH_DELIVERY_ASSIGNMENTS. Workflow parameters are resolved via WF_PARAMETER_LIST_T.

Usage Notes

GML_RCV_DB_COMMON is typically invoked from Oracle Forms-based receiving and RMA windows during lot entry, and from custom integration code that pre-validates receipts before calling the standard receiving APIs. Because it is classified as OTHER rather than as a public or private API, it is best treated as a controlled internal utility: callers should supply a valid p_api_version, honor the returned x_return_status values, and avoid direct dependency where a supported public receiving API exists. The package is referenced by two other packages in the ETRM catalog, indicating layered reuse within the GML receiving code path.