Search Results insert_tax_information

Overview

APPS.PER_DE_ELE_API is a public PL/SQL API package in Oracle E-Business Suite that supports German statutory payroll requirements, specifically the maintenance of tax information, tax exemptions, and social insurance data for employees. In the Oracle HRMS architecture, the PER_ prefix denotes a package belonging to the People (Human Resources) product family, while the DE infix identifies country-specific functionality for Germany (Deutschland). This package therefore serves as a business-logic layer that isolates German localization business rules from the core element-entry and payroll processing framework.

The package is classified as an API and is validated in the APPS schema on both Oracle EBS 12.1.1 and 12.2.2. It provides a controlled, programmatic interface through which German tax and social insurance attributes are created, modified, and removed, rather than requiring direct DML against underlying HRMS tables. This encapsulation ensures the consistent enforcement of validation rules and integration with the E-Business Tax and payroll frameworks.

Key Procedures and Functions

The documentation identifies ten public procedures and functions within the package, grouped into three maintenance domains and one utility routine:

• INSERT_TAX_INFORMATION — creates a new German tax information record for an employee or assignment.
• UPDATE_TAX_INFORMATION — modifies an existing tax information record, preserving the audit history expected of HRMS datetracked data.
• DELETE_TAX_INFORMATION — removes or end-dates a tax information record.
• INSERT_TAX_EXEMPTIONS — creates a tax exemption record, such as allowances claimed against German income tax.
• UPDATE_TAX_EXEMPTIONS — amends exemption details.
• DELETE_TAX_EXEMPTIONS — removes or end-dates an exemption record.
• INSERT_SOCIAL_INSURANCE_INFO — creates German social insurance details covering the statutory branches (health, pension, unemployment, and care insurance).
• UPDATE_SOCIAL_INSURANCE_INFO — modifies social insurance details.
• DELETE_SOCIAL_INSURANCE_INFO — removes or end-dates social insurance details.
• DECODE_LOOKUP — a utility function that translates Oracle lookup codes into their corresponding meaning values, supporting validation and display of coded German statutory attributes.

The naming convention reflects a deliberate CRUD decomposition of each business entity, allowing callers to invoke precisely the operation required without overloading a single maintenance routine.

Tables Accessed

Documented access is via APPS synonyms, here PAY_ELEMENT_ENTRIES_F, the core Oracle Payroll table that stores element entry values for an assignment over a datetracked period. The tax information, tax exemption, and social insurance attributes maintained through this API are persisted as element entries, which is consistent with the Oracle HRMS design principle that payroll-relevant data be represented as elements. Because the package is an API, it should be assumed to perform validation and derived logic around these writes, and to rely on HR_API for shared HRMS API infrastructure. Additional dependent objects in the dependency list include standard SYS packages.

Usage Notes

APPS.PER_DE_ELE_API is referenced by the view HR_DE_SOCIAL_INSURANCE_INFO_V and by the package HR_DE_TAX_SUPPORT, both German localization components. The view provides a query interface over social insurance information, while HR_DE_TAX_SUPPORT invokes the API's tax routines as part of German tax processing. The dependency listing also shows the package body referencing itself, typical of internal helper calls. Typical invocation paths include German localization forms, payroll-related concurrent programs, and custom extensions or conversions that must load employee tax and social insurance data. Direct SQL updates to PAY_ELEMENT_ENTRIES_F should be avoided in favour of this API to preserve validation and datetrack integrity. As with all Oracle HRMS APIs, callers should adhere to the documented parameter and date-tracking semantics.