Search Results p_line_category

Overview

APPS.ONT_OEXOEUBK_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Order Management XML Publisher (BI Publisher) report OEXOEUBK, commonly identified as the Order Detail or Order/Line listing report used by the Order Management reporting family in Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates both the data-retrieval logic and the Data Template helper functions required by the XML Publisher report definition, and it executes in the APPS schema. It is classified in ETRM as an OTHER API, meaning it is not a public, supported programmatic interface but rather an internal implementation object tied to the concurrent report definition.

Its principal responsibility is to resolve display values for order and line attributes — most notably item identification, item description, order and line categories, currency, and company/operating unit context — and to expose those values to the XML template as bind parameters or formatted columns. The user search term p_line_category corresponds to one of the report parameters, whose display value is derived by the package rather than stored directly.

Key Procedures and Functions

The package exposes seventeen documented program units. The report-lifecycle entry points are BEFOREREPORT and AFTERREPORT, which initialize and finalize the report's global state and parameter values, and AFTERPFORM, which runs as an after-parameter-form trigger. P_ITEM_FLEX_CODEVALIDTRIGGER validates the key flexfield value passed for the item flexfield before the report executes.

Formula functions supply computed column values to the XML template. RP_ORDER_CATEGORYFORMULA derives the order category display, while RP_LINE_CATEGORYFORMULA derives the line category display — the function corresponding to the p_line_category attribute of the report. RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, and RP_FUNCTIONAL_CURRENCY_P are parameter getters that return report header values. RP_DATA_FOUND_P, RP_ITEM_FLEX_ALL_SEG_P, RP_PRINT_DESCRIPTION_P, and RP_DUMMY_ITEM_P are additional parameter accessors controlling report behavior and layout. C_MASTER_ORGFORMULA and C_PERIODICITY_DSPFORMULA are formula functions for the master organization and periodicity columns. ITEM_DSPFORMULA is the core item-resolution function; the header indicates it accepts the inventory item identifier, the item identifier type (internal versus customer item), the ordered item, organization context, and ordered item text, returning the formatted item string and description.

Tables Accessed

Table access is confined to reference and setup data, consistent with its role as a reporting helper. FND_CONCURRENT_REQUESTS and FND_CURRENCIES provide concurrent program context and functional currency information. Item data is read from MTL_CUSTOMER_ITEMS and MTL_CUSTOMER_ITEM_XREFS, which resolve customer item numbers and descriptions when the item identifier type is the customer variant. MTL_CROSS_REFERENCES and MTL_CROSS_REFERENCE_TYPES supply cross-reference values for item identification. DUAL serves as the standard single-row source for constant or formula expressions. The ITEM_DSPFORMULA source additionally joins MTL_SYSTEM_ITEMS_VL to retrieve concatenated item segments and descriptions.

Usage Notes

ONT_OEXOEUBK_XMLP_PKG is invoked exclusively through the XML Publisher concurrent program OEXOEUBK. It is not referenced by any other package, as confirmed by the ETRM dependency data (zero referencing packages), and it should not be called from custom code. The p_line_category parameter is resolved at run time through RP_LINE_CATEGORYFORMULA, so customization of line category display should be pursued in the report data template or query rather than by modifying this package. The header comment ($Header: OEXOEUBKB.pls 120.3 ... noship $) confirms the package is a non-shipped, generated artifact, reinforcing that it is regenerated from the report definition and may be overwritten during patching.