Search Results budgetary_control

Overview

PSA_BC_XLA_PUB is the public (PUB) package body in the APPS schema that supports Budgetary Control integration with Subledger Accounting (XLA) in Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, Budgetary Control is the ETRM feature that enforces funds availability checks against budgets for commitments, obligations, and actual transactions. The PSA_BC_XLA_PUB package provides the public API surface through which Budgetary Control interacts with Subledger Accounting — the accounting engine that transforms subledger transactions into journal entries. It abstracts the internal implementation held in the private package PSA_BC_XLA_PVT, exposing a stable public interface for callers that need to run budgetary control processing during subledger accounting events.

The package is classified as a public API package (API classification: PUB), which means it is intended to be invoked, and its documented routines are supported entry points. The dependency listing confirms it relies on FND_API, FND_LOG, FND_MSG_PUB, PSA_BC_XLA_PVT, and PSA_UTILS, following the standard Oracle EBS API conventions for error handling (FND_MSG_PUB), logging (FND_LOG), and the standard API result pattern (FND_API).

Key Procedures and Functions

The ETRM documentation records two documented procedures and functions in this package. The available metadata does not include parameter lists, so only the purpose of each is described.

• BUDGETARY_CONTROL — Invokes budgetary control processing in the context of Subledger Accounting. This procedure drives the funds availability check and related budgetary control logic for transactions processed through the XLA framework. It delegates the internal implementation to PSA_BC_XLA_PVT.
• GET_SLA_NOTUPGRADED_FLAG — Returns the Subledger Accounting "not upgraded" flag, which indicates whether the SLA upgrade state requires handling. Callers use this to determine whether SLA-related upgrade processing is still pending.

Both routines follow ETRM's public API design, meaning they should be invoked in preference to the private PSA_BC_XLA_PVT equivalents, which are subject to change.

Tables Accessed

The ETRM documentation for this object does not list any tables accessed via APPS synonyms. While Budgetary Control broadly reads and writes control budget and funds availability tables (such as PSA_BC_* tables) and subledger accounting tables (XLA_*), none are directly attributed to this package in the provided metadata, so no specific table dependencies can be confirmed from the documentation. Implementers should treat table access as encapsulated within PSA_BC_XLA_PVT and the PSA_UTILS utility package, which this package delegates to.

Usage Notes

PSA_BC_XLA_PUB is referenced by twenty other packages, indicating it is a widely consumed interface within the EBS application codebase. Typical invocation scenarios include subledger accounting processing where budgetary control checks must be applied, and upgrade-related logic that relies on the SLA not-upgraded flag. Because it is a public API package, custom code and extensions that need to perform the same budgetary control integration should call PSA_BC_XLA_PUB rather than the private PSA_BC_XLA_PVT package. The package is not referenced by any database object (such as a trigger or view), confirming that it is intended to be called programmatically rather than invoked automatically. Developers integrating with this package in 12.1.1 or 12.2.2 should review the documented procedures, use the standard FND_API conventions, and avoid depending on the private package, whose interface may change.