Search Results get_balance

Overview

APPS.GL_BUDGET_TRANSFER_PKG is a PL/SQL package body in the Oracle E-Business Suite General Ledger module that supports budget transfer processing and budget balance inquiry. Its principal business purpose is to compute the available balance for a given budget account combination so that a budget transfer can be validated before it is applied. The package resolves balances against two distinct data sources depending on the budgetary control configuration of the ledger: when budgetary control is enabled it reads from the budgetary control packets, and it always augments that figure with balances sourced from the interface layer. This dual-source approach ensures that pending, unposted budget activity is reflected alongside committed budgetary control balances.

Key Procedures and Functions

• GET_BALANCE — The central function of the package. It accepts a balance type, ledger, budgetary control enabled flag, period, budget version, currency, and a single code combination identifier, and returns a numeric balance. When the budgetary control flag is set to 'Y', it first accumulates a balance from budgetary control packets; it then adds the posted balance obtained from the interface layer for the same account, and returns the combined result.
• GET_FROM_TO_BALANCE — A wrapper procedure that resolves the balance for both the source (from) and destination (to) code combinations of a transfer by invoking GET_BALANCE twice. It returns both balances through IN OUT NOCOPY parameters.
• GET_BC_BALANCE — Retrieves the balance attributable to budgetary control packets for a given account, period, budget version, and currency. This function is used only when budgetary control is enabled.
• GET_POSTED_BALANCE — Retrieves the posted portion of the balance from the interface data, representing budget activity already interfaced into General Ledger.
• GET_FROM_TO_BC_BALANCE — The budgetary-control counterpart to GET_FROM_TO_BALANCE, resolving budgetary control balances for both the source and destination code combinations of a transfer.

Tables Accessed

• GL_BC_PACKETS — Stores budgetary control packet data; read to derive the budgetary control portion of a balance when budgetary control is enabled.
• GL_BC_PACKET_ARRIVAL_ORDER — Ordering mechanism for budgetary control packets, ensuring balances are aggregated in the correct sequence.
• GL_BALANCES — The core General Ledger balances table, providing authoritative account balances used in the transfer computation.
• GL_PERIOD_STATUSES — Supplies period open/closed status used to determine which periods are eligible when resolving balances.

These objects are referenced through APPS synonyms, which is standard for EBS packages residing in the APPS schema.

Usage Notes

GL_BUDGET_TRANSFER_PKG is an internal utility package rather than a public API. It is invoked during budget transfer flows — typically from General Ledger budget transfer forms or from concurrent programs that validate a transfer before committing it — where the available balance on both the source and destination accounts must be confirmed. The GET_BALANCE function is the most commonly referenced entry point, appearing as the search term associated with this object. Custom code should treat the package as read-only balance inquiry logic and should not assume the presence of undocumented parameters. Because the package conditionally reads budgetary control packets, behavior differs between ledgers with budgetary control enabled and those without, and callers must supply an accurate budgetary control flag and the correct budget version and currency to obtain meaningful results. No other packages in the ETRM metadata are documented as referencing this package, indicating a narrow, contained scope of use.