Search Results process_move_order_lines




Overview
Explore in AI Chat

Overview

GMI_MOVE_ORDER_LINES_PUB is a public PL/SQL package in the Oracle E-Business Suite Process Manufacturing (OPM/GMI) module. Its business purpose is to provide a programmatic interface for processing move order lines originating from GMI (Oracle Process Manufacturing) inventory transactions and, under specific historical circumstances, to drive related outbound Sales Order XML integration. The package header comment indicates the source file is GMIPMOLB.pls (version 120.2, last shipped 2008/01/10) and that the API was created on 03-MAY-2000. The package is classified as a "Global" API with a current version designation of 1.0 and no stated pre-requisites.

A critical note in the package history states that, following Inventory Convergence in Release 12, the Sales Order integration code within this package is no longer executed. The call to GR_WF_UTIL_PUB.INITIATE_PROCESS_SALES_ORDER that this package originally performed has been relocated to INV_Move_Order_PUB in the Inventory module. This is directly relevant to any user searching for "get_sales_order," since the sales-order-related logic historically associated with this package is superseded in R12 environments.

Key Procedures and Functions

The ETRM metadata documents a single public procedure:

  • PROCESS_MOVE_ORDER_LINES — The principal entry point of the package. It accepts a move order line table type (based on GMI_Move_Order_GLOBAL.mo_line_tbl) along with standard API control parameters such as an API version number, an initialization message list flag, a validation level flag, and a commit flag. It returns an output move order line table plus the standard return status, message count, and message data. Its purpose is to validate and process the supplied move order lines, applying the API's validation rules and, where instructed, committing the results.

No additional public procedures or functions are documented for this package.

Tables Accessed

The documented tables referenced via APPS synonyms are:

  • OE_ORDER_HEADERS_ALL — The Order Management sales order header table. Access relates to the historical third-party Sales Order XML outbound integration path present prior to Inventory Convergence.
  • OE_ORDER_LINES_ALL — The Order Management sales order line table, likewise accessed in connection with sales order processing logic.
  • PLITBLM — The generic PL/SQL index-by table storage used by the EBS API framework for message handling and related temporary data structures.

Usage Notes

This package is typically invoked from custom PL/SQL code or from internal OPM inventory processing that needs to validate and persist collections of move order lines through a supported, public API rather than direct table manipulation. Callers supply the input move order line table and receive the processed output table and standard API status outputs.

Because the R12 code path for sales order initiation now resides in INV_Move_Order_PUB, developers searching for sales-order behavior referenced as "get_sales_order" should recognize that this package's sales order responsibilities are legacy. In 12.1.1 and 12.2.2 deployments, integration development and debugging around outbound sales orders from move orders should target the Inventory package, while GMI_MOVE_ORDER_LINES_PUB should be treated as the OPM move order line processing API.