Search Results po_poxrvrur_xmlp_pkg

Overview

PO_POXRVRUR_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its naming convention—combining the PO module prefix, the report short name POXRVRUR, and the _XMLP_PKG suffix—identifies it as the server-side package generated for an Oracle XML Publisher (BI Publisher) report within the Purchasing application. The "RVRUR" component corresponds to the Purchasing "Receiving Value by Receiving Location" style report layout, which is used by purchasing and receiving organizations to analyze the value of goods received across receiving locations and inventory organizations. The package provides the report's data logic and formatting hooks and is executed when the concurrent program that owns the report definition is run. Its ETRM status is VALID, confirming that the package compiles successfully and its dependencies are satisfied in the documented release (12.2.2).

Key Procedures and Functions

The package exposes six documented program units. These are the standard XML Publisher report lifecycle hooks, each invoked automatically by the report engine at a defined point during report execution:

• BEFOREREPORT — Executed once before the main report query is run. It is typically used to initialize package-level variables, derive runtime parameters, and set up any report-level context required by the data fetch.
• AFTERREPORT — Executed once after all report data has been processed. It is used to finalize report state, release resources, or perform any closing logic needed after the output has been generated.
• BEFOREPFORM — Executed before the report's parameter form is displayed. It prepares the parameter form, and is where defaults or validations that condition the parameter LOVs or prompt values are applied.
• AFTERPFORM — Executed after the parameter form is submitted. It captures and validates the user-entered parameter values before they are passed to the main report query.
• BETWEENPAGE — Executed at page boundaries during output generation. It is used for page-level formatting logic, such as repeating headers, subtotals, and page-break handling.
• GET_PRECISION — A helper function that returns the numeric precision used when formatting monetary or quantity values in the report output, ensuring consistent decimal presentation.

No parameter lists are documented in the ETRM metadata; the names and lifecycle roles above reflect the standard XML Publisher package contract.

Tables Accessed

The ETRM metadata for this package does not enumerate any base tables referenced through APPS synonyms. In practice, the underlying report query for a Purchasing receiving-value report would read receiving and receiving-transaction tables such as RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, joined to purchasing and inventory organization views to derive quantities, unit prices, and extended values by receiving location. Because the documented metadata does not list these as package-level dependencies, they should be confirmed against the report's data model and the dependent database objects rather than assumed.

Usage Notes

PO_POXRVRUR_XMLP_PKG is not intended for direct invocation by end users or custom code. It is executed indirectly by the XML Publisher concurrent program associated with the POXRVRUR report definition; the report engine calls BEFOREPFORM and AFTERPFORM during parameter entry, BEFOREREPORT before data retrieval, BETWEENPAGE during output formatting, and AFTERREPORT at completion. The package is referenced by no other documented packages and references only SYS.STANDARD, so it is effectively self-contained aside from the report definition that drives it. Customizations should be applied through the XML Publisher template and data definition rather than by modifying this generated package, since regenerating the report will overwrite package-level changes. Because it is a report-support package, it is not exposed as a public API and should be treated as internal to the Purchasing reporting infrastructure.