Search Results jai_ar_trx_lines_pkg




Overview
Explore in AI Chat

Overview

The APPS.JAI_AR_TRX_LINES_PKG package body is a core component of the Oracle E-Business Suite (EBS) India Localization (JA) tax engine, specifically targeting Accounts Receivable (AR) transaction line processing. In Oracle EBS 12.1.1 and 12.2.2 environments, this package encapsulates the business logic required to compute, default, and recalculate Indian indirect taxes (such as VAT, CST, excise, and service tax) on AR transaction lines. It bridges the standard Oracle Receivables data model with the India-specific tax determination framework maintained in the JAI_ schema objects and the JAI_AR_TRX_LINES staging table.

The package is classified as VALID in the APPS schema and carries an API classification of OTHER rather than a formally published public API. It acts as a private service layer invoked by higher-level India Localization flows that populate and maintain AR transaction line tax details. Its primary responsibility is to derive tax applicability, insert or update corresponding rows in local tax line tables, and maintain consistency between the standard Receivables tables and the India tax repository.

Key Procedures and Functions

The ETRM documentation records six procedures and functions within this package body:

  • POPULATE_JAI_AR_LINES — Populates the India AR transaction lines repository, creating the localized tax line records associated with an AR transaction line.
  • DEFAULT_TAX — Applies India tax defaultation rules to determine applicable taxes for a given transaction line based on regime, tax category, and configuration.
  • GET_SERVICE_TYPE — Returns the service type classification used to drive service tax determination.
  • RECALCULATE_TAX_FOR_DM — Recomputes tax amounts on AR lines associated with debit memo transactions.
  • RECALCULATE_TAX_FOR_INV_CM — Recomputes tax amounts on AR lines associated with invoices and credit memos.
  • DELETE_AR_TRX_LINES — Removes India AR transaction line records, typically during reversal, cancellation, or re-processing scenarios.

Tables Accessed

The package reads from and writes to a broad set of standard Receivables and India Localization tables. Standard Receivables tables include RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, RA_CUST_TRX_TYPES_ALL, and RA_INTERFACE_LINES_ALL, providing transaction header, line, distribution, transaction type, and interface context. Customer data is sourced from HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL, and India-specific address data from JAI_CMN_CUS_ADDRESSES.

India Localization tax configuration and storage objects include JAI_AR_TRX_LINES, JAI_AR_TRX_TAX_LINES, JAI_AR_TRXS, JAI_AR_TRX_APPS_RELS_T, JAI_AR_TRX_INS_LINES_T, JAI_CMN_TAXES_ALL, JAI_CMN_TAX_CTGS_ALL, JAI_CMN_TAX_CTG_LINES, JAI_AP_TDS_THHOLD_SLABS, and JAI_AP_TDS_THHOLD_TAXES. These supply tax rates, threshold slabs, and category definitions used during defaultation and recalculation.

Usage Notes

This package is invoked indirectly from India Localization AR flows and standard Receivables transaction processing, rather than being called directly from an end-user form. It is typically triggered when AR transactions, debit memos, invoices, or credit memos are created, updated, or reversed in an India-enabled operating unit, ensuring the localized tax lines remain synchronized with the underlying transaction.

The metadata confirms that APPS.JAI_AR_TRX_LINES_PKG is referenced by one other package and is not referenced by any database object such as a trigger or view. This indicates it functions as a subordinate service module within the India Localization package family. Customizations should treat it as a non-public internal API; developers requiring India tax logic should prefer the supported public APIs and let the standard flows invoke this package. Logging is handled through FND_LOG and error propagation through APP_EXCEPTION, consistent with standard Oracle EBS development practice.