Search Results get_format_value

Overview

APPS.PAY_IN_24Q_ER_RETURNS is a payroll reporting package body in the Oracle E-Business Suite India localization (pay_in_* naming convention, source file pyineqit.pkb). It supports the statutory Form 24Q quarterly e-TDS return filing that Indian employers must submit for salary TDS deducted under Section 192 of the Income Tax Act. The package assembles the challan, deductee, salary, and employer-classification data that the 24Q statement (and its annexures) require, and exposes report-format values consumed by the India payroll report templates.

The package is classified as OTHER in the ETRM repository, is owned by APPS, and is referenced by two other packages. It reads from pay_action_information, where the flexfield context IN_24Q_CHALLAN holds the captured challan particulars keyed by action_context_id, and it joins to payroll action, organization, and person tables to resolve the data set for a given GRE and assessment period.

Key Procedures and Functions

Fourteen documented routines make up the package:

• CHALLAN_REC_COUNT — Returns the total number of distinct challan records in the Magtape / challan details for a GRE, assessment period, and maximum action ID.
• SALARY_REC_COUNT — Returns the count of salary (deductee) records included in the return.
• DEDUCTEE_REC_COUNT — Returns the number of deductee records for the return; used in annexure-level tallies.
• DEDUCTEE_SALARY_COUNT — Returns the count of salary rows tied to deductees.
• CHAPTER_VIA_REC_COUNT — Returns record counts for the chapter VI-A deduction detail.
• GROSS_TOT_TDS_CHALLAN — Computes gross total income, total TDS, and challan-level totals for the statement.
• TOTAL_GROSS_TOT_INCOME — Aggregates gross total income across the selected deductee population.
• GET_24Q_VALUES — Returns the principal 24Q statement values (employee, deductor, and income fields).
• GET_24Q_TAX_VALUES — Returns the tax-computation values for the 24Q statement.
• GET_EMPLR_CLASS — Returns the employer classification (e.g., government, company, other) required on the form.
• GET_LOCATION_DETAILS — Returns address/location details of the deductor for the return.
• GET_EMP_CATEGORY — Returns the employee category used to classify deductees.
• GET_FORMAT_VALUE — (the term the user searched) Returns a formatted/display value used when building the 24Q output layout, so that stored codes are presented in the required filing format.
• GET_PRODUCT_RELEASE — Returns the current product release/version of the India payroll code, used for version-stamped output.

Tables Accessed

• PAY_ACTION_INFORMATION — Principal data source; supplies challan and 24Q flexfield values under action_information_category IN_24Q_CHALLAN.
• PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS — Restrict data to the action context and GRE being reported.
• HR_ORGANIZATION_INFORMATION — Resolves deductor/GRE organization attributes.
• PER_ALL_PEOPLE_F — Resolves employee (deductee) details.
• FND_APPLICATION, FND_APPLICATION_TL, FND_PRODUCT_INSTALLATIONS, DUAL — Used for application/product release lookup and single-row utility queries.

Usage Notes

The package is invoked by the India 24Q report and concurrent programs in Oracle Payroll, and it may also be called directly from custom code. Typical callers pass p_gre_org_id, p_assess_period, and p_max_action_id. Debug output is controlled through hr_utility.debug_enabled and routed via pay_in_utils.set_location and trace, so DBMS output must be enabled if a developer wants to diagnose a failing call such as GET_FORMAT_VALUE. The DATE filter uses fnd_date.canonical_to_date against SYSDATE, so rows whose effective date is in the future are excluded.