Search Results get_bvid




Overview
Explore in AI Chat

Overview

APPS.BUDGET_INQUIRY_PKG is a server-side PL/SQL package in the Oracle E-Business Suite General Ledger module, owned by the APPS schema and classified under the ETRM reference as an OTHER-type API. It is the inquiry-side engine that supports the Budget Inquiry responsibility, allowing users to review budget balances, dependent amounts, and budgetary control results without invoking the full budgeting maintenance workflow. The package resolves the session context (ledger, budget version, currency, and template) required by the budget inquiry views, and it exposes the account hierarchy lookups that drive the summary-code and rollup presentations.

In ETRM 12.2.2 the package is documented as VALID and is referenced by five other APPS packages, indicating it sits beneath the budget inquiry user interface rather than at the top of the call stack. Its principal consumers are the GL budget inquiry views, which include GL_BUDGET_DEPENDENT_AMTS_V, GL_BUDGET_DEP_BALANCES_V, GL_BUDGET_DETAIL_BALANCES_V, GL_CONTROL_BUDGET_BALANCES_V, and GL_SUMMARY_CODE_COMBS_V. Because these are inquiry views, the package is read-oriented and does not post journal entries or modify budget balances.

Key Procedures and Functions

The documented interface comprises ten procedures and functions:

  • SET_CRITERIA — Establishes the inquiry search criteria used by subsequent calls in the session.
  • SET_LEDGER_ID — Records the ledger context for the inquiry.
  • GET_LEDGER_ID — Returns the ledger identifier currently held in the package state.
  • GET_BVID — Returns the budget version identifier (BVID) for the active inquiry.
  • GET_CURRENCY — Returns the currency associated with the budget inquiry context.
  • GET_TEMPLATE_ID — Returns the identifier of the budget inquiry template in use.
  • GET_FACTOR — Returns the conversion or display factor applied to inquiry amounts.
  • GET_FUNCT_CURR — Returns the functional currency for the ledger in context.
  • GET_CCID — Returns the code combination identifier for the account being inspected.
  • CHECK_DETAIL_ACCOUNTS — Validates whether detail accounts exist for the inquiry criteria supplied.

The pattern of paired setters and getters indicates the package maintains session-level state so that forms and views can retrieve resolved identifiers without re-querying the ledger and budget version setup each time.

Tables Accessed

The ETRM metadata records a single documented table reference: GL_ACCOUNT_HIERARCHIES, accessed through an APPS synonym. This table supplies the account hierarchy and rollup definitions used by the summary-code views, allowing the inquiry to present balances at summary and detail levels consistently. The remaining data displayed by the budget inquiry views is sourced from the GL budget balances and dependent-amount objects underlying those views; the package itself primarily supplies context and validation rather than direct balance retrieval.

Usage Notes

BUDGET_INQUIRY_PKG is invoked indirectly through the Budget Inquiry forms and the GL budget inquiry views rather than being called directly by end users. Because it is referenced by five dependent packages, customizations should treat it as a supporting layer: callers should set ledger, criteria, and template context before retrieving BVID, currency, factor, functional currency, or CCID values. In 12.1.1 and 12.2.2 the package is VALID and requires no patching for standard inquiry use. Developers extending budget inquiry should avoid modifying package state assumptions in the getters, since dependent views rely on the same session context. Direct calls from custom concurrent programs are possible but uncommon; the intended path is through the inquiry user interface and its underlying views.