Search Results delete_element_entry

Overview

PER_IE_VEHICLE_ALLOC_RULES is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified as a custom API (API classification: OTHER). It supports the Irish (IE) statutory reporting requirements for company vehicles provided to employees, specifically the Benefit-in-Kind (BIK) reporting obligations administered through the Irish payroll/localization legislation. The package encapsulates business rules that govern the lifecycle of vehicle allocation records stored in the PQP_VEHICLE_ALLOCATIONS_F table and their associated payroll element entries.

Its primary responsibility is to keep the assignment-level payroll element entry "IE BIK Company Vehicle" synchronized with the effective-dating of the corresponding vehicle allocation. When a vehicle allocation ends, the related element entry must be closed so that the Benefit-in-Kind earnings or deductions cease from the correct payroll period. This logic is not delivered as a seeded Oracle product routine; it is a localization-support package referenced by one other package in the APPS schema, confirming it operates as a dependency within a larger IE vehicle allocation processing chain.

Key Procedures and Functions

The package exposes a single documented program unit:

• ELEMENT_END_DATE_UPDATE — Updates the end date of the payroll element entry linked to a given vehicle allocation. It identifies the correct element entry for an assignment by matching the vehicle allocation identifier against the screen entry value of the "Vehicle Allocation" input value on the "IE BIK Company Vehicle" element type, then applies the effective date so the element entry terminates in line with the allocation. The procedure is scoped to a vehicle allocation identifier and an effective date; internal cursor logic resolves the latest element entry, maximum object version, and related date earned values before determining the update to apply.

The header comment indicates the source file is peievehd.pkb with version 120.0.12000000.4, dated 2007, reflecting the maintenance lineage of the IE localization codebase across the 12.1.x and 12.2.x releases.

Tables Accessed

The package reads across the payroll and HR effective-dated schema, joined exclusively through APPS synonyms:

• PQP_VEHICLE_ALLOCATIONS_F — the primary driver table holding the vehicle allocation record being processed, matched on VEHICLE_ALLOCATION_ID and effective dates.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_LINKS_F — used to locate the "IE BIK Company Vehicle" element entry and its "Vehicle Allocation" input value, resolving the link between the allocation and the payroll element.
• PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS — provide the payroll processing context, establishing which assignment action and run results relate to the element entry, and supplying the date earned value.
• PER_ALL_ASSIGNMENTS_F, PER_TIME_PERIODS — supply assignment and time-period context for effective-date validation and period alignment.

Usage Notes

ELEMENT_END_DATE_UPDATE is not intended for standalone invocation. In Oracle EBS 12.1.1 and 12.2.2 deployments, it is typically called from within the IE vehicle allocation localization forms or from a controlling package that manages vehicle allocation end-dating. Because it is referenced by one other package, callers should invoke it in that dependency context, supplying a valid vehicle allocation identifier and the effective date on which the allocation terminates.

The procedure depends on effective-dated joins, so callers must pass dates that fall within the currently active date-tracked rows for the element type, link, input value, and allocation. As a custom APPS-owned package, it is not exposed through standard Oracle public APIs and carries no documented API classification beyond OTHER; any customization or extension should be undertaken with awareness of the one dependent package and the IE localization release level. Note that the table PER_TIME_PERIODS is listed in the metadata, though it does not appear in the visible excerpt, indicating the full package performs additional period-based date determination beyond the excerpt shown.