Search Results per_ie_vehicle_alloc_rules




Overview
Explore in AI Chat

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:

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.