Search Results cf_sysdateformula

Overview

APPS.AR_ARBRRMBM_XMLP_PKG is the generated PL/SQL package that backs the Oracle Receivables XML Publisher (BI Publisher) concurrent report known internally as ARBRRMBM, the Automatic Remittance Batch Report / Remittance Batch Listing. In Oracle EBS 12.1.1 and 12.2.2 the XML Publisher report architecture separates the data model from the report layout: a PL/SQL package supplies the "before report," "after report," and "after parameter form" triggers along with the lexical and formula columns consumed by the RTF template. AR_ARBRRMBM_XMLP_PKG performs exactly that role. It declares the report's bind and parameter variables, derives display and lookup values through formula functions, and exposes the standard XML Publisher entry points so the report can be run from the Submit Request form or Scheduled Requests. Its header comment, dated 2007, identifies it as a shipped (noship-tagged) Oracle-owned object.

Key Procedures and Functions

The package publishes eighteen documented functions and procedures, all of which exist to populate the XML output and control report lifecycle.

• BEFOREREPORT — the Before Report trigger; performs report-level initialization before data extraction.
• AFTERREPORT — the After Report trigger; finalizes the report after data has been fetched.
• AFTERPFORM — the After Parameter Form trigger; executes after the concurrent program parameters are submitted, typically to validate or transform parameter values.
• REPORT_NAMEFORMULA — returns the report name, accepting a company name argument to resolve the header title.
• SUB_TITLEFORMULA — returns the report subtitle string displayed beneath the main heading.
• CF_SYSDATEFORMULA — the column formula returning the system date as a CHAR value; this is the specific function returned by the user's search term "cf_sysdateformula," and it supplies the run-date stamp printed on the report output.
• RP_DSP_SORT_BYFORMULA / RP_DSP_STATUSFORMULA — format the sort-by and status display values shown in the report layout.
• DISP_REMIT_METHODFORMULA / DISP_REMIT_ACCOUNTFORMULA / DISP_INC_FORMATTEDFORMULA / DISP_SUM_OR_DETFORMULA — return display labels for the remittance method, remittance bank account, the include-formatted indicator, and the summary-or-detailed selection respectively.
• DET_BATCH_STATUSFORMULA — returns the descriptive batch status for a supplied batch status code.
• DUMMY_CURRENCYFORMULA — resolves a currency code value passed from the data model.
• RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_SUB_TITLE_P, RP_DATA_FOUND_P — accessor functions returning the corresponding package globals to the layout.

Tables Accessed

Per the documented metadata, the only table accessed is CE_BANK_ACCOUNTS through an APPS synonym. The package uses it to validate and derive remittance bank account information, supporting the bank and bank account display columns and the remittance account lookup used by the report layout. The date range and deposit parameters are handled through package variables rather than further table references.

Usage Notes

The package is invoked indirectly whenever the Automatic Remittance Batch Report is submitted as a concurrent request. Oracle XML Publisher calls BEFOREREPORT, AFTERPFORM, and AFTERREPORT automatically, and resolves the column formulas (including CF_SYSDATEFORMULA) during XML rendering. It is referenced by no other PL/SQL package and holds no public API classification, so it should not be called directly from custom code. Customizations belong in the RTF template or a copy of the concurrent program definition, not in this Oracle-owned package.