Search Results p_date_from

Overview

APPS.HR_DE_TAX_SUPPORT is a German localization support package within Oracle E-Business Suite Human Resources. Its primary business function is to perform bulk (batch) maintenance of German tax-related assignment data, including the maintenance of tax class, number of children, tax-free income, and additional income attributes for employees. The header comment identifies the source file as perdetbu.pkb, indicating that the package belongs to the PER (Human Resources) product family, with the "DE" token denoting the German (Deutschland) localization.

In EBS 12.1.1 and 12.2.2 the package is classified under ETRM as an "OTHER" API, meaning that it is not part of the officially supported public API set but is nonetheless depended on by other code. The package supports scenario-based mass updates driven by organization hierarchy selection, allowing payroll or HR administrators to apply tax-relevant changes to a defined population of assignments in a single operation rather than through individual record maintenance.

Key Procedures and Functions

The package exposes four documented procedures. The central driver is BATCH_UPDATE, which accepts a date-from parameter (the source of the "p_date_from" search term), business group, organization hierarchy, top organization, assignment set, action, process identifier, and the German tax attributes to be applied (tax class, number of children, tax-free income, additional income). It resolves the applicable organization structure version and element set for the supplied date before processing assignments. This date-sensitive logic is visible in the internal cursors: get_org_structure_version selects the maximum organization structure version whose date_from is not later than the supplied date and whose date_to has not elapsed; get_org_structure_element and get_organizations then walk the hierarchy elements to derive the affected organizations.

TAX_RECORD is responsible for creating or maintaining the German tax record for an assignment. GET_TAX_RECORD retrieves existing tax record information, serving as query support for validation or reporting. DELETE_ASSIGNMENT removes the tax-related assignment data processed by the package. Together these procedures provide the create, read, and delete operations used by the batch update flow and its supporting processes.

Tables Accessed

• PER_ORG_STRUCTURE_VERSIONS and PER_ORG_STRUCTURE_ELEMENTS — used to resolve the hierarchy version valid as of the supplied date-from and to expand the top organization into the set of child organizations that determine the affected assignment population.
• PER_ALL_ASSIGNMENTS_F — the core HR assignment table against which tax-relevant changes are applied for the selected employees, scoped by business group and date-effective criteria.
• HR_ASSIGNMENT_SET_AMENDMENTS — records amendment activity associated with assignment sets when the batch process acts on an assignment set.
• PAY_ELEMENT_ENTRIES_F — holds element entry values through which tax-related earnings and deductions are persisted for the affected assignments.
• DUAL — used in the hierarchy cursor to include the top organization itself in the union of selected organizations.

Usage Notes

HR_DE_TAX_SUPPORT is typically invoked to support mass tax data maintenance for German employees. Because ETRM classifies it as an "OTHER" API and it is referenced by one other package, it should generally be treated as an internal implementation package rather than a public integration point. Custom code calling BATCH_UPDATE must supply a valid date-from so that the correct organization structure version is resolved; passing an incorrect or out-of-range date can select the wrong hierarchy version or no version at all, resulting in an empty organization set. Processes should be run within the correct business group security context and, where assignment sets are used, with amendment tracking enabled so that HR_ASSIGNMENT_SET_AMENDMENTS is populated correctly. In EBS 12.1.1 and 12.2.2 no public API contract is documented, so any direct invocation should be verified against the installed version of the package body.