HRMS Delete Positions API
Declare l_rows_processed NUMBER := 0; l_commit_point NUMBER := 250; l_batch_run_number hr_api_batch_message_lines.batch_run_number%TYPE; l_dummy_line_id hr_api_batch_message_lines.line_id%TYPE; l_sequence NUMBER := 0; V_job_id number := 62; -------------------- -- Out Parameters -- -------------------- l_position_id NUMBER; l_object_version_number NUMBER; l_position_definition_id NUMBER; l_name VARCHAR2(1000); V_Error varchar2(3000); -- Cursor Pos is select * from HR_ALL_POSITIONS_F where position_id = 14428; BEGIN FOR i IN pos LOOP BEGIN l_position_id := NULL; l_object_version_number := NULL; l_position_definition_id := NULL; l_name := NULL; hr_position_api.DELETE_POSITION(p_validate => FALSE ,p_position_id => i.position_id ,p_object_version_number => i.object_version_number ); Commit; dbms_output.put_line('Done'); EXCEPTION WHEN OTHERS THEN V_Error := SQLERRM; dbms_output.put_line(v_error); END; END LOOP; END ;