Search Results pay_itr_del




Overview
Explore in AI Chat

Overview

PAY_ITR_DEL is a PL/SQL package body owned by the APPS schema that provides the deletion logic for the payroll iterative rules infrastructure in Oracle E-Business Suite. The "ITR" prefix maps to the PAY_ITERATIVE_RULES_F table and its associated business layer, PAY_ITR_BUS. Iterative rules support payroll processing requirements that must be evaluated repeatedly, such as automatic retroactive adjustments and iterative calculation loops. Because these rules drive payroll calculations across potentially many assignment action cycles, the deletion path must be controlled rather than allowing direct DML against the underlying table. PAY_ITR_DEL exists to enforce that control.

The package is classified as OTHER in the ETRM metadata; it is an internal, sealed business-layer routine rather than a public Oracle HRMS API. Its status is VALID in both 12.1.1 and 12.2.2, and it exposes three documented entry points: DELETE_DML, DEL, and one additional documented procedure/function. The package is not referenced by any other database object, but it itself references a set of HR and payroll facilities, including HR_API, HR_UTILITY, DT_API, PAY_ITR_BUS, PAY_ITR_RKD, PAY_ITR_SHD, PAY_ITERATIVE_RULES_F, and the standard SYS.STANDARD package.

Key Procedures and Functions

  • DELETE_DML — Performs the core deletion DML against the iterative rules definition. It encapsulates the physical delete and is the internal workhorse called when a rule record must be removed from PAY_ITERATIVE_RULES_F.
  • DEL — The higher-level delete entry point. It orchestrates the deletion workflow, applying business validation and routing through PAY_ITR_BUS and the shadow/audit packages before any row is removed.
  • Third documented unit — The metadata records three documented procedures/functions in total. The remaining unit supports the delete lifecycle, consistent with the referenced PAY_ITR_RKD and PAY_ITR_SHD packages.

No parameter lists are published in the ETRM extract; callers should not assume a public signature and should invoke the package only through the supported HRMS business layer.

Tables Accessed

The single documented table is PAY_ITERATIVE_RULES_F, accessed via an APPS synonym. This is the definition table for iterative rules; DELETE_DML removes rows from it. The references to PAY_ITR_BUS, PAY_ITR_RKD, and PAY_ITR_SHD indicate that the package participates in the standard payroll entity lifecycle: business-layer validation (BUS), row-level delete handling (RKD), and shadow/audit propagation (SHD). The HR_API and HR_UTILITY references confirm integration with the HR security and utility framework, while DT_API indicates involvement in the date-tracked delete pattern common to date-effective HRMS tables.

Usage Notes

PAY_ITR_DEL is an internal package. It is not referenced by any other database object and is not a supported integration point for custom code. In practice it is invoked indirectly, either from the iterative rules maintenance form within the payroll configuration UI or from internal concurrent processing that purges or restructures iterative rule definitions. Custom extensions that need to add or remove iterative rules should call the public business API (PAY_ITR_BUS) rather than PAY_ITR_DEL directly, so that validation, audit shadowing, and date-track integrity are preserved. Because the package performs DML, any direct call requires correct APPS context and effective-dated key values. Customers upgrading between 12.1.1 and 12.2.2 should treat the package as version-managed and revalidate any wrapper code after patching.