Oracle HRMS API – Create or Update Employee Salary

Oracle HRMS API – Create or Update Employee Salary

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;