Search Results per_vgr_del




Overview
Explore in AI Chat

Overview

PER_VGR_DEL is a PL/SQL package owned by the APPS schema that serves as the delete-handler utility for the Valid Grades entity within Oracle Human Resources. Valid Grades define the grade ranges that are permissible for a given business group, grade structure, or assignment, and they form part of the validation framework that governs grade entry across HR and Payroll transactions. The package encapsulates the deletion logic required to remove a valid grade record while preserving referential integrity and triggering the appropriate runtime behavior expected by the surrounding HR APIs. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases the object is shipped with a VALID status, confirmed by its presence in the ETRM inventory under the OTHER API classification, meaning it is an internal supporting package rather than a formally published public API. Its name follows the standard Oracle HR naming convention in which the PER_ prefix denotes a Human Resources object and the _DEL suffix denotes a delete operation.

Key Procedures and Functions

The ETRM metadata documents a single program unit within the package, identified as DEL. Consistent with the naming convention used throughout the HR API family, DEL is the procedure responsible for performing the removal of a valid grade. Although the metadata does not publish a parameter list, the procedure is designed to be invoked against an existing valid grade record and to carry out the deletion in a controlled manner, including any validation or cleanup logic that the application expects before the row is removed. No additional procedures or functions are documented, indicating that the package is deliberately narrow in scope and is not intended as a general-purpose utility library.

Tables Accessed

The documented table reference for PER_VGR_DEL is PER_VALID_GRADES, which is accessed through an APPS synonym. This is the base table that stores valid grade definitions, and it is the target of the delete operation performed by the DEL procedure. The package does not, according to the documented metadata, reference any other application tables directly. The dependency listing shows that PER_VGR_DEL also references PER_VGR_SHD, the shadow table associated with the Valid Grades entity. Shadow tables in Oracle HR hold the original values of a record as it is modified, so their involvement in the delete path is consistent with the auditing and history-tracking behavior applied to HR setup data.

Usage Notes

PER_VGR_DEL is not typically called directly by end users or by custom code. It is referenced by three other packages — HR_JOB_API, HR_POSITION_API, and HR_PSF_DEL — which means it is invoked indirectly when jobs, positions, or position setup records that carry valid grade associations are deleted. The package also references itself, confirming that recursion or internal reuse occurs within its own deletion logic. In practice, the delete of a valid grade is initiated either from the Oracle HR forms that maintain grade setup or through the higher-level APIs named above, and PER_VGR_DEL performs the underlying work. Developers extending or integrating with HR should treat the package as internal infrastructure: customizations should call the supported public APIs such as HR_JOB_API and HR_POSITION_API rather than PER_VGR_DEL, and any direct dependency on its DEL procedure should be validated against both the 12.1.1 and 12.2.2 code lines, since Oracle may alter internal package signatures between releases without prior notice.