Search Results valid_grade

Overview

PER_VGR_BUS is a business-layer PL/SQL package in the APPS schema that encapsulates the validation logic for the Valid Grades entity in Oracle Human Resources. Valid Grades define which grade combinations are permissible within a grade structure or grade ladder, and the records created and maintained through this entity are stored in the PER_VALID_GRADES table. The package acts as the transactional engine behind the Valid Grades maintenance screen, providing the row-level validation that fires when users insert, update, or delete valid grade definitions.

Rather than exposing database constraints directly to the form or to concurrent processes, Oracle EBS routes these operations through PER_VGR_BUS so that business rules—such as ensuring a grade belongs to the correct business group, confirming the grade is valid for the applicable legislation, and preventing duplicate or circular grade combinations—are applied consistently regardless of the entry point. The package is classified as OTHER in the ETRM API registry, indicating it is an internal business component rather than a published public API.

Key Procedures and Functions

The documented interface consists of four callable units:

• INSERT_VALIDATE — Validates a new Valid Grades record before it is committed. It confirms that the proposed grade relationship is permissible and that all mandatory attributes are consistent with the parent grade structure.
• UPDATE_VALIDATE — Validates modifications to an existing Valid Grades record, ensuring that changes do not violate grade structure integrity or introduce invalid combinations.
• DELETE_VALIDATE — Determines whether an existing Valid Grades record may be removed, guarding against deletion that would leave dependent grade data in an inconsistent state.
• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the Valid Grades context. This supports the legislative filtering that governs which grades and grade rules are valid for a given business group's country-specific configuration.

These procedures follow the standard Oracle HRMS pattern of separating validation from the actual DML, which is performed by the companion table handlers PER_VGR_INS, PER_VGR_UPD, and PER_VGR_DEL.

Tables Accessed

• PER_VALID_GRADES — The primary entity table holding Valid Grades definitions. The package reads and validates against it to enforce integrity of the grade relationship records.
• PER_GRADES — The grade definition table, referenced to confirm that the grades involved in a valid grade relationship exist and carry the expected attributes, including the legislation context returned by RETURN_LEGISLATION_CODE.

The ETRM dependency report also lists the shadow table PER_VGR_SHD, which reflects the audit/history copy maintained for the Valid Grades entity.

Usage Notes

PER_VGR_BUS is invoked indirectly. The Valid Grades form calls the table handlers PER_VGR_INS, PER_VGR_UPD, and PER_VGR_DEL, which in turn call the corresponding *_VALIDATE procedures in this package before committing changes to PER_VALID_GRADES. The ETRM metadata confirms this direction of dependency: PER_VGR_BUS is referenced by those three handlers rather than referencing them.

Because the validation routines are bound into the standard form processing flow, custom code that manipulates Valid Grades records directly should call PER_VGR_BUS validation procedures before issuing DML, to preserve the same business rules the seeded forms enforce. The package is version-independent in behavior across EBS 12.1.1 and 12.2.2, with the only notable difference being the alternate APPS synonym resolution in the 12.2 online patching edition. Direct invocation by concurrent programs is uncommon; the package is predominantly a form-driven validation component.