Search Results jai_cmn_mtax_pkg




Overview
Explore in AI Chat

Overview

APPS.JAI_CMN_MTAX_PKG is a PL/SQL package belonging to the Oracle E-Business Suite Financials family of localization components, specifically associated with the India Localization (JAI) module. The package name—combining "CMN" (common), "MTAX" (multiple taxes or tax modification), and "PKG" (package)—indicates that it encapsulates shared logic for handling multiple tax lines, tax defaulting, and tax category updates across transactions. Its primary business role is to manage the routing of tax-related requests, the propagation of tax category changes to downstream transaction records, redetermination of default taxes, removal of tax lines subsequent to validation, and validation of withholding tax on Bills of Exchange (BOE). Within the Oracle EBS 12.1.1 and 12.2.2 environments, the package maintains data integrity between tax headers, tax details, BOE records, and customer/site information, ensuring that Indian statutory tax rules are consistently applied.

Key Procedures and Functions

The package exposes five documented procedures, each serving a distinct functional purpose:

  • ROUTE_REQUEST — Directs tax-related requests to the appropriate processing path, serving as the entry-point dispatcher for the package's operations.
  • PROCESS_TAX_CAT_UPDATE — Handles updates originating from tax category changes, applying modifications to affected tax header and detail records.
  • DO_TAX_REDEFAULTATION — Performs redetermination (re-defaulting) of taxes, recalculating applicable tax lines when underlying data changes.
  • DEL_TAXES_AFTER_VALIDATE — Removes tax records following the validation stage, accommodating corrections or reversals.
  • CHK_BOE_TAX — Validates Bill of Exchange tax information, verifying that BOE-related tax details are consistent prior to processing.

Parameter lists are not exposed in the available metadata and should be confirmed against the live package specification.

Tables Accessed

The package reads and writes through APPS synonyms across a documented set of tables:

Usage Notes

JAI_CMN_MTAX_PKG is referenced by no other packages in the documented metadata, meaning it is invoked at the top level—typically from India Localization forms, concurrent programs, or custom extensions. The presence of FND_CONCURRENT_PROGRAMS among its dependencies suggests it supports concurrent processing for bulk tax updates and redetermination. It is customarily called during tax category maintenance, BOE validation, and post-validation corrections. Implementers extending India Localization tax logic should call the documented procedures rather than manipulating the underlying JAI_CMN_MTAX tables directly.