Search Results challan_rec_count

Overview

APPS.PAY_IN_EOY_ER_RETURNS is an Oracle E-Business Suite PL/SQL package body that supports the Indian statutory year-end reporting process for employer returns. It assembles and validates the aggregates required for the annual end-of-year (EOY) reporting cycle, including challan reconciliation, deductee-level totals, and quarterly return figures. The package belongs to the Oracle Payroll localization layer for India and is classified as OTHER within the ETRM repository, meaning it is not a public API intended for direct external invocation but rather an internal utility/derivation package called by accompanying reporting programs.

The version header (pyinerit.pkb 120.4 dated 2006/05/19) indicates the package has been stable across the 12.1.1 and 12.2.2 application releases. Its responsibilities center on reconciling the organization-level TDS challan data captured against HR organization information with the deductee and gross totals drawn from payroll action data.

Key Procedures and Functions

• CHALLAN_REC_COUNT — Returns the total number of records in the challan detail portion of the Magtape extract for a given reporting organization and assessment year. It is a counting function used to populate or validate record control totals on the return file.
• DEDUCTEE_REC_COUNT — Returns the count of deductee-level records for the assessment year. This is the function most commonly located by searches for the term "deductee_rec_count," and it supplies the deductee control total required for the EOY statement output.
• PERQ_REC_COUNT — Returns the record count for the quarterly (per-quarter) portion of the return.
• GROSS_TOT_TDS_CHALLAN — Derives the gross and total TDS amounts associated with challan records.
• GROSS_TOT_TDS_DEDUCTEE — Derives the gross and total TDS amounts at the deductee level, complementing the challan-based total.
• GET_EOY_VALUES — Retrieves the consolidated end-of-year values required for return preparation.
• GET_TDE_REMARKS — Returns the TDS remark text associated with the return or deductee records.
• GET_EMPLR_CLASS — Returns the employer classification applicable to the reporting organization.
• GET_LOCATION_DETAILS — Returns address and location details used in the EOY return header.

Tables Accessed

• HR_ORGANIZATION_INFORMATION — The principal source table. The challan count logic joins two contexts, PER_IN_IT_CHALLAN_INFO and PER_IN_CHALLAN_BANK, on organization_id and on the challan identifier held in org_information5, filtering by the assessment year derived from the financial-year string. Employer class and location details are likewise read from this table.
• PAY_ACTION_INFORMATION and PAY_PAYROLL_ACTIONS — Provide payroll run action context for the gross and TDS totals.
• PAY_ASSIGNMENT_ACTIONS and PER_ALL_ASSIGNMENTS_F — Supply assignment-level results used in the deductee and gross total derivations.
• PER_ASSIGNMENT_EXTRA_INFO — Supplies assignment-level tax attributes relevant to deductee reporting.
• DUAL — Used for single-row derivations and default returns.

Usage Notes

The package is not referenced by any other packaged API (referenced by 0 other packages), which confirms it is invoked from the India year-end return concurrent programs and their supporting logic rather than from a declared API surface. Typical invocation occurs when the employer EOY return extract is generated: the concurrent program calls the various record-count functions to populate control totals, then calls the gross/TDS functions to populate monetary aggregates, and finally the remark and location helpers to complete the return header and footer.

Debugging is conditional on hr_utility.debug_enabled, with trace output routed through pay_in_utils. Because the functions return VARCHAR2 counts and amounts, callers should expect string-typed return values needing explicit conversion. Custom code should not call these functions directly unless it fully replicates the year-end context parameters, as the assessement-year arithmetic and organization scoping are specific to the statutory layout.