Search Results igc_cbc_pa_bc_pkg




Overview
Explore in AI Chat

Overview

IGC_CBC_PA_BC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the flow-down of cost and accounting activity from the public-sector contract billing and cost-collection infrastructure. In the ETRM (Enterprise Resource Transaction Model) classification scheme it is registered as an OTHER-type API, meaning it is not a formal public interface but an internal utility exercised by the concurrent-program and cost-collection layer rather than by end-user forms. Its documented role centers on validating and processing Public Accounting (PA) cost or expenditure data prior to posting against period, interface, and result-code rank records.

The package header carries the revision marker IGCBPBCS.pls, with the header comment dated 2007/10/08, indicating a stable, long-lived component that has survived the 12.1.1 to 12.2.2 upgrade path with minimal structural change. The naming convention — IGC for the Oracle Grants/Cost Collection family, CBC for Cost/Billing Collection, PA for Public Accounting — reflects its lineage in the Oracle Public Sector Financials and Grants Accounting product family that underpins contract billing in federal and public-sector deployments.

Key Procedures and Functions

The package exposes a single documented program unit:

  • IGCPAFCK — A boolean-returning function that performs the core validation and processing check for a given public-accounting transaction. Its signature accepts a sob (set of books) identifier, a header identifier, a mode, an actual-flag, and a document type, and returns status information through two OUT parameters: a return status and a batch result code. Two further parameters, p_debug and p_conc_proc, default to FND_API.G_FALSE and govern diagnostic tracing and concurrent-processing behavior respectively. The function returns TRUE on success and FALSE on failure, following the conventional Oracle API return-boolean pattern.

The parameter design — carrying both a business header identifier and a mode/actual-flag/document-type triplet — indicates that IGCPAFCK is invoked for multiple processing contexts (actual versus encumbrance, different document types) from a single shared validation entry point. No other procedures or functions are documented in the ETRM metadata for this package.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • GL_PERIOD_STATUSES — consulted to determine the open/closed state of the accounting period for the relevant set of books before allowing processing to proceed.
  • IGC_CC_ACCT_LINES — holds the cost-collection account line detail that the function validates and advances.
  • IGC_CC_INTERFACE — the cost-collection interface staging table through which validated records are passed for downstream creation of accounting entries.
  • IGC_CC_RESULT_CODE_RANKS — supplies the result-code ranking data used to interpret or prioritize the outcome recorded in the batch result code.

Usage Notes

IGCPAFCK is typically invoked from concurrent programs and internal cost-collection routines rather than directly from a user-facing form; the p_conc_proc flag confirms it is designed to run within the concurrent manager. The p_debug parameter allows targeted diagnostics without code modification. Because the package is referenced by five other packages, it should be treated as a shared internal component: implementers extending Grants or Public Sector cost collection should call it rather than duplicate its validation logic, and any modification must respect the OUT-parameter contract to avoid breaking dependent callers. In 12.1.1 and 12.2.2 the object resides in the APPS schema; ETRM classifies it as OTHER, so it is not covered by Oracle's public API compatibility guarantees.