oracle預存程序

create or replace procedure Proc_Update_StaffInfo
is
  temp number;
  cursor cur_staff is select * from HR_RS_Staff where Deleted = 0 and sysdate > EntryTime + 365;
begin
    for u in cur_staff
      loop
        temp :=  mod(floor(sysdate - to_date(u.EntryTime,'yyyy-MM-dd')),365);

        if temp <> 0 then
          -- 員工企齡
          update HR_RS_Staff set EnterprisesAge = EnterprisesAge + 1 where ID = u.ID;
         
          -- 員工年假資訊
          select count(*) into temp from HR_KQ_StaffAnnualLeave where ID = u.ID;
          if temp = 0 then
            insert into HR_KQ_StaffAnnualLeave(ID, Staffid, Numberofdays, Deleted, Createtime, Modifytime)values(u.ID, u.ID, 5, 0, sysdate, sysdate);
          else
            update HR_KQ_StaffAnnualLeave set Numberofdays = 40 where ID = u.ID;
          end if;
        end if;
      end loop;
end;