Search Results pa_paxmgpsd_xmlp_pkg




Overview
Explore in AI Chat

Overview

PA_PAXMGPSD_XMLP_PKG is a PL/SQL package in the APPS schema that supports the XML Publisher (BI Publisher) report commonly associated with Project Accounting gross margin and project summary reporting (the "PAXMGP" or "PAXMGPSD" report family in Oracle Projects). The package functions as the report-specific PL/SQL library that drives concurrent program execution: it supplies the data elements, formulas, and display values consumed by the report's XML data template and layout. Consistent with the standard Oracle EBS XML Publisher report architecture, the package implements a BEFORE REPORT trigger, encapsulating query logic and derived-column formulas that would otherwise reside in the report definition itself.

The package is classified as OTHER in the ETRM metadata, meaning it is not a public, supported application programming interface; it is an internal component of a seeded Oracle Projects report. It is marked VALID in both 12.1.1 and 12.2.2 environments, confirming it is a standard, shipped object rather than a customization artifact.

Key Procedures and Functions

The package exposes 32 documented procedures and functions. The principal entry point, and the one most referenced by report definitions, is BEFOREREPORT, which performs report-level initialization prior to data extraction. It is complemented by AFTERREPORT and AFTERPFORM for post-processing and post-formula logic within the report lifecycle.

Cover-page and header values are supplied by GET_COVER_PAGE_VALUES, GET_COMPANY_NAME, GET_PERIOD, and PERIOD_NAMEFORMULA, which collectively establish the report period, operating unit/company identity, and page headers. Currency handling is addressed by CF_CURRENCY_CODEFORMULA.

Amount derivation and aggregation are handled by a set of calculation routines, including GET_PERIOD_AMT and GET_PERIOD_AMT_SUM for period-based amounts (and their summarized totals), and the formula functions C_PROJECT_ACTUAL_COSTFORMULA, C_ACT_PER_REVFORMULA, C_ACT_PER_COSTFORMULA, C_ACT_PER_REV_SUMFORMULA, and C_ACT_PER_COST_SUMFORMULA, which compute actual-versus-budget cost and revenue ratios, including summed variants used in report subtotal rows. Additional financial formulas include UNBILLED_RECEIVABLESFORMULA, UNEARNED_REVENUEFORMULA, and UNBILLED_RETNFORMULA for receivables, revenue recognition, and retention balances.

Supporting utilities include GET_RSRC_NAME_DISP, which formats resource-name display values, and NO_DATA_FOUND_FUNC, which provides controlled handling of empty result sets.

Tables Accessed

The package reads from four APPS synonym-referenced tables. PA_PROJECTS supplies project identifiers and attributes used throughout the report headings and groupings. PA_PERIODS provides period definitions and naming, supporting GET_PERIOD and PERIOD_NAMEFORMULA. PA_BUDGET_TYPES supplies the budget type context required for actual-versus-budget cost and revenue comparisons. PA_IMPLEMENTATIONS is referenced for implementation-level parameters, such as operating unit and currency settings relevant to CF_CURRENCY_CODEFORMULA and company-name retrieval.

Usage Notes

This package is invoked indirectly by the Oracle Projects XML Publisher concurrent program through the report definition's trigger bindings and formula columns; it is not intended to be called directly from forms or custom PL/SQL. Because ETRM lists zero dependent packages, it is a leaf-level report library with no downstream callers in the APPS schema. Customizations should avoid modifying this seeded object, as it is preserved during patching; any extensions should be implemented through a custom copy of the report and its supporting package.