Delete HRMS Job API

DECLARE
   p_validate   BOOLEAN;
   v_validate   BOOLEAN := FALSE;

   CURSOR c1
   IS
  
   select job_id,object_version_number from per_jobs where job_id = 35952;
  
BEGIN
   FOR a IN c1
   LOOP
     hr_job_api.delete_job (p_validate => v_validate,
                                       p_job_id => a.job_id,
                                       p_object_version_number => a.object_version_number
      );
   END LOOP;
END;