Search Results close_period_check

Overview

GMI_TRANS_ENGINE_PVT is a private PL/SQL package in the Oracle E-Business Suite Process Manufacturing (OPM) module, owned by the APPS schema and classified as a PVT (private) API. It forms the internal engine behind the public transaction interface defined in GMI_TRANS_ENGINE_PUB. Its business function is to create and maintain inventory transactions in the Process Manufacturing inventory transaction staging tables, specifically IC_TRAN_PND (pending transactions) and IC_TRAN_CMP (completed transactions). The package header carries a source header reference of GMIVTXNS.pls and version history dating from January 2000 through November 2002, reflecting its origins in the Oracle Process Manufacturing (formerly "GMI" — Global Manufacturing Industries) inventory architecture. It supplies the low-level build, validation, and persistence logic used whenever process inventory movements must be recorded without direct user interaction with the transaction forms. The package is declared with AUTHID CURRENT_USER and contains nine documented procedures and functions.

Key Procedures and Functions

• CREATE_PENDING_TRANSACTION — Builds and inserts a new pending inventory transaction record, accepting a transaction record typed from GMI_TRANS_ENGINE_PUB.ictran_rec and returning the resulting IC_TRAN_PND row along with standard FND_API return status, message count, and message data.
• CREATE_COMPLETED_TRANSACTION — Creates a completed transaction, writing directly into the completed transaction table rather than staging in the pending table.
• DELETE_PENDING_TRANSACTION — Removes a pending transaction record, typically used to back out an unprocessed or erroneous staged entry.
• UPDATE_PENDING_TRANSACTION — Modifies the attributes of an existing pending transaction prior to processing.
• UPDATE_PENDING_TO_COMPLETED — Promotes a pending transaction to completed status, moving or transforming the record so it is recognised as an executed inventory movement.
• PENDING_TRANSACTION_BUILD — Internal routine that assembles the pending transaction row from supplied input values, applying defaults and preparing the record for insertion.
• COMPLETED_TRANSACTION_BUILD — Equivalent build routine for completed transactions, constructing the completed row before persistence.
• SET_DEFAULTS — Populates default values on the transaction record when callers do not supply them explicitly.
• CLOSE_PERIOD_CHECK — Validates whether the target inventory accounting period is open, preventing transactions from being written into a closed period (added under bug reference B1834369).

Tables Accessed

• IC_TRAN_PND — The pending transaction staging table; the primary insert, update, and delete target.
• IC_TRAN_CMP — The completed transaction table, written when transactions are finalised.
• IC_ITEM_MST — Item master, read to validate the item referenced by the transaction.
• IC_LOCT_INV — Location inventory, read to validate and resolve inventory location and quantity information.
• IC_LOTS_MST — Lot master, read to validate lot-controlled item transactions.

Usage Notes

As a PVT-class API, GMI_TRANS_ENGINE_PVT is not intended for direct invocation by external or custom code. It is referenced by one other package — the public GMI_TRANS_ENGINE_PUB — which acts as the supported entry point. In practice the package is invoked indirectly through process inventory transaction forms, concurrent programs that process staged inventory movements, and any OPM flow that must create or complete inventory transactions programmatically. Customisations and integrations should call GMI_TRANS_ENGINE_PUB instead of this package, since private APIs may change between releases without notice. This behaviour is consistent across Oracle EBS 12.1.1 and 12.2.2, where the package is documented in ETRM under the APPS schema with the same nine procedures.