Search Results element_end_date_update

Overview

PER_IE_VEHICLE_ALLOC_RULES is an APPS-owned PL/SQL package within the Oracle E-Business Suite Payroll and Human Resources modules. Its name and referenced schema objects indicate that it supports vehicle allocation processing for the Irish (IE) localization, where employer-provided vehicles and their associated benefit-in-kind calculations are governed by Irish Revenue rules. In Oracle EBS 12.1.1 and 12.2.2, the package operates as a supplemental rules handler that manages the lifecycle of vehicle allocation records stored in the PQP_VEHICLE_ALLOCATIONS_F table and the payroll elements that represent the resulting benefit values.

The package is classified in the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API, meaning it is not a public, supported extension interface intended for direct customer invocation. Instead, it is a supporting internal utility invoked by other payroll or HR processing logic. The header comment ($Header: peievehd.pkh 120.0.12000000.1 2007/01/21) shows the package specification was last shipped in 2007 and remains stable across the 12.1.1 and 12.2.2 releases, with no functional signature changes.

Key Procedures and Functions

The documented package specification exposes a single procedure:

• element_end_date_update — Accepts a vehicle allocation identifier and an effective date, and is used to update the end date on the payroll element entries associated with that vehicle allocation. In practice, this procedure is invoked when a vehicle allocation must be terminated or curtailed as of a specific effective date, ensuring that the corresponding payroll element entries (and hence the benefit-in-kind deductions or charges) cease to apply from that date forward. The procedure abstracts the date-effective updates required across the element entry and element entry value tables so that the payroll element no longer generates run results beyond the specified effective date.

No public functions are documented; the package therefore serves as a narrowly scoped maintenance routine rather than a general-purpose rules engine. Callers must supply a valid p_vehicle_allocation_id corresponding to a record in PQP_VEHICLE_ALLOCATIONS_F and an effective date that is meaningful to the element entry's date-tracked structure.

Tables Accessed

ETRM metadata identifies the following tables referenced through APPS synonyms:

• PQP_VEHICLE_ALLOCATIONS_F — the driving entity. Holds the vehicle allocation record whose termination is being processed.
• PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F — the date-effective element entry and entry value tables updated to reflect the new end date.
• PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F — reference data used to resolve the correct element, link, and input value definitions for the vehicle allocation element.
• PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS — payroll context tables consulted to identify related assignment actions, payroll actions, and prior run results that constrain how the end date may be applied.
• PER_ALL_ASSIGNMENTS_F and PER_TIME_PERIODS — used to validate the assignment and the time period within which the effective date falls.

Usage Notes

PER_IE_VEHICLE_ALLOC_RULES is not exposed as a concurrent program or a public API. It is invoked internally—typically from Irish payroll localization logic or from forms supporting vehicle allocation maintenance—whenever a vehicle allocation must be closed or its effectivity shortened. Because the package updates date-tracked payroll tables, any invocation must pass a date consistent with open payroll periods to avoid retroactive recalculation errors.

Customers should not call this package directly in custom code; the supported extension points for payroll element processing are the standard PAY_ELEMENT_ENTRY_API and related public APIs. The package is referenced by one other package in the ETRM metadata, confirming its role as a subordinate utility. Any modification to its behavior would require Oracle-supplied patches, since the specification is shipped and owned by Oracle.