Search Results hr_grade_step_api




Overview
Explore in AI Chat

Overview

APPS.HR_GRADE_STEP_API is a public PL/SQL API package that provides programmatic maintenance of grade steps within Oracle E-Business Suite Human Resources. A grade step represents a discrete progression point within a grade scale, and each step is linked to a specific point in the associated pay scale. The package therefore sits at the intersection of grade scale definition and pay scale configuration, allowing administrators and integrators to build and alter step structures without direct table manipulation. The package is declared AUTHID CURRENT_USER and is licensed for use with Human Resources, as stated in its embedded REP header. The documented display name is "Grade Step," and the package is classified as an API in the ETRM repository for release 12.2.2, where it is owned by the APPS schema.

Key Procedures and Functions

  • CREATE_GRADE_STEP — Creates a new grade step for a given grade scale. The step is linked to a point in the pay scale associated with the parent grade scale. Prerequisites are that a grade scale already exists and that a pay scale point exists in the associated pay scale. On success the grade step is created; on failure no step is created and an error is raised. The procedure supports a validation-only mode and a DateTrack effective date, and it accepts a business group identifier that must match the business group of the parent grade scale.
  • UPDATE_GRADE_STEP — Modifies the definition of an existing grade step, including the pay scale point to which the step is linked. Because grade step data is DateTracked, updates are applied with respect to an effective date so that historical definitions remain intact and future-dated changes take effect at the appropriate point in time.
  • DELETE_GRADE_STEP — Removes a grade step from the grade scale. As with the other operations, deletion is DateTrack-aware and subject to the standard validation behavior of the package.

Each of the documented procedures follows the package's common API conventions: a validation flag that allows callers to verify data without committing changes, an effective date that governs the DateTrack operation, and standard error signaling on failure. Parameter-level details should be taken from the package specification rather than inferred.

Tables Accessed

The package operates against PER_SPINAL_POINT_STEPS_F, referenced through an APPS synonym. This table stores the grade step definitions and the link between each grade step and its corresponding pay scale point (spinal point). The create, update, and delete procedures all resolve to inserts, DateTracked updates, and DateTracked deletions against this table. The parent grade scale and pay scale records are prerequisites validated by the API rather than owned by it.

Usage Notes

HR_GRADE_STEP_API is typically invoked from the Grade Steps maintenance function within the Human Resources grade structures setup, from custom PL/SQL that provisions grade scales in bulk as part of an implementation or data migration, and from integration code that synchronizes grade structures with external compensation systems. Two other packages in the ETRM repository reference this package, indicating that other application logic also depends on it. Custom callers should supply a valid business group matching the parent grade scale, use the validate mode first in test environments, and choose effective dates deliberately because step records are DateTracked. Direct DML against PER_SPINAL_POINT_STEPS_F should be avoided in favor of this API so that the DateTrack and validation rules are consistently applied. The package is available in both 12.1.1 and 12.2.2 environments.