Terminating an Employee using API in HRMS

I have created this procedure to terminate an employee using API but it doesn't change anything in the employee screen

please advice .

Create or replace PROCEDURE  XX_API_END_QA (EMP_NB in number) IS

   Cursor c_emp_cur Is

         Select ppos.period_of_service_id

               ,ppos.object_version_number

               ,papf.person_type_id

         From per_all_people_f papf

             ,per_periods_of_service ppos

         Where papf.person_id = ppos.person_id

         And sysdate Between papf.effective_start_date and papf.effective_end_date

         And sysdate between ppos.date_start And coalesce(ppos.projected_termination_date,actual_termination_date,sysdate)