Search Results gmi_tran_cmp_pvt




Overview
Explore in AI Chat

Overview

GMI_TRAN_CMP_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (Enterprise Territory and Resource Management) module as a PVT (private) API. Its name reflects its role as the transaction completion handler within the Process Manufacturing (OPM/GMI) transaction engine framework. Specifically, the package supports the completion and comparison stage of transaction processing in Oracle Process Manufacturing, providing the low-level procedure calls that persist and retrieve completed transaction comparison records.

The package operates strictly as an internal or private API — it is not intended for direct invocation by external customizations. It is referenced primarily by GMI_TRANS_ENGINE_PVT, which serves as the public-facing engine coordinator. GMI_TRAN_CMP_PVT depends on GMI_TRANS_ENGINE_PUB (the public transaction engine package), the IC_TRAN_CMP table, and the standard SYS.STANDARD package. Because it is versioned as PVT, Oracle reserves the right to change its signature without notice, and it should never be called directly from custom code.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package:

  • INSERT_IC_TRAN_CMP — Persists a completed transaction comparison record into the IC_TRAN_CMP table. This procedure is invoked as part of the transaction completion flow, taking the transaction comparison data assembled by the calling engine package and writing it to the database. It is the write-side operation of the package.
  • FETCH_IC_TRAN_CMP — Retrieves existing transaction comparison records from IC_TRAN_CMP. This read-side procedure is used to query completed comparison data, likely for validation, reconciliation, or downstream processing within the transaction engine's completion logic.

No parameter lists are documented, and per the private API convention, none should be assumed or replicated in custom code.

Tables Accessed

The package references the following tables via APPS synonyms:

  • IC_TRAN_CMP — The primary transaction comparison table. INSERT_IC_TRAN_CMP writes to this table, and FETCH_IC_TRAN_CMP reads from it. This table stores the results of comparing inventory transactions during the completion phase of the process manufacturing transaction engine.
  • GEM5_TRANS_ID_S — A sequence used to generate unique transaction identifiers for the records inserted into IC_TRAN_CMP. Its presence confirms the package creates new rows requiring system-generated keys.
  • DUAL — The standard Oracle single-row dummy table, typically used for sequence value retrieval or simple conditional logic.

Usage Notes

GMI_TRAN_CMP_PVT is invoked internally by GMI_TRANS_ENGINE_PVT, which orchestrates transaction completion within the Oracle Process Manufacturing transaction engine. It is not exposed through Oracle Forms, concurrent programs, or public APIs. The package is one of several private helpers supporting the public GMI_TRANS_ENGINE_PUB interface.

Users searching for "gmi_trans_engine_pub" should note that GMI_TRAN_CMP_PVT is a supporting private package, not the public entry point. Customizations requiring transaction completion or comparison functionality must use the public GMI_TRANS_ENGINE_PUB API, which in turn may call this private package. Because the package is owned by APPS and carries PVT classification, direct invocation, alteration, or wrapping of its procedures is unsupported and should be avoided in any EBS 12.1.1 or 12.2.2 implementation.