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 ;