Search Results get_24q_tax_values

Overview

The APPS.PAY_IN_24Q_ER_RETURNS package is an Oracle E-Business Suite database object that supports the Indian statutory reporting requirements associated with Form 24Q, the quarterly TDS (Tax Deducted at Source) return for salary payments filed with the Income Tax Department. The package resides in the APPS schema and is classified as a payroll/localization utility ("OTHER" API classification in ETRM 12.2.2). Its primary business role is to compute, aggregate, and format the employer (deductor) level and deductee (employee) level values needed to generate the 24Q return, including challan details, salary totals, and tax values. It is therefore a core component of Oracle Payroll's Indian localization for TDS reporting and is validated as VALID in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, each serving a discrete reporting purpose:

• CHALLAN_REC_COUNT – Determines the count of challan (tax payment) records relevant to the return.
• SALARY_REC_COUNT – Returns the number of salary records included in the return.
• DEDUCTEE_REC_COUNT – Counts deductee (employee) records returned in the statement.
• DEDUCTEE_SALARY_COUNT – Captures salary counts at the deductee level.
• CHAPTER_VIA_REC_COUNT – Counts records applicable to specific chapters/sections of the reporting regulations.
• GROSS_TOT_TDS_CHALLAN – Aggregates gross totals and TDS amounts associated with challans.
• TOTAL_GROSS_TOT_INCOME – Produces the total gross income figure for the return.
• GET_24Q_VALUES – Retrieves core Form 24Q field values.
• GET_24Q_TAX_VALUES – Retrieves the tax-related field values for the return.
• GET_EMPLR_CLASS – Returns the employer classification, used to determine reporting format and applicability.
• GET_LOCATION_DETAILS – Resolves location/address details for the deductor.
• GET_FORMAT_VALUE – Supplies formatted output values consistent with the prescribed file layout.
• GET_EMP_CATEGORY – Returns the employee category used to segment deductee data.
• GET_PRODUCT_RELEASE – Returns the product release/version information, typically used to drive version-dependent formatting.

Tables Accessed

The package reads from a set of Payroll and HR tables via APPS synonyms, including PAY_ACTION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PER_ALL_PEOPLE_F, PER_ASSIGNMENTS_F, HR_LOCATIONS, HR_ORGANIZATION_INFORMATION, and PAY_MAGTAPE_GENERIC. These provide the payroll run results, assignment/action context, employee and assignment details, employer location and organization data, and generic magnetic-media output handling. It also references FND_APPLICATION, FND_APPLICATION_TL, FND_PRODUCT_INSTALLATIONS, DUAL, and helper packages FND_DATE, FND_NUMBER, and FND_PROFILE for formatting, profile option retrieval, and product release determination. No direct table writes are documented; the package functions primarily as a read/aggregation layer feeding the return-generation process.

Usage Notes

The package is referenced by the concurrent-program wrapper packages PAY_IN_24QC_ER_RETURNS (twice) and PAY_IN_24QC_ARCHIVE, indicating it is invoked as part of the standard Indian 24Q return generation and archival concurrent programs rather than directly by end users. It is not typically called from a form. Customizations and extensions that require 24Q employer-level values should call these procedures rather than re-implementing the aggregation logic, since the package encapsulates the prescribed formatting, product-release awareness, and profile-driven behavior. Because it depends on FND utility packages and Payroll data, correct operation requires that the Indian localization patches be applied and that payroll actions for the reporting quarter be complete before invocation.