Search Results maintain_bal_fchk

Overview

APPS.PA_BGT_BASELINE_PKG is a PL/SQL package body in the Oracle E-Business Suite Projects (PA) module that supports budgetary control baseline processing. Its central responsibility is the maintenance and validation of budgetary control balances and funds-checking baselines for projects, tasks, and award-related structures. The package operates at the intersection of Project Budgeting and Budgetary Control, ensuring that commitments, expenditures, and cost distribution activity are reconciled against the established funding baseline.

The package is classified as OTHER in the ETRM metadata rather than as a public API, indicating it is an internal implementation unit invoked by other application logic rather than a formally published extension interface. It is documented as not being referenced by any database object, although one other package is recorded as referencing it, reflecting its role as a shared internal utility within the PA budgetary control flow.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package body:

• MAINTAIN_BAL_FCHK — The primary routine of the package. Its name connotes maintenance of balances followed by a funds check. In operation, it is responsible for establishing or refreshing budgetary control balance records and then performing the funds checking logic that determines whether sufficient budget authority exists for the associated transactions. It is the mechanism through which the package fulfills its baseline maintenance obligations to the broader budgetary control architecture.

No parameter lists are documented for MAINTAIN_BAL_FCHK; the ETRM record identifies the procedure by name and purpose only. Additional private helpers are not enumerated in the documented metadata.

Tables Accessed

The package reads and writes against a broad set of PA and GL tables through APPS synonyms. The budgetary control core tables include PA_BC_BALANCES, PA_BC_COMMITMENTS_ALL, PA_BC_PACKETS, and PA_BC_PACKETS_S, which store the balances, commitments, and packet structures used during funds checking. PA_BUDGET_LINES and PA_BUDGET_VERSIONS supply the budget baseline data against which balances are validated, while PA_BUDGETARY_CONTROL_OPTIONS provides the configuration that governs how checks are performed. PA_BC_PACKETS_S is the interface table variant associated with the packets structure.

Transaction-level facts are drawn from PA_EXPENDITURES_ALL, PA_EXPENDITURE_ITEMS_ALL, PA_COST_DISTRIBUTION_LINES_ALL, and PA_AUD_COST_DIST_LINES, allowing the package to aggregate actual and audited cost activity. GL_BC_PACKETS_S and GL_PERIOD_STATUSES link the PA balances to General Ledger packet processing and accounting period state, ensuring that baseline checks respect open and closed periods. Project and task hierarchy context comes from PA_PROJECTS_ALL, PA_TASKS, PA_RESOURCE_ASSIGNMENTS, and PA_IMPLEMENTATIONS_ALL. PUBLIC.DUAL and the PLITBLM PL/SQL table type are also referenced.

Usage Notes

PA_BGT_BASELINE_PKG is invoked internally during budgetary control processing rather than being called directly from a form. Typical invocation paths include Project Budgeting funds-check flows, the budgetary control engine that reconciles commitments and expenditures, and period-end baseline maintenance. The package relies on FND_API for the standard API return-status convention, FND_MSG_PUB for message stack handling, FND_GLOBAL for session context, and FND_PROFILE for profile option retrieval. It also delegates funds-checking to PA_FUNDS_CONTROL_PKG and uses PA_DEBUG and PA_FCK_UTIL for diagnostics and utility support. Custom code should not call MAINTAIN_BAL_FCHK directly unless it fully replicates the surrounding budgetary control transaction context.