Results for “cp_1formula”

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

Overview

PSB_PSBRPBRT_XMLP_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that backs the "PSB: PSBRPBRT" XML Publisher (BI Publisher) concurrent program report. The report belongs to the Public Sector Budgeting (PSB) product family, which supports budget formulation, budget entry, and budget versus actual analysis for public sector and government organizations. Its name follows Oracle's standard convention for XML Publisher report package wrappers: the report short name followed by the _XMLP_PKG suffix. The package serves as an XML Publisher data model supporting shell, providing the formula columns, before/after report triggers, and after-formula (AfterPForm) logic required by the report's RTF or XML template.

The package is documented in ETRM as VALID and classified as API classification OTHER, meaning it is not a published public API but an internal report-support package. Its dependencies are limited to SYS.STANDARD and, reflexively, itself; no other application packages reference it. This isolated dependency profile confirms that the package is invoked exclusively by the XML Publisher report engine at runtime rather than by other PL/SQL code.

Key Procedures and Functions

ETRM documents 12 procedures and functions. The before and after triggers control report lifecycle behavior:

• BEFOREREPORT — Executes before the report query runs; typically initializes session context, resolves report parameters, and prepares package-level state used by later formula columns.
• AFTERPFORM — Runs after the report parameter form is submitted but before the main query, used to derive or validate parameter values.
• AFTERREPORT — Executes after the report data set has been generated, performing cleanup or final computations.

The remaining entries are formula columns or their supporting program units referenced by the XML template:

• CF_OPEN_BALANCEFORMULA and CF_END_BALANCEFORMULA — Formula columns that expose the opening and ending budget balances for each reported row.
• CP_OPEN_BALANCE_P and CP_END_BALANCE_P — Supporting program units that compute the opening and ending balances used by the formulas above.
• CP_1FORMULA, CP_END_BALANCEFORMULA, and CF_ACCT_FLEX_DESCFORMULA — Additional formula columns; CP_1FORMULA is a generic single-value column, and CF_ACCT_FLEX_DESCFORMULA renders the accounting flexfield concatenated description.
• CP_NO_DATA_FOUND_P and CP_END_OF_REPORT_P — Control PL/SQL units that suppress output or emit an end-of-report marker when the query returns no rows or the data set is exhausted.

Tables Accessed

The package reads from two tables through APPS synonyms:

• GL_PERIOD_STATUSES — The General Ledger period-status table. It supplies period names, period years, and open/closed status so the report can label periods correctly and restrict reporting to the appropriate accounting periods.
• PSB_BUDGET_GROUPS — The Public Sector Budgeting budget group definition table. It provides the budget group identifiers and descriptive attributes that drive the report's budget balance rows.

No inserts, updates, or deletes are documented; the package is read-only with respect to these tables, consistent with its report-support role.

Usage Notes

PSB_PSBRPBRT_XMLP_PKG is invoked indirectly by the XML Publisher runtime when the associated PSB concurrent program is submitted. Users do not call it from forms or custom code. Because the package is classified OTHER, it is not a supported integration point; customizations should target the underlying report template or a copy rather than the seeded package. The package is present and valid in both EBS 12.1.1 and 12.2.2; no code changes to this object are documented between the two releases. Developers diagnosing report output issues should verify the concurrent program definition, the XML Publisher template registration, and the parameter values passed into BEFOREREPORT and AFTERPFORM before examining package logic.