Search Results per_valid_grades_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_VALID_GRADES_PKG is a server-side PL/SQL package in Oracle EBS Human Resources (PER) that maintains the integrity of valid grade definitions — the intersection records that authorize a specific grade for use with a specific job within a business group. The package body (pevgr01t.pkb, version 120.0.12020000.2) supports the validation and retrieval logic required by the Grade and Valid Grades setup forms, and is classified as an OTHER API rather than a public interface. It bundles grade-name lookup, primary-key sequence generation, and uniqueness and date-range validation for the PER_VALID_GRADES entity, allowing the Oracle Forms layer to centralize these checks rather than embed them in form triggers.

Key Procedures and Functions

  • GET_GRADE — Retrieves the grade name for a supplied grade identifier by querying the PER_GRADES_VL view. This is the procedure matched by the user's "get_grade" search and is the most commonly referenced entry point in the package. If no row is found, it raises the standard HR error message HR_6153_ALL_PROCEDURE_FAIL with the procedure name and step token populated.
  • GET_NEXT_SEQUENCE — Returns the next available primary key from the PER_VALID_GRADES_S sequence when the incoming identifier is null, supporting new-row inserts into the valid grades table.
  • CHECK_UNIQUE_GRADE — Verifies that a grade assignment is not duplicated for a given business group, job, and grade, while excluding the current row from the comparison during updates. Date-range parameters were added to restrict the uniqueness check to an effective period, reflecting the dated nature of grade and job relationships.
  • CHECK_DATE_FROM and CHECK_DATE_TO — Validate the effective start and end dates of a valid grade record, ensuring the date range is coherent and consistent with the parent job and grade definitions.

Tables Accessed

The package operates against three documented objects exposed through APPS synonyms. PER_GRADES (read via the PER_GRADES_VL view) supplies the grade name returned by GET_GRADE and is the reference for grade validation. PER_VALID_GRADES is the transactional table validated by CHECK_UNIQUE_GRADE, CHECK_DATE_FROM, and CHECK_DATE_TO, and its rowid is used to exclude the current record during update. PER_VALID_GRADES_S is the sequence backing GET_NEXT_SEQUENCE for primary-key generation.

Usage Notes

The package is invoked from the Oracle HRMS Grade and Valid Grades forms, where it supplies grade-name display values, new surrogate keys, and pre-insert and pre-update validation. It is not documented as being referenced by any other package, so custom integrations should treat it as an internal helper and avoid direct dependency where a supported public API exists. Because GET_GRADE and CHECK_UNIQUE_GRADE depend on the effective dates and business-group context of the calling form, callers must populate the business group, job, grade, and date parameters consistently with the form session. Behavior is identical across EBS 12.1.1 and 12.2.2; the source header indicates the current file revision is aligned to the 12.2.0 code line, with earlier fixes such as the PER_GRADES_VL synonym change (Bug 13538388) and dated uniqueness checks (Bug 3338072) already incorporated.