Search Results rp_order_by_p

Overview

ONT_OEXAUCRC_XMLP_PKG is the packaged body that supports the Oracle Order Management credit check report (internally associated with the OEXAUCRC report definition). In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates the PL/SQL logic invoked by the Oracle Reports runtime during execution of the credit check concurrent program. Its principal responsibility is to gather and prepare report-level bind values—such as the operating unit name, order type, order number, and the meaning of the credit check processing rule selected at submission—and then delegate the substantive data retrieval to the credit check processor routine exposed by OE_CREDIT_CHECK_RPT.

Because the package is registered under the APPS schema and classified as OTHER in ETRM, it is not an open public API but rather an internal report-support package. It is tightly coupled to the OEXAUCRC report template and is executed solely in the context of that concurrent request.

Key Procedures and Functions

• BEFOREREPORT — Executes before the report body is generated. It captures the concurrent request ID via FND_GLOBAL, resolves descriptive values for the operating unit and order identifiers, and calls OE_CREDIT_CHECK_RPT.CREDIT_CHECK_PROCESSOR to populate the report data set.
• AFTERREPORT — Runs after report generation, providing the standard post-processing hook used for cleanup or finalization within the report lifecycle.
• RP_REPORT_NAME_P — Returns the report name value used by the report layout.
• RP_DATA_FOUND_P — Indicates whether qualifying credit check data was located for the requested parameters.
• RP_ORDER_TYPE_P — Returns the order type description resolved from OE_TRANSACTION_TYPES.
• RP_ORDER_BY_P — Returns the display meaning of the credit check process rule selected in the P_ORDER_BY parameter, resolved from the CREDIT_CHECK_PROCESS_RULE lookup.
• RP_OPERATING_UNIT_P — Returns the operating unit name corresponding to the submitted organization.
• RP_ORDER_NUMBER_P — Returns the order number associated with the submitted header identifier.

Tables Accessed

The package reads two documented tables through APPS synonyms:

• OE_ORDER_HEADERS_ALL — Queried by header ID to retrieve the order number (ORDER_NUMBER) for display on the report header.
• OE_TRANSACTION_TYPES — Joined to the order header via ORDER_TYPE_ID to obtain the transaction type name (OTT.NAME) used as the report's order type description.

In addition, supporting lookups and reference tables are consulted during the before-report phase, including HR_OPERATING_UNITS for the operating unit name and OE_LOOKUPS for the CREDIT_CHECK_PROCESS_RULE meaning mapped to the P_ORDER_BY parameter.

Usage Notes

ONT_OEXAUCRC_XMLP_PKG is invoked exclusively by the Oracle Reports engine when the credit check concurrent program is submitted. It is not referenced by any other documented package (ETRM records zero dependent packages), confirming its role as a terminal, report-specific artifact. The before-report trigger resolves display values and invokes the credit check processor; the parameter getter functions (RP_ORDER_BY_P, RP_OPERATING_UNIT_P, RP_ORDER_NUMBER_P, RP_ORDER_TYPE_P, RP_REPORT_NAME_P, RP_DATA_FOUND_P) supply bind values to the report template.

When troubleshooting the report—particularly when a user searches for the parameter RP_ORDER_BY_P—the relevant logic is the lookup resolution performed in BEFOREREPORT, where P_ORDER_BY is translated against the CREDIT_CHECK_PROCESS_RULE lookup type. Customizations should not modify this package directly; a cloned report definition should be used, since patching in 12.1.1 and 12.2.2 will overwrite file-based changes.