Search Results p_order_type_low

Overview

The APPS.ONT_OEXOEUBD_XMLP_PKG package body implements the server-side PL/SQL logic for the Oracle Order Management "Order Exception / Created By" XML Publisher (BI Publisher) concurrent report, internally identified as report OEXOEUBD. Consistent with the XML Publisher concurrent program architecture in Oracle E-Business Suite 12.1.1 and 12.2.2, this package does not contain business data extraction logic itself; rather, it provides the parameter-token substitution, formatting helper functions, and report-level triggers that Oracle Reports and the XML Publisher engine call during program execution. Its primary responsibility is to translate user-entered concurrent request parameters — most notably a "created by" range and an order-date range — into dynamically generated SQL predicate fragments that are injected into the report's data model at runtime.

Key Procedures and Functions

Eighteen documented program units are exposed. The report-level triggers are BEFOREREPORT (performs initialization before the query executes) and AFTERREPORT (invoked at report termination, containing a user-exit cleanup block that is effectively a no-op but returns a BOOLEAN success flag). AFTERPFORM is the central parameter-processing routine: it resolves the "sort by" lookup value from OE_LOOKUPS into LP_ORDER_BY_MEAN, builds the ORDER BY clause (LP_ORDER_BY), and — critically for the searched term — constructs the LP_CREATED_BY predicate. When P_CREATED_BY_LOW alone is supplied, the fragment becomes and fu.user_name >= :P_created_by_low; when both P_CREATED_BY_LOW and P_CREATED_BY_HIGH are supplied, a BETWEEN predicate against fu.user_name is generated. The P_ITEM_FLEX_CODEVALIDTRIGGER function is a validation trigger stub that unconditionally returns TRUE.

The remaining functions are report formatting and lookup helpers: RP_ORDER_CATEGORYFORMULA and RP_LINE_CATEGORYFORMULA (category display), C_LINE_AMTFORMULA (line amount calculation), C_PRECISIONFORMULA (numeric rounding precision), C_RECUR_CHARGESFORMULA, RP_C_EXT_TOTAL_ROUNDED_P and RP_C_RECUR_CHARGE_ROUNDED_P (rounded extended and recurring charge values), 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, and RP_PRINT_DESCRIPTION_P.

Tables Accessed

The package references three APPS synonyms. OE_LOOKUPS is queried in AFTERPFORM to resolve the meaning of the selected sort option; a NO_DATA_FOUND handler falls back to echoing the raw parameter. FND_CONCURRENT_REQUESTS is used to establish concurrent request context (request ID, program name, and related attributes) for headers and subtitles. FND_CURRENCIES supplies functional currency information used by RP_FUNCTIONAL_CURRENCY_P and the rounding formulas. OE_TRANSACTION_TYPES_TL is referenced for translated order/transaction type descriptions used in reporting output.

Usage Notes

ONT_OEXOEUBD_XMLP_PKG is invoked indirectly by the XML Publisher concurrent program that executes the OEXOEUBD data template; end users never call it directly. At runtime the concurrent manager passes the request parameter values (P_CREATED_BY_LOW, P_CREATED_BY_HIGH, P_ORDER_DATE_LOW, P_ORDER_DATE_HIGH, P_ORDER_BY, and others) into the package, which then resolves tokens such as LP_CREATED_BY and LP_ORDER_DATE that the report query references. Because the source header dates to 2007 and carries the noship designation, this package should be treated as a seeded, Oracle-owned object in 12.1.1 and 12.2.2. No other packages depend on it, so it should not be extended or replaced by custom code; any customization belongs in a copy of the concurrent program and its underlying XML template.