Search Results process_move_order_line

Overview

GMI_MOVE_ORDER_LINES_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Process Manufacturing (OPM) family of modules, where the term "move order" refers to an internal request to transfer material between inventory locations, subinventories, or organizations. In this context the package supports the line-level processing of move orders that originate from OPM execution and are subsequently handed off to Oracle Order Management for fulfillment. The API classification of PUB indicates that the package exposes a public, supported interface intended for external invocation, as opposed to a private helper that should only be called internally.

The package is documented as VALID and forms part of the broader GMI_MOVE_ORDER_* API set, sharing dependency on GMI_MOVE_ORDER_GLOBAL, which supplies global constants, error handling conventions, and shared utility logic across the move order APIs.

Key Procedures and Functions

The documented interface exposes a single procedure:

• PROCESS_MOVE_ORDER_LINES — The core public entry point for validating and processing move order lines. It is responsible for accepting move order line data, applying the business rules associated with the move order transaction, and persisting or propagating the resulting records. Because it is the sole documented procedure in the package, it represents the entire supported public surface; no parameter signatures are published in the ETRM metadata, and callers should consult the package specification in the database for the exact argument list in their patch level.

Tables Accessed

The package is documented as referencing three tables through APPS synonyms:

• OE_ORDER_HEADERS_ALL — The Order Management header table, which stores order-level attributes used when the move order is represented as an order and subsequently fulfilled through shipping and inventory transactions.
• OE_ORDER_LINES_ALL — The Order Management line table, where individual move order lines are represented as order lines. The procedure reads and/or writes the line records needed to keep execution and fulfillment aligned.
• PLITBLM — The OPM material line detail table, which holds the item, lot, and quantity detail associated with process manufacturing transactions. This table anchors the material being moved and links the OPM side of the transaction to the Order Management representation.

In addition to these documented tables, the package depends on FND_API (the Oracle Application Object Library API utility package used for standard return-status handling) and the STANDARD package in the SYS schema.

Usage Notes

GMI_MOVE_ORDER_LINES_PUB is typically invoked from OPM inventory and execution flows, either directly from OPM forms or from server-side processing triggered when move order lines must be validated and pushed into Order Management. Customizations that need to programmatically create or process move order lines should call PROCESS_MOVE_ORDER_LINES rather than inserting into the underlying tables, thereby preserving the validation, defaulting, and error-handling behavior implemented by FND_API conventions.

The ETRM metadata records no other packages referencing GMI_MOVE_ORDER_LINES_PUB, indicating it is an entry point rather than a dependent internal component. Callers should capture the standard FND_API return status and inspect any error message returned by the procedure, and should not assume fixed signatures across EBS releases; parameter lists are not documented in this metadata and must be verified against the installed package specification for 12.1.1 or 12.2.2.