Search Results create_dflt_lot_from_scratch

Overview

GMI_RESERVATION_UTIL is a private utility package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Process Manufacturing (OPM) reservation process. Its header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner. The package encapsulates a collection of helper routines that are not intended for direct public invocation; instead, they are consumed by other reservation-related packages and processes. As of the ETRM 12.2.2 metadata, the package is classified as a UTIL object and is referenced by 38 other packages, underscoring its role as a shared foundation for OPM reservation logic. Its history shows steady evolution: created in March 2000, modified in April 2000 to move Transfer_Msg_Stack out to OE_MSG_PUB (OEXUMSGS.pls), extended in September 2002 for Bill-Only functionality, and further extended in late 2002 to support the WSH.H Harmonization project, including the addition of p_delivery_detail_id to the line_allocated procedure.

Key Procedures and Functions

The documented interface exposes 33 procedures and functions. The following are representative of the package's responsibilities:

• CHECK_MISSING — Detects missing or incomplete reservation data prior to processing.
• VALIDATION_FOR_QUERY — Validates inputs used when querying reservation information.
• VALIDATION_BEFORE_ALLOCATE — Performs pre-allocation validation checks.
• GET_DEFAULT_LOT / CREATE_DEFAULT_LOT — Determine whether a default lot may be used and create one when required.
• GET_DEFAULTLOT_FROM_ITEMCTL — Derives the default lot from item control settings.
• CREATE_EMPTY_DEFAULT_LOT / DEFAULT_LOT_EXIST — Support creation and existence checks for default lots.
• GET_ALLOCATION — Retrieves allocation information for a reservation.
• GET_OPMUOM_FROM_APPSUOM / GET_APPSUOM_FROM_OPMUOM — Convert units of measure between OPM and Apps conventions.
• GET_ORG_FROM_SO_LINE — Resolves the inventory organization associated with a sales order line.
• GET_OPM_ITEM_FROM_APPS — Maps an Apps item to its OPM item equivalent.
• REALLOCATE — Reallocates reserved material.
• VALIDATION_ICTRAN_REC — Validates inventory transaction records.
• SET_PICK_LOTS — Establishes pick lot information.
• CREATE_DFLT_LOT_FROM_SCRATCH — Creates a default lot from scratch.
• CREATE_TRANSACTION_FOR_RCV — Creates a transaction for receiving.
• BALANCE_DEFAULT_LOT — Balances the default lot.
• PRINTLN — Output utility for diagnostic printing.

Transfer_Msg_Stack was formerly part of this package but was moved to OE_MSG_PUB as documented in the package header history.

Tables Accessed

The package reads and writes a range of tables through APPS synonyms. Inventory master and lot tables (IC_ITEM_MST, IC_LOTS_MST, IC_LOCT_INV, IC_LOCT_MST, IC_WHSE_MST, IC_TRAN_PND, IC_TXN_REQUEST_LINES) support lot, location, and transaction processing. MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, and MTL_UNITS_OF_MEASURE provide Oracle Inventory item, location, subinventory, and UOM data. MTL_SALES_ORDERS and OE_ORDER_HEADERS_ALL link reservations to sales order context. FND_LANGUAGES and FND_USER supply language and user context for validation and messaging.

Usage Notes

Because this is a private package (Type: Private), it is not intended as a public API. It is invoked internally by OPM reservation flows and by the 38 dependent packages recorded in ETRM. Typical invocation paths include Oracle Forms-based reservation screens, concurrent programs that allocate or reallocate material, and internal PL/SQL calls from other reservation utilities. Custom code should not call these procedures directly; instead, the supported public reservation APIs should be used. The presence of GET_OPMUOM_FROM_APPSUOM and GET_APPSUOM_FROM_OPMUOM confirms that the package bridges OPM and Oracle Apps unit-of-measure conventions during reservation. The WSH.H Harmonization additions (Validate_lot_number, line_allocated, and the p_delivery_detail_id parameter) indicate that shipping-related reservation validation also relies on this package, particularly for delivery detail tracking.