Search Results create_deductee_detail

Overview

JAI_AP_TDS_ETDS_PKG is the Oracle E-Business Suite globalization package that generates electronic Tax Deducted at Source (eTDS) return files for Indian statutory reporting. It belongs to the JA (Asia/Pacific localizations) product family and resides in the APPS schema, where it operates against AP, HR, HZ, GL and FND base tables through APPS synonyms. The package assembles the flat-file formats mandated by the Indian Income Tax Department — the quarterly eTDS statement and the associated challan and deductee schedules — by reading payables withholding data captured in Oracle Payables and writing formatted, delimited output to a server-side operating system file via UTL_FILE.

A substantial portion of the package body is devoted to fixed-width field definitions. Named constants such as s_line_number, s_record_type, s_file_type, s_upload_type, s_file_sequence_number, s_deductor_tan, s_number_of_batches, s_batch_number, s_challan_count and s_deductee_count establish the exact character positions required by the statutory file layout, while formatting constants (v_delimeter, v_format_amount, v_format_rate, padding characters) govern value presentation. The file is written through a UTL_FILE handle (v_filehandle) to a directory resolved into v_utl_file_dir with a file name held in v_utl_file_name.

Key Procedures and Functions

• OPENFILE / CLOSEFILE — Manage the UTL_FILE handle lifecycle, obtaining the output directory and file name and releasing the handle when generation completes.
• FORMATAMOUNT / GETSECTIONCODE — Formatting helpers that render monetary values to the prescribed numeric picture and derive the statutory section code applicable to a deduction.
• POPULATE_DETAILS — The principal data-gathering routine, collecting the payables, withholding and organizational information required to build the return.
• CREATE_FILE_HEADER / CREATE_FH — Emit the file-level header record containing the deductor TAN, file type, upload type and sequence information.
• CREATE_BATCH_HEADER / CREATE_BH — Emit the batch header carrying the batch number and counts of challans and deductees.
• CREATE_CHALLAN_DETAIL / CREATE_CD — Write the challan detail (CD) record for each tax payment, reporting the bank, branch, challan serial, deposit date and amount remitted. This is the routine referenced by the search term create_cd.
• CREATE_DEDUCTEE_DETAIL / CREATE_DD — Write the deductee detail (DD) record covering each deductee, the paid amount, TDS deducted and the applicable section.
• CREATE_QUARTERLY_FILE_HEADER, CREATE_QUARTERLY_BATCH_HEADER, CREATE_QUART_CHALLAN_DTL, CREATE_QUART_DEDUCTEE_DTL — Quarterly-statement equivalents of the four record-generating routines above.
• VALIDATE_FILE_HEADER, VALIDATE_BATCH_HEADER, VALIDATE_CHALLAN_DETAIL — Consistency checks applied to generated records; failures are recorded in JAI_AP_ETDS_ERRORS_T.

Twenty-five documented procedures and functions are catalogued in total, the remainder supporting internal formatting, padding and control-break logic.

Tables Accessed

• AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL — Source of invoice, withholding distribution, payment and cheque data that determines deductee and challan content.
• AP_BANK_BRANCHES, HR_LOCATIONS_ALL, HR_ALL_ORGANIZATION_UNITS — Bank branch and organization/address attributes needed for deductor and challan identification.
• HZ_ORGANIZATION_PROFILES — Deductee party details, including name, address and Permanent Account Number.
• FND_FLEX_VALUE_SETS — Key flexfield value-set lookups used when resolving section and classification codes.
• GL_PERIODS, GL_PERIOD_SETS — Accounting period resolution for quarterly return selection.
• JAI_AP_ETDS_REQUESTS — Driving request record capturing the parameters of the eTDS generation run.
• JAI_AP_ETDS_T — Interface/staging table holding the extracted eTDS data between population and file writing.
• JAI_AP_ETDS_ERRORS_T — Repository for validation errors raised by the VALIDATE_* routines.
• UTL_FILE — Oracle-supplied package used to write the generated return file to the database server file system.

Usage Notes

The package is normally invoked from the Oracle Payables India eTDS concurrent program, which supplies the request parameters recorded in JAI_AP_ETDS_REQUESTS and directs output to the directory configured through the UTL_FILE_DIR or DIRECTORY object. It is not designed for interactive use from a form. The header comment identifier ($Header: jai_ap_tds_etds.pls 120.8.12010000.3 2008/11/20 ...) indicates a long-stable code line maintained through Release 12.1.1 and carried forward into 12.2.2 with no functional redesign. Because the package writes to the server file system, the database directory and file naming parameters must be correctly configured before submission. On 12.2.2 deployments the same APPS synonym and grant model applies. Custom callers should generally invoke the concurrent program rather than the package procedures directly, and only one other package is documented as referencing this package.