Search Results cf_percent_changeformula

Overview

APPS.PSB_PSBRPBRS_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent report PSBRPBRS, known within the Public Sector Budgeting (PSB) module as the Budget Revisions report. The package encapsulates the report-level logic that the XML Publisher runtime invokes during report execution: it initializes the concurrent request context, resolves translatable messages for the no-data and end-of-report conditions, and supplies the derived values consumed by the report's data model and layout templates. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is classified as an "OTHER" API, meaning it is not a public, supported integration interface but a report implementation artifact generated by Oracle Reports to XML Publisher conversion. The reported library unit name aligns with the source header PSBRPBRSB.pls, and the source copyright header dates the implementation to 2008.

Key Procedures and Functions

The package exposes eleven documented program units. BEFOREREPORT is the standard XML Publisher before-report trigger; it loads message text via FND_MESSAGE for CP_NO_DATA_FOUND and CP_END_OF_REPORT, and captures the concurrent request identifier through FND_GLOBAL.CONC_REQUEST_ID. AFTERREPORT is the complementary after-report trigger used for teardown and final report handling.

CP_ORIGINAL_BUDGETFORMULA, CF_ORIGINAL_BUDGETFORMULA, and CP_ORIGINAL_BUDGET_P form the original-budget retrieval layer. The two CP_ORIGINAL_BUDGETFORMULA overloads return the budget balance: one is a passthrough that returns the supplied CF_ORIGINAL_BUDGET value, while the multi-argument version delegates to PSB_BUDGET_REVISIONS_PVT.FIND_ORIGINAL_BUDGET_BALANCE, passing the code combination, budget group, GL period, GL budget version, set of books, end period, and currency code, and returning NVL(L_ORIGINAL_BUDGET,0).

CF_PERCENT_CHANGEFORMULA derives the percentage change between the budget balance and the revision amount. It resolves the currency code from PSB_BUDGET_REVISION_ACCOUNTS_V for the active budget revision, guards against division by zero when the budget balance is null or zero, and applies PSB_BUDGET_REVISIONS_PVT.GET_ROUNDED_AMOUNT to the computed percentage so the reported figure respects currency rounding rules. The remaining formula functions—CF_ACCT_FLEX_DESCFORMULA, CF_CURRENCY_CODEFORMULA, and CF_DOCUMENT_POSTING_STATUSFORMULA—supply the accounting flexfield description, the currency code, and the document posting status display value respectively. The user's search term, "cf_document_posting_statusform", corresponds to CF_DOCUMENT_POSTING_STATUSFORMULA, the formula column that renders the posting status of the budget revision document in the report output. CP_END_OF_REPORT_P and CP_NO_DATA_FOUND_P are the package variables holding the localized message strings set in BEFOREREPORT.

Tables Accessed

The only directly documented table reference is PSB_BUDGET_REVISIONS, accessed through its APPS synonym. It is the base transactional table for budget revision documents and provides the document context, including the budget revision identifier used to resolve the currency code in CF_PERCENT_CHANGEFORMULA. The package additionally reads PSB_BUDGET_REVISION_ACCOUNTS_V, the revision accounts view, to obtain the distinct currency code for a given budget revision. All original-budget balance computation is delegated to the PSB_BUDGET_REVISIONS_PVT package rather than being performed directly in this body.

Usage Notes

PSB_PSBRPBRS_XMLP_PKG is invoked exclusively by the XML Publisher runtime when the PSBRPBRS concurrent program is submitted; it is not called directly by forms, and the ETRM metadata records zero packages referencing it. In 12.1.1 and 12.2.2 the report should be run through the standard Submit Request or concurrent manager interface so that FND_GLOBAL.CONC_REQUEST_ID resolves correctly and the PSB message names are available in the current language. Customizations must not modify the generated package body, because regeneration of the XML Publisher report definition overwrites it; any desired change to revenue or budget calculation behavior should be implemented in PSB_BUDGET_REVISIONS_PVT, from which this package derives its business values.