Search Results currency_fmt_mask

Overview

PA_PAXPCPRS_XMLP_PKG is an Oracle Application Object Library PL/SQL package body owned by APPS within the Oracle E-Business Suite environment. It is associated with the XML Publisher (BI Publisher) report program for project cross-charge and revenue comparison processing. The package body encapsulates the server-side logic required to support a concurrent-program-driven XML report: it initializes session and profile context in the before-report stage, resolves report parameters into display values, computes column-level aggregation and variance formulas through a family of formula functions, and finalizes the run in the after-report stage. Because it is an XMLP-generated package, it bridges the EBS Concurrent Manager execution model with the XML Publisher template engine, supplying the data model values consumed by the report layout. It is registered in the APPS schema and is documented with an API classification of OTHER, indicating it is not a public APIs entry point but an internal report implementation component.

Key Procedures and Functions

The documented interface comprises 42 procedures and functions. The principal entry points include GET_COVER_PAGE_VALUES, which returns a boolean indicating whether cover-page parameter values were resolved; BEFOREREPORT, which runs before the report data is fetched; AFTERREPORT, which performs post-processing after the report completes; GET_COMPANY_NAME, which retrieves the reporting company name; and NO_DATA_FOUND_FUNC, a handler that supports graceful behavior when a lookup or query returns no rows.

The remaining documented members are report formula functions that supply computed columns to the XML template. These are organized into consistent families:

• C_DIFFFORMULA and C_DIFF2FORMULA — compute difference (variance) values.
• C_DISP_ORG_POT_REVFORMULA, C_DISP_ORG_ACC_REVFORMULA, C_DISP_ORG_DIFF_REVFORMULA — organization-level potential revenue, accrued revenue, and revenue difference.
• C_DISP_ORG_TOT_POTFORMULA, C_DISP_ORG_TOT_ACCFORMULA, C_DISP_ORG_TOT_DIFFFORMULA — organization-level totals for the same measures.
• C_DISP_MGR_POT_REVFORMULA, C_DISP_MGR_ACC_REVFORMULA, C_DISP_MGR_DIFF_REVFORMULA — manager-level potential, accrued, and difference revenue.
• C_DISP_MGR_TOT_POTFORMULA, C_DISP_MGR_TOT_ACCFORMULA, C_DISP_MGR_TOT_DIFFFORMULA — manager-level totals.
• C_DISP_TOT_POT_REVFORMULA — overall total potential revenue.

Tables Accessed

The package reads from two documented tables through APPS synonyms. PA_PROJECTS is used to resolve the project identifier into a project number (SEGMENT1) for display on the report output. PA_IMPLEMENTATIONS is referenced to support project-related implementation and business-group context required for correct report selection and formatting. These reads occur primarily during the before-report phase, where parameter values such as project organization, project number, project manager name, and the YES_NO lookup meaning are resolved into report-level variables. The package is documented as read-only with respect to these tables.

Usage Notes

PA_PAXPCPRS_XMLP_PKG is invoked indirectly by the Concurrent Manager when the associated project cross-charge report is submitted; end users do not call it directly. It is not referenced by any other documented package, confirming its role as a terminal report implementation rather than a reusable service layer. The BEFOREREPORT routine sets the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID and reads profile options such as PA_DEBUG_MODE using FND_PROFILE.VALUE, illustrating the standard XMLP initialization pattern. Parameter values, including the accrual-through date, are converted to character format for template consumption, and lookup meanings are resolved through FND_LOOKUPS. Customizations should avoid modifying this generated package body directly, since regeneration of the XML Publisher data model will overwrite changes; extensions are better placed in a wrapper package or in a customized template. The "currency_fmt_mask" term commonly associated with such reports refers to the format mask applied to currency columns in the template layer rather than to logic inside this package body.