Search Results gmi_move_order_line_util




Overview

GMI_MOVE_ORDER_GLOBAL is an Oracle Applications (APPS) PL/SQL package belonging to the Process Manufacturing (GMI/OPM) module of Oracle E-Business Suite. Its documented status in ETRM 12.2.2 is VALID, and it is classified as an "OTHER" API rather than a public, interface-oriented API. In practice the package functions as a low-level, shared utility layer for the move order subsystem, centralizing common global logic used across move order header, line, and pick-release processing. It exposes both a package specification and a package body, and it is called by higher-level public and private APIs rather than being invoked directly by end users. Because it references inventory lot, location, and pending-transaction master tables, its role is fundamentally transactional: it supports validation and staging of inventory movement data that the move order flows subsequently commit.

Key Procedures and Functions

The ETRM metadata documents zero explicitly named procedures or functions for this package, so no parameter lists or individual routine names can be asserted. What is documented is its participation in the move order call stack: it is referenced by fifteen other packages, indicating that its routines are consumed as internal building blocks rather than exposed as a standalone API. Typical responsibilities implied by this position in the dependency graph include shared validation of move order lines, resolution of inventory locations and lots, and preparation of pending inventory transactions. Consumers should not rely on the package's internal routine signatures, since they are not published as part of the supported interface; the supported entry points are the public packages that call it.

Tables Accessed

Three base tables are documented as referenced through APPS synonyms:

  • IC_LOCT_MST — the inventory location master. Accessed to validate and resolve source and destination locations used on move order lines.
  • IC_LOTS_MST — the lot master. Accessed to validate lot numbers and lot-controlled inventory associated with move order transactions.
  • IC_TRAN_PND — pending inventory transactions. Accessed to stage movement records prior to their posting to the inventory transaction tables.

Collectively these references confirm that the package operates at the inventory-transaction layer of the move order process, bridging validated location and lot data with staged pending transactions.

Usage Notes

GMI_MOVE_ORDER_GLOBAL is not intended to be called directly from custom code. It is invoked indirectly through the documented dependent packages, which include GMI_MOVE_ORDER_HEADER_PUB, GMI_MOVE_ORDER_LINES_PUB, GMI_MOVE_ORDER_HEADER_UTIL, GMI_MOVE_ORDER_LINE_UTIL (the object most commonly reached when searching for "gmi_move_order_line_util"), GMI_PICK_CONFIRM_PUB, GMI_PICK_RELEASE_PUB, GMI_PICK_WAVE_CONFIRM_PUB, GMI_AUTO_ALLOC_BATCH_PKG, and GMI_OM_UTILITIES_PKG, among others. These packages are in turn driven by Oracle Process Manufacturing move order forms, pick release and pick confirm flows, auto-allocation batch processing, and order management integration routines. Customizations that need move order functionality should integrate at the public package layer and treat GMI_MOVE_ORDER_GLOBAL as an internal implementation detail. Because routine signatures are undocumented and subject to change between 12.1.1 and 12.2.2, direct dependency on this package risks upgrade breakage.