Search Results lp_order_by

Overview

APPS.AR_ARXDIR_XMLP_PKG is the PL/SQL package generated by Oracle Reports for the Receivables Dunning Letter / Invoice Directory concurrent program (report template ARXDIR). Like all XML Publisher report packages in Oracle E-Business Suite 12.1.1 and 12.2.2, it is a report-side wrapper: it declares the report's bind parameters, holds local (LP_) placeholder variables that mirror those parameters for the report layout, exposes formula columns consumed by the RTF template, and provides the BEFORE/AFTER report and parameter-form triggers that the Reports runtime executes during a run. The package is authored with AUTHID CURRENT_USER, so all unqualified objects resolve through the APPS schema synonyms at run time.

The user's search term "lp_order_by" maps to the local variable LP_ORDER_BY, declared as VARCHAR2(900) with a default of a single space. It is the layout-facing counterpart of the bind parameter P_ORDER_BY (VARCHAR2(50)), which receives the user's "Order By" selection from the concurrent program parameter window. The package also carries a fix-era companion variable, P_ORDER_BY_T, added to handle the translated/derived ordering string. LP_ORDER_BY exists because the Order By parameter drives a dynamically constructed SQL sort clause used by the report query, and the report layout needs a printable representation of that clause. The 900-byte width reflects that the value is frequently a concatenation of several columns rather than a single token.

Key Procedures and Functions

• BEFOREREPORT — Standard report trigger that initializes package state, seeds the LP_ variables from the bind parameters (including LP_ORDER_BY from P_ORDER_BY), and prepares the query context. This is where the "Order By" value is normalized.
• AFTERPFORM — Fires after the parameter form is submitted; used to validate or transform parameter values, notably the order-by string, before the query executes.
• AFTERREPORT — Cleanup trigger executed at the end of report processing.
• REPORT_NAMEFORMULA — Returns the display name of the report for the layout header.
• C_DATA_NOT_FOUNDFORMULA — Supplies the "no data found" message text to the template.
• C_CUST_SUMMARY_LABELFORMULA and C_CURRENCY_SUMMARY_LABELFORMULA — Return the localized label text for the customer and currency summary sections.
• CONS_NUMBERFORMULA — Formats the consolidation / customer number value presented on the letter.
• RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_DATA_FOUND_P, RP_SUM_FOR_P — Template helper functions returning company name, report name, a data-found flag, and a summation helper value respectively.
• RPD_REPORT_TOTAL_INV_P, RPD_REPORT_TOTAL_BAL_P, RPD_REPORT_TOTAL_DISP_P — Return report-level totals for invoices, balances, and disputed amounts, used in the letter's summary block.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS, read via its APPS synonym to resolve the concurrent request context from P_CONC_REQUEST_ID. This is the standard mechanism by which the package retrieves run-time attributes such as the request's organization or the concurrent program context. All other data used by the report is retrieved by the report's own SQL query, not by this package directly.

Usage Notes

The package is never called by application forms or custom PL/SQL. It is invoked exclusively by the Oracle Reports runtime when the ARXDIR concurrent program is submitted, typically from the Receivables Collections workbench or the standard request submission flow. Because the package is regenerated whenever the report is recompiled, it should be treated as read-only; customizations belong in the report definition, not in the package body. The LP_ORDER_BY variable is relevant only at run time and cannot be set externally.