Search Results lp_created_by

Overview

ONT_OEXOEUBD_XMLP_PKG is an Oracle E-Business Suite Order Management report package that encapsulates the PL/SQL logic supporting the XML Publisher concurrent program "Order Organizer" style detail report, internally identified as OEXOEUBD. The package is owned by APPS and registered with an API classification of OTHER in ETRM 12.2.2. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema and relies on APPS synonyms for all referenced data dictionary and application tables.

The business purpose of the package is to gather, filter, format and expose report parameters for an Order Information portal report that lists order headers and lines with return, header and line detail. It encapsulates parameter handling such as order type, order category, line category, manager, created-by, order date range, and print description, and it prepares derived display values used by the XML Publisher template. The user search term lp_order_type corresponds directly to the package-level variable LP_ORDER_TYPE, a VARCHAR2(1000) bind used to render the formatted order type range in the report output.

Key Procedures and Functions

The documented package contains the following entry points and helper programs:

• BEFOREREPORT — Executes at report runtime before the data model query fires; initialises session and parameter state required for the report.
• AFTERPFORM — Executes after the parameter form is submitted; used to post-process and validate user-entered parameter values.
• AFTERREPORT — Executes after the report data is generated; typically used to clean up package state and release resources.
• P_ITEM_FLEX_CODEVALIDTRIGGER — Validation trigger for the item flex code parameter, ensuring the supplied flexfield value is valid before report execution.
• RP_ORDER_CATEGORYFORMULA, RP_LINE_CATEGORYFORMULA — Formula functions that derive the formatted display value for order category and line category respectively.
• C_LINE_AMTFORMULA, C_PRECISIONFORMULA, C_RECUR_CHARGESFORMULA — Numeric formula functions that compute line amount, currency precision and recurring charge display values for the report output.
• RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_COMPANY_NAME_P, RP_FUNCTIONAL_CURRENCY_P, RP_DATA_FOUND_P, RP_ITEM_FLEX_ALL_SEG_P, RP_PRINT_DESCRIPTION_P, RP_C_EXT_TOTAL_ROUNDED_P, RP_C_RECUR_CHARGE_ROUNDED_P — Accessor procedures that publish the corresponding RP_* global values to the XML Publisher report template.

Tables Accessed

The package references three documented base objects through APPS synonyms:

• FND_CONCURRENT_REQUESTS — Read to obtain the concurrent request identifier (P_CONC_REQUEST_ID) and related execution context for the running report.
• FND_CURRENCIES — Read to resolve currency precision and functional currency information used by the precision and rounding formula functions.
• OE_TRANSACTION_TYPES_TL — Read to translate and resolve order transaction type descriptions used by the order type parameter and LP_ORDER_TYPE display variable.

Additional globals such as P_SOB_ID, P_ORGANIZATION_ID, P_ORDER_DATE_LOW, P_ORDER_DATE_HIGH and P_ORDER_TYPE_LOW/HIGH are populated from the concurrent program parameter set and are not sourced from the three documented tables.

Usage Notes

ONT_OEXOEUBD_XMLP_PKG is invoked exclusively by the concurrent program that hosts the OEXOEUBD XML Publisher report; it is not referenced by any other PL/SQL package per ETRM metadata. The package is registered as an API classification of OTHER, so it is not part of the public Order Management API surface and should not be called from custom code. Substitution variables such as LP_ORDER_TYPE, LP_CREATED_BY, LP_ORDER_DATE, LP_MANAGER, LP_ORDER_CATEGORY and LP_LINE_CATEGORY are defined among the package globals and are intended for consumption by the associated RTF or eText template rather than by external callers.

In both 12.1.1 and 12.2.2 the package resides in the APPS schema and relies on AUTHID CURRENT_USER and APPS synonyms, so any changes to the underlying table synonyms or to the concurrent program definition can affect its behaviour. The header comment references OEXOEUBDS.pls at version 120.1 (2007/12/25), indicating the file has remained stable across releases and is treated as a report-specific support package rather than a versioned business API.