Saturday Jun 09, 2012

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;

 

About

Welcome to My Oracle World Puneet Rajkumar

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today