Search Results delete_ele_template_objects

Overview

The APPS.PQP_EARNINGS_TEMPLATE package is an Oracle E-Business Suite PL/SQL API that supports the creation, maintenance, and removal of earnings element templates and their associated template objects. Within Oracle Payroll and the related HR/Payroll configuration model, an element template represents a pre-defined blueprint for generating element types, input values, balance feeds, balance types, and balance dimensions in a single, coordinated operation. The package is primarily exercised during the setup and cloning of payroll earnings definitions, allowing implementation teams and localization processes to construct complete earnings objects without manually maintaining each underlying database entity in isolation.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema, relying on APPS synonyms to access the underlying Payroll tables. Its header reference (pqeetdrv.pkh) confirms it as a driver-level API used by template-generation workflows rather than an end-user-facing utility.

Key Procedures and Functions

ETRM documents four procedures/functions in this package:

• CREATE_ELE_TEMPLATE_OBJECTS — The primary function, returning a NUMBER. It accepts user-supplied attributes for an earnings element—name, reporting name, description, classification, category, processing type (recurring or non-recurring), priority, standard link and overtime-base flags, FLSA hours, calculation formula, separation check, deduction processing, reduce-regular indicator, effective dates, supplementary category, legislation code, business group, and termination rule—and creates the corresponding template and dependent payroll objects. This is the function most commonly referenced by the user search term create_ele_template_objects.
• GET_OBJ_ID — A retrieval routine used to obtain the identifier of a template or related core object, typically after creation or during subsequent processing.
• ADD_FLSA_REDUCE_REG_FEEDS — Adds FLSA and reduce-regular balance feeds associated with the template, ensuring statutory and costing-related balances are populated.
• DELETE_ELE_TEMPLATE_OBJECTS — Removes the template and its dependent objects, supporting rollback or cleanup of template creation.

Tables Accessed

The package reads and writes several core Payroll tables through APPS synonyms:

• PAY_ELEMENT_TEMPLATES, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F — the primary element template, element type, and input value definitions created or removed.
• PAY_BALANCE_FEEDS_F, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS — balance feed, balance type, and dimension records maintained to route element results to balances.
• PAY_TEMPLATE_CORE_OBJECTS — the linking table that maps template objects to their core payroll entities.
• PAY_SHADOW_ELEMENT_TYPES — shadow element records used for calculation and reporting alignment.

Usage Notes

This package is an internal API exposed for configuration and localization use. It is typically invoked from Oracle Payroll setup forms, from earnings template integration processes, or from custom PL/SQL that programmatically generates element definitions. Because CREATE_ELE_TEMPLATE_OBJECTS writes to multiple interconnected tables, callers should invoke it within a transaction that permits rollback on failure, and should validate that the referenced business group, legislation, and formula exist before calling. The package is referenced by two other packages, indicating it is a reusable dependency within the Payroll template-generation framework rather than a standalone entry point.