Results for “pqp_uk_vehicle_template”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PQP_UK_VEHICLE_TEMPLATE package is a United Kingdom localization component within the Oracle E-Business Suite payroll schema. It provides a programmatic utility for creating and removing element templates specifically oriented toward company vehicle processing under UK legislation. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, which is standard practice for payroll APIs that must respect the calling session's security context.

The package header carries the version marker pqukcmtp.pkh 120.0, dated 2005, indicating it belongs to an established generation of UK payroll localizations. A global constant, g_template_leg_code, is initialized to the value 'GB', confirming that every template element produced by this package is tagged to the Great Britain legislation code. A second global, g_template_leg_subgroup, is declared to hold the legislation subgroup associated with template elements. Together these globals scope all template creation activity to the UK legislative framework.

Key Procedures and Functions

Two callable units are documented in the package specification.

• CREATE_USER_TEMPLATE — a function returning a numeric value. It accepts a broad set of descriptive parameters covering the element name, reporting name, description, classification, processing type, priority, standard link flag, vehicle type, table indicator flag, table name, effective start and end dates, and a business group identifier. Its role is to assemble and persist a user-defined element template for UK vehicle-related payroll processing, returning an identifier associated with the created template.
• DELETE_USER_TEMPLATE — a procedure that removes a previously created user template. It is scoped by business group, element type identifier, element name, and effective date, allowing targeted removal of a specific template record within the correct legislative and organizational context.

No parameter lists beyond those documented should be assumed; the signatures above reflect the specification as published.

Tables Accessed

The package operates across a broad set of core payroll and flexfield tables, accessed through APPS synonyms.

• PAY_ELEMENT_TEMPLATES, PAY_TEMPLATE_CORE_OBJECTS — the principal template definition and linkage stores that CREATE_USER_TEMPLATE and DELETE_USER_TEMPLATE manipulate.
• PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPE_EXTRA_INFO, PAY_INPUT_VALUES_F — element type definitions, extended attributes, and input value definitions created as part of a template.
• PAY_BALANCE_TYPES — balance definitions referenced when templates feed or consume balances.
• PAY_SHADOW_ELEMENT_TYPES, PAY_SHADOW_BALANCE_TYPES, PAY_SHADOW_INPUT_VALUES — shadow copies required for date-tracked element processing.
• FND_FLEX_VALUE_SETS — validation of flexfield value sets used by template elements.
• PLITBLM — the standard EBS PL/SQL table used for bulk processing.

Usage Notes

This package is typically invoked from UK payroll localization setup flows rather than by end users directly. It is called when a vehicular element template must be instantiated for a business group, most commonly during configuration of company car or vehicle benefit processing. Because the package is not referenced by any other documented package, it functions as a leaf-level API, suggesting it is called directly from concurrent programs, forms-based setup routines, or custom localization scripts.

The business group parameter is mandatory in practice, as payroll element creation must be partitioned by legislation and organization. The AUTHID CURRENT_USER clause means callers must hold appropriate privileges on the underlying payroll tables. The hard-coded 'GB' legislation code constrains the package to UK operations; it is not intended for other legislations.