Search Results pay_ele_tmplt_class_usg_s

Overview

APPS.PAY_CREATE_ELEMNT_TMPLT_RECORD is a PL/SQL package body in the Oracle E-Business Suite Payroll (PAY) schema that provides the programmatic infrastructure for creating and populating payroll element template records. In Oracle Payroll, an element is the fundamental building block used to represent earnings, deductions, and other payroll components. Rather than requiring administrators to configure each element individually, Oracle Payroll supports element templates — pre-defined blueprints that specify the classification, processing rules, balance feeds, and input values required for a given type of element. The PAY_CREATE_ELEMNT_TMPLT_RECORD package encapsulates the logic that takes a template definition and generates the corresponding element records, class usages, and associated sub-component definitions. The user search term "pay_ele_tmplt_class_usg_s" corresponds directly to the PAY_ELE_TMPLT_CLASS_USG_S table referenced by this package, which stores the classification usage definitions belonging to each element template. The package carries a status of VALID and is classified as OTHER (not strictly an API in the traditional sense, but a supporting creation utility). It has been stable across EBS 12.1.1 and 12.2.2, with the 12.2.2 ETRM documenting seven procedures.

Key Procedures and Functions

The package exposes seven documented procedures, each focused on a specific template-creation scenario:

• CREATE_ELEMNT_TMPLT_USAGES — Creates the classification usage records that associate an element template with one or more element classifications. This procedure populates PAY_ELE_TMPLT_CLASS_USAGES and its synonym-backed key-flex table.
• CREATE_DEDN_FLAT_AMT_TEMPL — Generates a deduction element template based on a flat monetary amount.
• CREATE_DEDN_PCT_AMT_TEMPL — Generates a deduction element template based on a percentage amount.
• CREATE_EARN_FLAT_AMT_TEMPL — Generates an earnings element template based on a flat monetary amount.
• CREATE_EARN_HXR_AMT_TEMPL — Generates an earnings element template based on an hours-times-rate calculation (HXR).
• CREATE_EARN_PCT_AMT_TEMPL — Generates an earnings element template based on a percentage of a balance or rate.
• CREATE_ALL_TEMPLATES — A driver procedure that orchestrates creation of the full set of templates, invoking the individual creation routines in sequence.

The procedure names indicate that parameter lists are encapsulated and not publicly documented in the ETRM excerpt; usage should follow the signature defined in the package specification.

Tables Accessed

The package reads and writes the following documented tables (accessed through APPS synonyms):

• PAY_ELEMENT_TEMPLATES — The master template definition table, storing the template name, type, and primary attributes.
• PAY_ELEMENT_CLASSIFICATIONS — Reference data mapping templates to valid element classifications.
• PAY_ELE_TMPLT_CLASS_USAGES — The classified usage records that link a template to its classifications; this is the table matching the user's search term's base name.
• PAY_ELE_TMPLT_CLASS_USG_S — The primary key flexfield (key flex structure) table for template class usages, storing the unique segment combinations.
• PAY_BALANCE_DIMENSIONS — Used to establish balance feed dimensions for the generated elements.
• DUAL and PLITBLM — Utility references (PLITBLM is the PL/SQL integer table type) rather than business tables.

In addition, the package depends on other packages — notably PAY_ELEMENT_TEMPLATE_API, PAY_ETM_INS, PAY_SBF_INS, PAY_SBT_INS, PAY_SDB_INS, PAY_SET_INS, PAY_SFR_INS, PAY_SF_INS, and PAY_SIV_INS — which perform the low-level inserts into element, balance feed, and input value tables.

Usage Notes

PAY_CREATE_ELEMNT_TMPLT_RECORD is typically invoked during element template setup, often through the Element Templates window in Oracle Payroll or as part of a concurrent process that bulk-generates templates for a localization or legislative implementation. In 12.2.2, the package remains valid and its signature is unchanged from 12.1.1. The package is not referenced by any database object (per ETRM), but the inverse dependency is documented: it references HR_UTILITY, DUAL, PLITBLM, STANDARD, and the various PAY_*_INS packages. It is referenced by one other package. Custom code should invoke the public procedures via the package specification, and administrators performing bulk template creation should run the procedures in a controlled environment, as failures during creation can leave partial records across PAY_ELEMENT_TEMPLATES, PAY_ELE_TMPLT_CLASS_USAGES, and PAY_ELE_TMPLT_CLASS_USG_S.