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 ;