Search Results pay_set_del




Overview
Explore in AI Chat

Overview

PAY_SET_SHD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the Oracle Payroll (PAY) element and element set infrastructure. The suffix "SHD" denotes a shadow or secondary processing utility, and the package operates in close conjunction with the core element set business logic packages (PAY_SET_BUS, PAY_SET_INS, PAY_SET_UPD, PAY_SET_DEL) to manage element set definitions and their underlying shadow or template structures. Its primary business function is to support the maintenance and regeneration of element sets — the groupings of payroll elements used during payroll run processing — and to facilitate the conversion of programmatic arguments when element sets are copied, altered, or templated.

The package is classified as OTHER in the ETRM 12.2.2 metadata, indicating it is not a public documented API but rather an internal implementation component. It is validated (VALID status) in both 12.1.1 and 12.2.2, confirming its continued presence across the two release lines.

Key Procedures and Functions

  • CONSTRAINT_ERROR — Handles constraint-related exceptions raised during element set processing, likely mapping Oracle constraint violations (such as unique or foreign key conflicts) into meaningful application-level error conditions.
  • API_UPDATING — A flag or guard routine that indicates an API-driven update is in progress, used to differentiate programmatic updates from concurrent-manager or form-driven DML.
  • LCK — Provides locking behaviour for element set records, ensuring that concurrent operations against the same element set do not corrupt shared state.
  • CONVERT_ARGS — Converts or normalises arguments passed into the element set API layer, translating between calling conventions used by the business packages and the shadow processing routines.

The package does not expose documented public parameters; its routines are internal helpers invoked by the element set business layer.

Tables Accessed

Two documented tables are referenced via APPS synonyms:

  • ALL_CONSTRAINTS — Read to inspect constraint definitions, supporting the CONSTRAINT_ERROR routine in interpreting and reporting constraint violations.
  • PAY_SHADOW_ELEMENT_TYPES — The core shadow element type table, which stores the shadow definitions used when element sets reference element types. PAY_SET_SHD reads and writes here to synchronise shadow records with their parent element set definitions.

Usage Notes

PAY_SET_SHD is not intended for direct invocation by end users or custom integrators. It is referenced by six other packages — PAY_ELEMENT_TEMPLATE_GEN, PAY_ELEMENT_TEMPLATE_UTIL, PAY_SET_BUS, PAY_SET_DEL, PAY_SET_INS, and PAY_SET_UPD — which collectively form the element set and element template management layer. Invocation therefore occurs indirectly through:

  • Oracle Payroll element set forms, where users create, copy, or modify element sets.
  • Concurrent programs that generate or regenerate element templates and element sets.
  • Custom code that calls the documented business API packages (PAY_SET_BUS/INS/UPD/DEL) rather than PAY_SET_SHD itself.

Because the package interacts with locking, constraint handling, and shadow element type data, customisations should avoid direct DML on PAY_SHADOW_ELEMENT_TYPES and instead route all changes through the supported element set API packages to preserve data integrity.