Search Results lp_attribute




Overview
Explore in AI Chat

Overview

APPS.ONT_OEXDERUL_XMLP_PKG is the generated PL/SQL package that backs the Oracle Order Management seeded XML Publisher (BI Publisher) report commonly associated with the "Order Details / Order Line" extract family, identified internally by the report short name OEXDERUL. The package is a wrapper produced by the Oracle Reports-to-XML Publisher conversion utilities, and its structure follows the standard XMLP_PKG template used throughout Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve through the APPS schema under the privileges of the invoking user.

The business purpose is to supply runtime values to the report layout and to control report scheduling behavior. The package declares a battery of global variables — including P_CONC_REQUEST_ID, P_ORDER_BY, P_OBJECT, P_ATTRIBUTE, P_SOB_ID and a set of LP_ and RP_ prefixed variables — that carry concurrent request context and report parameter values between the Oracle Reports-compatible PL/SQL layer and the XML Publisher data definition. It is particularly relevant to attribute-driven extraction, since the user search term "lp_attribute" maps directly to LP_ATTRIBUTE VARCHAR2(200), a local package variable used to hold the attribute code selected at runtime.

Key Procedures and Functions

  • BEFOREREPORT — Standard entry point executed before the report body runs; initializes package state and report-level globals.
  • AFTERREPORT — Post-processing hook run after the report completes.
  • AFTERPFORM — Executes after the report parameter form is processed; used to derive working variables such as the LP_/WHERE clause constructs from user selections.
  • SOURCEVALUEFORMULA — Returns a CHAR value for a given source type, attribute code and source; used to resolve seeded attribute values for the layout.
  • RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_DATA_FOUND_P, RP_CONDITION_P, RP_OBJECT_P, RP_ATTRIBUTE_P, RP_SEEDED_P — Accessor functions that expose the corresponding RP_ globals (report name, subtitle, data-found indicator, condition, object, attribute and seeded flags) to the XML Publisher template.

The LP_ATTRIBUTE variable is populated during this flow and surfaced through RP_ATTRIBUTE_P.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS, accessed through APPS synonyms. This is used to read concurrent request context, principally to obtain the request ID and related runtime information stored in P_CONC_REQUEST_ID and to drive conditional logic in BEFOREREPORT and AFTERPFORM. The report's actual order data query is defined externally in the XML Publisher data template rather than inside this package.

Usage Notes

ONT_OEXDERUL_XMLP_PKG is invoked indirectly by the concurrent program definition that submits the OEXDERUL XML Publisher report. Submissions occur through the Standard Request Submission form or via FND_REQUEST.SUBMIT_REQUEST in custom code. The RP_ accessor functions are called by the layout template; the LP_ variables, including LP_ATTRIBUTE, are populated internally and should not be set directly. No other packages reference this package, so customization should be limited to extending the data template rather than modifying the generated package.