API创建/更新员工薪水

DECLARE 
    lb_inv_next_sal_date_warning      BOOLEAN; 
    lb_proposed_salary_warning         BOOLEAN; 
    lb_approved_warning                       BOOLEAN; 
    lb_payroll_warning                            BOOLEAN; 
    ln_pay_proposal_id                           NUMBER; 
    ln_object_version_number                NUMBER; 
 

BEGIN 
   -- Create or Upadte Employee Salary Proposal 
   -- ---------------------------------------------------------------- 
    hr_maintain_proposal_api.cre_or_upd_salary_proposal 
    (    -- Input data elements 
         -- ------------------------------ 
         p_business_group_id                   => fnd_profile.value('PER_BUSINESS_GROUP_ID'), 
         p_assignment_id                            => 33561, 
         p_change_date                                => TO_DATE('13-JUN-2011'), 
         p_proposed_salary_n                   => 1000, 
         p_approved                                      => 'Y', 
         -- Output data elements 
         -- -------------------------------- 
         p_pay_proposal_id                       => ln_pay_proposal_id, 
         p_object_version_number           => ln_object_version_number,   
         p_inv_next_sal_date_warning  => lb_inv_next_sal_date_warning, 
         p_proposed_salary_warning     => lb_proposed_salary_warning, 
         p_approved_warning                   => lb_approved_warning, 
         p_payroll_warning                        => lb_payroll_warning 
    ); 
  
 COMMIT; 


EXCEPTION 
       WHEN OTHERS THEN 
                          ROLLBACK; 
                          dbms_output.put_line(SQLERRM); 
END;