Search Results pa_papwprirep_xmlp_pkg




Overview
Explore in AI Chat

Overview

PA_PAPWPRIREP_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an OTHER API. The name follows the standard Oracle XML Publisher (BI Publisher) concurrent program convention: the P_ prefix denotes the "Project" application, PAPWPRIREP is the short name of the underlying concurrent program, and the _XMLP_PKG suffix indicates the package was generated to support an XML Publisher report template. Within Oracle Projects, this package supports the Project Performance reporting family of concurrent programs, which consolidate project-level cost, budget, revenue, and commitment data into output suitable for XML Publisher rendering. The package is currently VALID in both EBS 12.1.1 and 12.2.2. ETRM references list only SYS.STANDARD as a dependency and record that the package is self-referencing; no other APPS packages depend on it.

Key Procedures and Functions

ETRM documents two callable units within this package:

  • GET_COMPANY_NAME — Returns the reporting company/organization name used in the report header and output metadata. This routine typically resolves the company name for the operating unit or legal entity associated with the report run, ensuring that printed or exported output carries the correct organizational identity.
  • CLEANUP — Performs post-processing cleanup for the package. In XML Publisher report packages, CLEANUP is commonly invoked at the end of the concurrent run to release global PL/SQL state, reset package-level variables, or remove temporary artifacts created during report generation so that subsequent executions start from a clean state.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The two entries represent the full documented interface surface of the package.

Tables Accessed

ETRM records two tables accessed through APPS synonyms:

  • PA_IMPLEMENTATIONS — The Oracle Projects implementation/installation table. It stores installation-level settings and is commonly queried to retrieve organizational and setup context, such as the company name returned by GET_COMPANY_NAME.
  • PA_PWP_RELEASE_REPORT — A Project Performance (PWP) reporting structure that holds report driving data. The XML Publisher report reads this table as its principal data source, with the package supplying the surrounding PL/SQL logic for header values and cleanup.

Direct references to SYS.STANDARD reflect normal PL/SQL built-in usage rather than application data access.

Usage Notes

This package is not a public application programming interface. It is invoked indirectly when the associated XML Publisher concurrent program (PAPWPRIREP) is submitted from the Oracle Projects responsibility or through the concurrent manager. The XML Publisher engine calls GET_COMPANY_NAME during report data generation and CLEANUP at completion. Because no other packages reference it (referenced-by count is zero) and no parameters are documented, custom code should not call this package directly; extending the report is instead accomplished by modifying the XML Publisher data template and RTF/BI Publisher layout. Developers should treat the package as an internal implementation detail of the PAPWPRIREP concurrent program, and any direct invocation in customizations risks incompatibility across EBS releases, particularly given the package's self-referencing dependency chain.