Search Results per_sps_ins




Overview
Explore in AI Chat

Overview

APPS.PER_SPS_INS is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema (APPS) that supports the Grade Step Placement and spinal point infrastructure within Oracle HRMS. "SPS" refers to Spinal Point System, the mechanism used in HRMS to define incremental pay progression for grades and grade steps. The package's role is centered on the insertion of spinal point definitions, primarily into the grade spine and spinal point tables that underpin salary progression logic.

The package is classified as an "OTHER" API in ETRM metadata for 12.2.2 and is closely related to its sibling packages PER_SPS_BUS, PER_SPS_UPD, and PER_SPS_INS itself (self-referential dependencies via the dependent-code linkage). It has four documented program units, of which the insertion-related procedures perform the operative work. This package is valid and compiled in the APPS schema, indicating it is a supported internal component rather than a stand-alone public API.

Key Procedures and Functions

Four documented program units exist in PER_SPS_INS:

  • SET_BASE_KEY_VALUE — Establishes the base key value used by the insertion routines, typically resolving or assigning the primary key surrogate for a spinal point or grade spine record before the DML is executed.
  • INSERT_DML — Performs the core DML insert operations against the underlying spinal point and grade spine tables. This is the engine that writes the newly constructed record set.
  • INS — The high-level insertion entry point that orchestrates validation, base key resolution, and the subsequent insert DML. Callers invoke this procedure to create a spinal point / grade spine definition.
  • Additional dependent routine — Referenced through APPS.PER_SPS_INS's own dependency chain (e.g., shared internal utilities in PER_SPS_SHD).

No parameter lists are exposed in the metadata; consumers should rely on the documented package specification in the EBS instance for exact signatures.

Tables Accessed

PER_SPS_INS accesses the following tables via APPS synonyms:

  • PER_SPINAL_POINTS — The master spinal point definitions; INS inserts new point records here.
  • PER_SPINAL_POINT_STEPS_F / _S — Date-tracked (F = full, S = shadow) step mappings for spinal points, written by INSERT_DML.
  • PER_GRADE_SPINES_F — Grade-level spine definitions, populated when a grade's progression ladder is created.
  • PER_PARENT_SPINES — Parent spine relationships used to link derived spines to their parents.

Usage Notes

PER_SPS_INS is not typically called directly by end-user forms; it is invoked from HRMS configuration flows such as Grade Step Placement setup and the spinal point definition screens. The package is referenced by HR_GRADE_STEP_API, PER_SPS_BUS, PER_SPS_UPD, and PER_SPS_INS (recursive), indicating it forms the write side of the SPS business layer while PER_SPS_BUS handles business rules and PER_SPS_UPD handles updates. Custom code should prefer the public HRMS APIs (e.g., HR_GRADE_STEP_API) rather than calling PER_SPS_INS directly, because the package performs unguarded DML and assumes base key context has been established. It also relies on the shadow table PER_SPS_SHD and the SYS.STANDARD package. In both 12.1.1 and 12.2.2, the package behaves identically from a caller's perspective; no Online Patching-specific changes are documented.