Results for “pa_paxingen_xmlp_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_PAXINGEN_XMLP_PKG is a report-generator package body used by Oracle Projects to support the "PAXINGEN" concurrent report in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The name follows the standard XML Publisher (BI Publisher) report package convention, where an XMLP report is wrapped by a PL/SQL package that produces the report's data model in XML form. The suffix "XINGEN" identifies the specific report, and the package encapsulates the query logic, bind parameters, and formatting computations required to render that report against the Projects schema.

Functionally, the package belongs to the Projects reporting layer. It retrieves implementation settings, organization information, project attributes, and currency details, and shapes them into the group filters and columns expected by the associated XML template. It is classified in the ETRM metadata with API classification "OTHER," reflecting its role as a report support package rather than a public application programming interface.

Key Procedures and Functions

The documented package exposes 31 procedures and functions. The most significant are:

• BEFOREREPORT and AFTERREPORT — standard XML Publisher report hooks executed before and after the data model is generated; they typically initialize session context and release resources.
• GET_COVER_PAGE_VALUES — assembles the values shown on the report cover page, such as company name and reporting parameters.
• GET_COMPANY_NAME — resolves the organization or company name for the report header.
• GET_START_ORG — determines the starting organization for the reporting hierarchy.
• Group filter functions — G_PROJECT_HDR_GROUPFILTER, G_ITEM_INFO_GROUPFILTER, G_ITEM_DETAILS_GROUPFILTER, G_UNBILLED_DETAILS_GROUPFILTER, G_UNBILLED_EVENTS_GROUPFILTER, G_INVOICE_GROUPFILTER, G_UNBILLED_INFO_GROUPFILTER, and G_RETN_INVOICE_GROUPFILTER — each defines the grouping logic for one section of the report.
• Formula functions — CF_CURENCY_CODEFORMULA, CF_CC_PROJ_LABELFORMULA, C_INVPROC_CURR_TYPEFORMULA, C_CREDIT_MEMO_REASONFORMULA, C_UBR_UERFORMULA, C_UBR_UER_LABEL_P, and C_COMPANY_NAME_HEADER_P — compute derived display values used in the XML output.

Tables Accessed

The documented dependencies include both Oracle Applications foundation tables and Projects-specific tables:

• PA_IMPLEMENTATIONS — supplies implementation-level settings and business group context.
• PA_ORG_REPORTING_SESSIONS — provides the reporting session and organization hierarchy context.
• PA_PROJECTS and PA_PROJECTS_ALL — hold the project header information reported on.
• PA_PROJECT_TYPES_ALL — used to filter and describe project types.
• GL_SETS_OF_BOOKS, HR_ORGANIZATION_UNITS, PA_LOOKUPS, and FND_LOOKUPS/FND_LOOKUP_VALUES_VL — resolve set of books, organizations, and lookup meanings.
• PA_MULTI_CURRENCY, PA_MULTI_CURRENCY_TXN, PA_PROJECT_ROLE_TYPES, PA_PROJ_STATUSES_V, and PER_PEOPLE_F — supply currency, role, status, and person attributes.

Usage Notes

This package is invoked indirectly by the XML Publisher concurrent program associated with the PAXINGEN report. It is not referenced by any other database object and is not intended for direct calls from custom code. Administrators and developers encountering it should treat it as internal report infrastructure; customization is normally performed by modifying the underlying XML template or by extending the report's query, not by editing the package body. Because the package is documented as VALID in the APPS schema, it can be relied upon as part of the supported Projects reporting stack in both 12.1.1 and 12.2.2.