Search Results ont_oexoeocs_xmlp_pkg




Overview
Explore in AI Chat

Overview

ONT_OEXOEOCS_XMLP_PKG is an Oracle E-Business Suite package owned by the APPS schema in Release 12.1.1 and 12.2.2. It is the generated PL/SQL package body that backs the Oracle Order Management seeded report commonly identified as the Order Organizer / order detail listing output (the "OEXOEOCS" report). Rather than performing core transactional work, the package acts as the report-driving layer for an Oracle Reports / XML Publisher concurrent program. It declares the report parameters, the global variables used to hold derived values, and the formatting and validation routines that Oracle Reports invokes at runtime.

The package is classified as OTHER in the ETRM metadata and is not referenced by any other packages, confirming that it is an entry-point artifact bound directly to a concurrent program rather than a reusable API. Its naming convention (the XMLP_PKG suffix) reflects the Oracle Reports to XML Publisher conversion where the report's PL/SQL logic is extracted into a package.

Key Procedures and Functions

The package exposes 42 documented routines. The primary lifecycle entry points are BEFOREREPORT and AFTERREPORT, which bracket report execution and initialize parameter defaults and clean up state respectively. Supporting before/after logic includes AFTERPFORM, which runs after the report parameter form is submitted, and the validation triggers P_ITEM_FLEX_CODEVALIDTRIGGER and P_USE_FUNCTIONAL_CURRENCYVALID, which enforce consistency of the item-flex and functional-currency parameter selections.

The remaining routines fall into two groups. Formatting "formula" functions return display-ready values to the report layout: C_SET_LBLFORMULA, ITEM_DSPFORMULA, C_GL_CONV_RATEFORMULA, C_AMOUNTFORMULA, C_CURRENCY_CODEFORMULA, RP_ORDER_CATEGORYFORMULA, RP_LINE_CATEGORYFORMULA, CF_UNIT4FORMULA, CF_UNIT3FORMULA, and the c_precisionformula referenced by the search. C_PRECISIONFORMULA governs numeric precision (currency and quantity rounding) applied to the report's numeric columns, and is closely tied to the P_MIXED_PRECISION parameter declared in the specification. Group procedures such as RP_DUMMY_ITEM_P, RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, and RP_FUNCTIONAL_CURRENCY_P populate header and title globals displayed at the top of the report. No parameter lists are documented, so their signatures should be confirmed against the deployed source.

Tables Accessed

The package reads reference and setup data through APPS synonyms: FND_CONCURRENT_REQUESTS for concurrent request context; FND_CURRENCIES and DUAL for currency code and dual-purpose conversions; MTL_CROSS_REFERENCES, MTL_CROSS_REFERENCE_TYPES, MTL_CUSTOMER_ITEMS, MTL_CUSTOMER_ITEM_XREFS, and MTL_SYSTEM_ITEMS_KFV to resolve customer item numbers, cross-reference types, and item descriptions against the item master key flexfield view. These tables support the item-flex and description display logic driven by the P_ITEM_FLEX_CODE and P_PRINT_DESCRIPTION parameters.

Usage Notes

ONT_OEXOEOCS_XMLP_PKG is invoked exclusively through its associated concurrent program; it is not intended for direct call from forms or custom code. Because C_PRECISIONFORMULA and the other formulas are called by the report layout, customization should be limited to the concurrent program's parameters and to the report template, not to the package body, as the package is regenerated from the Oracle Reports definition. Any modification risks being overwritten during patching.