Search Results ont_oexoeccl_xmlp_pkg




Overview
Explore in AI Chat

Overview

ONT_OEXOECCL_XMLP_PKG is an Oracle Order Management report package body owned by APPS and classified as OTHER within the ETRM metadata model. Its name follows the standard Oracle Reports XML Publisher (XMLP) PL/SQL library convention: the embedded "XMLP" token indicates it backs a concurrent-program report definition generated from a Reports-to-XML Publisher migration, while the "OEXOECCL" stem identifies the underlying Order Management report. The body encapsulates the report's bind variables, lexical substitution clauses, and group-level formatting logic so that the Oracle Reports runtime (or the XML Publisher concurrent engine, depending on execution path) can invoke them at defined trigger points.

Functionally, the package supports the order hold or order header detail report in Order Management, allowing users to constrain results by customer name, customer number, order number, currency code, order type, and hold-applied date ranges. The p_item_flex_code search term that surfaces this object corresponds to the item key flexfield segment handling exposed through the package's item flex valid trigger and related item identifier functions.

Key Procedures and Functions

The documented interface comprises 22 procedures and functions. Predictable-format triggers include BEFOREREPORT, which initializes report-level state, and AFTERREPORT, which performs post-report cleanup and error trapping. AFTERPFORM is the core parameter-formatting trigger; the source excerpt shows it conditionally building lexical LP_ variables (for customer name, customer number, order number, currency code, hold-applied date range, and order type) from non-null user parameters, defaulting each to a space when unset.

Formula columns include C_DATA_NOT_FOUNDFORMULA and C_ADDRESSFORMULA, used to derive display values for the "no data found" indicator and address blocks. The P_ITEM_FLEX_CODEVALIDTRIGGER validates the item flexfield code parameter at runtime, tying directly to the user's search term. Item resolution is handled by INVENTORY_ITEM_ID_P, ORDERED_ITEM_P, and ORDERED_ITEM_ID_P.

Report metadata and profile values are exposed through RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P, RP_DATA_FOUND_P, RP_DATE_HOLD_APPLIED_RANGE_P, RP_SHIP_P, RP_ORDER_P, RP_VAT_PROFILE_P, RP_PRINT_DESCRIPTION_P, and RP_ITEM_FLEX_ALL_SEG_P, the last of which returns the concatenated item flexfield segments for display.

Tables Accessed

Usage Notes

The package is invoked exclusively as part of its parent Oracle Reports / XML Publisher concurrent program; it is not an API and is not referenced by any other PL/SQL package (referenced by 0 other packages per ETRM). Custom code should not call these functions directly. The correct extension point for adding item flexfield filtering is the P_ITEM_FLEX_CODE parameter and its validation trigger, propagated through RP_ITEM_FLEX_ALL_SEG_P. The header comment ($Header: OEXOECCLB.pls 120.2 2008/05/05) marks the file noship, indicating it is a development artifact shipped only as part of the compiled report object, consistent across 12.1.1 and 12.2.2.