Search Results p_salesrep_high

Overview

ONT_OEXOEIOS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that implements the server-side logic for the Order/Invoice Summary Report published through the XML Publisher (BI Publisher) concurrent program framework. In both Release 12.1.1 and 12.2.2 the package serves as the report logic container: it initializes the runtime environment, resolves report-level profile values, and supplies the formula and summary functions that the report layout invokes while generating output for a submitted concurrent request. It is classified as an OTHER API in the ETRM repository, meaning it is not part of Oracle's published, supported public interface and is regenerated by the XML Publisher report definition rather than maintained as a hand-coded integration point. The package reads transactional order and invoice data from Order Management and Receivables tables and presents aggregated order counts, line counts, ordered amounts, invoiced amounts, credit amounts, and balance-due figures for a selected range of customers, sales representatives, order types, and order numbers.

Key Procedures and Functions

• BEFOREREPORT — Executes before the report data model; assigns P_CONC_REQUEST_ID from FND_GLOBAL, obtains the current operating unit through MO_GLOBAL.GET_CURRENT_ORG_ID, derives the company name and functional currency from GL_SETS_OF_BOOKS and FND_CURRENCIES using P_SOB_ID, and resolves the concurrent program name into RP_REPORT_NAME.
• BEFOREPFORM and AFTERPFORM — Parameter form entry and exit triggers, used to prepare and validate the report parameters prior to submission.
• AFTERREPORT — Post-processing trigger executed once the report output has been produced.
• Formula functions — C_ORDER_COUNTFORMULA, C_LINE_COUNTFORMULA, C_COMPUTE_AMOUNTSFORMULA, C_ORDER_AMOUNTFORMULA, C_PRECISIONFORMULA, C_DATA_NOT_FOUNDFORMULA and RP_CURR_LABELFORMULA compute and format derived display values such as counts, amounts, currency labels and decimal precision, and control how missing data is rendered.
• Placeholder/parameter accessors — C_INV_ORDER_AMT_P, C_BALANCE_DUE_P, C_CREDIT_AMOUNT_P, C_AMOUNT_P, RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P, RP_USE_FUNCTIONAL_CURRENCYFORM and C_PRECISIONFORMULA expose report constants and user-entered parameter values to the layout template.

Tables Accessed

• FND_CONCURRENT_REQUESTS — read to identify the submitted request and its program definition for report name resolution.
• FND_CURRENCIES — joined to the set of books to confirm the functional currency code.
• OE_ORDER_LINES and OE_TRANSACTION_TYPES_TL — provide ordered line quantities, amounts and translated order type descriptions.
• RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL — supply invoice header and line information used to compute invoiced amounts and balances.
• AR_PAYMENT_SCHEDULES — provides payment schedule balances used for balance-due and credit calculations.

Usage Notes

The package is invoked indirectly through the Order/Invoice Summary Report concurrent program; it is not called from Oracle Forms or by other PL/SQL packages, as the ETRM metadata records zero referencing packages. The parameter P_SALESREP_HIGH, together with its low counterpart, delimits the sales representative range reported on. Because the package is regenerated from the XML Publisher data definition, customizations should be applied to the report definition or handled through concurrent program parameters rather than by editing the package body, which Oracle may overwrite during patching or upgrade. All queries execute under the APPS schema and rely on MO_GLOBAL for operating unit security context.