Search Results get_ee_value

Overview

APPS.PAY_IN_FORM_24Q_WEB_ADI is an Oracle E-Business Suite PL/SQL package body belonging to the Oracle Payroll (PAY) module, specifically the India localization (PAY_IN) set of utilities. Its header comment, $Header: pyinwadi.pkb 120.17.12020000.2 2013/01/18, confirms it is a shipped Oracle file maintained under the 12.1.1 and 12.2.2 code lines. The package supports the generation of the Indian Form 24Q, the quarterly statement of tax deducted at source (TDS) on salary payments that employers must file with the Income Tax Department. Form 24Q reporting requires the payroll system to derive values such as the assessment year, dates on which earnings were paid, employee-level tax deductions, the Tax Deduction and Collection Account Number (TAN) of the employer, and the balance of tax deposited with the government. This package encapsulates that retrieval logic so that the Form 24Q web-based concurrent program and its supporting ADI (Application Data Interface) output can assemble a compliant return.

Key Procedures and Functions

ETRM documents twelve callable units in this package. The following are named per the metadata; parameter lists are intentionally omitted where not documented.

• GET_ASSESSMENT_YEAR — returns the Indian assessment year for which the Form 24Q is being prepared. The source excerpt shows it reads the package-level variable g_assessment_year and traces its value when debug is enabled.
• SET_ASSESSMENT_YEAR — sets the package-level assessment year so that other routines in the same session use a consistent filing period. The excerpt shows it accepts a VARCHAR2 input and assigns it to g_assessment_year.
• GET_DATE_EARNED — derives the date on which salary was earned, a field required to classify payments into the correct quarter of the assessment year.
• GET_DATE_EARNED_EE — the employee-level variant of the date-earned derivation.
• GET_EE_VALUE — returns a value for a specific employee, used by the Form 24Q layout to populate per-employee columns. This is the unit most commonly referenced in custom India payroll extensions.
• GET_TAN_NUMBER — retrieves the employer's TAN, which must appear on every Form 24Q statement.
• GET_TAN_NUMBER_EE — the employee-associated variant of the TAN lookup.
• GET_ORG_ID — returns the organization identifier used to scope the payroll data to the correct reporting establishment.
• GET_BALANCE_VALUE — fetches a payroll balance value used in the tax computation for the filing.
• GET_TOTAL_TAX_DEPOSITED — returns the total tax deposited, reconciled against the challan details on the return.
• CREATE_FORM_24 — the main driver that assembles and writes the Form 24Q output.
• GET_BG_ID — returns the business group identifier, used to scope organization-level data.

Tables Accessed

The package reads through APPS synonyms. PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F provide the payroll element and entry data from which salary, deduction, and balance figures are derived. PAY_ASSIGNMENT_ACTIONS and PAY_ACTION_INTERLOCKS supply the payroll action and processing context, while PAY_PAYROLL_ACTIONS identifies the payroll run. HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX deliver organization and key flexfield attributes, including TAN and establishment details. DUAL supports single-row computations.

Usage Notes

The package is invoked in the context of the Form 24Q web extraction concurrent program and its ADI output, both of which run under the APPS schema. Because the assessment year is held in a package-level variable, callers should invoke SET_ASSESSMENT_YEAR before requesting dependent values. The package is referenced by two other packages according to ETRM, indicating that custom India payroll extensions and reporting utilities call GET_EE_VALUE and related functions directly. Debug output is controlled by HR_UTILITY.DEBUG_ENABLED and emitted through PAY_IN_UTILS, following the standard Oracle India localization tracing pattern.