Search Results cf_salespersonformula

Overview

AR_ARXPDI_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Receivables "ARXPDI" XML Publisher (BI Publisher) concurrent program. The suffix "XMLP_PKG" follows the standard Oracle naming convention for generated packages that wrap a report's data model: an XML Publisher data template typically calls a corresponding package that retrieves the report data and returns it as XML. In Oracle EBS 12.1.1 and 12.2.2, these packages are embedded in the report definition and invoked by the XML Publisher engine when the associated concurrent program is submitted. The package status is VALID in the documented environment, confirming that it compiles and is registered correctly.

Key Procedures and Functions

The package exposes 33 documented procedures and functions. These fall into several logical categories:

• Report lifecycle routines — BEFOREREPORT and AFTERREPORT are standard XML Publisher package entry points executed at the start and end of report generation respectively. AFTERPFORM is a parameter-form (PFORM) callback invoked after the report parameter form is processed.
• Formula functions and constants — REPORT_NAMEFORMULA, C_TEMP_SALFORMULA, C_DATA_FOUNDFORMULA, and C_CUSTOM_CHECKFORMULA are used to compute report-level values, such as the report name, temporary salary values, data-found flags, and custom validation results, that the XML template references directly.
• Lookup and display helpers — GET_LOOKUP_MEANING resolves lookup codes to their descriptive meaning, while SET_DISPLAY_FOR_CORE and SET_DISPLAY_FOR_GOV control whether core or government-specific fields are displayed, allowing one report to serve multiple business configurations.
• Boilerplate and formatting — GET_BOILER_PLATES retrieves reusable boilerplate text (standard clauses, headers, or footers) for inclusion in the printed output.
• Conditional value formulas — INVOICE_NUMBER_CONSFORMULA, CF_ORDER_BYFORMULA, and CF_SALESPERSONFORMULA supply formatted invoice numbers, dynamic ORDER BY clauses, and salesperson values to the report query.
• Parameter and validation routines — ACCT_BAL_APROMPT_P, RP_OLD_CURR_P, RP_CURR_CHECK_P, RP_OLD_CUSTOMER_P, RP_CUST_CHECK_P, and RP_COMPANY_NAME_P handle prompting, retrieval, and validation of report parameters such as account balances, currency, customer, and company name.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS, accessed through an APPS synonym. This is the standard concurrent processing table, and the package reads it to identify the current request, retrieve request-level context, and drive conditional logic tied to the running concurrent program. No Receivables business tables are listed in the documented dependency set.

Usage Notes

AR_ARXPDI_XMLP_PKG is not intended for direct invocation from forms or custom PL/SQL. It is invoked indirectly by the XML Publisher engine when the associated ARXPDI concurrent program is run, with BEFOREREPORT and the various formula functions called during data model execution. Because the package is registered as an APPS object with no external references, customization should be performed through the report's XML template and parameter configuration rather than by modifying the package body. Direct changes to the package body are overwritten by patching and are not supported under the Oracle support policy.