Search Results in_state

Overview

APPS.JAI_AP_TDS_ETDS_PKG is the Oracle E-Business Suite India Localization package responsible for generating electronic Tax Deducted at Source (eTDS) files for Accounts Payable. Its source header identifies it as jai_ap_tds_etds.plb, last shipped at version 120.15.12010000.8 (20-Nov-2008). The package encapsulates the data extraction, formatting, and flat-file emission logic required to satisfy Indian statutory eTDS reporting in the formats mandated by the income tax authorities. It assembles deductee, challan, batch, and file-level records from standard Oracle Payables and India Localization tables and writes them to the filesystem through UTL_FILE. The package is registered with an API classification of OTHER and is referenced by one other package. Its change history reflects a lineage of localization bug fixes spanning 2004 to 2008, including corrections for vendor prepayment invoice TDS and base taxable amount calculation, section code printing for deductee details, migration of the AP lookup code from 'TDS' to 'INDIA TDS', CASE-compliance renaming of DB entities, and R12 initiatives to remove literals from DML statements and cursors.

Key Procedures and Functions

The package exposes twenty-five documented procedures and functions, organized into distinct functional groups:

• File lifecycle: OPENFILE and CLOSEFILE manage the UTL_FILE handle used to write the output eTDS file.
• Formatting helpers: FORMATAMOUNT and GETSECTIONCODE produce standardized output values—amount formatting and deductee section code derivation respectively. The absence of a getSectionCode call for the deductee section was corrected under Bug# 3708878.
• Data population: POPULATE_DETAILS drives the overall extraction and staging of eTDS data.
• Record builders (current format): CREATE_FILE_HEADER, CREATE_BATCH_HEADER, CREATE_CHALLAN_DETAIL, and CREATE_DEDUCTEE_DETAIL generate the file header, batch header, challan detail, and deductee detail records.
• Record builders (short-form variants): CREATE_FH, CREATE_BH, CREATE_CD, and CREATE_DD provide equivalent construction of the file header, batch header, challan detail, and deductee detail records.
• Quarterly format builders: CREATE_QUARTERLY_FILE_HEADER, CREATE_QUARTERLY_BATCH_HEADER, CREATE_QUART_CHALLAN_DTL, and CREATE_QUART_DEDUCTEE_DTL produce the quarterly eTDS return segments.
• Validators: VALIDATE_FILE_HEADER, VALIDATE_BATCH_HEADER, and VALIDATE_CHALLAN_DETAIL verify the integrity and completeness of the corresponding record segments before file generation.

Collectively these routines segregate header, batch, challan, and deductee responsibilities, allowing both regular and quarterly return formats to be emitted from a common data model.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• JAI_AP_ETDS_T — the primary staging and extract table holding eTDS TDS and base taxable amounts; the subject of the prepayment invoice correction under Bug# 3603545.
• JAI_AP_ETDS_REQUESTS — tracks eTDS generation requests.
• JAI_AP_ETDS_ERRORS_T — captures validation or processing errors.
• Payables transaction tables: AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_CHECKS_ALL, and AP_INVOICE_PAYMENTS_ALL supply invoice, distribution, payment, and withholding data.
• Supplier and organization data: HZ_ORGANIZATION_PROFILES, HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, AP_BANK_BRANCHES provide deductee, bank, and location attributes.
• Reference and period data: FND_FLEX_VALUE_SETS, GL_PERIODS, and GL_PERIOD_SETS resolve lookup values and reporting periods.
• UTL_FILE — the Oracle-supplied package used to open, write, and close the flat eTDS output file.

Usage Notes

JAI_AP_TDS_ETDS_PKG is invoked in the India Localization eTDS concurrent program flow, where it extracts qualifying withholding transactions for a reporting period, stages them in JAI_AP_ETDS_T, validates the derived segments, and writes the formatted return to a server-side file via UTL_FILE. Because it is a package body registered as an OTHER API, it is not exposed as a public PL/SQL API for general customer calls; it is consumed internally by the India localization module and by the one dependent package documented in the metadata. The functionality is relevant to both Oracle EBS 12.1.1 and 12.2.2, since the 120.15.12010000.8 file version corresponds to the R12 code line. Customizations should avoid direct invocation of individual CREATE_* or VALIDATE_* routines, as their sequencing and internal state are managed by POPULATE_DETAILS. The package writes to the filesystem and therefore requires the UTL_FILE directory and database directory object privileges to be correctly configured for the eTDS output path. Users searching for "in_state" will typically encounter this package in the context of state-level deductee and challan attributes produced during eTDS record construction.