Search Results master_budget_nameformula




Overview
Explore in AI Chat

Overview

APPS.GL_GLXRBCR_XMLP_PKG is the generated PL/SQL package body that supports the Oracle General Ledger concurrent program "GLXRBCR" — the Budget vs. Actual Report (also surfaced in certain releases as the "Budgetary Control Report" / "Budget vs. Encumbrance" style comparative report). It is an XML Publisher (BI Publisher) report package, evidenced by the _XMLP_PKG suffix and the $Header: GLXRBCRS.pls source identifier. The package does not contain independent business logic; rather it serves as the runtime container in which Oracle Reports/BI Publisher binds its data model parameters, formulates the SQL fragments (flexfield ordering, select clauses, WHERE predicates) used by the report query, and exposes the substitution values needed by the report template.

The package is compiled with AUTHID CURRENT_USER and executes under the APPS schema. It exposes a set of global package variables that mirror the concurrent program's report parameters — for example P_CONC_REQUEST_ID, P_LEDGER_ID, P_BUDGET_VERSION_ID, P_PERIOD_TYPE, P_CURRENCY_CODE, P_PERIOD_NAME, P_ACCESS_SET_ID, and CHART_OF_ACCOUNTS_ID.

Key Procedures and Functions

The package documents thirteen program units. The lifecycle anchors are BEFOREREPORT and AFTERREPORT, which fire before the report query executes and after the result set is produced; they populate ledger and access-set context used by the report. The *FORMULA procedures — AVAILABLE_BUDGETFORMULA, MASTER_BUDGET_NAMEFORMULA, and SELECT_MASTER_BUDGET/SELECT_DETAIL_BUDGET derivation — compute the projected budget values that the report compares against actuals.

The remaining units are the parameter/lexical accessors that Oracle Reports invokes to bind runtime values:

  • CHART_OF_ACCOUNTS_ID_P — returns the chart of accounts identifier used to drive the key flexfield query. The user search term "chart_of_accounts_id_p" maps directly to this function.
  • ORDERBY_FLEX_P — returns the ORDER BY clause built from the accounting flexfield segments.
  • SELECT_FLEX_P — returns the SELECT expression that concatenates the thirty flexfield segments.
  • LEDGER_NAME_P — returns the ledger name.
  • ACCESS_SET_NAME_P — returns the access set name.
  • WHERE_DAS_P — returns the Data Access Set WHERE predicate (defaulted to 'AND 1=1').
  • PTD_YTD_DSP_P — returns the period-to-date / year-to-date display indicator.
These are formula/PL-SQL columns referenced by the report's query; they are not public APIs and must not be called from custom code without understanding the report's runtime contract.

Tables Accessed

The package references two APPS synonyms: GL_ACCESS_SETS and GL_LEDGERS. From GL_LEDGERS it obtains the ledger name and the chart of accounts id associated with the ledger; from GL_ACCESS_SETS it obtains the access set name and the data access set predicate used to restrict ledger/balancing segment values. No direct DML is performed against these tables — they are read to supply parameter defaults and the WHERE clause used by the report query. The actual budget and actual balances are read by the report's own SQL, not by this package.

Usage Notes

This package is invoked exclusively by the Oracle Reports/XML Publisher runtime when the GLXRBCR concurrent program is submitted. It is registered in the concurrent program definition as the report's PL/SQL package and is executed under the APPS schema. It is referenced by zero other packages, confirming it is a leaf-level report support unit. Customizations should avoid calling its procedures directly; instead, use the supported concurrent program or, where needed, query GL_LEDGERS and GL_ACCESS_SETS independently. The hardcoded default CHART_OF_ACCOUNTS_ID := '50105' is a shipped initialization value that is overwritten at runtime by the ledger context; it is not a configuration setting.