Search Results c_remittance_batch_name_p
Overview
APPS.AR_ARZACS_XMLP_PKG is a PL/SQL package that supports the Oracle Receivables AutoClear Remittance Batch report (ARZACS), a concurrent program published through the XML Publisher reporting framework. Its principal business purpose is to automate the clearing of receipts remitted to the bank, releasing them from unapplied or unidentified status and matching them against corresponding bank charges, discounts, and remittance batch activity. The package encapsulates the report's parameter handling, its before-report and after-report logic, and a set of query helper functions that populate the lexical substitution variables and columns used by the XML Publisher data template.
The package is classified as OTHER in the ETRM metadata, indicating that it is not a public, supported API. It exists to serve a specific concurrent report rather than to provide reusable business logic to calling applications. It is owner-defined in the APPS schema and, per documented metadata, is not referenced by any other package.
Key Procedures and Functions
The package exposes 27 documented procedures and functions. The report lifecycle functions are BEFOREREPORT, AFTERREPORT, and BEFOREPFORM, which set up and tear down runtime state before and after report execution, together with AFTERPFORM, which runs after the report's parameter form is processed. The formula functions CF_TRANS_TYPEFORMULA and CF_BR_DATE_DISPFORMULA derive display values for transaction type and bank risk dates used in the report layout.
The remainder of the documented surface consists of paired package variables and their accessor functions. Each accessor, named with a trailing _P suffix, returns the corresponding package-level variable: C_REC1_P, FUNC_CURRENCY_CODE_P, COMPANY_NAME_P, C_NLS_YES_P, C_NLS_NO_P, C_PAYMENT_METHOD_NAME_P, C_REMITTANCE_BANK_ACC_NAME_P, and C_REMITTANCE_BATCH_NAME_P. The variable C_REMITTANCE_BATCH_NAME_P, which corresponds to the user's search term, exposes the remittance batch name assigned during parameter retrieval.
Business data retrieval is handled by GET_SET_OF_BOOKS, GET_PAYMENT_METHOD, GET_REMITTANCE_BANK_ACCOUNT, GET_BATCH_DETAILS, and GET_MAX_CHR. These functions resolve the ledger, receipt method, remittance bank account, and batch information required to drive the clearing logic and the report's output.
Tables Accessed
The package reads from seven Oracle Receivables and Treasury tables through APPS synonyms. AR_BATCHES and AR_CASH_RECEIPT_HISTORY supply batch and receipt history records used to identify which receipts are eligible for clearing. AR_RECEIPT_METHODS and CE_BANK_ACCOUNTS provide the payment method and remittance bank account definitions resolved by the lookup functions. AR_SYSTEM_PARAMETERS and GL_PERIOD_STATUSES establish accounting context, including the functional currency and open or closed period status. RA_CUST_TRX_TYPES is used to classify the transaction types appearing in the report.
Usage Notes
AR_ARZACS_XMLP_PKG is invoked indirectly by the AutoClear Remittance Batch concurrent program when the report is submitted from the Receipts workbench or the Standard Report Submission form. The report's parameter values, including remittance batch name, clearing date, bank account, and receipt number ranges, are bound to the package variables listed above before report execution begins.
Because the package is classified as OTHER and is not referenced by any other package, it should not be called directly from custom code. Customizations should instead target the underlying XML Publisher data template or the concurrent program definition. The package header carries a 2007 copyright and revision marker, reflecting its long-standing role in the Receivables clearing process across EBS 12.1.1 and 12.2.2.