Search Results get_prev_nil_challan_ind

Overview

APPS.PAY_IN_24QC_ER_RETURNS is an Oracle E-Business Suite payroll localization package body belonging to the Oracle HRMS/Payroll module for India. Its documented purpose is to support statutory reporting under the Indian Income Tax Act, specifically the generation and correction of Form 24Q (the quarterly statement of tax deducted at source on salaries) filed by an employer (deductor) with the Income Tax Department. The package assembles the quarterly e-returns and correction returns, computing file sequence numbers, deductor challan details, salary and deductee record counts, gross income, and total tax deducted at source (TDS) values. The header comment (pyin24cr.pkb) and the routine names confirm a focus on 24Q correction returns. It is classified in ETRM as an OTHER API rather than a public concurrent or self-service API, and it is referenced by one other package.

Key Procedures and Functions

The 12.2.2 documentation registers twelve public units:

• GET_FILE_SEQ_NO — Returns the file sequence number of the correction report, derived by counting existing 24Q receipt definitions for the deductor organization, assessment year, and quarter and incrementing the count. It reads HR_ORGANIZATION_INFORMATION (context PER_IN_FORM24Q_RECEIPT_DF).
• CHALLAN_REC_COUNT_24QC — Returns the count of challan records for the 24Q correction return (the routine the user search term "chapter_via_rec_count" relates to as a sibling counter).
• GET_RRR_NO — Retrieves the receipt/return reference number used to identify the return submission.
• TOTAL_GROSS_TOT_INCOME — Computes the total gross income declared across the reported deductee records.
• SALARY_REC_COUNT — Returns the salary record count included in the return.
• CHAPTER_VIA_REC_COUNT — Returns the record count for the chapter VI-A (deduction) particulars in the return.
• GROSS_TOT_TDS_CHALLAN_24Q — Aggregates total TDS amounts against challan details for Form 24Q.
• GET_PREV_NIL_CHALLAN_IND — Returns an indicator denoting whether the previous challan was nil.
• DEDUCTEE_REC_COUNT_24Q — Returns the number of deductee records for the quarter.
• GET_24QC_TAX_VALUES — Retrieves tax values relevant to the 24Q correction return.
• GET_ARCHIVE_PAY_ACTION — Obtains the archived payroll action used as the data source for the return.
• REMOVE_CURR_FORMAT — Strips currency formatting from a value to produce numeric text suitable for the e-return file layout.

Tables Accessed

The package reads the following APPS-synonymed base tables:

• PAY_PAYROLL_ACTIONS — Source of payroll run/action metadata used to locate the archived payroll action for the return period.
• PAY_ASSIGNMENT_ACTIONS — Assignment-level payroll action results underpinning salary, deductee, and gross income aggregations.
• PAY_ACTION_INFORMATION — Action-level information values used to derive challan and tax figures.
• HR_ORGANIZATION_INFORMATION — Stores deductor (organization) Form 24Q receipt definition attributes, including assessment year, quarter, and correction indicator used by GET_FILE_SEQ_NO.

Usage Notes

PAY_IN_24QC_ER_RETURNS is not exposed directly to end users; it is invoked by higher-level India statutory reporting processes and concurrent programs that generate Form 24Q quarterly and correction e-returns. It executes within the standard payroll run context (associated with an archived payroll action), so callers must supply valid organization, assessment year, and quarter parameters. Debug output is controlled through hr_utility.debug_enabled and routed to the FND log via PAY_IN_UTILS trace routines. Because the package is classified as an OTHER API and referenced by only one other package, customizations should treat it as an internal implementation unit and interact with it only through the supported 24Q reporting interfaces.