Search Results check_element_freq

Overview

APPS.HR_ELEMENTS is a server-side PL/SQL package within the Oracle E-Business Suite 12.1.1 and 12.2.2 Oracle HRMS (Human Resources Management System) schema. Its principal business function is to centralize the validation, maintenance, and rule-management logic that surrounds element types — the configurable earning, deduction, and information components used in payroll and compensation processing. Because element types drive payroll calculations, their names, classifications, input values, and processing rules must remain internally consistent and free of duplication, the package exposes a set of validation and maintenance entry points that Forms and concurrent processes invoke before committing changes to the underlying PAY schema tables. The package header carries the revision string $Header: pyelemnt.pkh 120.0 2005/05/29 ..., indicating a long-standing, stable interface that has been carried forward largely unchanged into the 12.x releases.

Key Procedures and Functions

The documented interface comprises seventeen procedures and functions. Validation routines include CHK_ELEMENT_NAME, which detects duplicate element names within a business group and legislation, and CHK_REPORTING_NAME, which performs the equivalent duplication check for reporting names when one is supplied. CHK_ELEMENT_TYPE enforces the broader business rules governing element type attributes, while CHK_UPD_ELEMENT_TYPE determines whether specific attributes may lawfully be updated during an element type modification (explicitly excluding element name and classification, which are not updatable). CHK_DEL_ELEMENT_TYPE governs the validity of deleting an element type, and ELEMENT_PRIORITY_OK checks priority assignments. CHECK_ELEMENT_FREQ verifies element-to-payroll frequency relationships, and RELIES is a dependency check used to confirm relationships between element constructs.

Maintenance procedures include INS_INPUT_VALUE, which inserts input value definitions; INS_SUB_CLASSIFICATION_RULES; INS_OWNERSHIPS, which records application ownership of elements; and the third-party extension handlers INS_3P_ELEMENT_TYPE, UPD_3P_ELEMENT_TYPE, and DEL_3P_ELEMENT_TYPE. Deletion of dependent rule sets is handled by DEL_FORMULA_RESULT_RULES and, most relevant to the search term DEL_STATUS_PROCESSING_RULES, which removes status processing rules associated with an element type when those rules are no longer applicable.

Tables Accessed

The package reads and writes the core payroll configuration tables through APPS synonyms. Element type definitions and their translations are held in PAY_ELEMENT_TYPES_F, with classifications in PAY_ELEMENT_CLASSIFICATIONS and linkages in PAY_ELEMENT_LINKS_F. Input value definitions and their translated forms reside in PAY_INPUT_VALUES_F, PAY_INPUT_VALUES_F_TL, and PAY_INPUT_VALUES_S. Rule storage spans PAY_ELEMENT_TYPE_RULES, PAY_FORMULA_RESULT_RULES_F, PAY_ELE_PAYROLL_FREQ_RULES, and PAY_FREQ_RULE_PERIODS. Ownership and legislative context are drawn from HR_APPLICATION_OWNERSHIPS and PAY_LEGISLATION_RULES. Payroll action and assignment action records are referenced via PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS, and language support is provided through FND_LANGUAGES.

Usage Notes

HR_ELEMENTS is a low-level package, classified as OTHER, and is referenced by eleven other packages. It is normally invoked indirectly — from the Element and Element Type Forms, from payroll setup flows, and from concurrent programs that create or migrate element definitions — rather than called directly by end users. Custom developers extending element types, particularly via third-party (3P) element APIs, call the INS/UPD/DEL_3P_ELEMENT_TYPE routines and rely on the CHK_* routines for pre-commit validation. The presence of DEL_STATUS_PROCESSING_RULES confirms the package participates in cleanup of rule data when element status processing configurations are removed.