HRMS Delete Employee API
Hi guys today we will explain HRMS Delete Employee API
DECLARE CURSOR c1 IS SELECT person_id FROM per_all_people_f; --WHERE Person_id = 1 l_cnt NUMBER := 0; BEGIN FOR x IN c1 LOOP BEGIN hr_person_delete.delete_a_person (x.person_id, FALSE, SYSDATE); l_cnt := l_cnt + 1; EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line (SQLERRM); END; END LOOP; Commit; DBMS_OUTPUT.put_line (l_cnt || ' persons deleted'); END;
