Search Results remove_curr_format

Overview

APPS.PAY_IN_24QC_ARCHIVE is a PL/SQL package body belonging to the Oracle E-Business Suite (EBS) Indian payroll localization, commonly shipped with release 12.1.1 and 12.2.2. The naming convention indicates that the package supports the statutory Form 24Q quarterly return, which Indian employers must file for Tax Deducted at Source (TDS) on salaries. The "_ARCHIVE" suffix denotes that the package is responsible for persisting the salary and assignment action data that underlies each quarterly 24Q statement, so that the return can be reproduced or re-generated after the payroll run has been closed. In effect, it is the archival engine that snapshots the assignment action context, salary records and formatting information required to render the 24Q report. The package is classified as OTHER in the ETRM metadata, meaning it is not a public API, and it is referenced by zero other packages, so it is expected to be invoked through forms, concurrent programs or localization-specific drivers rather than called from general application code.

Key Procedures and Functions

The package exposes ten documented program units. GET_24Q_VALUES, the entry point most often searched for, drives the extraction of the quarterly 24Q values that will be written to the archive. ARCHIVE_CODE performs the actual archival of salary and assignment action records. DEINITIALIZATION_CODE and INITIALIZATION_CODE bracket the archival process, handling setup and teardown of package state and PL/SQL tables. CHECK_C5_CHANGE_ONLY evaluates whether the C5 (salary detail) segment has changed, allowing the package to detect and process only modified records. RANGE_CODE and ASSIGNMENT_ACTION_CODE derive the range and assignment action identifiers used to select the records to archive. ASSIGNMENT_END_DATE determines the effective end date applicable to an assignment for archival purposes. GET_FORMAT_VALUE retrieves the display format for a value, and REMOVE_CURR_FORMAT strips currency formatting from the stored values so they can be archived and later presented in the prescribed 24Q layout. Collectively these units implement a controlled read–transform–store cycle over the payroll data underlying the quarterly return.

Tables Accessed

The package reads from core HR and payroll tables through APPS synonyms. Assignment and person context is drawn from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F and PER_ASSIGNMENT_EXTRA_INFO. Organization and flexfield metadata come from HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX. Payroll action and assignment action data are sourced from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS. Salary and element data are read from PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_TYPES_F, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES and PAY_BALANCE_DIMENSIONS. Together these tables supply the person, assignment, element entry, balance and action information needed to reconstruct the quarterly TDS position for each employee.

Usage Notes

PAY_IN_24QC_ARCHIVE is normally invoked as part of the Indian 24Q archival or report generation flow, typically triggered from a concurrent program or a localization form after payroll has been run and before the quarterly return is filed. Because it is not referenced by any other package and is not a public API, custom code should not call it directly; instead, use the standard 24Q submission process, which invokes GET_24Q_VALUES and the related routines internally. Debug output is controlled by HR_UTILITY.DEBUG_ENABLED and routed through PAY_IN_UTILS. Care should be taken to run the archival only for closed payroll periods, since the stored snapshots are used to reproduce the 24Q statement in later periods.