Search Results create_hrly_basic_sal_template
Overview
PAY_AE_ELEMENT_TEMPLATE_PKG is an Oracle Applications (APPS) PL/SQL package within the Oracle E-Business Suite payroll schema. The "AE" component of the name designates the United Arab Emirates localization, and the package provides the logic required to generate and maintain payroll element templates specific to UAE statutory and business requirements. In Oracle Payroll, an element template is a reusable definition that carries the configuration attributes — classification, input values, rate logic, and eligibility rules — used to mass-create element types for a legislative or business context. This package encapsulates that generation logic so that the many recurring UAE allowance, deduction, and rate-based elements can be created consistently rather than manually.
The package is classified as OTHER (not a public API) and holds VALID status in the APPS schema. It is referenced by PAY_AE_RULES, indicating that the UAE payroll rules engine depends on the templates produced here.
Key Procedures and Functions
The package exposes 18 documented procedures and functions organized into three functional groups.
- Rate and lookup utilities — GET_RATE_FROM_TAB_ID and GET_RATE_FROM_TAB_NAME retrieve rate values from the rate tables by identifier or name; GET_EMPLOYEE_DETAILS and GET_ABSENCE_DAYS retrieve assignment-level employee attributes and absence day counts used when populating template input values.
- Template creation routines — CREATE_TEMPLATES is the master driver that builds the set of UAE element templates in a single execution. Individual builders create specific template shapes: CREATE_FLAT_AMT_TEMPLATE (fixed-amount elements), CREATE_PERC_TEMPLATE (percentage-based elements), CREATE_BASIC_SAL_TEMPLATE and CREATE_HRLY_BASIC_SAL_TEMPLATE (monthly and hourly basic salary), CREATE_HSG_ALLW_TEMPLATE (housing allowance), CREATE_TRN_ALLW_TEMPLATE (transport allowance), CREATE_COL_ALLW_TEMPLATE (cost-of-living allowance), CREATE_CHILD_ALLW_TEMPLATE (child allowance), CREATE_SOCIAL_ALLW_TEMPLATE (social allowance), CREATE_SHIFT_ALLW_TEMPLATE (shift allowance), CREATE_OT_ALLW_TEMPLATE (overtime), and CREATE_UNP_LEAVE_DEDN_TEMPLATE (unpaid leave deduction).
- Post-processing — ELEMENT_TEMPLATE_POST_PROCESS finalizes templates after creation, applying dependent configuration such as classification usages and sub-classification rules.
No parameter lists are documented in the ETRM metadata, so signatures should be inspected in the database before invocation.
Tables Accessed
The package reads and writes both payroll configuration and HR assignment data through APPS synonyms. Configuration tables include PAY_ELEMENT_TEMPLATES, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELE_TMPLT_CLASS_USAGES and PAY_ELE_TMPLT_CLASS_USG_S (template-to-classification mappings), PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F (element type and input value definitions), PAY_RATES, PAY_GRADE_RULES_F, and PAY_SUB_CLASSIFICATION_RULES_F/S. Reference data is drawn from FND_CURRENCIES and FND_FLEX_VALUE_SETS. HR data is read from PER_ALL_ASSIGNMENTS_F, PER_ABSENCE_ATTENDANCES, and PER_ABSENCE_ATTENDANCE_TYPES to support the employee-detail and absence-day lookups.
Usage Notes
This package is intended for UAE localization setup and maintenance rather than day-to-day payroll processing. It is typically invoked during initial implementation or legislative patching to generate the standard UAE element template set, or from controlled custom code and concurrent programs when templates must be regenerated. Because it is not classified as a public API and writes directly to element template and classification tables, it should be executed only by knowledgeable administrators, with changes validated through the standard Element Design Wizard afterwards. The dependency on PAY_AE_RULES confirms it operates in tandem with the UAE payroll rules framework in EBS 12.1.1 and 12.2.2.