Search Results cf_1formula0090




Overview
Explore in AI Chat

Overview

PSB_PSBRPVPR_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the XML Publisher (BI Publisher) report "PSBRPVPR" — the Position/Budget Report with Position and Variance analysis used in the Public Sector Budgeting (PSB) module. The report renders budget and position worksheets that have been extracted through the PSB budget preparation cycle. The package is classified as an API classification of OTHER, meaning it is not a public integration API but rather a report-supporting package generated to wrap the XML Publisher data model for the corresponding concurrent program.

The package defines the global variables and report-level logic required to drive the report layout: bind parameters (worksheet ID, concurrent request ID, data extract ID, budget year ID), report-level totals (CP_ELEM_TOTAL, CP_POS_TOTAL, CP_POS_ASS_WS), display strings (CP_NO_DATA_FOUND, CP_END_OF_REPORT), and descriptive attributes (currency code, extract name, worksheet name, year name, report type). The header indicates a 2008 source revision (PSBRPVPRS.pls 120.0) and marks the package as shipped with Oracle (noship is absent from the change line), consistent with a standard EBS-delivered report program.

Key Procedures and Functions

The package exposes sixteen documented functions and no standalone procedures. They fall into two categories.

  • Report lifecycle functions: BEFOREREPORT, BEFOREPFORM, AFTERPFORM, AFTERREPORT, and BETWEENPAGE. These are standard XML Publisher report triggers that initialize the data model, process parameters, perform post-format logic, and handle page transitions.
  • Value-derivation functions: CF_1FORMULA0090, which is the function the user searched for. In Oracle XML Publisher concurrent package generation, functions named CF_nFORMULAmmmm are auto-generated from formulas typed directly into the RTF template's field definitions. CF_1FORMULA0090 takes a single input of BUDGET_GROUP_ID_1 and returns a VARCHAR2; it computes the display value for a template field based on the budget group.
  • Placeholder accessors: CP_CURRENCY_CODE_P, CP_ELEM_TOTAL_P, CP_POS_TOTAL_P, CP_NO_DATA_FOUND_P, CP_END_OF_REPORT_P, CP_POS_ASS_WS_P, CP_EXTRACT_NAME_P, CP_WORKSHEET_NAME_P, CP_YEAR_NAME_P, and CP_REPORT_TYPE_P. These simply return the value of the corresponding global variable so the template data model can reference them.

Tables Accessed

The package reads through three APPS synonyms, which correspond to the core Public Sector Budgeting schema objects:

No inserts or updates are performed; the package is read-only and serves the report data model.

Usage Notes

PSB_PSBRPVPR_XMLP_PKG is invoked indirectly by the concurrent program that runs the PSBRPVPR XML Publisher report. Users launch it from the Public Sector Budgeting menu or from a request set; the concurrent manager calls the executable, which calls the package's data model functions. It is not referenced by any other package (referenced by 0 other packages), indicating it is a leaf node in the dependency graph. Developers customizing the report template should modify the RTF layout rather than the package, and any change to template field formulas will regenerate corresponding CF_nFORMULAmmmm functions on the next concurrent program definition compile. Because it is owned by APPS and shipped by Oracle, custom modifications should be placed in a copy or in a custom template to remain upgrade-safe across 12.1.1 and 12.2.2.