Search Results pa_paxmgtsd_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PA_PAXMGTSD_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Projects XML Publisher (BI Publisher) report commonly associated with the Project Status/Management Summary extract, referenced by the search term pa_paxmgtsd_xmlp_pkg. In Oracle E-Business Suite 12.1.1 and 12.2.2, concurrent programs that use the XML Publisher (XMLP) reporting framework are implemented as a package with two components: a specification that declares the report's data functions and formula (group) functions, and a body that supplies the logic. The naming convention _XMLP_PKG identifies this object as the report data-definition package executed by the concurrent manager during the report's "data fetch" phase.

The package's business function is to gather project performance data — actual cost, actual revenue, budget cost, and progress information — across a set of projects, tasks, and accounting periods, and present it to the XML Publisher engine as formatted report lines. The body is owned by APPS and is documented as VALID, indicating it compiled successfully and is available for use in the environment surveyed by ETRM.

Key Procedures and Functions

The package exposes 39 documented procedures and functions, a subset of which is shown below. These fall into three functional categories.

Tables Accessed

ETRM records direct dependencies on the following application tables, read through APPS synonyms:

  • PA_PROJECTS — project definition and descriptive attributes for the projects included in the report.
  • PA_TASKS — task-level detail used to break project data down to lower levels.
  • PA_PERIODS — the accounting period calendar used to select and label the reporting period.
  • PA_BUDGET_TYPES — budget type definitions that qualify which budget figures are presented.
  • PA_IMPLEMENTATIONS — Projects implementation configuration, used to determine reporting and currency behavior.

Additional listed dependencies include FND_GLOBAL and FND_PROFILE (session and profile option values), GL_SETS_OF_BOOKS (ledger/currency context), HR_ORGANIZATION_UNITS and PER_PEOPLE_F (organization and person name resolution), PA_LOOKUPS (meaning resolution for coded values), and the APIs PA_ACCUM_API and PA_MULTI_CURRENCY for accumulated project amounts and currency conversion.

Usage Notes

This package is not called by other database objects — ETRM reports that it is referenced by zero packages. It is invoked exclusively as the data-definition program for its associated XML Publisher concurrent program. Users run the concurrent request from the Projects responsibility; the concurrent manager then calls BEFOREREPORT, the per-row and formula functions as the XML Publisher engine walks the defined data groups, and finally AFTERREPORT. Customizations should not modify the package directly, because it is a generated artifact that may be overwritten during patching; the supported approach is to extend the underlying report definition or to call the package's public functions from custom reporting code where a programmatic result is required.