Oracle HRMS API – Create or Update Employee Salary

Posted by PRajkumar on Oracle Blogs See other posts from Oracle Blogs or by PRajkumar
Published on Sat, 9 Jun 2012 21:01:33 +0000 Indexed on 2012/06/09 22:44 UTC
Read the original article Hit count: 983

Filed under:

API --  hr_maintain_proposal_api.cre_or_upd_salary_proposal

 

Note - Salary Basis is required to be assigned to employee assignment before to run Salary Proposal API

Example --

 

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;
/

SHOW ERR;

 

© Oracle Blogs or respective owner

Related posts about /Oracle