Search Results pay_pgr_del




Overview
Explore in AI Chat

Overview

PAY_PGR_DEL is a PL/SQL package owned by the APPS schema that supports the Oracle Payroll "Grade Rules" (PGR) feature set. Grade rules define the relationship between grade steps and the rate values that apply to an employee's assignment, and they are maintained through the Grade Rule Rate Value window in the Oracle HRMS Payroll application. The package name follows the standard EBS naming convention for the family of Grade Rules programs, where the "PGR" prefix denotes Payroll Grade Rules and the "_DEL" suffix denotes deletion logic.

The object is documented as VALID in the ETRM repository with an API classification of OTHER, indicating that it is an internal supporting package rather than a formally published public API. Its principal role is to perform the removal of grade rule rate value records from the underlying tables, isolating that delete logic so that other Grade Rules programs can invoke it without duplicating the DML.

Key Procedures and Functions

The package exposes three documented procedures or functions. Note that ETRM does not publish formal parameter lists for these units, so only their purpose is described here.

  • DELETE_DML — Performs the core data manipulation operation that removes the target grade rule rate value rows. This is the workhorse routine that carries out the actual delete on the underlying table, and it is the entry point that sibling packages such as PAY_PGR_UPD call when a rate value must be purged.
  • DEL — The wrapper or driver routine for the deletion process. It orchestrates the delete operation, providing the callable interface through which the Grade Rules forms and concurrent logic request that one or more grade rule rate values be removed.
  • The package definition also documents the standard package specification and body units, which hold no independent business logic but expose the procedures above to the calling applications.

Tables Accessed

PAY_PGR_DEL references the table PAY_GRADE_RULES_F through the APPS synonym layer. PAY_GRADE_RULES_F is the Grade Rules base table in the Payroll (PAY) schema. It stores the grade rule definitions that tie a grade, grade step, and rate to a specific validity period. Because this is a delete-oriented package, the access against PAY_GRADE_RULES_F is primarily DML — removal of rate value rows that are no longer required or that have been superseded. The package additionally depends on the PAY_PGR_SHD shadow or history package, which maintains the corresponding audit and date-tracked versions of the Grade Rules records.

Usage Notes

PAY_PGR_DEL is not intended to be called directly by end users. It is invoked in the following contexts:

  • Grade Rule Rate Value form — When a user deletes a rate value line in the Payroll Grade Rule Rate Value window, the form logic delegates the physical delete to this package.
  • PAY_PGR_UPD — The update package for Grade Rules references PAY_PGR_DEL, allowing an update operation to remove obsolete rate rows as part of a broader maintenance action.
  • HR_RATE_VALUES_API — The public rate values API references PAY_PGR_DEL, so deletions driven through the API may cascade into this package's DELETE_DML routine.

Customizations should never call PAY_PGR_DEL in isolation. Because the package bypasses the public HR_RATE_VALUES_API and writes directly to PAY_GRADE_RULES_F, direct invocation risks leaving the shadow records in PAY_PGR_SHD, and any dependent derived rate data, out of synchronization. Custom code should always prefer HR_RATE_VALUES_API, which in turn manages PAY_PGR_DEL appropriately within a controlled transaction.