Results for “cf_open_balanceformula”

12 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PSB_PSBRPBRT_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher (BI Publisher) report PSBRPBRT, a Budget Revisions report within the Public Sector Budgeting (PSB) module. The package implements the report's data logic, derived-column formulas, and Oracle Reports integration hooks required to render the report output. Its header comment indicates the source file PSBRPBRTB.pls at version 120.0, dated 07-Jan-2008, confirming it is a standard, non-customized seed object shipped under the APPS schema.

The package is significant in the ETRM context because it contains the runtime implementation of the report formulas — the CF_ (column formula) and CP_ (parameter/placeholder formula) routines — as well as the DSR (Data Source Reference) functions that bridge report parameters to the XML Publisher template. The user search term cp_open_balance_p maps directly to CP_OPEN_BALANCE_P, one of the documented placeholder functions used to expose the opening budget balance to the report layout.

Key Procedures and Functions

The package exposes twelve documented functions, all oriented toward report generation:

  • CF_OPEN_BALANCEFORMULA — computes the opening balance for a given account/combination by invoking the budget revisions private API to locate the original budget balance.
  • CF_END_BALANCEFORMULA — derives the ending balance by combining the opening balance with the revision value.
  • CF_ACCT_FLEX_DESCFORMULA — builds the descriptive flexfield account description used in the report output.
  • CP_1FORMULA, CP_OPEN_BALANCE_P, CP_END_BALANCE_P — placeholder/parameter wrapper functions that present the open and end balances, and the constant "1" placeholder, to the XML template with NVL protection against nulls.
  • CP_NO_DATA_FOUND_P, CP_END_OF_REPORT_P — placeholder functions returning the localized messages PSB_NO_DATA_FOUND and PSB_END_OF_REPORT.
  • BEFOREREPORT — initializes the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID and loads the two message strings from FND_MESSAGE.
  • AFTERPFORM — post-parameter form processing; queries the set of books ID using GL_PERIOD_STATUSES and the budget group, and sets date format variables.
  • AFTERREPORT — performs report-level cleanup after the XML output is produced.

Tables Accessed

The package reads from two APPS-synonymed tables:

  • GL_PERIOD_STATUSES — used in AFTERPFORM to resolve the SET_OF_BOOKS_ID for the reporting context, ensuring the report selects the correct ledger periods.
  • PSB_BUDGET_GROUPS — the budget group source used to drive the budget revision report's parameter and balance lookups.

Balance retrieval is delegated to the PSB_BUDGET_REVISIONS_PVT API rather than querying base tables directly, an encapsulation pattern typical of PSB reporting packages.

Usage Notes

APPS.PSB_PSBRPBRT_XMLP_PKG is invoked indirectly by XML Publisher when the PSBRPBRT concurrent program executes. The BEFOREREPORT and AFTERREPORT hooks integrate with the Oracle Reports runtime (SRW) that XML Publisher wraps. The ETRM metadata records zero referencing packages, meaning it is a top-level consumer rather than a shared library; custom code should not call it directly but instead extend the report template or data model. No direct procedure-level dependency surface is exposed to other PL/SQL units.