Search Results cf_trx_date_lowformula

Overview

APPS.AR_ARBRATBR_XMLP_PKG is the generated PL/SQL package that backs the Oracle Receivables XML Publisher concurrent program commonly known as the Transaction Batch Report (report short name ARBRATBR). It is an Oracle Reports-to-XML-Publisher migration package, defined with AUTHID CURRENT_USER, and its internal header identifies the source file as ARBRATBRS.pls. In Oracle EBS 12.1.1 and 12.2.2 the package serves as the data and formatting engine for the batch report: it declares the report parameters, holds the global work variables produced by the Before Report trigger, resolves values from Receivables setup tables, and supplies column-level formula functions that format dates and amounts for the published output.

The package is classified as OTHER in ETRM, meaning it is not a public API; it is intended to be invoked only by the concurrent program and the XML Publisher template that depend on it. It is referenced by zero other packages, confirming its role as a terminal report implementation rather than a reusable library. The search term "cf_maturity_dateformula" corresponds directly to the function CF_MATURITY_DATEFORMULA, one of several CF_* formula functions that XML Publisher calls to render a formatted value for a report column.

Key Procedures and Functions

The package exposes 36 documented procedures and functions, comprising report parameter globals (P_*), computed globals (CP_*), report triggers, column formula functions, and return-value accessors. Notable entries include:

• BEFOREREPORT and AFTERREPORT — report-level triggers that initialize and finalize the report, populating the CP_* package globals before the data model executes.
• CF_MATURITY_DATEFORMULA — formats the maturity date of a transaction or receipt for display in the report output, applying the session-appropriate date format.
• CF_TRX_DATEFORMULA — formats the transaction date column.
• CF_SYSDATEFORMULA — returns the current system date in report format.
• CF_FUNC_AMT_ASSIGNEDFORMULA — converts the assigned amount into the functional currency using the supplied exchange rate.
• CF_REPORT_TITLEFORMULA — builds the report title string.
• CF_DUE_DATE_LOWFORMULA, CF_DUE_DATE_HIGHFORMULA, CF_TRX_DATE_LOWFORMULA, CF_TRX_DATE_HIGHFORMULA — render the low/high selection date ranges as display text.
• CF_ISSUE_DATEFORMULA — formats the batch issue date.
• CP_*_P accessor functions (CP_SOB_P, CP_PRECISION_P, CP_FUNC_CURR_P, CP_VERSION_P, CP_REQUEST_ID_P, CP_BATCH_NAME_P, CP_BATCH_STATUS_P, CP_DUE_DATE_LOW_P, and the remaining accessors) — expose the computed globals to subsequent report queries and template calls.

The declared globals include P_VERSION, P_BATCH, P_REQUEST_ID, P_SET_OF_BOOKS_ID and P_CONC_REQUEST_ID (input parameters), plus CP_SOB, CP_PRECISION, CP_FUNC_CURR, CP_VERSION, CP_REQUEST_ID, CP_BATCH_NAME, CP_BATCH_STATUS, the date range, transaction number range, payment method, issue date, customer class, category, name and number, location, bank name, transaction type, currency code and source globals used throughout the layout.

Tables Accessed

All table references are made through APPS synonyms. The package reads:

• AR_BR_TRX_BATCH_RPT — the primary report data source for transaction batch records.
• RA_BATCHES and RA_BATCH_SOURCES — batch header and source information used to resolve CP_BATCH_NAME and CP_BATCH_STATUS.
• AR_SELECTION_CRITERIA — the report selection criteria used to derive the due date, transaction date, transaction number and other range globals.
• AP_SYSTEM_PARAMETERS — organization and functional currency settings.
• AR_RECEIPT_METHODS — payment method descriptions for the payment method display.
• HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES and HZ_PARTIES — customer name, number, account, class, category and site/location information used in the customer columns.
• RA_CUST_TRX_TYPES — transaction type name resolution.

The package is essentially read-only with respect to these objects; it queries configuration and transactional data to populate the globals that the report template consumes.

Usage Notes

AR_ARBRATBR_XMLP_PKG is invoked exclusively through the Transaction Batch Report concurrent program registration in Oracle Receivables. The concurrent manager supplies the P_* parameters, executes BEFOREREPORT to populate the CP_* globals, runs the report query against AR_BR_TRX_BATCH_RPT, and invokes the CF_* formula functions and CP_*_P accessors as the XML Publisher template renders each column. It is not intended for direct invocation from Forms, workflow, or custom PL/SQL, and it is not a public API. Customizations should be limited to the underlying report definition and RTF template rather than modifications to this generated package, since the package is regenerated whenever the report definition is recompiled and any manual edits will be overwritten.