Search Results ont_oexoeosr_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.ONT_OEXOEOSR_XMLP_PKG is the PL/SQL package body generated by Oracle Reports for the XML Publisher/Oracle Reports concurrent program "Order Organizer Report" (report file OEXOEOSRS). It encapsulates all server-side logic that would otherwise reside in the report's formula columns, user parameters, and group filters. The package is part of the Oracle Order Management (ONT) module and provides a structured, database-resident implementation of the report's business rules, allowing the concurrent program to execute parameter validation and data formatting directly within the database.

The package exposes a large set of global PL/SQL variables and constants that map directly to the report's user parameters, such as P_ORDER_NUM_LOW, P_ORDER_NUM_HIGH, P_ORDER_TYPE_LOW, P_ORDER_TYPE_HIGH, P_CUSTOMER_NAME_LOW, P_CUSTOMER_NAME_HIGH, P_SALESREP_LOW, P_SALESREP_HIGH, and date range parameters. Additional lexicals such as LP_ORDER_NUM, LP_COUNTRY, LP_SALESREP, LP_CUSTOMER_NAME, and LP_ORDER_TYPE are used to hold display values tokenized into the report layout. The user search term "lp_order_num" corresponds to one of these lexical placeholders, which carries the formatted order number value rendered in the report output.

Key Procedures and Functions

The package documents 38 procedures and functions. The key processing units are:

Tables Accessed

The package queries the following tables through APPS synonyms:

  • FND_CONCURRENT_REQUESTS — resolves request context, such as the responsible application and user, from the concurrent request ID.
  • FND_CURRENCIES — supplies currency names, symbols, and formatting for the currency label and amount display columns.
  • OE_AGREEMENTS — provides agreement information associated with orders when the report includes agreement data.
  • OE_ORDER_LINES_ALL — the primary source of order line detail, including ordered, listed, and shipped amounts and quantities.
  • OE_ORDER_SOURCES — classifies the order source (for example, manual entry, EDI, or web) for the order source column.
  • OE_TRANSACTION_TYPES_TL — supplies translated transaction type names used in the order type parameter and display columns.

Usage Notes

ONT_OEXOEOSR_XMLP_PKG is invoked exclusively by the Order Organizer Report concurrent program through the Oracle Reports runtime. It is not intended for direct invocation by forms or custom PL/SQL. In Oracle EBS 12.1.1 and 12.2.2, the package is deployed in the APPS schema and is regenerated whenever the report definition is recompiled. The package is referenced by no other packages, confirming its role as a report-specific container. Customizations should avoid modifying the package directly, since changes are overwritten on regeneration; instead, report-level enhancements should be applied through the Oracle Reports source file OEXOEOSRS.rdf. The lexical "lp_order_num" is populated at runtime to render the order number in the report output and should not be manipulated outside the report execution context.