Search Results l_order_type_high

Overview

The APPS.ONT_OEXWFASG_XMLP_PKG package body supports the Oracle Order Management Workflow Assignments Report, a concurrent-program report in the Oracle E-Business Suite Order-to-Cash (ONT) application. The package encapsulates the server-side PL/SQL logic that the Oracle Reports XML Publisher (XMLP) executable invokes at report runtime. It is classified under ETRM as an OTHER API type, meaning it is not a public integration API but rather an internal supporting package for the report's Before Report, After Report, and After Parameter Form triggers.

The package's primary responsibility is report initialization and parameter-driven query construction. It resolves the current concurrent request identifier, derives display values for report parameters, constructs the dynamic WHERE clause used to filter order transaction types, and populates global package variables used by the report layout. The header comment (OEXWFASGB.pls 120.1, dated 2007/12/25) indicates a stable, long-lived artifact consistent with both the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

• BEFOREREPORT — Executes prior to report data retrieval. It assigns the concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID, copies the order-type high and low values into display variables (L_ORDER_TYPE_HIGH_DISP, L_ORDER_TYPE_LOW_DISP), resolves the company name from the set of books, and derives the report name from the concurrent program definition. Legacy SRW.USER_EXIT('FND SRWINIT') calls are commented out in this XMLP variant.
• AFTERREPORT — Executes after report completion. It performs cleanup of report resources; the legacy FND SRWEXIT call is neutralized. Returns a Boolean indicating successful termination.
• AFTERPFORM — Executes after the parameter form is submitted. It builds the dynamic LP_WHERE_CLAUSE predicate when both P_ORDER_TYPE_LO and P_ORDER_TYPE_HI are non-null, restricting results to transaction types between the supplied range, and resolves the descriptive name of the low order type from OE_TRANSACTION_TYPES_TL.
• RP_REPORT_NAME_P — Returns the report name value (RP_REPORT_NAME) for use in the report header or layout.
• RP_COMPANY_NAME_P — Returns the company name value (RP_COMPANY_NAME), populated from GL_SETS_OF_BOOKS, for display in the report output.

Tables Accessed

• FND_CONCURRENT_REQUESTS — Joined with FND_CONCURRENT_PROGRAMS_VL in BEFOREREPORT to resolve the running report's concurrent program name for header display. Also references the request ID for parameter association.
• OE_TRANSACTION_TYPES_TL — Queried in AFTERPFORM using the low order-type value to retrieve the translatable name of the transaction type, which is displayed on the report and used to interpret the range filter (the metadata for p_order_type_hi relates to the P_ORDER_TYPE_HI parameter used in this predicate).
• GL_SETS_OF_BOOKS — Read in BEFOREREPORT to resolve the ledger/company name from the P_SOB_ID parameter for the report's organization header.

Usage Notes

This package is invoked exclusively through the Workflow Assignments Report concurrent program's XML Publisher report definition. It is not referenced by other packages (ETRM confirms zero dependent packages). The p_order_type_hi search term corresponds to the report parameter P_ORDER_TYPE_HI, which pairs with P_ORDER_TYPE_LO to constrain the report to a closed range of order transaction types via the dynamically assembled LP_WHERE_CLAUSE. Administrators should note that the package relies on commented-out SRW user exits, reflecting the migration from Oracle Reports to the XML Publisher integration path. Customizations should avoid modifying this seeded package directly; instead, use standard report parameter entry or a custom copy.