Results for “deletion_allowed”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_ELEMENT_CLASS_PKG is the server-side PL/SQL package body that encapsulates the business logic governing element classifications in Oracle Payroll. An element classification defines the fundamental nature of a payroll element — for example Earnings, Deductions, or Employer Charges — and determines how the element interacts with balance feeds, costing, and taxation. This package provides the validation and maintenance layer that the Element Classifications form and related setup interfaces invoke when users create, modify, or delete classification definitions within a specific business group and legislation.

The package body is an "OTHER" classified API, meaning it is a supporting internal package rather than a formally published public API. Its responsibilities center on enforcing uniqueness, translation integrity, and referential constraints before database changes are committed. Because classifications are legislation-specific and translatable, the package also manages the multilingual (TL) mirror records that store user-facing names and descriptions across installed languages.

Key Procedures and Functions

• NAME_NOT_UNIQUE — Determines whether a proposed classification name duplicates an existing classification within the same legislation and business group, raising the standard HR error when a collision is detected.
• SET_TRANSLATION_GLOBALS — Establishes package-level globals (business group and legislation code) used during translation validation.
• VALIDATE_TRANSLATION — Validates translated rows for a classification against the active legislation and language context.
• DELETION_ALLOWED — Checks whether a classification may be removed without violating dependent element types or classification rules.
• USER_CAN_MODIFY_PRIMARY — Confirms whether the current user is permitted to alter the primary (base-language) definition.
• INSERT_ROW — Inserts a new element classification record, enforcing the validation rules described above.
• LOCK_ROW — Acquires a row-level lock to serialize concurrent updates.
• UPDATE_ROW — Applies modifications to an existing classification.
• DELETE_ROW — Removes a classification after confirming deletion is permissible.
• ADD_LANGUAGE — Creates the translation row for a newly installed language.
• TRANSLATE_ROW — Maintains translated name and description values in the TL table.

Tables Accessed

• PAY_ELEMENT_CLASSIFICATIONS — The base table holding classification definitions; primary target of insert, update, delete, and uniqueness checks.
• PAY_ELEMENT_CLASSIFICATIONS_TL — Stores translated names and descriptions, managed by the translation procedures.
• PAY_ELEMENT_TYPES_F — Referenced to verify classification usage before permitting deletion or modification.
• PAY_ELE_CLASSIFICATION_RULES and PAY_SUB_CLASSIFICATION_RULES_F — Consulted for dependent rule definitions.
• PAY_BALANCE_CLASSIFICATIONS — Used to confirm balance associations tied to classifications.
• FND_LANGUAGES, FND_PRODUCT_INSTALLATIONS, HR_LEGISLATION_INSTALLATIONS — Support language availability and legislation installation checks during translation validation.

Usage Notes

This package is invoked indirectly rather than called directly by end users. The Element Classifications setup form triggers its procedures on save, delete, and language installation events, ensuring data integrity across the classification and translation tables before changes are posted. Because it is not a published API, customizations and third-party integrations should treat it as internal; direct calls are unsupported and may break across patches. It is referenced by one other package within the Payroll schema, reflecting its role as a shared validation utility. In EBS 12.1.1 and 12.2.2 the behavior is consistent, with the TL architecture unchanged; the 12.2.2 form runs in the standard OA framework while the same server-side package continues to enforce the documented rules.