Search Results get_dml_operation

Overview

APPS.PQH_GSP_GRD_STEP_REMOVE is a PL/SQL package body that forms part of the Oracle E-Business Suite grade and grade step (GSP) workforce management infrastructure. Its principal business function is to remove, purge, and unlink grade step related data that has been staged or captured as part of the Grade Step Placement (GSP) processing flows. The package operates against the copy entity results framework (BEN_COPY_ENTITY_RESULTS) that Oracle HRMS uses to track DML operations performed during entity copy, purge, and removal operations. In EBS 12.1.1 and 12.2.2 this family of packages is invoked during the cleanup of grade step placement records, eligibility profiles, optional (OPT) associations, and OIPL/PLIP assignment records, allowing administrators to reverse or purge grade step data without leaving orphaned rows in dependent tables.

Key Procedures and Functions

The package exposes eleven documented program units. The two helper functions, GET_OVN and GET_DML_OPERATION, retrieve the object version number and DML operation type respectively from the BEN_COPY_ENTITY_RESULTS record identified by a copy entity result identifier. These values are consumed by the removal procedures to perform consistent, version-checked deletes.

• PURGE_PAY_SCALE — purges pay scale data associated with a removed grade step.
• PURGE_OPT_ABR_HRRATE_CRRATE — purges optional absence, HR rate, and CR rate records tied to the grade step.
• REMOVE_ELIG_PROFILE — removes eligibility profile associations linked to the grade step.
• REMOVE_OPT — removes optional (OPT) records related to the grade step.
• REMOVE_OIPL_STEP_FLAVOUR — removes OIPL step flavour records.
• REMOVE_OIPL_POINT_FLAVOUR — removes OIPL point flavour records.
• REMOVE_OIPL — removes OIPL assignment records associated with the grade step.
• REMOVE_PLIP — removes PLIP records associated with the grade step.
• UNLINK_OPT_ABR_HRRATE_CRRATE — unlinks (rather than purges) optional absence, HR rate, and CR rate records, preserving the underlying data while severing the association.

Tables Accessed

The only table documented in the ETRM metadata is BEN_COPY_ENTITY_RESULTS (referenced through an APPS synonym). The package reads this table to obtain the object version number and DML operation for a given copy entity result, and delegates the actual deletion of the staged entity result row to BEN_COPY_ENTITY_RESULTS_API.DELETE_COPY_ENTITY_RESULTS. This pattern ensures that the underlying grade step removal is recorded and version-controlled through Oracle’s standard copy entity results framework rather than through direct DML against grade step tables. Because the package is classified as API type "OTHER" and is referenced by one other package, it is expected that the removal procedures target additional grade-step-related tables that are not enumerated in the excerpted metadata.

Usage Notes

PQH_GSP_GRD_STEP_REMOVE is typically invoked indirectly rather than from end-user forms. In the 12.1.1 and 12.2.2 code lines, packages in this family are called by higher-level GSP processing packages — reflected here by the single "referenced by" dependency — during grade step placement copy, purge, and removal operations. Custom code and extensions that need to programmatically reverse a grade step placement should call the appropriate REMOVE_* or PURGE_* procedure, supplying the copy entity result identifier and effective date, rather than deleting rows directly. The get_ovn and get_dml_operation helpers illustrate the mandatory version-check pattern: callers must pass a valid object_version_number (or rely on the default null to have it looked up) so that the removal is guarded against concurrent modification. The inclusion of HR_UTILITY.SET_LOCATION calls throughout indicates the package is designed for use with the standard HRMS debug and trace facility, so DBMS_OUTPUT or HR_UTILITY tracing can be enabled when diagnosing removal failures.