Search Results pay_element_class_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_ELEMENT_CLASS_PKG is the Oracle Payroll package that manages the definition, maintenance, and multilingual translation of element classifications. Within Oracle EBS 12.1.1 and 12.2.2, element classifications group element types into logical categories that control processing priority, costability, distribution rules, and payment treatment. The package exposes an API-style interface for querying classifications, validating uniqueness and translation data, and performing row-level DML against the underlying classification tables. It is defined with AUTHID CURRENT_USER, so execution runs with the privileges of the calling user rather than the package owner.

The package is central to the "name_not_unique" search term. Its NAME_NOT_UNIQUE function exists specifically to detect duplicate classification names for a given legislation and business group, and is used during validation of new or updated classification records.

Key Procedures and Functions

  • NAME_NOT_UNIQUE — Function returning a BOOLEAN that determines whether a proposed classification name already exists for the specified classification, legislation code, business group, and row identifier. It underpins uniqueness validation.
  • SET_TRANSLATION_GLOBALS — Procedure that establishes translation context globals given a business group and legislation code.
  • VALIDATE_TRANSLATION — Procedure validating a translated classification name and description against a classification and language.
  • DELETION_ALLOWED — Function returning BOOLEAN indicating whether a given classification may be deleted.
  • USER_CAN_MODIFY_PRIMARY — Function returning BOOLEAN indicating whether the caller may modify primary classifications for a legislation.
  • INSERT_ROW — Procedure that creates a new element classification record with its costability, priority, distribution, and related attributes.
  • LOCK_ROW — Procedure that locks a classification row, typically preceding an update.
  • UPDATE_ROW — Procedure that modifies an existing classification row.
  • DELETE_ROW — Procedure that removes a classification row.
  • ADD_LANGUAGE — Procedure that adds a language row in the translation table for a classification.
  • TRANSLATE_ROW — Procedure that updates translated name and description values for a classification.

Tables Accessed

The package operates against base and translation tables through APPS synonyms:

Usage Notes

PAY_ELEMENT_CLASS_PKG is invoked by Oracle Payroll maintenance forms (such as the element classification and element type setup forms), by concurrent programs that seed or migrate element classifications, and by custom PL/SQL extensions performing validated inserts, updates, or translations. The NAME_NOT_UNIQUE function should be called before submitting a new classification name to enforce uniqueness for the business group and legislation combination. The package is referenced by one other package, and its DML procedures should generally be used in place of direct table manipulation to ensure validation and translation integrity. As with all Payroll APIs, callers should respect legislation security and business group context.