Search Results declare_house_rent

Overview

The APPS.PAY_IN_TAX_DECLARATION package supports the India localization (IN) statutory tax declaration process within Oracle E-Business Suite Payroll. Indian income tax regulations require employees to submit investment and expenditure declarations — such as house rent paid, life insurance premiums, tuition fees, and various Chapter VI-A deductions — so that the employer can compute TDS (Tax Deducted at Source) accurately during the payroll cycle. This package encapsulates the business rules that validate, lock, store, and retrieve those declarations against employee assignments.

It is classified as an OTHER API in the ETRM repository and remains VALID in the APPS schema across release 12.1.1 and 12.2.2. The package sits between the declaration entry forms (typically the India Tax Declaration window in HRMS) and the underlying payroll element structures that store the declared amounts as element entries. Its responsibilities include determining whether a declaration falls inside a locking period, evaluating approval status, validating declaration types, and writing declaration values into the appropriate element entries.

Key Procedures and Functions

• IS_LOCKING_PERIOD — Determines whether the current date falls within a period during which declarations may not be modified, preventing changes after payroll cutoff.
• IS_APPROVED / GET_APPROVAL_STATUS — Return whether a declaration has been approved and report its current approval state.
• GET_TAX_YEAR, GET_LAST_UPDATED_DATE, GET_CITY_TYPE — Retrieve contextual attributes for a declaration, including the applicable tax year, last update timestamp, and city classification (relevant to HRA calculation).
• GET_VALUE, GET_NUMERIC_VALUE, GET_PLANNED_VALUE, GET_DONATION_TYPE — Read stored declaration values in character or numeric form, retrieves the planned (declared) amount, and identifies donation categories.
• DECLARE_HOUSE_RENT, DECLARE_CHAPTER6A, DECLARE_SECTION88, DECLARE_OTHER_INCOME — Entry points for declaring house rent, Chapter VI-A deductions, Section 88 investments, and other income.
• DECLARE_SECTION80DD, DECLARE_SECTION80G, DECLARE_SECTION80CCE, DECLARE_LIFE_INSURANCE_PREMIUM, DECLARE_VPF, DECLARE_TUITION_FEE — Specific declaration routines for medical disability (80DD), donations (80G), 80CCE aggregate limits, LIC premiums, Voluntary Provident Fund, and children's tuition fees.

The 34 documented procedures follow a consistent pattern: validation of the input context, resolution of the applicable element type, and insertion or update of element entry records.

Tables Accessed

The package reads and writes payroll element data through PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_ELEMENT_LINKS_F, since each declaration maps to an input value on a payroll element. Flexible user-defined declaration structures are resolved via PAY_USER_COLUMNS, PAY_USER_ROWS_F, PAY_USER_TABLES, and PAY_USER_COLUMN_INSTANCES_F. Employee and assignment context is obtained from PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_ASSIGNMENT_EXTRA_INFO, and PER_ADDRESSES. Organization and flexfield context draws on HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, and FF_GLOBALS_F.

Usage Notes

This package is invoked primarily from the India Tax Declaration form and related payroll concurrent processes, and is referenced by the PAY_IN_TAX_DECLARATIONS_V view and the PER_IN_DISABILITY_LEG_HOOK hook. Custom code should call the DECLARE_* procedures rather than manipulating element entry tables directly, allowing the package to enforce locking-period and approval checks. Because declarations feed TDS calculation, this package must be executed before the payroll run that consumes the resulting element entries.