Search Results cp_version

Overview

AR_ARBRATBR_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Receivables AutoBatch Report (report short name ARBRATBR), an XML Publisher concurrent program output. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher (BI Publisher) concurrent programs are driven by a package automatically produced by the Oracle Reports-to-XML Publisher conversion utility. The package supplies the report's data model: it derives run-time parameters, executes the report's main queries, and exposes the values required by the report's RTF template.

The business function is to print batches created by the AutoBatch process together with their selection criteria, transaction attributes, and status. The package is not a general-purpose API; it exists specifically to satisfy a single concurrent program and is classified as OTHER in ETRM because it implements no public business interface.

The CF_TRX_DATEFORMULA function the user searched for is one of the package's XML Publisher formula columns. It returns a character representation of a transaction date for the report layout, following the same pattern as the other date formula functions in the package.

Key Procedures and Functions

The package exposes 36 documented procedures and functions, most of which are generated formula columns or cached parameter accessors.

• CF_MATURITY_DATEFORMULA — accepts a maturity date and returns it as a formatted character string via FND_DATE. Used to render the maturity date column in the report.
• CF_SYSDATEFORMULA — returns the current system date as a formatted character string.
• CF_TRX_DATEFORMULA — returns the transaction date as a formatted character string for the report output.
• CF_DUE_DATE_LOWFORMULA / CF_DUE_DATE_HIGHFORMULA — format the low and high due-date selection criteria into display strings.
• CF_TRX_DATE_LOWFORMULA / CF_TRX_DATE_HIGHFORMULA — format the low and high transaction-date selection criteria.
• CF_ISSUE_DATEFORMULA — formats the batch issue date.
• CF_FUNC_AMT_ASSIGNEDFORMULA — formats the functional amount assigned to the batch.
• CF_REPORT_TITLEFORMULA — builds the report title string shown in the layout.
• BEFOREREPORT — the before-report trigger. It initializes the concurrent request ID via FND_GLOBAL, retrieves precision, functional currency, and set of books name from AP_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, and FND_CURRENCIES_VL, sets the Summary/Detail version indicator from P_VERSION, resolves the prior request ID from AR_BR_TRX_BATCH_RPT when P_REQUEST_ID is null, and populates the CP_* cached values for batch name and status, due-date and transaction-date and transaction-number ranges, payment method, issue date, customer class and category, customer name, number, and location, bank name, transaction type, currency code, and batch source.
• AFTERREPORT — the after-report trigger that performs end-of-report cleanup for the concurrent request.
• CP_* accessor functions — CP_SOB_P, CP_PRECISION_P, CP_FUNC_CURR_P, CP_VERSION_P, CP_REQUEST_ID_P, CP_BATCH_NAME_P, and CP_BATCH_STATUS_P, among others, return cached report values to the layout without re-querying the database.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• AP_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, and FND_CURRENCIES_VL (via the BEFOREREPORT join) — supply precision, base currency code, and set of books name.
• AR_BR_TRX_BATCH_RPT — the AutoBatch report staging table; read to resolve the highest request ID for the given batch.
• RA_BATCHES and RA_BATCH_SOURCES — the batch header and source definition, providing batch name, status, issue date, currency, and source.
• AR_SELECTION_CRITERIA — the selection criteria rows that define the batch, providing due-date, transaction-date, and transaction-number low/high ranges.
• AR_RECEIPT_METHODS — payment method name.
• RA_CUST_TRX_TYPES — transaction type name.
• HZ_PARTIES, HZ_CUST_ACCOUNTS, and HZ_CUST_SITE_USES — customer name, account number, and site location.

All access is read-only; the package writes no data.

Usage Notes

AR_ARBRATBR_XMLP_PKG is invoked only through the AR AutoBatch Report concurrent program. The XML Publisher engine calls BEFOREREPORT, executes the data queries, invokes the CF_* formula functions for formatted columns, reads the CP_* accessor functions, and finally calls AFTERREPORT. The package is not referenced by any other package, so custom code should not call it directly; instead, callers should submit the concurrent program. Parameter P_VERSION controls whether the output is Summary or Detail, and P_REQUEST_ID optionally overrides the request ID otherwise derived from AR_BR_TRX_BATCH_RPT. Because the package is regenerated whenever the report definition changes, customizations should be placed in the RTF template or in a separate custom package rather than in this body.