Search Results declare_section80cce

Overview

APPS.PAY_IN_TAX_DECLARATION is an Oracle E-Business Suite Payroll (PAY) package body that supports the Indian statutory tax declaration process, known locally as the "Brazilian Municipal Tax Declaration Form" in the user's search context but properly documented in ETRM as an Indian payroll legislative tax declaration utility. The package manages the capture, validation, storage, and approval of employee tax investment declarations — the annual proof-of-investment submissions employees file to claim exemptions and deductions under Indian income tax rules. These declarations drive TDS (Tax Deducted at Source) computation for the payroll year.

The package body carries the header pyintaxd.pkb 120.26.12020000.14, confirming its presence in the 12.1.1 and 12.2.2 release streams. It is classified in ETRM as an OTHER API, meaning it is not a formally published open interface but is referenced internally by other Oracle Payroll components and by two dependent packages.

The package maintains a substantial global state section, including a legislation code variable, several PL/SQL tables keyed by tax section (t_entry_details_tab for sections 80DD, 80G, insurance, and 80CCE), and an input-values collection (t_input_values_tab) used to read tax element inputs from payroll element entries.

Key Procedures and Functions

The package exposes 34 documented procedures and functions organized into logical groups:

• Period and Approval Control: IS_LOCKING_PERIOD returns freeze-period start dates and a lock flag; IS_APPROVED checks declaration approval status; GET_APPROVAL_STATUS retrieves the current workflow or approval state; GET_LAST_UPDATED_DATE returns the most recent modification timestamp.
• Lookup and Value Retrieval: GET_CITY_TYPE, GET_TAX_YEAR, GET_DONATION_TYPE, GET_PLANNED_VALUE, GET_VALUE, and GET_NUMERIC_VALUE resolve reference data and declared amounts from payroll element entries.
• Declaration Sections: DECLARE_HOUSE_RENT, DECLARE_CHAPTER6A, DECLARE_SECTION88, DECLARE_SECTION80DD, DECLARE_SECTION80G, DECLARE_SECTION80CCE, DECLARE_LIFE_INSURANCE_PREMIUM, DECLARE_VPF, DECLARE_TUITION_FEE, and DECLARE_OTHER_INCOME each process employee entries for the corresponding Indian tax deduction or exemption section.

These procedures collectively validate declared values, persist them as element entry values, and make them available to the payroll tax calculation engine.

Tables Accessed

The package reads and writes a broad set of Payroll and HR tables through APPS synonyms:

• Payroll element data: PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_INPUT_VALUES_F store declarations as element entry inputs.
• Descriptive flexfield and user tables: PAY_USER_TABLES, PAY_USER_COLUMNS, PAY_USER_ROWS_F, PAY_USER_COLUMN_INSTANCES_F hold supplementary declaration attributes.
• Assignment and person data: PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_EXTRA_INFO, PER_ADDRESSES, and HR_ORGANIZATION_INFORMATION provide employee, assignment, and organizational context.
• Flexfield and global context: FF_GLOBALS_F and HR_SOFT_CODING_KEYFLEX supply legislative and cost allocation context.

Usage Notes

PAY_IN_TAX_DECLARATION is normally invoked indirectly — from the Indian Tax Declaration entry forms or from concurrent programs that validate and process employee declaration submissions during the payroll period. Custom code that manipulates Indian tax declarations should call the documented procedures rather than writing directly to the underlying element entry tables, ensuring consistent validation and approval behavior. Because the package is classified as OTHER rather than a public API, Oracle may change its internals between patch levels; integrators should isolate their calls and retest after applying payroll legislative patches.