Search Results per_vgr_upd




Overview
Explore in AI Chat

Overview

PER_VGR_UPD is a PL/SQL package in the APPS schema responsible for maintaining valid grade records within Oracle E-Business Suite. Its name follows the Oracle naming standard for the Valid Grades entity: "PER" identifies the Human Resources (People) product family, "VGR" denotes "Valid Grade," and the "UPD" suffix indicates the package's role as an update handler. The package operates against the PER_VALID_GRADES table, the repository that stores the grade definitions attached to positions and jobs within an enterprise's grade structure.

PER_VGR_UPD functions as an internal validation and update layer rather than an end-user facing API. It is classified as an "OTHER" API in the ETRM documentation, confirming that it is not one of the published business APIs supported for external customer use. Oracle exposes the package as an implementation detail that supports the higher-level HR_JOB_API and HR_POSITION_API business interfaces. The package status is VALID in both 12.1.1 and 12.2.2, indicating it is a compiled, functioning object in the shipped product.

Key Procedures and Functions

The documented metadata lists a single public procedure:

  • UPD — The update entry point for valid grade information. It accepts and applies changes to grade definitions associated with jobs and positions, performing the row-level validation and persistence logic needed to keep PER_VALID_GRADES consistent. Its companion logic is stored in the package body and additionally depends on the PER_VGR_SHD shared code package, which is the standard Oracle mechanism for holding common validation and data-fetch routines shared across related Valid Grade packages.

No parameter lists are published in the ETRM metadata; the procedure signature is Oracle-proprietary and should not be treated as a stable integration contract.

Tables Accessed

  • PER_VALID_GRADES — The sole documented table reference, accessed through an APPS synonym. This table stores the effective-dated grade records valid for a given job or position. The package reads existing rows, validates proposed changes against the grade hierarchy and date-effectivity rules, and writes the updated grade assignments as part of the UPD operation.

Usage Notes

PER_VGR_UPD is invoked indirectly through the HR business APIs. The documented dependency list shows that HR_JOB_API and HR_POSITION_API both reference PER_VGR_UPD, meaning that grade maintenance performed through the jobs or positions forms in the Oracle HR application is ultimately routed through this package. The package also appears in its own referenced-by list, indicating internal recursive or overloaded calls within the package body.

In addition to the HR APIs, the Oracle HRMS Forms layer and any concurrent process that modifies job-grade or position-grade associations rely on this package's update logic. Custom development should not call PER_VGR_UPD directly; integrations that must maintain valid grades should be built on HR_JOB_API or HR_POSITION_API, which encapsulate the same validation while remaining supported. Because PER_VGR_UPD is an undocumented internal object, its signature may change without notice across patches or point releases; any custom code that currently calls it should be scheduled for replacement with the supported APIs before upgrade to 12.2.2 or later.