Search Results sort_by_phonetics

Overview

AR_ARXCCP_XMLP_PKG is an Oracle EBS PL/SQL package body owned by APPS that provides the server-side logic behind the Receivables concurrent report program associated with the ARXCCP (Receivables report) library. It belongs to the XML Publisher/Reports 6i generated package family, where each concurrent report is bound to a compiled .plx/.pll library that exposes formula columns and report triggers through PL/SQL functions. The package encapsulates the report's before-report and after-report processing, resolves user-facing terminology from Oracle lookups, determines the report name at runtime, and applies the report's sort ordering — notably the component driven by the user search term "p_sort2". Because it is a report-support package rather than a public API, its primary business function is to supply dynamic, NLS-aware and instance-aware values to the report layout while remaining invisible to end users.

Key Procedures and Functions

• BEFOREREPORT — Core initialization trigger. Populates P_CONC_REQUEST_ID from FND_GLOBAL.conc_request_id, invokes Set_Sort_Order, and returns TRUE to allow the report to execute. This is where sort order from the parameter (including the p_sort2 selection) is resolved.
• AFTERREPORT — Closure trigger executed once the report completes; returns TRUE. In the original Reports form it replaced the SRW.SRWEXIT user exit.
• SET_SORT_ORDER — Translates the runtime sort parameters (p_sort1/p_sort2 and related flags) into an ORDER BY representation used by the report query. This is the object most directly relevant to the "p_sort2" search and is therefore the reported sortable field driver.
• REPORT_NAMEFORMULA — Returns the concurrent program name by querying FND_CONCURRENT_PROGRAMS_VL joined to FND_CONCURRENT_REQUESTS on the current P_CONC_REQUEST_ID; assigns the value to the RP_REPORT_NAME global/parameter.
• NLS_YES1FORMULA, NLS_YESFORMULA, NLS_NO1FORMULA, NLS_NOFORMULA — Resolve Yes/No display strings by reading the YES/NO lookup meanings from AR_LOOKUPS for codes Y and N, ensuring the report honors the session's language.
• NLS_YES_P, NLS_NO_P, RP_REPORT_NAME_P — Parameter/placeholder accessors that expose the resolved NLS_YES, nls_no and RP_Report_name values back to the report definition.

Tables Accessed

Two reference data sources are documented. FND_CONCURRENT_REQUESTS is queried (via the APPS synonym) to identify the current concurrent request and thereby derive the concurrent program application and program identifiers; this drives REPORT_NAMEFORMULA. AR_LOOKUPS is queried via dynamic SQL to obtain the Yes/No lookup meanings used by the NLS formula functions. No application transaction tables (such as AR_CASH_RECEIPTS or RA_CUSTOMER_TRX_ALL) are referenced inside this package; the report's data extraction SQL resides in the report definition itself rather than in this PL/SQL body.

Usage Notes

AR_ARXCCP_XMLP_PKG is invoked exclusively through its bound Oracle Reports concurrent program: the Reports engine calls BeforeReport when the program is submitted, executes the layout and queries, then calls AfterReport. It is not referenced by any other PL/SQL package (0 referrers documented), so direct calls from custom code are not expected or supported. The package is version-stamped from the 2007 ARXCCPB.pls source and remains valid under EBS 12.1.1 and 12.2.2, where FND_GLOBAL.conc_request_id and FND_CONCURRENT_PROGRAMS_VL continue to provide request and program context. Because the sort parameters, including p_sort2, are evaluated at BeforeReport time through Set_Sort_Order, changing the concurrent program's sort parameter at submission is the supported way to control report ordering.