Results for “igc_cbc_po_grp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGC_CBC_PO_GRP is a grouping (GRP-classified) PL/SQL package body owned by APPS in Oracle E-Business Suite. The IGC prefix indicates it belongs to the Grants, Contracts, and Budgeting (formerly Grants Accounting) product family, and the CBC and PO components of its name identify its central concern: Commitment Budgetary Control (CBC) applied to Purchasing documents. In practice the package supplies the date-handling and control-flag logic that governs whether encumbrance accounting is enabled for a purchasing transaction and which General Ledger accounting date (the "GL encumbered date") should be carried on that transaction.

Consistent with the pattern of CBC integration packages in EBS, the object encapsulates the interaction between Purchasing encumbrance data and the budgetary control period logic maintained in GL. At package initialization it derives the operating unit context through fnd_profile.value('ORG_ID'), which is the standard mechanism used by multi-org-aware CBC routines to scope period and system-parameter lookups to a single ledger context. Client code therefore does not pass the operating unit; it is implicit.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents ten public units in this package. They fall into three functional clusters. Date determination: GET_FISCAL_YEAR resolves the fiscal year applicable to a given accounting date; GET_CBC_ACCT_UPDATE and UPDATE_CBC_ACCT_DATE retrieve and apply the CBC-correct accounting date for a purchasing document; GL_DATE_ROLL_FORWARD advances a GL date past invalid or closed periods; VALID_CBC_ACCT_DATE tests whether a candidate accounting date is valid for CBC purposes. Enablement checks: IS_CBC_ENABLED reports whether CBC is switched on for the installation, while CBC_PO_ENABLED_FLAG reports whether CBC is enabled specifically for purchasing documents; CBC_HEADER_VALIDATIONS performs the header-level validation sweep invoked before a CBC PO operation proceeds. Funds-check cancellation: SET_FUNDCHK_CANCEL_FLAG and FUNDCHK_CANCEL_FLAG set and read the fund-check cancellation indicator, most likely held as a package global, allowing a caller to suspend funds checking for a controlled scope of activity.

No parameter lists are published in the ETRM metadata for these units, and none should be assumed; callers should obtain signatures from the deployed package specification (IGC_CBC_PO_SPEC) before invoking them.

Tables Accessed

The package reads Purchasing encumbrance data through APPS synonyms. PO_DISTRIBUTIONS, PO_LINES, PO_LINE_LOCATIONS, PO_HEADERS and PO_RELEASES provide the requisition-to-purchase-order distribution detail used for date and encumbrance evaluation. PO_REQUISITION_HEADERS, PO_REQUISITION_LINES and PO_REQ_DISTRIBUTIONS serve the equivalent purpose for requisition-sourced demand, and the embedded cursor c_req_dates in the source excerpt confirms direct reading of po_req_distributions and po_requisition_lines in support of the user's po_req search—returning the minimum and maximum GL encumbered dates for a requisition header while filtering out finally-closed, cancelled, non-inventory (line_location_id null) and non-VENDOR source lines.

GL_PERIODS and GL_PERIOD_STATUSES supply the period calendar and open/closed statuses required by the roll-forward and validation routines, while FINANCIALS_SYSTEM_PARAMETERS and FND_APPLICATION provide setup context used by the enablement checks. IGC_CC_BC_ENABLE holds the CBC configuration flag consulted by IS_CBC_ENABLED and CBC_PO_ENABLED_FLAG.

Usage Notes

IGC_CBC_PO_GRP is a group-type package, meaning it is intended for internal use by other CBC and purchasing-integration packages rather than by end users. Four other packages reference it, so it functions as a shared utility layer beneath higher-level CBC APIs. Typical invocation paths are Grants Accounting and Purchasing forms that need to display or default a valid GL encumbered date, concurrent programs that re-derive or roll forward accounting dates across a batch of requisitions and purchase orders, and custom extension code performing CBC enablement checks before creating requisitions or purchase orders. Because the package reads the ORG_ID profile at initialization, callers must ensure the correct operating unit is set in the session before calling any routine that depends on GL period or system parameter data.