Search Results p_salesrep_low

Overview

The APPS.ONT_OEXOEOSR_XMLP_PKG package body is the generated PL/SQL package that backs the Oracle Order Management seeded concurrent program report OEXOEOSR (Order Source / Salesrep Order Detail Report). Its source header (OEXOEOSRB.pls 120.1, 2007/12/25) confirms it is a report XML Publisher (BI Publisher) support package, originally created for Oracle Reports and later converted to the XMLP architecture. The package exists purely to service the runtime data model of that concurrent report: it initialises session context, resolves descriptive lookup values, defines the report's formula columns and group-level summary calculations, and supplies the substitution values consumed by the report layout template.

In Oracle EBS 12.1.1 and 12.2.2 this object resides in the APPS schema and is classified as OTHER; it is not a published business API. It is created by the Order Management patch/installation driver and is regenerated whenever the underlying report definition changes. As with all _XMLP_PKG packages, the naming convention ties it to the concurrent program short name, and each invocation is scoped to a single concurrent request.

Key Procedures and Functions

The package contains 38 documented program units. The most significant are:

• BEFOREREPORT — the main initialisation routine. It captures the concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID, converts the order date low/high parameters to display format, reads the RECURRING_CHARGES system parameter through OE_SYS_PARAMETERS for the current operating unit, resolves the current org ID via MO_GLOBAL.GET_CURRENT_ORG_ID, and populates report-level variables such as company name, functional currency, order source name, and report name.
• AFTERREPORT and AFTERPFORM — post-report and post-parameter-form hooks used for cleanup and parameter form validation.
• RP_*_P functions — RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P, RP_DATA_FOUND_P, RP_ORDER_NUMBER_RANGE_P, and RP_SALESREP_RANGE_P. These supply the header, sub-title, and range-description text displayed on the report output. RP_SALESREP_RANGE_P in particular renders the resolved salesperson range associated with the p_salesrep_low and p_salesrep_high parameters.
• Formula functions — C_DATA_NOT_FOUNDFORMULA, RP_CURR_LABELFORMULA, C_ORDER_COUNTFORMULA, C_LINE_COUNTFORMULA, RP_USE_FUNCTIONAL_CURRENCYFORM, C_ORDER_AMOUNTFORMULA, C_LIST_AMOUNTFORMULA, C_SHIPPED_AMOUNTFORMULA, CF_1FORMULA, and C_CURRENCYFORMULA. These compute the currency label, conditional currency conversion flag, and the order, list, and shipped amount aggregates returned per data group.

Tables Accessed

The package reads the following APPS synonyms:

• FND_CONCURRENT_REQUESTS and the FND_CONCURRENT_PROGRAMS view — used to derive the report name from the current request.
• FND_CURRENCIES and GL_SETS_OF_BOOKS — joined to obtain the ledger name and functional currency for the reporting set of books.
• OE_ORDER_SOURCES — resolves the order source name from the P_ORDER_SOURCE parameter.
• OE_AGREEMENTS, OE_ORDER_LINES_ALL, and OE_TRANSACTION_TYPES_TL — supply the transactional order line, agreement, and translated transaction type data upon which the report query and its amount formulas operate.

No INSERT, UPDATE, or DELETE operations are documented; the package is strictly read-only against the transactional and reference tables.

Usage Notes

The package is invoked exclusively by the Order Management concurrent program via the XML Publisher / Oracle Reports runtime, never directly from a form or custom code. The BEFOREREPORT trigger fires once per request before the query executes, while the formula functions are evaluated per row or per group during output generation. Because the package is regenerated by patching, customisations should be applied to a copied report definition rather than to this APPS-owned package body. Note that if P_SOB_ID or P_CONC_REQUEST_ID is not populated, the internal NO_DATA_FOUND handlers silently leave report-level variables null, which manifests as blank header fields on the output rather than as a hard error.