Search Results per_sps_del




Overview
Explore in AI Chat

Overview

PER_SPS_DEL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the deletion (DML) logic for the Spinal Point Steps entity within the Oracle Human Resources (HR) and Payroll product family. "SPS" denotes Spinal Point Steps, a component of the grade/step framework used to define pay progression structures for employees, most notably in public sector and other regulated payroll environments where grades are divided into discrete incremental steps (spinal points).

The package operates as a low-level data manipulation utility rather than a business-facing API. Its documented API classification is OTHER, confirming that it is intended for internal use by higher-level HR packages and forms rather than for direct invocation by external or custom code. It functions as a subordinate routine that supports the wider PER_SPS family of packages responsible for creating, updating, and removing spinal point step definitions.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package:

  • DELETE_DML — The core data manipulation routine responsible for physically removing spinal point step records from the underlying base tables. It performs the actual delete operations against the entity's transactional tables.
  • DEL — The public entry point for the deletion operation. This procedure wraps the deletion logic and is the routine invoked by callers within the PER_SPS package family, notably PER_SPS_UPD.
  • A third documented procedure/function completes the package's public interface; consistent with the naming pattern, it supports the deletion workflow. Parameter lists are not enumerated in the ETRM metadata and should be obtained from the database package specification.

The separation of DEL and DELETE_DML reflects a common EBS design pattern in which the outer routine handles validation and orchestration while the inner routine performs the raw DML.

Tables Accessed

The package references two base tables through APPS synonyms:

  • PER_GRADE_SPINES_F — The grade spinal definition table, holding the header records that define a spinal point structure attached to a grade.
  • PER_SPINAL_POINT_STEPS_F — The spinal point step table, holding the individual step (increment) records belonging to a spinal structure. This is the child entity from which PER_SPS_DEL removes rows.

Both tables use the _F suffix characteristic of EBS date-tracked (datetrack) tables, indicating that deletions must respect the effective-dating model. The package also reads the shadow table PER_SPS_SHD, which stores the audit/history image of spinal point step changes, ensuring the removal of a step is reflected in the corresponding shadow record.

Usage Notes

PER_SPS_DEL is not exposed directly to end users or to the concurrent manager. It is invoked programmatically:

  • Package-to-package calls — The dependency metadata shows PER_SPS_DEL is referenced by PER_SPS_UPD, which coordinates updates and deletions of spinal point steps. It is also referenced by HR_GRADE_STEP_API, the public grade/step API, and by itself.
  • Forms — Grade and spinal point maintenance forms on the HR responsibility indirectly trigger this package when a user deletes a step record, via the calling API layer.
  • Custom code — Customizations requiring deletion of spinal point steps should call HR_GRADE_STEP_API or PER_SPS_UPD rather than PER_SPS_DEL directly, to ensure datetrack integrity and shadow-table synchronization are preserved. Direct calls bypass the validation and audit handling provided at the higher layers.

Because the package manipulates datetracked HR data, any use should occur within a properly initialized HR session and be committed only after full validation of dependent grade and payroll element links.