Search Results oe_order_lines_u1

Overview

GML_MOBILE_MOVE_ORDER is an Oracle EBS PL/SQL package body owned by APPS and classified under the Process Manufacturing (OPM/GML) application family. Its business purpose is to support mobile and web-based move order processing for lot-controlled inventory in process manufacturing environments. The package encapsulates the allocation and transaction logic required when a user scans or selects material to satisfy a move order, retrieves valid allocation parameters, and commits the resulting allocation to the inventory transaction engine.

The package header declares two package-level globals: g_gtin_cross_ref_type, initialized from the profile option INV:GTIN_CROSS_REFERENCE_TYPE, and g_gtin_code_length, fixed at 14. These globals indicate that the package supports GTIN-based cross-reference resolution, which is significant for customers scanning barcoded material. The package is documented at version 120.0 (May 2005), placing it in the 11i lineage carried forward into EBS 12.1.1 and 12.2.2. It is not referenced by any other documented package, indicating it is a terminal integration point invoked directly by mobile user interfaces or custom code rather than by other server-side APIs.

Key Procedures and Functions

The ETRM metadata documents thirteen procedures and functions. The LOV-oriented procedures—GET_SALES_ORDER_LOV, GET_ITEM_LOV, GET_LOCATION_LOV, GET_LOT_LOV, GET_SUB_LOT_LOV, GET_MOVE_ORDER_LOV, GET_DELIVERY_LOV, GET_PICKSLIP_LOV, and GET_REASON_CODE_LOV—supply valid values to the mobile or web interface, allowing the operator to select a sales order, item, storage location, lot or sub-lot, move order, delivery, pick slip, or reason code. GET_STACKED_MESSAGES retrieves accumulated API error or informational messages for display to the user.

The transaction-bearing procedures are the core of the package. GET_ALLOCATION_PARAMETERS accepts an allocation class, organization, customer, and ship-to organization, and returns the applicable grade along with a return status. The source shows it delegating to GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS and extracting the PREFQC_GRADE from the OP_ALOT_PRM record. SAVE_ALLOCATION accepts a comprehensive set of transaction attributes—transaction ID, lot, location, allocated quantities, grade, lot number and status, transaction date, reason code, item, line, warehouse, line detail, unit of measure, and move order line—and persists the allocation through the transaction engine using the GMI_TRANS_ENGINE_PUB.ictran_rec structure. AUTO_ALLOCATE supports automated allocation of available inventory to move order demand.

Tables Accessed

The package reads and writes across OPM, inventory, and order management schemas via APPS synonyms. IC_ITEM_MST, IC_LOCT_INV, IC_LOCT_MST, IC_LOTS_MST, IC_WHSE_MST, and IC_TRAN_PND support item, location, lot, warehouse, and pending transaction data. IC_TXN_REQUEST_HEADERS and IC_TXN_REQUEST_LINES represent the move order header and line tables central to this package's function. MTL_SYSTEM_ITEMS and MTL_CROSS_REFERENCES provide Oracle Inventory item definitions and cross-reference data used with the GTIN globals. OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL tie allocations back to sales order demand. OP_ALOT_PRM supplies allocation parameter and grade defaults, SY_REAS_CDS provides reason codes, and WSH_DELIVERY_ASSIGNMENTS links move orders to deliveries.

Usage Notes

GML_MOBILE_MOVE_ORDER is designed for invocation from mobile handheld or web forms that present move order allocation screens to warehouse operators. The LOV procedures populate selection lists; GET_ALLOCATION_PARAMETERS is called before allocation to determine the correct grade; SAVE_ALLOCATION commits the transaction; and GET_STACKED_MESSAGES surfaces any messages returned by the underlying APIs. Because the package is not referenced by other packages, customizations should call it directly from forms or custom PL/SQL, observing the FND_API return status conventions and the NOCOPY OUT parameter pattern used throughout.