Search Results installment_printing_pending_p

Overview

AR_RAXINVPR_XMLP_PKG is the packaged body that supports the Oracle Receivables Invoice Print Report, a standard concurrent program in Oracle E-Business Suite 12.1.1 and 12.2.2. The package belongs to the APPS schema and is compiled with AUTHID CURRENT_USER, meaning that its runtime execution resolves database objects and privileges under the calling user rather than the package owner. The report produces formatted invoice documents for printing or reprinting, and this package supplies the runtime logic that drives report parameters, the query predicates used to select invoices, and formatting values consumed by the XML Publisher template.

The metadata shows that the package declares a substantial set of public variables that hold report parameter values, including transaction number ranges, customer identifiers, invoice dates, installment numbers, and batch identifiers. Two large VARCHAR2 variables, p_where1 and p_where2, hold dynamically constructed WHERE clauses that join billing, customer, party, site, terms, and transaction type information. The phrase "a_bill" appears in these predicates as the alias for the billing-level table, tied to u_bill through the customer account site and site use identifiers. This package is fundamental to invoice presentation and is therefore referenced whenever the Invoice Print or Print Invoice concurrent program is run.

Key Procedures and Functions

ETRM documents seventeen procedures and functions in this package. These include lifecycle routines such as BEFOREREPORT, AFTERPFORM, and AFTERREPORT, which initialize parameters, process the parameter form, and perform cleanup or post-processing after the report executes. Data formatting helpers include INSTALLMENT_LAST_PRINT_DATEFOR, INSTALLMENT_PRINTING_PENDING_P, and D_AMOUNTFORMULA, which support installment display and monetary formatting within the output.

The remaining documented routines are accessors that return report parameter values: RP_DATA_FOUND_P, RP_COMPANY_NAME_P, RP_REPORT_NAME_P, PRINT_OPTION_P, TYPE_ID_P, CUSTOMER_ID_P, BATCH_ID_P, OPEN_INVOICES_P, INVOICE_DATES_P, INVOICE_NUMBERS_P, and FUNCTIONAL_CURRENCY_P. Together they expose the values entered or derived from the concurrent program parameter form, the operating unit name, and the reporting currency to the query and template layers. No parameter lists are documented in the supplied metadata, so the signatures are noted by purpose only.

Tables Accessed

The package reads from several APPS synonyms. AR_SYSTEM_PARAMETERS provides receivables system options used during report initialization. FND_CONCURRENT_REQUESTS supplies concurrent request context, including the request identifier referenced by RP_DATA_FOUND_P. HZ_CUST_ACCOUNTS and HZ_PARTIES provide customer account and party details used in the billing joins. RA_BATCHES supports batch-level selection and printing, while RA_CUST_TRX_TYPES supplies transaction type attributes such as the type code used in the DECODE against the INV/CM lookup.

Usage Notes

This package is invoked indirectly by the Receivables Invoice Print concurrent program rather than being called by application forms. It is also relevant in 12.2.2, where the same report is registered as part of the invoice delivery and print lifecycle. Because the package uses AUTHID CURRENT_USER, any custom callers must have appropriate grants on the underlying objects. Customization should be avoided; parameter and query behavior are driven by the standard report definition, and modifying the package body risks conflicts during patching.