ORA-20001: You cannot update an approved salary date When Running API(hr_maintain_proposal_api.cre_o

set serveroutput on;

 

 declare

 l_object_version_number   number;

 l_inv_next_sal_date_warning boolean;

 l_proposed_salary_warning  boolean;

 l_approved_warning     boolean;

 l_payroll_warning      boolean;

 l_pay_proposal_id      number;

 l_counter          number:=0;

 

 cursor cr_proposal is

  select pay_proposal_id, object_version_number from per_pay_proposals

  where 1=1

  and change_date = to_date('05-JUN-2008','DD-MON-YYYY')

  and assignment_id in (1215);

      

 begin

dbms_output.put_line(' salary updates starts.');

 open cr_proposal;

  loop

   fetch cr_proposal into l_pay_proposal_id, l_object_version_number;

   exit when cr_proposal%NOTFOUND;

 hr_maintain_proposal_api.update_salary_proposal(