Search Results create_form_24




Overview
Explore in AI Chat

Overview

APPS.PAY_IN_FORM_24Q_WEB_ADI is a PL/SQL package that supports the Indian statutory Form 24Q (quarterly TDS return on salaries) reporting process within Oracle E-Business Suite Payroll. Form 24Q is the quarterly statement filed by employers in India to report tax deducted at source on salary payments, and the package encapsulates much of the data derivation logic needed to assemble that return. It belongs to the "OTHER" API classification, indicating it is primarily an internal implementation package rather than a formally published public API. The package addresses the need to resolve assessment year context, employee-level earning dates, Tax Account Number (TAN) details, organization identifiers, and aggregated tax deposit balances into a form the reporting layer can consume.

Key Procedures and Functions

  • GET_ASSESSMENT_YEAR / SET_ASSESSMENT_YEAR — Accessor and mutator for the package global g_assessment_year. These control the assessment year context under which the Form 24Q data is derived.
  • GET_DATE_EARNED — Returns the date earned for a given assignment action, resolving the timing of the payroll run relevant to the return.
  • GET_DATE_EARNED_EE — Returns the date earned at element-entry level for an employee.
  • GET_EE_VALUE — Retrieves a stored element input value for an employee, supporting the extraction of taxable and deduction amounts.
  • GET_TAN_NUMBER / GET_TAN_NUMBER_EE — Return the employer's Tax Account Number, at organization/deduction level and at employee level respectively. These are the procedures relevant to the search term "get_tan_number".
  • GET_ORG_ID — Resolves the organization identifier used to scope the TAN and statutory information.
  • GET_BALANCE_VALUE — Returns an accumulated balance (such as a year-to-date taxable or TDS amount) for use in the return.
  • GET_TOTAL_TAX_DEPOSITED — Returns the total tax deposited, providing the reconciliation figure for the challan reporting portion of the return.
  • CREATE_FORM_24 — Performs the generation of the Form 24Q data set, orchestrating the supporting functions.
  • GET_BG_ID — Returns the business group identifier associated with the reporting context.

Tables Accessed

The package reads from the standard Payroll and HR schema through APPS synonyms. Payroll run and action data come from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PAY_ACTION_INTERLOCKS. Element and entry details are sourced from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F. Employer statutory identity, including the TAN, is held in HR_ORGANIZATION_INFORMATION, while HR_SOFT_CODING_KEYFLEX provides the key flexfield segments used to qualify balances. DUAL supports scalar lookups. The package is predominantly read-oriented against these transactional tables.

Usage Notes

PAY_IN_FORM_24Q_WEB_ADI is invoked indirectly by the Form 24Q web reporting flow rather than being called by name from a form or concurrent program. Two other packages reference it, meaning it normally executes as a helper layer beneath a higher-level reporting entry point. Because it is classified as OTHER and its header carries an older $Header revision, customizations should treat the package as internal and avoid dependencies on its signatures. Where an organization must extend or debug TAN retrieval, GET_TAN_NUMBER and GET_TAN_NUMBER_EE are the documented access points, with organization context resolved through HR_ORGANIZATION_INFORMATION and GET_ORG_ID ranking the applicable employer record. This behavior is consistent across EBS 12.1.1 and 12.2.2.