Page process for deleting rows from EMP and DEPT table.

deleteProc

declare 
  l_emp  apex_application_global.vc_arr2 := apex_util.string_to_table(:p17_empnos);
  l_dept apex_application_global.vc_arr2 := apex_util.string_to_table(:p17_deptnos);
begin
   for i in 1 .. l_emp.count
   loop
      delete from emp  where empno   = l_emp(i);
   end loop;
   for i in 1 .. l_dept.count
   loop
      delete from dept where deptno  = l_dept(i);
   end loop;
end;