Search Results rp_order_number_p

Overview

ONT_OEXAUCRC_XMLP_PKG is an Oracle Application Object Library package owned by the APPS schema that backs the concurrent program "Credit Check Processor Report." The package name follows the standard Oracle E-Business Suite convention for XML Publisher report logic packages: the ONT prefix denotes Order Management, the OEXAUCRC stem identifies the executable, and the XMLP_PKG suffix indicates that the package supplies report-level parameters, functions, and layout bindings to the XML Publisher / BI Publisher engine. In EBS 12.1.1 and 12.2.2, this package operates strictly as a report wrapper. It does not expose a public API and is classified in the ETRM repository as OTHER, meaning it is not part of Oracle's published interface surface and should not be called directly by custom code.

The business purpose of the report is to present credit check results for sales orders. The package collects the concurrent program's input parameters, exposes global state for the report query, and returns report metadata such as the report title, operating unit, order type, and order number for the XML layout template. It is a "no ship" object (per its $Header comment dated 25 December 2007), but it remains present in supported 12.1.1 and 12.2.2 environments and continues to be referenced by the concurrent manager at runtime.

Key Procedures and Functions

Eight documented subprograms exist. BEFOREREPORT performs the pre-query setup required for the report, initializing the package-level state after the concurrent manager passes parameter values. AFTERREPORT performs post-query cleanup.

• RP_REPORT_NAME_P — returns the report title, initialized to 'Credit Check Processor Report'.
• RP_DATA_FOUND_P — returns a status string indicating whether the report query returned any rows, allowing the layout to render a "no data" message.
• RP_ORDER_TYPE_P — returns the transaction type value used to filter or label report output.
• RP_ORDER_BY_P — returns the effective ORDER BY clause, derived from P_ORDER_BY.
• RP_OPERATING_UNIT_P — returns the operating unit name associated with P_ORG_ID.
• RP_ORDER_NUMBER_P — returns the order number as a NUMBER; this is the function requested in the user's search term "rp_order_number_p" and is the documented accessor for order header identification in the report output.

Supporting parameters include P_ORDER_BY, P_HEADER_ID, P_PARTY_NAME_LOW/HIGH, P_ORG_ID, P_CUST_PROF_CLASS_LOW/HIGH, P_CUST_ACCT_NUMBER_LOW/HIGH, P_ORDER_DATE_LOW/HIGH (with character equivalents LP_ORDER_DATE_LOW and LP_ORDER_DATE_HIGH), and P_CONC_REQUEST_ID.

Tables Accessed

The ETRM metadata documents two tables accessed via APPS synonyms: OE_ORDER_HEADERS_ALL and OE_TRANSACTION_TYPES. OE_ORDER_HEADERS_ALL supplies order header data, including order number, order date, customer, and operating unit context; OE_TRANSACTION_TYPES provides the transaction type name and attributes used to classify and filter orders within the credit check report. The package itself does not contain the report SQL; the query is defined in the underlying report definition, while the package supplies the parameter values and accessor functions consumed by that query and the XML layout.

Usage Notes

ONT_OEXAUCRC_XMLP_PKG is invoked exclusively through the concurrent program framework. The concurrent manager calls BEFOREREPORT, executes the report query using the package globals, retrieves values through the RP_* accessor functions during XML template rendering, then calls AFTERREPORT. It is referenced by zero other packages, confirming its self-contained report-wrapper role.

Custom code should not call these functions directly. Integrations that require credit check data should use supported Order Management APIs or query OE_ORDER_HEADERS_ALL and OE_TRANSACTION_TYPES directly. The order number accessor RP_ORDER_NUMBER_P is meaningful only within an active concurrent program run, since it depends on package state populated at report startup.