/* 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;
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