Search Results pa_bgt_baseline_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_BGT_BASELINE_PKG is a PL/SQL package within the Oracle E-Business Suite Projects (PA) module that supports budgetary control processing at the point a project budget version is baselined. Its core responsibility is to maintain the balances that underpin budgetary control, funds checking, and integration with General Ledger. When a budget version is baselined (or a baselining action is otherwise processed), the package evaluates the associated project and budget version, determines the applicable budgetary control type and integration flag, and coordinates the maintenance of budgetary balance records so that subsequent funds checks and encumbrance processing operate against accurate, current figures. The package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the calling user rather than the definer, which is consistent with the security model used across many PA budgetary control routines.

The source header indicates a revision dated 2005 and references an "R12 Funds Management Uptake" parameter that stores the newly baselined budget version ID, reflecting the package's adaptation for Release 12 funds management behavior. The package is compact, exposing a single documented procedure, but it plays a targeted role in the broader funds control and budget balance maintenance flow.

Key Procedures and Functions

The ETRM metadata documents one procedure for this package:

  • MAINTAIN_BAL_FCHK — Maintains budgetary balances and supports funds checking activity in the context of a baselined budget version. The procedure accepts inputs identifying the project, the budget version, and (for the R12 funds management uptake) the newly baselined budget version ID, together with the budget control type, a calling-mode indicator, and a budget integration flag. It returns a standard return status and error message code, following the conventional PA API error-handling pattern (x_return_status / x_error_message_code). The procedure drives the balance maintenance logic that follows a baselining event.

No other procedures or functions are documented in the ETRM metadata, and per Oracle EBS naming and API conventions, callers should validate x_return_status and handle x_error_message_code accordingly.

Tables Accessed

The package references the following tables through APPS synonyms, which indicate the data domains it touches:

Usage Notes

PA_BGT_BASELINE_PKG is an internal Projects budgetary control utility rather than a general-purpose public API. It is typically invoked during the budget baselining process — for example, from budget baseline processing or from higher-level PA funds control packages. The metadata notes that it is referenced by one other package, confirming its role as a dependent routine called by enclosing budgetary control logic rather than being driven directly by end users. It is not associated with an Oracle Forms interface or a standalone concurrent program per the documented metadata; instead, it is called programmatically. Customizations should avoid direct invocation unless the full baselining and funds control context is reproduced, since correct behavior depends on the surrounding budgetary control configuration and period status. All calls should honor the project/budget version identifiers and the R12 baselined-version parameter, and should check the returned status and error message code.