Search Results igc_cc_po_interface_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGC_CC_PO_INTERFACE_PKG package body is a component of the Oracle E-Business Suite (EBS) Grants and Costing / Contracts Commitments (IGC) module, which supports commitment control and budgetary checking for purchase order transactions. In EBS 12.1.1 and 12.2.2, this package acts as the interface layer that bridges Purchasing (PO) transaction data with the IGC commitment control accounting engine. Its primary business function is to convert commitment control (CC) records into standard Oracle Purchasing documents and to synchronize approval status information between the two subsystems.

The package is classified as a non-standard (OTHER) API within the ETRM metadata. It is marked VALID in the APPS schema and is not referenced by any other database object, indicating it serves as a top-level entry point rather than a shared utility. It is, however, referenced by ten other packages, which underscores its role as a coordinating module invoked by higher-level commitment control processes.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package body:

  • CONVERT_CC_TO_PO — The principal routine, responsible for transforming commitment control records into Oracle Purchasing documents (headers, lines, distributions, and line locations). It orchestrates the transfer of validated CC data into the PO schema.
  • UPDATE_PO_APPROVED_FLAG — Updates the approved flag on purchase order records, ensuring that approval status established in the commitment control workflow is reflected on the corresponding PO documents.
  • LOCK_PO_ROW — Acquires a row-level lock on the target purchase order row, providing concurrency protection so that conversion and approval updates do not collide with other transactions.

These procedures rely on the internal IGC private packages IGC_CC_PO_HEADERS_ALL_PVT, IGC_CC_PO_LINES_ALL_PVT, IGC_CC_PO_LINE_LOCS_ALL_PVT, and IGC_CC_PO_DIST_ALL_PVT to perform the actual inserts and updates, along with IGC_CC_BUDGETARY_CTRL_PKG for budgetary validation.

Tables Accessed

The package reads and writes several core EBS tables through APPS synonyms:

Usage Notes

This package is typically invoked indirectly rather than called directly by end users. It is expected to be triggered by IGC commitment control concurrent programs or by the higher-level packages (the ten referencing packages) that manage the commitment control lifecycle. It may also be called from custom PL/SQL when organizations need to programmatically convert commitment control records into purchasing documents.

Standard Oracle exception handling is used through FND_API, FND_MSG_PUB, FND_MESSAGE, and APP_EXCEPTION, so callers should check the message stack after invocation. Because LOCK_PO_ROW enforces row locking, callers must ensure they do not hold conflicting locks or invoke the package within long-running transactions that could cause contention. As with all APPS-owned code, direct modification is not supported; extensions should be built through supported APIs or custom wrappers.