Search Results pa_paxaasrp_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PAXAASRP_XMLP_PKG is a PL/SQL package that supports the Oracle Projects "Actual Amounts vs. Budgeted Amounts Report" (PAXAASRP) concurrent program. The package is generated by Oracle XML Publisher (XMLP) when a report definition is registered against an Oracle Reports source. Its primary purpose is to supply the runtime parameters, global variables, and report-level trigger logic that the XML Publisher engine invokes at the beginning and end of report execution, and to populate header or "cover page" values that appear on the printed output.

The package declares a set of public variables, including P_FUNCTION_CODE, P_debug_mode, P_CONC_REQUEST_ID, P_rule_optimizer, C_COMPANY_NAME_HEADER, and C_function_name, which hold session and report context information. The package was last updated in the 12.0 code line (header references PAXAASRPS.pls 120.0) and remains relevant across Oracle EBS 12.1.1 and 12.2.2 installations, where it resides in the APPS schema and is classified as an "OTHER" API in ETRM.

Key Procedures and Functions

The package exposes six documented program units. GET_COVER_PAGE_VALUES returns a BOOLEAN and is responsible for populating the cover-page fields of the report, particularly the company name header. BEFOREREPORT is the standard XMLP wrapper trigger that executes before the report query runs, initializing globals and invoking the cover-page logic. AFTERREPORT runs after the main query completes, performing cleanup or final formatting tasks.

GET_COMPANY_NAME also returns a BOOLEAN and retrieves the legal entity or implementation name used in the report header. The two accessor functions, C_COMPANY_NAME_HEADER_P and C_function_name_P, return VARCHAR2 values that expose the internal C_COMPANY_NAME_HEADER and C_function_name globals to the report layout. These accessors follow the XMLP naming convention in which a trailing "_P" denotes an encapsulated variable getter. No parameter lists are documented; none of these functions are declared with formal arguments in the ETRM metadata.

Tables Accessed

The package reads from two Oracle Projects tables via APPS synonyms. PA_FUNCTIONS is used to resolve the function code and function name associated with the report context — the C_function_name global and P_FUNCTION_CODE variable derive from this table, supporting function-security and report-naming logic. PA_IMPLEMENTATIONS supplies implementation-level information, including the company or organization name that feeds C_COMPANY_NAME_HEADER through GET_COMPANY_NAME and GET_COVER_PAGE_VALUES. No insert, update, or delete operations are documented, indicating the package is read-only with respect to the database.

Usage Notes

PA_PAXAASRP_XMLP_PKG is not called directly by end users or developer-written code. It is invoked by the Oracle XML Publisher concurrent program engine when the PAXAASRP report is submitted. The BEFOREREPORT trigger fires during initialization, GET_COVER_PAGE_VALUES and GET_COMPANY_NAME populate header values, and AFTERREPORT executes during teardown. The accessor functions C_COMPANY_NAME_HEADER_P and C_function_name_P are referenced only from the report layout template. Because ETRM indicates the package is referenced by zero other packages, customization should avoid direct dependencies on these globals; instead, developers extending the report should follow the XMLP generated-package pattern or create a separate custom package. The presence of P_debug_mode and P_rule_optimizer variables reflects standard Oracle Reports runtime options passed by the concurrent manager.