Search Results lp_item_flex_all_seg

Overview

ONT_OEXOEORR_XMLP_PKG is the PL/SQL package specification that backs the Oracle Order Management concurrent program "Order Organizer Report" (short name OEXOEORR), an XML Publisher report in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package follows the standard Oracle Reports-to-XML Publisher migration pattern: it declares the report's concurrent program parameters, executes a BEFORE REPORT trigger, resolves lexical and value-set logic, and exposes getter functions that the XML template calls to render the report output. All objects reside in the APPS schema and are classified as OTHER in the ETRM metadata repository.

The parameter block covers the report's full input surface: order date low/high, sold-to and ship-to organization, order type, line type, item flexfield range, return reason, sort order, functional currency derived from SOB ID, and trace/description toggles. Character parameters used as flexfield or date range inputs, such as P_ITEM_FLEX_CODE and the CP_ORDER_DATE_LOW/HIGH character copies, are converted to their native DATE or segment forms in AFTERPFORM.

Key Procedures and Functions

• BEFOREREPORT — The report-level Before Report trigger. It initializes lexical globals (LP_ITEM_FLEX_CODE_LOW/HIGH, LP_ITEM_FLEX_ALL_SEG, LP_RETURN_REASON, LP_ORDER_DATE, LP_CREDIT_ORDER_TYPE, LP_CREDIT_ORDER_LINE_TYPE) and resolves reference data before the main query executes.
• AFTERPFORM — Fires after the parameter form is submitted; validates and converts character date inputs into P_ORDER_DATE_LOW and P_ORDER_DATE_HIGH, and derives SOB-related values.
• AFTERREPORT — Post-report cleanup trigger; releases report-level state and returns control to the concurrent manager.
• P_ITEM_FLEX_CODEVALIDTRIGGER — Validation trigger for the item flexfield parameter, confirming the entered value maps to a valid item flexfield segment.
• C_SET_LBLFORMULA, C_VALUEFORMULA, C_MASTER_ORGFORMULA — Format trigger helpers that populate label, value, and master organization display fields in the report header and item flex section.
• RP_*_P getter functions — Twenty functions (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, RP_ITEM_FLEX_ALL_SEG_WHERE_P, and their peers) exposed to the XML Publisher template. RP_ITEM_FLEX_CODE_P returns the flexfield concatenation string defaulted to 'SI.SEGMENT1'; RP_ITEM_FLEX_APROMPT_P and RP_ITEM_FLEX_LPROMPT_P return the application and descriptive flexfield prompts.

Tables Accessed

• FND_CONCURRENT_REQUESTS — Read to retrieve the concurrent request context for the running instance.
• FND_CURRENCIES — Supplies the functional currency name for the SOB ID.
• MTL_SYSTEM_ITEMS_KFV — Key flexfield view used to resolve item segment values for the flexfield range filter.
• MTL_CUSTOMER_ITEMS, MTL_CUSTOMER_ITEM_XREFS, MTL_CROSS_REFERENCES, MTL_CROSS_REFERENCE_TYPES — Cross-reference data supporting customer item and cross-reference number display on the report.
• OE_TRANSACTION_TYPES_TL — Translated order and line type names for the credit order type and line type parameters.

Usage Notes

This package is invoked exclusively by the Order Organizer Report concurrent program; no other package in the EBS codebase references it. Oracle Reports consumes the specification at runtime to run the Before Report, After Report, After P Form, and validation triggers, while the XML Publisher engine calls the RP_*_P functions during template rendering. The "noship" header indicates the file is not shipped as standalone code and is regenerated from the .rdf source during the standard build. Customizations should avoid direct calls to this package; the supported extension points are the underlying report parameters and the XML template, not the generated PL/SQL.