Friday, 6 June 2014

Delete HRMS Position API

/* Formatted on 6/6/2014 11:37:49 AM (QP5 v5.115.810.9015) */
DECLARE
   p_validate   BOOLEAN;
   v_validate   BOOLEAN := FALSE;

   CURSOR c1
   IS
      SELECT position_id, object_version_number
      FROM per_all_positions
      WHERE position_id = 60491;
BEGIN
   FOR a IN c1
   LOOP
      hr_position_api.delete_position (p_validate => v_validate,
                                       p_position_id => a.position_id,
                                       p_object_version_number => a.object_version_number
      );
   END LOOP;
END;

No comments:

Post a Comment