Search Results po_poxvdrvl_xmlp_pkg

Overview

APPS.PO_POXVDRVL_XMLP_PKG is a PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Purchasing module's vendor detail report. The package name follows Oracle's standard XML Publisher (BI Publisher) report integration convention: the "XMLP_PKG" suffix identifies packages generated to supply the data model and layout logic behind an XML Publisher concurrent program template. In EBS 12.1.1 and 12.2.2, the underlying object is classified as VALID and its API classification is OTHER, meaning it is not part of a published business API but is an internal report-support package restricted to the reporting framework.

Its primary role is to define the report query behavior, control the order-by clause of the extracted vendor data set, and execute the pre- and post-processing logic that wraps report execution. The package is only dependent on the SYS.STANDARD package, confirming that it is a lightweight, self-contained unit whose SQL parsing is handled by the report engine rather than by direct catalog dependencies.

Key Procedures and Functions

The ETRM documentation records three documented procedures or functions in this package:

• ORDERBY_CLAUSEFORMULA — Supplies the ORDER BY clause used by the report's main query when extracting vendor records. It allows the report to be sorted based on user-selected or parameter-driven sort criteria, ensuring the extracted XML data is presented in the expected sequence.
• BEFOREREPORT — A report trigger executed before the main data query is run. It is used to initialize package-level variables, derive report parameters, validate inputs, and prepare any global context required by the report's data model.
• AFTERREPORT — A post-report trigger invoked once data extraction has completed. It is used to release resources, reset package state, and perform any closing actions needed before control returns to the concurrent manager.

No parameter lists are documented in the metadata, and the naming pattern indicates these are the standard XML Publisher report hooks.

Tables Accessed

The ETRM extract for this object does not list any table references accessed via APPS synonyms, meaning the package's documented dependency set is limited to SYS.STANDARD. In practice, a vendor detail report support package of this type would query Purchasing and supplier master data such as PO_VENDORS, PO_VENDOR_SITES_ALL, and related address and contact tables through the report's SQL definition rather than through hard-coded references in the package. Where table access occurs, it is driven by the report data model that the package's triggers orchestrate.

Usage Notes

This package is invoked indirectly by the XML Publisher concurrent program associated with the vendor detail report. When the concurrent request is submitted, the Oracle reports/XML Publisher runtime calls BEFOREREPORT, executes the report query with the ORDER BY clause returned by ORDERBY_CLAUSEFORMULA, and finally calls AFTERREPORT to complete the request lifecycle. It is not intended to be called directly from Oracle Forms, custom PL/SQL, or any other application extension; it is referenced only by itself within the APPS schema and by the reporting engine.

Because the package is classified as OTHER and carries no published API surface, customizations or extensions should avoid direct calls or modifications. Any functional change, such as modifying sort behavior or adding report parameters, should be executed through the supported XML Publisher template and data model configuration, or by applying vendor patches, in order to preserve upgrade integrity across EBS 12.1.1 and 12.2.2.