Search Results nls_yes1formula

Overview

APPS.AR_ARXCCP_XMLP_PKG is the Oracle Reports PL/SQL library package associated with the Receivables customer report commonly identified as the Customer Report or Customer Listing (report short name ARXCCP). The package is declared with AUTHID CURRENT_USER and its source header identifies it as a Receivables (AR) object maintained under the ARXCCPS.pls script. Its principal business role is to supply the bind and lexical parameters, translated display literals, report title, and sorting behavior required by the underlying XML Publisher or Oracle Reports definition to produce a listing of customers over a selected customer number range.

The package stores the report's selection and formatting parameters as package-level variables, including the set of books identifier, low and high customer number range, the concurrent request identifier, two sort keys, a phonetics sort indicator, the report name, and the localized "Yes"/"No" strings. It exists primarily to bridge the concurrent program parameter form and report layout: the parameters are populated at runtime, then read by report queries and formulas.

Key Procedures and Functions

The documented API surface comprises eleven members grouped as follows.

• NLS_YES1FORMULA and NLS_YESFORMULA — formula functions returning the localized affirmative text. They exist in pairs because the character-mode and bitmap report layouts, and separate layout sections within a single report, require independent formula columns that each evaluate the same translated value.
• NLS_NO1FORMULA and NLS_NOFORMULA — the mirrored pair returning the localized negative text. These functions are the object family most directly associated with the search term "nls_no1formula," which corresponds to the second of the two "No" formulas.
• REPORT_NAMEFORMULA — returns the display title of the report for use in the report header.
• BEFOREREPORT and AFTERREPORT — the standard Oracle Reports format triggers. BeforeReport typically performs validation and initialization, including invocation of the sort-order logic; AfterReport performs any end-of-run cleanup. Both return a boolean indicating success.
• NLS_YES_P, NLS_NO_P, and RP_REPORT_NAME_P — accessor functions that expose the package variables NLS_YES, NLS_NO, and RP_REPORT_NAME respectively to the report definition.
• SET_SORT_ORDER — a procedure that resolves the P_SORT1 and P_SORT2 parameter values into the effective ORDER BY clause applied to the customer listing.

The package also declares public variables for CUST_DEFAULT, P_SET_OF_BOOKS_ID, P_LOW_CUST_NUM, P_HIGH_CUST_NUM, P_CONC_REQUEST_ID, P_SORT1, SORT_BY_PHONETICS, P_SORT2, NLS_YES, NLS_NO, and RP_REPORT_NAME.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS, accessed through an APPS synonym. This is used to correlate the run with its concurrent request context, including the request identifier held in P_CONC_REQUEST_ID, so that the report can behave consistently with the concurrent manager's execution record. The customer data returned by the report is supplied by the report's own query, not by this package directly; the package contributes predicates and ordering through its parameters.

Usage Notes

AR_ARXCCP_XMLP_PKG is not a general-purpose API. It is invoked implicitly by the Receivables customer concurrent program when the associated report is run from the Submit Requests form, and its format triggers are executed by the Reports runtime at the defined report events. The NLS formula functions are referenced by the report layout, and Set_Sort_Order is called during BeforeReport. The package is referenced by zero other packages, confirming that it is a leaf-level report support object rather than a shared library. Customizations should be limited to extending or wrapping the report definition, since modifying the seeded package body can affect the standard customer listing output and is not supported.