Search Results c_qty_ordered_dsp_p

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.

• BEFOREREPORT / AFTERREPORT — Standard Oracle Reports triggers executed at report start and completion, used to initialize and finalize the report environment and globals.
• BEFOREPFORM / AFTERPFORM — Parameter form triggers that run before and after the parameter form is processed, driving initialization of the concurrent request ID and derived parameter values.
• P_SOB_IDVALIDTRIGGER, P_USE_FUNCTIONAL_CURRENCYVALID, P_INTERFACE_LINE_CONTEXTVALIDT — Validation triggers that verify user-entered parameters, notably the set-of-books identifier, the functional currency flag, and the interface line context.
• C_USE_CURRENCYFORMULA, C_DATA_NOT_FOUNDFORMULA, RP_USE_FUNCTIONAL_CURRENCYFORM — Formula columns that determine currency display behavior and detect the no-data condition to control report messaging.
• C_QTY_ORDERED_P, C_QTY_SHIPPED_P, C_QTY_INVOICED_P — Summary functions populating the ordered, shipped, and invoiced quantity cells.
• C_QTY_SHIPPED_DSP_P, C_QTY_ORDERED_DSP_P, C_QTY_INVOICED_DSP_P — Display-formatting counterparts that render the quantity values as character strings.
• RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P — Accessor functions returning report header globals such as report name, subtitle, company name, and functional currency.

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.