Search Results before_delete_line

Overview

ARP_ETAX_SERVICES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the core tax calculation and tax-line maintenance services for Oracle Receivables. In the context of EBS 12.1.1 and 12.2.2, it supports the E-Business Tax (EBTax) integration by allowing Receivables transaction lines to be evaluated, taxed, overridden, and reconciled against tax rules configured in the E-Business Tax repository. The package bridges AutoInvoice and manual transaction entry by calculating tax amounts, populating EBT tax determination results, and maintaining the tax flags and factor data associated with customer transaction lines.

The object is classified as OTHER in the ETRM metadata, indicating that it is an internal service package rather than a public, fully documented API. It is marked VALID in the APPS schema and is referenced by eight other packages, confirming its role as a shared utility within the Receivables tax-processing stack.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. The principal entry point is CALCULATE, which drives the overall tax computation, supported by CALCULATE_TAX for the underlying tax determination and amount derivation. POPULATE_EBT_PLSQL_TABLES loads the E-Business Tax PL/SQL collection structures used during calculation.

• SET_LINE_FLAGS — updates tax-related indicator flags on transaction lines.
• DELETE_TAX_F_CTL_ID — removes the tax control identifier association from a line.
• MARK_TAX_LINES_DELETED — flags tax lines as logically deleted.
• BEFORE_UPDATE_LINE / BEFORE_DELETE_LINE — maintain tax data integrity during line DML.
• PRINT_EBT_PLSQL_VARS — diagnostic output of EBT PL/SQL variables.
• LINE_DET_FACTORS / HEADER_DET_FACTORS — derive tax determination factors at line and header levels.
• GET_TAX_ACTION — returns the applicable tax action for a transaction.
• OVERRIDE_TAX_LINES — applies manual tax overrides.
• IS_TAX_UPDATE_ALLOWED — validates whether tax may be updated for a line.
• VALIDATE_FOR_TAX — performs pre-tax validation checks.
• UPDATE_EXCHANGE_INFO — refreshes currency exchange information.
• COPY_INV_TAX_DISTS — copies invoice tax distributions.

Tables Accessed

The package reads and writes RA_CUSTOMER_TRX_LINES, the primary transaction line table, and related Receivables tables including AR_MEMO_LINES_B, AR_PAYMENT_SCHEDULES, and AR_SYSTEM_PARAMETERS. Setup and reference data are drawn from FND_CURRENCIES, FND_DOCUMENT_SEQUENCES, HR_ALL_ORGANIZATION_UNITS, and JTF_RS_SALESREPS. Customer and location context is retrieved from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_LOCATIONS, HZ_PARTIES, and HZ_PARTY_SITES. PER_ALL_ASSIGNMENTS_F supplies assignment information used in tax determination.

Usage Notes

ARP_ETAX_SERVICES_PKG is invoked indirectly through standard Receivables processing rather than called directly by end users. It is referenced by ARP_CTL_PKG, ARP_PROCESS_CREDIT, ARP_PROCESS_HEADER_UPDTE_COVER, ARP_PROCESS_LINE, ARP_TRX_COMPLETE_CHK, and ARW_CM_COVER, which drive transaction entry, completion checks, credit processing, and credit memo cover logic. Because it is not a documented public API, customizations should avoid direct calls; integrations should instead rely on the standard Receivables APIs and AutoInvoice interfaces that invoke this package internally. Any modification carries broad impact given its eight dependent packages.