Results for “get_prim_vin”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PAY_GB_P11D_CAR_EXTRACT is a PL/SQL package body belonging to the Oracle E-Business Suite UK payroll (PAY) product family. Its purpose is to extract, assemble, and report company car benefit-in-kind data required for the United Kingdom P11D statutory filing. The P11D form reports taxable benefits provided to employees, and company cars represent one of the most significant benefit categories. This package isolates the car-related data — vehicle identification, make and model, list price, fuel type, and CO2 emissions — from the underlying Oracle Advanced Benefits extraction framework (BEN_EXT_*) and returns it in a form suitable for P11D reporting.
The package is classified as "OTHER" in the ETRM API classification, indicating it is an internal implementation unit rather than a published, customer-callable API. It is not referenced by any other package, so it operates as a terminal extraction module invoked through the benefits extract infrastructure.
Key Procedures and Functions
The package exposes paired "GET_" and wrapper functions for each car attribute. The GET_ functions accept an assignment context and return the raw value; the unprefixed counterparts (for example PRIM_MAKE) act as the reporting-layer wrappers that format and emit the value into the extract record. The documented routines include:
- GET_PRIM_ASG_START_DATE / GET_PRIM_ASG_END_DATE — Establish the effective assignment period for the primary assignment, bounding the benefit window.
- GET_PRIM_BEN_START_DATE / PRIM_BEN_START_DATE and GET_PRIM_BEN_END_DATE / PRIM_BEN_END_DATE — Determine the benefit entitlement start and end dates, ensuring only periods within the P11D tax year are reported.
- GET_PRIM_VIN / PRIM_VIN — Retrieve the Vehicle Identification Number of the primary company car.
- GET_PRIM_MAKE / PRIM_MAKE and GET_PRIM_MODEL / PRIM_MODEL — Return the vehicle manufacturer and model designations.
- GET_PRIM_DFR / PRIM_DFR — Return the date first registered, a critical input for the company car benefit calculation.
- GET_PRIM_PRICE / PRIM_PRICE — Return the list price used to compute the taxable benefit.
- GET_PRIM_FUEL_TYPE / PRIM_FUEL_TYPE — Return the fuel category (petrol, diesel, hybrid), which drives the appropriate percentage multiplier.
- GET_PRIM_CO2_EMI / PRIM_CO2_EMI — Return the CO2 emission figure, the principal determinant of the benefit-in-kind percentage.
Tables Accessed
The package reads from the BEN_EXT_* family — BEN_EXT_DFN, BEN_EXT_RCD, BEN_EXT_RCD_IN_FILE, BEN_EXT_RSLT, and BEN_EXT_RSLT_DTL — which hold the extract definition, record, and result data. Assignment and person context comes from PER_ALL_ASSIGNMENTS_F and PER_ALL_PEOPLE_F. Business group and organization data come from HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX. Payroll and consolidation context comes from PAY_ALL_PAYROLLS_F and PAY_CONSOLIDATION_SETS. Car-specific attributes, including vehicle details, are sourced from PQP_ASSIGNMENT_ATTRIBUTES_F. Assignment status and set membership are resolved through PER_ASSIGNMENT_STATUS_TYPES, HR_ASSIGNMENT_SETS, and HR_ASSIGNMENT_SET_AMENDMENTS.
Usage Notes
This package is executed within the Oracle Advanced Benefits extract framework, normally triggered by a concurrent program that runs the P11D Car Extract for a business group. The get_bus_group_id function resolves the business group from the assignment, and get_param_ext_start_date reads the "Extract Start Date" parameter via hruserdt.get_table_value, defaulting to the start of the fiscal year when the parameter is absent or malformed. Because the package is not referenced by other packages, it is not intended for direct customer invocation; customization should instead target the extract definition and attribute mappings that feed it. The $Header line indicates maintenance release 120.8 dated August 2011, consistent with the 12.1.1 and 12.2.2 code lines.