Search Results jai_ap_tds_old_pkg




Overview
Explore in AI Chat

Overview

JAI_AP_TDS_OLD_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Tax Deducted at Source (TDS) processing for Oracle Payables within the Oracle Financials for India (JAI) product family. Its object name carries the suffix "OLD," indicating that it represents a legacy component retained for backward compatibility, likely superseded by a newer TDS package but still valid and referenced within the application. The package provides the programmatic backbone for handling TDS-sensitive invoice operations, including invoice approval, cancellation, prepayment application and unapplication, and status retrieval. Because TDS compliance in India requires that withholding tax be calculated, recorded, and reported at the invoice and payment level, this package bridges standard Payables invoice processing with the India-localized TDS tables and error-handling infrastructure. The ETRM metadata confirms the package is VALID and classified as an "OTHER" API, meaning it is not a formally published open interface but is exposed for internal invocation by related TDS packages and concurrent processing logic. It is referenced by two other packages, most notably JAI_AP_TDS_CANCELLATION_PKG, confirming its role as a shared utility layer for TDS-aware invoice lifecycle events.

Key Procedures and Functions

The package exposes five documented procedures and functions, each aligned to a distinct Payables/TDS lifecycle event:

  • CANCEL_INVOICE — Handles cancellation of an invoice while preserving TDS integrity, ensuring TDS records and holds associated with the cancelled invoice are consistently managed.
  • PROCESS_PREPAYMENT_APPLY — Manages the application of a prepayment to an invoice, adjusting TDS implications that arise when prepayments are matched against standard invoices.
  • PROCESS_PREPAYMENT_UNAPPLY — Reverses a previously applied prepayment, restoring TDS balances and associations to their prior state.
  • APPROVE_INVOICE — Executes the approval-side TDS logic, including validation and recording of withholding details as the invoice moves to an approved status.
  • GET_INVOICE_STATUS — Returns the current status of an invoice, allowing callers to branch logic based on whether the invoice is entered, validated, approved, or cancelled.

Parameter lists are not documented in the ETRM metadata and should not be assumed; callers should inspect the package specification directly.

Tables Accessed

The package reads and writes a broad set of Payables and India-localization tables through APPS synonyms. Core Payables tables include AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_INTERFACE, AP_INVOICES_INTERFACE, AP_PAYMENT_SCHEDULES_ALL, AP_BATCHES_ALL, AP_HOLDS, and the interface sequence AP_INVOICES_INTERFACE_S and AP_INVOICE_LINES_INTERFACE_S. These support header, line, distribution, payment schedule, and hold manipulation. Setup and period validation draws on FINANCIALS_SYSTEM_PARAMS_ALL and GL_PERIOD_STATUSES. The India-specific tables JAI_AP_TDS_INVOICES, JAI_AP_TDS_THHOLD_TRXS_S1, JAI_CMN_TAXES_ALL, and JAI_CMN_ERRORS_T store TDS invoice records, withholding transaction sequences, tax definitions, and error logging respectively.

Usage Notes

JAI_AP_TDS_OLD_PKG is typically invoked indirectly rather than by end users. Its principal caller is JAI_AP_TDS_CANCELLATION_PKG, which delegates cancellation-related TDS handling to this package. It is also self-referenced, indicating internal procedure calls. Customizations and extensions that intercept Payables invoice approval, cancellation, or prepayment application in an India TDS context may call these procedures directly, provided the calling code respects the same TDS validation and error-logging conventions. Because the package accesses interface and base tables together, it should be invoked within the same transaction boundaries as the triggering Payables event to avoid inconsistent TDS state. Given its "OLD" designation, new development should preferentially target the current replacement package where one exists, using this package only to preserve compatibility with existing customizations on EBS 12.1.1 and 12.2.2.