Search Results p_order_date_high

Overview

ONT_OEXOEORR_XMLP_PKG is the PL/SQL package body that backs the Oracle Order Management "Order Organizer Report" (short name OEXOEORR), a BI Publisher / XML Publisher concurrent program. It is an XMLP wrapper package generated by the Oracle Reports-to-XML Publisher conversion utilities, and its role is to expose report-level parameters, lexical bindings, and derived display values to the report template at runtime. The package runs in the APPS schema and is classified under the ETRM taxonomy as OTHER rather than as a public API.

The package is not a business-logic engine. It performs report initialization, resolves organization and item context, formats date range parameters for the report header, and resolves the report title, company name, and functional currency. The user search term p_order_date_low refers to a report parameter accepted by the concurrent program; the package converts it in BEFOREREPORT to the character form CP_ORDER_DATE_LOW using the DD-MON-YY mask so it can be displayed in the report layout.

Key Procedures and Functions

• BEFOREREPORT — The main before-report trigger. Captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, converts P_ORDER_DATE_LOW and P_ORDER_DATE_HIGH into CP_ORDER_DATE_LOW and CP_ORDER_DATE_HIGH, establishes the operating unit through MO_GLOBAL.GET_CURRENT_ORG_ID, resolves the item name from MTL_SYSTEM_ITEMS_KFV, and retrieves the set of books name and functional currency.
• AFTERREPORT — Post-processing hook invoked after the report completes.
• AFTERPFORM — Parameter form post-processing trigger.
• P_ITEM_FLEX_CODEVALIDTRIGGER — Validation trigger for the item flexfield parameter.
• C_SET_LBLFORMULA, C_VALUEFORMULA, C_MASTER_ORGFORMULA — Formula columns used to derive label, value, and master organization values in the report query.
• RP_*_P series — Accessor functions returning report-level values: RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P, RP_DATA_FOUND_P, RP_ITEM_FLEX_LPROMPT_P, RP_ITEM_FLEX_CODE_P, RP_ITEM_FLEX_APROMPT_P, RP_ORDER_DATE_RANGE_P, RP_ORDER_BY_P, RP_RETURN_REASON_P, RP_FLEX_OR_DESC_P, and RP_ITEM_FLEX_ALL_SEG_WHERE_P.

In total 26 documented units exist, twenty of which are named above; the remainder are supporting internal routines. No parameter lists are documented in the ETRM source, and none are reproduced here.

Tables Accessed

• FND_CURRENCIES and GL_SETS_OF_BOOKS — joined in BEFOREREPORT to obtain company name and functional currency for the report header.
• MTL_SYSTEM_ITEMS_KFV — resolves the concatenated segment description for the selected inventory item.
• MTL_CROSS_REFERENCES, MTL_CROSS_REFERENCE_TYPES, MTL_CUSTOMER_ITEMS, MTL_CUSTOMER_ITEM_XREFS — supply cross-reference and customer item information used by the report's item flexfield sections.
• OE_TRANSACTION_TYPES_TL — supplies translated transaction type descriptions.
• FND_CONCURRENT_REQUESTS — provides concurrent program context, including the program name resolved into L_REPORT_NAME.

All tables are referenced through APPS synonyms, consistent with the package's APPS schema ownership.

Usage Notes

ONT_OEXOEORR_XMLP_PKG is invoked exclusively by the Order Organizer Report concurrent program. Users do not call it from forms or custom code; the ETRM metadata records zero dependent packages. Customizations should target the underlying report definition or the concurrent program parameters (such as P_ORDER_DATE_LOW) rather than the generated package body, since it carries an Oracle noship header and is subject to regeneration. Supporting instances running Oracle EBS 12.1.1 and 12.2.2 rely on this package to populate XML tags consumed by the OEXOEORR template.