Search Results pay_in_eoy_er_returns




Overview
Explore in AI Chat

Overview

The APPS.PAY_IN_EOY_ER_RETURNS package is a PL/SQL server-side component within the Oracle E-Business Suite (EBS) Payroll module, specifically supporting the Oracle Payroll localization for India (the PAY_IN prefix denotes the Indian legislative extension). Its name indicates its role in the processing of End-of-Year (EOY) Employer (ER) Returns, the statutory statements that Indian employers must file for tax deduction at source (TDS) on salaries. In Oracle EBS 12.1.1 and 12.2.2, this package generates and validates the aggregated figures reported on EOY returns, including challan-level counts, deductee counts, perquisite counts, and gross totals of TDS. It is a non-API utility package classified as OTHER, meaning it is intended primarily for internal use by the Indian Payroll EOY reporting framework rather than as a published integration interface. The package is currently VALID in the APPS schema, and it depends on a set of payroll action, assignment, and HR organization objects to derive the data required for statutory reporting.

Key Procedures and Functions

The package exposes nine documented procedures and functions. Their purposes are as follows:

  • CHALLAN_REC_COUNT — Determines the count of challan records associated with the EOY employer return, supporting the reconciliation of tax remittances against reported TDS.
  • DEDUCTEE_REC_COUNT — Returns the count of deductee records (employees against whom TDS was deducted) included in the return.
  • PERQ_REC_COUNT — Returns the count of perquisite records, capturing non-cash benefits valued for tax purposes.
  • GROSS_TOT_TDS_CHALLAN — Computes the gross total of TDS as represented at challan level, aggregating the amounts remitted to government.
  • GROSS_TOT_TDS_DEDUCTEE — Computes the gross total of TDS at deductee level, i.e., the sum of deductions attributed to individual employees.
  • GET_EOY_VALUES — Retrieves the set of EOY values required for return generation, acting as a central accessor for end-of-year figures.
  • GET_TDE_REMARKS — Fetches the remarks associated with the TDS deductee entry, used to populate the remarks field on the return.
  • GET_EMPLR_CLASS — Returns the employer class, a classification relevant to statutory reporting of the deductor.
  • GET_LOCATION_DETAILS — Retrieves location details of the employer or establishment, drawn from HR location data.

Tables Accessed

The package reads and processes data from several documented tables via APPS synonyms. Payroll action and action-information data is drawn from PAY_PAYROLL_ACTIONS, PAY_ACTION_INFORMATION, and PAY_ASSIGNMENT_ACTIONS, providing the run results and assignment-level actions necessary for EOY aggregation. HR organization data is sourced from HR_ORGANIZATION_INFORMATION, while employer location details come from HR_LOCATIONS. Assignment and extra-information records are accessed through PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_EXTRA_INFO, which supply employee assignment context and statutory extra information (such as PAN and tax-relevant attributes). The DUAL table is used for scalar computations and validations. Additional dependencies include FND_DATE, HR_GENERAL, and PAY_MAGTAPE_GENERIC, indicating the package uses date utilities, HR general routines, and generic payroll output routines.

Usage Notes

This package is not a public API and is referenced by zero other packages according to the ETRM metadata. It is typically invoked indirectly by the Indian Payroll EOY return generation framework, most commonly through concurrent programs or report definitions that produce the Employer Return outputs, and potentially through supporting forms. Because the package body is self-referential in the dependency listing, it is designed for internal iteration over return records. Developers extending or troubleshooting Indian EOY returns should treat these procedures and functions as read-oriented accessors rather than callable integration points. As with all Indian Payroll legislative objects, behavior is tied to the localization patch level; environments in 12.1.1 and 12.2.2 should be verified against the current statutory format, as EOY return structures are periodically revised by tax authorities.