api to delete employee in oracle hrms

api to delete employee in oracle hrms

In this post , We will be discuss about api to delete employee in oracle hrms. Oracle has given the standard api to delete the employees in oracle apps. This is the complete script to delete the employee record in oracle hrms. Standard API HR_PERSON_API.DELETE_PERSON is used to delete the employee record in oracle hrms. Please find below the detail script using api to delete employee in oracle hrms.

Detail Script using api to delete employee in oracle hrms

DECLARE

  v_validate BOOLEAN    := FALSE;

  v_effective_date DATE := sysdate;

  l_person_id                 NUMBER    := 0;

  l_perform_predel_validation BOOLEAN   := FALSE;

  l_person_org_manager_warning VARCHAR2(2000);

BEGIN

                         hr_person_api.delete_person(v_validate         => l_validate ,

                              p_effective_date             => v_effective_date ,

                              p_person_id                  => 2499 ,

                              p_perform_predel_validation  => l_perform_predel_validation ,

                              p_person_org_manager_warning => l_person_org_manager_warning );

                                                dbms_output.put_line('Employee has been deleted successfully');

                                                COMMIT;

EXCEPTION

WHEN OTHERS THEN

  dbms_output.put_line('Error : ' || sqlerrm);

END;

/

api to delete employee in oracle hrms