Search Results p_actual_flag

Overview

IGC_CBC_PA_BC_PKG is an Oracle EBS grants and contracts accounting package body owned by APPS. It belongs to the IGC (International Government Contracting) product family and supports the processing of project-related transactions routed to Oracle Projects. Its external naming convention—combining the CBC (contract billing/collection) and PA (Projects Accounting) prefixes—indicates that the package mediates the boundary between IGC contract billing data and the Oracle Projects PA_BC (Project Accounting Budgetary Control) interface.

The package is responsible for preparing, validating, and transferring IGC transaction lines into the Projects budgetary control interface, and for interpreting the results returned by Oracle Projects. Its design relies heavily on Oracle Application Framework logging facilities (FND_LOG), building a logging path from the combination of the package name and procedure, which confirms it is a diagnostic-capable integration package.

Key Procedures and Functions

The metadata documents one procedure, IGCPAFCK, within the package's public surface. This procedure is the principal control routine that operates against the project budgetary control interface.

• IGCPAFCK — The documented entry point used to invoke the package's processing logic. It coordinates the validation and transfer of IGC transaction data into the Projects budgetary control interface and evaluates the returned result codes.

Beyond the documented procedure, the package body as shipped exposes supporting routines that share the interface-processing responsibilities, including functions that derive a header result code (Get_H_Code), validate interface records (Validate_Interface), check project budgetary control status (Check_PA_BC), release reserved records (Unreserve_PA), and helper routines for debug messaging and message tokens (Put_Debug_Msg, message_token, add_message). These operate on mode, actual flag, and document type parameters that are characteristic of Projects interface processing.

Tables Accessed

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

• IGC_CC_INTERFACE — The IGC interface table that stages transaction lines prior to submission to Oracle Projects, serving as the primary source of records processed by the package.
• IGC_CC_ACCT_LINES — Holds accounting distribution lines associated with the interface transactions, used to build and validate the accounting information passed to Projects.
• IGC_CC_RESULT_CODE_RANKS — Supplies the ranking of result codes returned from the Projects budgetary control interface, enabling the package to determine the governing or most severe result for each interface header.
• GL_PERIOD_STATUSES — Provides period open/closed status, used to ensure that transactions are only passed for accounting periods in which the relevant ledgers and applications permit entry.

Usage Notes

IGC_CBC_PA_BC_PKG is referenced by five other packages, confirming that it is a shared service routine in the IGC integration layer rather than an isolated program. It is typically invoked from processes that move IGC contract billing transactions into Oracle Projects budgetary control—such as concurrent programs, workflow-driven submission logic, or other IGC program units that call IGCPAFCK after assembling interface records.

Because the package relies on FND_LOG and the AFLOG_ENABLED profile option for diagnostics, debugging should be enabled through the standard ATG logging profile before re-running a failing interface process. The inclusion of the p_actual_flag parameter across the validation and reservation functions indicates that callers must explicitly distinguish actual from budgetary or encumbrance transactions when invoking the package; supplying the correct value is essential to correct project budgetary control validation.