Search Results igc_cc_det_pf_pkg




Overview
Explore in AI Chat

Overview

IGC_CC_DET_PF_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (Enterprise Territory and Channel Management) module family. In release 12.1.1 and 12.2.2, this package forms part of the Contracts Core (IGC) subsystem responsible for managing commitment control detail and period‑of‑performance records. Its principal business function is to encapsulate the low‑level Data Manipulation Language (DML) operations for the IGC_CC_DET_PF entity — the detail table that stores period‑of‑performance (PF) information associated with commitment control header records.

The package provides a controlled, reusable interface so that other IGC contract packages do not need to issue direct INSERT, UPDATE, and DELETE statements against this sensitive table. By centralising row‑level manipulation, the package enforces consistent handling of the associated IGC_CC_DET_PF_S sequence and the WHO columns maintained through FND_API, ensuring auditability and referential integrity across the commitment control data model.

Key Procedures and Functions

The ETRM documentation exposes four public program units within IGC_CC_DET_PF_PKG, all of which are standard table‑handler procedures:

  • INSERT_ROW — Creates a new period‑of‑performance detail record in IGC_CC_DET_PF, populating the primary key from the IGC_CC_DET_PF_S sequence and initialising the audit columns.
  • LOCK_ROW — Acquires an exclusive row lock on an existing detail record, used to serialise concurrent updates during budgetary control, revaluation, or copy processing.
  • UPDATE_ROW — Modifies the attributes of an existing period‑of‑performance detail row while preserving change‑tracking information.
  • DELETE_ROW — Removes a period‑of‑performance detail record, typically invoked when a commitment control line is cancelled or copied over.

No parameter lists are published in the ETRM catalogue; the procedures follow the Oracle Forms‑style table handler convention, accepting column values and a return status. Callers should not assume a parameter signature without inspecting the package specification in the target instance.

Tables Accessed

The package operates against the following documented tables through APPS synonyms:

  • IGC_CC_DET_PF — the primary period‑of‑performance detail table that this package inserts, updates, locks, and deletes.
  • IGC_CC_DET_PF_S — the sequence supplying surrogate primary keys for new detail rows.
  • IGC_CC_ACCT_LINES — the commitment control account line table, referenced to validate or align detail records with their parent accounting lines.
  • IGC_CC_HEADERS — the commitment control header table, providing the parent context for each detail row.
  • FND_APPLICATION — the Oracle Application Object Library table used to resolve application identifiers for the WHO audit columns and messages.

Usage Notes

IGC_CC_DET_PF_PKG is not intended for end‑user invocation. It is called programmatically by higher‑level IGC business logic. The ETRM dependency report shows it is referenced by nine packages, including IGC_CC_ACCT_LINES_PKG, IGC_CC_BUDGETARY_CTRL_PKG, IGC_CC_COPY_PKG, IGC_CC_INT_CC_REL_PUB, IGC_CC_MPFS_PROCESS_PKG, IGC_CC_OPEN_INTERFACE_PKG, IGC_CC_REVALUE_PROCESS_PKG, IGC_CC_REVAL_FIX_PROCESS_PKG, and IGC_CC_YEP_PROCESS_PKG, as well as recursively by itself. This breadth of referencing packages indicates that the handler is exercised during budgetary control validation, contract copy, open interface import, revaluation, and year‑end processing concurrent programs.

Customisations should avoid bypassing this package and writing directly to IGC_CC_DET_PF, because doing so risks breaking audit column integrity and row‑locking discipline relied upon by these concurrent processes. When extending IGC functionality in 12.1.1 or 12.2.2, developers should call the documented INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW handlers rather than reimplementing DML.