Search Results per_vgr_ins




Overview
Explore in AI Chat

Overview

PER_VGR_INS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, delivered as part of the Oracle Human Resources (PER) product family. Its name follows the standard EBS object-naming convention for a row-level insert handler: the "VGR" component denotes Valid Grades, the "INS" suffix denotes insert. The package sits at the lowest tier of the Valid Grades maintenance stack, beneath the business logic package PER_VGR_BUS, the row-level insert validation package PER_VGR_RKI, and the shadow (audit) package PER_VGR_SHD. Together these components implement the table handler pattern used extensively throughout Oracle HRMS, in which every DML operation against a datetracked entity is routed through a dedicated, validated code path rather than issued directly against the table.

The object is reported with a status of VALID in ETRM 12.2.2 and is classified as an "OTHER" API, meaning it is not published as a supported public interface. It is a private implementation building block.

Key Procedures and Functions

ETRM documents a single program unit within the package body: the procedure INS. Consistent with the naming and the package's position in the handler stack, INS performs the physical insertion of one valid-grade row into the underlying PER_VALID_GRADES table, given pre-validated and derived column values supplied by its callers. It is the terminal write step in the insert chain: the business package PER_VGR_BUS assembles and normalizes the payload, PER_VGR_RKI applies row-level validation and datetrack checks, and PER_VGR_INS commits the row image to the table. ETRM does not publish a parameter list for INS, and no public signature should be assumed; callers within the stack are the only supported consumers.

Tables Accessed

  • PER_VALID_GRADES — the base table holding valid grade records (the association between a grade and an organization or other parent entity, effective-dated). This is the target of the insert operation performed by INS.
  • PER_VALID_GRADES_S — the corresponding shadow/audit table. Inserts into HRMS datetracked entities are mirrored into the shadow table so that audit history and datetrack corrections can be reconstructed; the shadow write is the responsibility of PER_VGR_SHD, invoked alongside this package.

Documented dependencies also include the HR_API and HR_UTILITY packages, which supply shared HRMS plumbing such as error handling, message lookup, and datetrack helper routines, and the SYS objects DUAL and STANDARD. The reference to PER_VGR_INS from within its own dependency list reflects the package specification being visible to the body.

Usage Notes

PER_VGR_INS is not intended for direct invocation by customers or by custom code. ETRM records that it is not referenced by any other database object outside the Valid Grades stack and that it is referenced by one other package — consistent with PER_VGR_BUS being the sole caller. The supported entry point for creating valid grade records is the Oracle HRMS forms and the published business APIs, which resolve to PER_VGR_BUS and then descend through PER_VGR_RKI to PER_VGR_INS.

In practice, the package executes during the maintenance of grade validity in the Grades window of the HRMS application, and during any bulk load or conversion that creates valid grade rows through the supported API layer. Because bypassing the handler stack would skip datetrack validation and shadow-table auditing, direct DML against PER_VALID_GRADES or direct calls to PER_VGR_INS should be avoided in all release levels, including 12.1.1 and 12.2.2.