Search Results c_grouping_name_p

Overview

PA_PAXRWDIF_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification of OTHER. Its naming convention identifies it as a report logic package (the _XMLP_PKG suffix) associated with an Oracle Projects XML Publisher concurrent program — specifically the "PAX RWDIF" (Project Awards/Revenue Difference) report. The package encapsulates the server-side PL/SQL that an XML Publisher report requires: it supplies the report's setup data, executes preparatory logic before the report renders, performs cleanup after rendering, and exposes the report's lexical and grouping parameters as callable functions. This division of responsibility lets the concurrent program define report parameters while the packaged logic resolves labels, groupings, and formatting metadata at runtime. The package status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, confirming its presence and active use across these releases.

Key Procedures and Functions

The ETRM documentation identifies six documented procedures and functions in this package. Their purposes are as follows:

• GET_COMPANY_NAME — returns the operating unit or company name used in the report output header, typically resolved from the environment of the concurrent request.
• BEFOREREPORT — the standard XML Publisher "before report" trigger function. It initializes the report's setup logic and resolves values needed by the data model prior to report execution.
• AFTERREPORT — the standard XML Publisher "after report" trigger function. It performs post-processing or cleanup once the report data has been produced.
• C_COMPANY_NAME_HEADER_P — a function supplying the company name header parameter, used to populate the header element of the report template.
• C_FORMAT_NAME_P — a function supplying the format name parameter, exposing the report's formatting value for use in the XML template.
• C_GROUPING_NAME_P — a function supplying the grouping name parameter, controlling how report rows are grouped in the output.

These entries follow the typical Oracle Reports/XML Publisher package pattern in which "before/after" triggers are declared as functions and the remaining parameters are surfaced through C_* functions bound into the report definition.

Tables Accessed

According to documented metadata, the package references two tables through APPS synonyms:

• PA_INVOICE_FORMATS — the Oracle Projects invoice format table. It is read to retrieve the report's format definition, which directly supports C_FORMAT_NAME_P.
• PA_INVOICE_GROUPS — the Oracle Projects invoice grouping table. It is read to determine the grouping structure reflected by C_GROUPING_NAME_P.

These accesses are consistent with the package's role of resolving report formatting and grouping parameters before the XML Publisher engine renders the output.

Usage Notes

PA_PAXRWDIF_XMLP_PKG is referenced by no other packages, per the documented dependency information, which indicates it functions as a leaf-level report package rather than a reusable API. It is normally invoked indirectly: the XML Publisher concurrent program associated with the PAX RWDIF report calls its BEFOREREPORT and AFTERREPORT triggers during execution, and the report definition binds the C_* functions into the template. Its only documented internal reference is to itself and the standard SYS.STANDARD package. Custom code should not call these functions directly; instead, use standard Oracle Projects APIs to compute revenue or award differences. Because the package is classified as OTHER rather than a public API, Oracle does not guarantee interface stability for it, and any custom dependency risks breakage during patching or upgrade.