Search Results delete_pre_process

Overview

The APPS.PAY_IN_ELEMENT_TEMPLATE_PKG package is the Oracle E-Business Suite Payroll API responsible for managing Element Templates used by the Element Template Wizard (ETW). Element templates allow implementers and HRMS administrators to define reusable blueprints that classify payroll elements, attach eligibility rules, formulas, balances, and input values, and then bulk-generate concrete element types from that blueprint. This package provides the procedural entry points that the ETW user interface and template-driven element creation flows rely on to persist a template definition, relate it to element classifications and subclassifications, and orchestrate the pre-processing and post-processing steps required to materialize a template into live payroll elements.

In EBS 12.1.1 and 12.2.2 the package is owned by APPS and, per the ETRM classification, is listed as an OTHER API rather than a formally published PL/SQL API with full backward-compatibility guarantees. Customizations should therefore invoke it cautiously and follow Oracle's documented upgrade guidance.

Key Procedures and Functions

• CREATE_TEMPLATE — Creates a new element template record, accepting a template name and returning the generated template identifier used by all subsequent association and processing calls.
• CREATE_TEMPLATE_ASSOCIATION — Associates a template with a classification so the template applies to elements belonging to that classification.
• DELETE_TEMPLATE_ASSOCIATION — Removes the relationship between a template and a classification, cleaning up template usage links.
• ELEMENT_TEMPLATE_PRE_PROCESS — First phase of the element generation lifecycle, performing validation and setup before the template is applied.
• ELEMENT_TEMPLATE_UPD_USER_STRU — The procedure most directly associated with the search term element_template_upd_user_stru; it updates the user-defined structure of the element template, propagating the template's definition of input values, formulas, and result rules to the generated element structure.
• ELEMENT_TEMPLATE_POST_PROCESS — Final phase that finalizes the created or updated element types once template processing completes.
• DELETE_PRE_PROCESS — Handles prerequisite validation and cleanup before a template or its associations are deleted.

Tables Accessed

The package reads and writes several core HRMS Payroll tables via APPS synonyms. PAY_ELEMENT_TEMPLATES, PAY_ELE_TMPLT_CLASS_USAGES, and PAY_ELE_TMPLT_CLASS_USG_S hold the template header and its classification usages. PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, FF_FORMULAS_F, and PAY_FORMULA_RESULT_RULES_F store the generated elements, input values, formulas, and result rules. PAY_ELEMENT_CLASSIFICATIONS and PAY_SUB_CLASSIFICATION_RULES_F support classification logic, while PAY_BALANCE_FEEDS_F, PAY_SHADOW_ELEMENT_TYPES, PAY_SHADOW_FORMULAS, PAY_TEMPLATE_EXCLUSION_RULES, FND_FLEX_VALUE_SETS, and FND_CURRENCIES provide balance feeds, shadow objects, exclusion rules, and flexfield/currency validation.

Usage Notes

This package is primarily invoked by the Element Template Wizard forms and by template-driven element creation concurrent programs rather than being called directly from end-user SQL. It is referenced by at least one other package, confirming it is part of a layered HRMS API stack. Because the ETRM flags it as OTHER and its header indicates a 2008 base version carried forward into 12.1.1 and 12.2.2, developers extending or calling ELEMENT_TEMPLATE_UPD_USER_STRU should treat the interface as internal, test thoroughly during patching, and avoid hard-coding assumptions about signature stability across releases.