Search Results ont_oexoeasr_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.ONT_OEXOEASR_XMLP_PKG is a report-support package generated by Oracle Reports for the Oracle Order Management agreement/sales report commonly known as the Sales Agreements report (source file OEXOEASRS.pls, version 120.1, header dated 2007/12/25). It is declared AUTHID CURRENT_USER and is classified as an "OTHER" API, meaning it is not a public integration interface but an internal report driver package. Its business function is to assemble the runtime parameters, validation triggers, and summary calculations required by the XML Publisher/Reports Concurrent Program that prints sales agreements and their related order quantities. The package maintains a set of package-level globals — including P_CONC_REQUEST_ID, P_SOB_ID, agreement high/low bounds, customer name ranges, salesperson, and order number ranges — that are populated from the concurrent program parameter form and then consumed during report execution.

Key Procedures and Functions

The package exposes 33 documented procedures and functions organized into report life-cycle hooks, validation triggers, formulas, and column-level accessors.

The user-searched term "get_derive_type" does not appear among the documented members of this package; derivation of the agreement type is handled through the LP_AGREEMENT_TYPE and LP_AGREEMENT_TYPE_DSP globals rather than a dedicated get_derive_type routine.

Tables Accessed

The package references the following tables through APPS synonyms:

  • FND_CONCURRENT_REQUESTS — Read by the report/parameter form triggers to obtain the concurrent request context (P_CONC_REQUEST_ID), supporting the standard Oracle Reports integration with the concurrent manager.
  • FND_CURRENCIES — Read by the currency formula functions to resolve currency codes and determine whether functional-currency display is enabled.

These are the only documented table references; the substantive agreement and order data is retrieved by the report's underlying query rather than by the package itself.

Usage Notes

ONT_OEXOEASR_XMLP_PKG is invoked exclusively by the Oracle Reports runtime and by the Concurrent Program framework when the Sales Agreements report is submitted. It should not be called directly by custom code. The package is marked NOSHIP and is regenerated whenever the associated report definition (OEXOEASR) is modified, so customer extensions should avoid modifying it in place. Because it is AUTHID CURRENT_USER, it executes with the privileges of the calling APPS user; grants are therefore not required beyond the standard APPS schema setup. No other packages reference it, confirming its role as a leaf-level report driver.