Search Results insert_tax_lines




Overview
Explore in AI Chat

Overview

ARP_ETAX_RECURR_UTIL is an internal Oracle Receivables utility package (owner APPS, API classification UTIL) that supports recurring electronic tax (eTax) processing within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal business function is to populate the ebt GT interface tables consumed by AutoInvoice for tax calculation, and to generate the corresponding tax lines, headers, and line records required when recurring invoice or credit memo data is processed. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking schema rather than the defining schema. The header comment records creation on 28-FEB-2005 by MRAYMOND, with the shipped file identified as AREBTICS.pls version 120.0.12010000.2.

Key Procedures and Functions

The documented package exposes four procedures:

  • CALCULATE_TAX — Drives the tax calculation cycle for a given import job. It accepts a request identifier, an error count passed in and out with NOCOPY, and an output return status. This is the coordinating entry point around which the remaining procedures operate.
  • INSERT_TAX_LINES — The procedure most frequently referenced by developers searching for "insert_tax_lines." It creates the tax line records associated with a recurring transaction, correlating the original line, the newly created customer transaction, and the newly created line, all within the context of a specific import request.
  • INSERT_HEADER — Creates the transaction header record for a specified customer transaction identifier, establishing the parent record to which generated lines belong.
  • INSERT_LINE — Creates an individual transaction line, linking the original source line to the newly generated line identifier.

Additionally, the package source documents a procedure named POPULATE_EBT_GT, which populates the ebt GT tables used by AutoInvoice for tax calculations. Per the embedded description, it is called twice during a run — once for the INV phase and once for the CM (regular) phase.

Tables Accessed

Through APPS synonyms, the package references a broad set of Receivables, Oracle Trading Community Architecture, and HR tables. Core transaction and tax structures include RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_BATCH_SOURCES, AR_MEMO_LINES_B, and AR_VAT_TAX. Supporting reference data includes AR_SYSTEM_PARAMETERS, FND_CURRENCIES, and FND_DOCUMENT_SEQUENCES. Customer and party data is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, and HZ_PARTY_SITES. Organizational and personnel context is supplied by HR_ALL_ORGANIZATION_UNITS, JTF_RS_SALESREPS, and PER_ALL_ASSIGNMENTS_F. Collectively these accesses support header and line creation, tax determination, currency and document sequence handling, and the resolution of customer, site, organization, and salesperson attributes needed to build valid AutoInvoice tax records.

Usage Notes

ARP_ETAX_RECURR_UTIL is not a public, supported API. It is invoked internally by AutoInvoice-related processing, typically from concurrent program execution where a request identifier is available to scope the work. The POPULATE_EBT_GT logic is explicitly described as being called once per phase — INV and CM — reflecting the recurring nature of the processing. Because eTax functionality is a niche Receivables capability and the package carries no documented references from other packages in the ETRM metadata, custom code should treat it as an unsupported internal object. Developers encountering INSERT_TAX_LINES in trace files or custom extensions should note that its identifiers relate to a single recurring transaction and that it expects the header and line records to already exist before tax lines are inserted. Direct invocation is discouraged; supported integration should rely on the standard AutoInvoice interfaces.