Search Results po_poxrfrar_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PO_POXRFRAR_XMLP_PKG package body is the generated PL/SQL wrapper that supports the Oracle E-Business Suite concurrent program and its associated XML Publisher (BI Publisher) report template for Purchasing. In Oracle EBS 12.1.1 and 12.2.2, the _XMLP_PKG suffix is a standard convention used by the Oracle Reports-to-XML Publisher migration utilities: the package encapsulates the report's parameter processing, its "before report" and "after report" trigger logic, and the SQL data model that feeds the XML template. The underlying business function delivered by this object is the extraction of Purchasing document data (RFQ and related purchasing structures, inferred from the POXRFRAR naming and the GET_P_STRUCT_NUM function) into a structured XML output for formatted presentation and printing. From a technical standpoint, the package is a plumbing layer rather than a business-logic API: it is validated (Status: VALID), owned by APPS, classified as OTHER, and is not referenced by any other database object, confirming it is a top-level, self-contained report driver.

Key Procedures and Functions

Three documented program units are exposed by this package body:

  • BEFOREREPORT — The standard "Before Report" trigger implementation. It executes initialization logic prior to the report's main data query, typically resolving and validating runtime parameters, setting up internal state variables, and preparing any context required by the data model.
  • AFTERREPORT — The standard "After Report" trigger implementation. It executes cleanup and finalization logic after the main query has completed, such as releasing resources or performing post-extraction processing.
  • GET_P_STRUCT_NUM — A function that supplies the purchasing document structure number parameter used by the report. Its naming follows the Oracle XML Publisher convention of GET_<parameter>, making the internal parameter value available to the data model and template.

The metadata documents only names and broad roles; no parameter signatures are asserted here.

Tables Accessed

The ETRM dependency section records that PO_POXRFRAR_XMLP_PKG references the following through APPS synonyms:

  • MTL_DEFAULT_SETS_VIEW — An inventory defaulting view, consulted to derive default organization and attribute set values needed when assembling the report output.
  • PO_LOOKUP_CODES — The Purchasing lookup repository, read to translate coded values into their display meanings for the report.
  • PO_POXRFRAR_XMLP_PKG — A self-reference (recursive dependency), reflecting the package's own internal calls.
  • STANDARD — The Oracle-supplied STANDARD package in the SYS schema, providing base PL/SQL functions used in the wrapper logic.

Usage Notes

This package is designed to be invoked indirectly rather than called from custom code. It is executed by the Oracle XML Publisher engine when the associated concurrent program is run: the concurrent manager launches the report, the package's BEFOREREPORT initializes parameters, the generated data model query runs, and AFTERREPORT finalizes execution, after which the XML output is rendered against the RTF template. Because the object is not referenced by any other database object, it sits at the top of its dependency chain and should be modified only through the XML Publisher / Oracle Reports migration tooling to preserve the generated code contract. Direct invocation from forms or custom PL/SQL is not recommended, as the package assumes the report runtime context established by the concurrent program.