Search Results jai_ap_tds_cancellation_pkg




Overview
Explore in AI Chat

Overview

The APPS.JAI_AP_TDS_CANCELLATION_PKG is a PL/SQL package owned by the APPS schema that supports the Oracle E-Business Suite localization for India, specifically the Tax Deducted at Source (TDS) functionality within Oracle Payables. Its principal business function is to manage the reversal and reconciliation of TDS withholding records when an invoice is cancelled or otherwise rendered ineligible for the withholding treatment originally applied. Under Indian statutory requirements, taxes deducted at source must be accurately tracked against supplier invoices and reported for periodic return filing; when an invoice is voided, cancelled, or fully reversed, the associated TDS transactions, thresholds, and slab balances must be unwound consistently so that the withholding register and subsequent statutory reports remain correct.

The package is documented as a standard Oracle EBS object with a status of VALID in the ETRM repository for release 12.1.1 and 12.2.2. It is classified as an OTHER API, indicating that it is an internal utility rather than a public extension interface, and it is not referenced by any other package in the documented dependency set. Its only external dependency recorded in the metadata is on the STANDARD package and SYS, reflecting the limited architectural coupling typical of a subsidiary cancellation utility.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

  • PROCESS_INVOICE — The sole documented entry point. Its name indicates that it accepts an invoice identifier context and performs the cancellation processing for TDS records associated with that invoice. In practice this procedure is expected to evaluate the invoice and its distributions, determine which withholding transactions, threshold accumulations, and tax lines were previously generated, and reverse or mark them as cancelled so that downstream TDS reporting and withholding certificate generation reflect the corrected liability.

The package body also contains a private implementation section (the "Package Body" and "SQL Statements" entries in the repository), but no additional callable signatures are exposed in the documentation. Parameter lists are not published in the metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes a defined set of base and India-localization tables through APPS synonyms:

Usage Notes

Because this package is an internal utility rather than a public API, it is normally invoked indirectly. Typical call sites include the Oracle Payables invoice cancellation and adjustment flows where India TDS is enabled, the India localization concurrent programs that reconcile withholding registers, and customization code that programmatically voids invoices containing TDS lines. Direct invocation should be reserved for remediation or data-fix scenarios and must respect the sequence generation for JAI_AP_TDS_INV_CANCELS_S and the integrity of the threshold accumulation tables. The package has no documented dependents, so changes to it carry limited blast radius, but any modification must preserve the statutory audit trail for Indian withholding tax reporting.