Search Results rp_dsp_sort_byformula

Overview

AR_ARXAPRMB_XMLP_PKG is the generated PL/SQL plugin package for the Oracle Receivables concurrent program report ARXAPRMB (Remittance Batch Report). In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (BI Publisher) concurrent programs are structured around a report-specific package that declares the report's bind parameters and implements the formula functions that Oracle Reports previously expressed in its layout triggers. This package provides the PL/SQL side of the report: the parameter variables populated by the concurrent manager, and the helper functions that format headings, titles, and display values as the report's data model is processed.

The business purpose is the printing and reconciliation of remittance batches created by AutoLockbox or manual remittance entry. Users run the report to review deposit numbers, remittance bank accounts, batch names, remittance methods, and remittance dates, and to select either a summary or detailed presentation of the remittance activity. The package coordinates those selections, resolves the sort order requested by the user, and drives the displayed status and amounts for each batch.

Key Procedures and Functions

• BEFOREREPORT — initialization logic executed before the report data model runs; sets up session and report context.
• AFTERREPORT — cleanup logic executed after the report completes.
• AFTERPFORM — runs after the parameter form values are accepted, allowing validation or defaulting of the user-entered parameters.
• REPORT_NAMEFORMULA — derives the report heading based on the company name supplied to it.
• SUB_TITLEFORMULA — builds the report subtitle, typically reflecting the selected remittance date range and sort order.
• RP_DSP_SORT_BYFORMULA — the function matching the search term "rp_dsp_sort_byformula". It returns the display text for the current sort-by selection, translating the internal value of P_SORT_BY into a user-readable label for the report header. The parameter defaults to 'REMITTANCE ACCOUNT', which is the standard sort criterion for this report.
• RP_DSP_STATUSFORMULA — returns the display string for the report status.
• AMOUNTFORMULA — returns the report amount for a batch, taking a status code and batch identifier as inputs.
• DISP_REMIT_METHODFORMULA — renders the remittance method (for example, the payment instrument type) for display.
• DISP_REMIT_ACCOUNTFORMULA — renders the remittance bank account for display.
• DISP_INC_FORMATTEDFORMULA — renders the "include formatted" indicator.
• DISP_SUM_OR_DETFORMULA — renders the summary-or-detailed selection.
• DET_BATCH_STATUSFORMULA — converts a stored batch status code into its descriptive text.
• RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_DATA_FOUND_P — accessor functions returning the current values of the corresponding report-level variables.

Tables Accessed

• AR_CASH_RECEIPTS — source of the remittance activity, including deposit number, remittance method, and bank account references.
• AR_CASH_RECEIPT_HISTORY — supplies batch status and status history used by DET_BATCH_STATUSFORMULA and AMOUNTFORMULA.
• CE_BANK_ACCOUNTS — resolves the remittance bank account and branch descriptive information.
• FND_CONCURRENT_REQUESTS — used to read concurrent request context, consistent with P_CONC_REQUEST_ID.

Usage Notes

The package is not called directly by application forms or by custom code. It is invoked by the concurrent manager when the ARXAPRMB report is submitted, at which point the parameter variables are populated and the formula functions are called by the report's data model and layout templates. No other packages reference it, so it should be treated as tightly coupled to the report definition; modifications belong in the report's supporting logic rather than in external callers. When diagnosing output problems, the functions of interest are those prefixed RP_DSP_, DISP_, and DET_, since these control what the user actually sees for sort order, status, remittance method, and batch status.