Search Results build_ar_tax_lines

Overview

ARP_ETAX_RECURR_UTIL is a utility package body in the Oracle E-Business Suite Receivables (AR) module that supports recurring tax processing for eTax (Latin American localizations / global tax engine integration). The package populates the interface table ZX_TRX_HEADERS_GT (and related ZX tax interface structures) by extracting Receivables transaction data and transforming it into the format required by the E-Business Tax engine (EBTax), so that tax can be calculated consistently on recurring transactions. The header comment records the source as AREBTICB.pls, last updated in the 12.1.1 code line (120.20.12010000.6), and the package is classified as a UTIL-type object in ETRM 12.2.2 where it is owned by APPS.

In practical terms, the package acts as an intermediary layer between standard AR transaction tables and the Tax engine's generic interface tables. It reads customer, site, tax, and transaction attributes, assembles header and line records, invokes the tax calculation service, and writes back calculated tax lines. This allows tax to be applied on transactions that are created or regenerated through recurring/automatic processes without going through the standard Receivables Tax form.

Key Procedures and Functions

• INSERT_HEADER — Private procedure that inserts a transaction header row into ZX_TRX_HEADERS_GT. It derives organization, legal entity, ledger, entity/event class and event type codes, reporting flag, transaction identifiers and descriptive attributes, document sequence information, batch source, Receivables transaction type, transaction dates, bill-to customer account site use, currency, and accounting precision attributes from the AR transaction records.
• INSERT_LINE — Populates the corresponding line-level data required by the Tax engine, drawing from AR transaction lines. It provides the detail necessary to associate a tax result back to the specific invoice/memo line.
• CALCULATE_TAX — Invokes the E-Business Tax calculation for the staged header and line records, coordinating submission of the populated interface data so the tax engine can return computed tax amounts and related tax attributes.
• INSERT_TAX_LINES — Writes the calculated tax results back as tax lines. This is the procedure indirectly associated with the "build_ar_tax_lines" search term, as it assembles and inserts the resulting AR tax line records.

A private DEBUG helper writes messages to the concurrent request log when the AFLOG_ENABLED profile option is set, using the g_headers_inserted, g_lines_inserted, and g_tax_lines_inserted counters.

Tables Accessed

The package reads transaction, customer, and setup data, and writes to Tax interface and AR tax line tables. Via APPS synonyms it references: RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES (recurring transactions and their lines); AR_MEMO_LINES_B, AR_VAT_TAX, and AR_SYSTEM_PARAMETERS (Receivables tax and system defaults); FND_CURRENCIES, FND_DOCUMENT_SEQUENCES, and HR_ALL_ORGANIZATION_UNITS / PER_ALL_ASSIGNMENTS_F (currency, sequencing, and organization data); HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, and HZ_PARTY_SITES (customer and site information for tax determination); JTF_RS_SALESREPS (salesrep attribution); and RA_BATCH_SOURCES (batch source context). Output is directed to the ZX_* generic interface tables (ZX_TRX_HEADERS_GT and associated line/tax-line structures) for EBTax processing.

Usage Notes

ARP_ETAX_RECURR_UTIL is an internal helper package, referenced by zero other packages in the documented metadata, and is therefore not intended as a public API for custom development. It is invoked indirectly by the Receivables eTax recurring tax flow — typically from concurrent programs or forms that create or reprice recurring transactions and require tax recalculation. Custom code should avoid calling this package directly; instead, use supported EBTax public APIs (such as ZX_API_PUB or AR's tax calculation entry points). Developers troubleshooting "build_ar_tax_lines" behavior should treat INSERT_TAX_LINES and the header/line insert procedures as the internal building blocks that construct tax lines for recurring AR transactions.