Search Results ont_oexoeorr_xmlp_pkg




Overview
Explore in AI Chat

Overview

ONT_OEXOEORR_XMLP_PKG is the PL/SQL package specification that backs the Oracle Order Management concurrent program "Order Organizer Report" (short name OEXOEORR), an XML Publisher report in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package follows the standard Oracle Reports-to-XML Publisher migration pattern: it declares the report's concurrent program parameters, executes a BEFORE REPORT trigger, resolves lexical and value-set logic, and exposes getter functions that the XML template calls to render the report output. All objects reside in the APPS schema and are classified as OTHER in the ETRM metadata repository.

The parameter block covers the report's full input surface: order date low/high, sold-to and ship-to organization, order type, line type, item flexfield range, return reason, sort order, functional currency derived from SOB ID, and trace/description toggles. Character parameters used as flexfield or date range inputs, such as P_ITEM_FLEX_CODE and the CP_ORDER_DATE_LOW/HIGH character copies, are converted to their native DATE or segment forms in AFTERPFORM.

Key Procedures and Functions

Tables Accessed

Usage Notes

This package is invoked exclusively by the Order Organizer Report concurrent program; no other package in the EBS codebase references it. Oracle Reports consumes the specification at runtime to run the Before Report, After Report, After P Form, and validation triggers, while the XML Publisher engine calls the RP_*_P functions during template rendering. The "noship" header indicates the file is not shipped as standalone code and is regenerated from the .rdf source during the standard build. Customizations should avoid direct calls to this package; the supported extension points are the underlying report parameters and the XML template, not the generated PL/SQL.