Search Results gmi_move_order_header_pvt




Overview
Explore in AI Chat

Overview

GMI_MOVE_ORDER_HEADER_PVT is a private PL/SQL package in the APPS schema that supports the Process Manufacturing (OPM) move order header functionality within Oracle E-Business Suite. It belongs to the standard private API layer that is characteristic of ETRM and OPM design: business logic is implemented in a PVT (private) package, which is then wrapped and exposed externally by a corresponding PUB (public) package. In this case, the public counterpart is GMI_MOVE_ORDER_HEADER_PUB, which is documented as referencing this private package.

The package occupies the header-level tier of the move order processing stack. It is concerned with the validation and processing of move order headers — the top-level record that identifies an inventory move order and governs its associated detail lines. Its dependency on GMI_MOVE_ORDER_GLOBAL indicates shared global variables and constants are leveraged from the broader GMI move order infrastructure, while its reliance on FND_API confirms that it follows the Oracle Application Object Library API programming standards, including the standard API return-status conventions.

Key Procedures and Functions

The ETRM metadata for Oracle EBS 12.2.2 documents two callable units in this package.

  • PROCESS_MOVE_ORDER_HEADER — The primary processing routine. It carries out the core header-level business logic, driving the creation or maintenance of a move order header record. This is the entry point through which the public package passes header-level requests for processing.
  • CHECK_REQUIRED — A validation routine. It verifies that mandatory header attributes have been supplied before processing proceeds, returning the standard validation outcome to the calling routine. This enforces data integrity at the API boundary.

Consistent with the private API pattern, both routines are intended for internal invocation through GMI_MOVE_ORDER_HEADER_PUB rather than for direct use by external callers. Parameter lists are not enumerated in the available metadata and should be confirmed against the deployed package specification for the specific release.

Tables Accessed

The documented table references are:

  • MTL_TXN_REQUEST_HEADERS_S — The Oracle Inventory move order header table (the sequence-backed table for MTL_TXN_REQUEST_HEADERS). The package reads and writes header records here, which is the expected target of PROCESS_MOVE_ORDER_HEADER given that GMI move orders are implemented over the standard inventory move order schema.
  • DUAL — The standard Oracle single-row utility table, used for scalar evaluations and simple value selection within PL/SQL logic.

All table access is performed through APPS synonyms.

Usage Notes

Because this is a PVT package, it should not be invoked directly by custom code. The supported integration point is the public wrapper, GMI_MOVE_ORDER_HEADER_PUB, which is the only documented package that references this private package and which exposes the callable interface. Typical invocation paths include OPM move order forms and concurrent programs, as well as any custom extensions that follow the published GMI move order API. The package is marked VALID, so it is installed and compiled in the target environment. The internal self-reference listed in the dependency output is normal for PL/SQL packages. Developers maintaining or extending move order processing should treat this package as the header-level implementation detail underlying the public API.