Search Results c_disp_org_tot_diffformula

Overview

PA_PAXPCPRS_XMLP_PKG is an Oracle Application Object Library (APPS) PL/SQL package stored in the E-Business Suite database, declared with AUTHID CURRENT_USER. It is the packaged PL/SQL body associated with the Oracle Projects (PA) XML Publisher concurrent report commonly referenced as "PAXPCPRS" — a project potential and accrued revenue reporting program (the "PC" segment in the name denotes project cost/potential reporting). In the Oracle EBS 12.1.1 and 12.2.2 releases this package supports report generation by supplying the cover-page values, header descriptions, and computed display columns that the XML Publisher template consumes. Its API classification in the ETRM is OTHER, reflecting that it is a report-support package rather than a public application programming interface. The package encapsulates the standard concurrent program lifecycle entry points — BEFORE REPORT and AFTER REPORT functions — together with a large set of named column formulas used for XML output formatting.

Key Procedures and Functions

The documented catalog lists 42 procedures and functions. The report lifecycle functions are BEFOREREPORT, which initializes report-level state and gathers the input parameters, and AFTERREPORT, which performs post-processing and cleanup. GET_COVER_PAGE_VALUES and GET_COMPANY_NAME populate the report cover page, including the company name header value. NO_DATA_FOUND_FUNC determines whether the query returned no rows. The remaining members are display formulas that format numeric revenue and difference values as character strings for the XML template: C_DIFFFORMULA and C_DIFF2FORMULA compute partial and total revenue differences; the C_DISP_ORG_* series (C_DISP_ORG_POT_REVFORMULA, C_DISP_ORG_ACC_REVFORMULA, C_DISP_ORG_DIFF_REVFORMULA, C_DISP_ORG_TOT_POTFORMULA, C_DISP_ORG_TOT_ACCFORMULA, C_DISP_ORG_TOT_DIFFFORMULA) format organization-level potential, accrued, difference and their totals; the C_DISP_MGR_* series (C_DISP_MGR_POT_REVFORMULA, C_DISP_MGR_ACC_REVFORMULA, C_DISP_MGR_DIFF_REVFORMULA, C_DISP_MGR_TOT_POTFORMULA, C_DISP_MGR_TOT_ACCFORMULA, C_DISP_MGR_TOT_DIFFFORMULA) perform the equivalent formatting at manager level; C_DISP_TOT_POT_REVFORMULA handles the grand total. The function of interest, C_DISP_ORG_POT_REVFORMULA, accepts the organization potential revenue amount and returns its formatted VARCHAR2 display representation for the report column. No parameter lists are documented beyond the source excerpt.

Tables Accessed

The package references two tables through APPS synonyms. PA_IMPLEMENTATIONS is read to retrieve implementation-level settings and options governing Oracle Projects behavior, which drive the report's configuration. PA_PROJECTS supplies project attributes such as project number, manager, and organization, which populate the header values (C_PROJ_NUMBER, C_PROJ_MANAGER, C_PROJ_ORG) and provide the driving data for the report body.

Usage Notes

The package is invoked indirectly through its concurrent program: Oracle Reports or XML Publisher calls BEFOREREPORT and AFTERREPORT automatically during execution, and the formula functions are referenced in the report's data model for the corresponding XML columns. It is not called from Oracle Forms and, per the ETRM, is not referenced by any other package (0 dependents). Customizations should follow Oracle's documented report extension patterns rather than modifying the package directly, since changes are overwritten by patching. The presence of P_CONC_REQUEST_ID confirms the standard concurrent-program context; the P_DEBUG_MODE and P_RULE_OPTIMIZER parameters indicate optional diagnostic and rule-optimization controls exposed to the report input.