Saturday Jun 09, 2012

Oracle HRMS API – Create Employee Payment Method

API --  hr_personal_pay_method_api.create_personal_pay_method

 

Example --

DECLARE  
ln_method_id  PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE;
ln_ext_acc_id        PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE;
ln_obj_ver_num    PAY_PERSONAL_PAYMENT_METHODS_F.OBJECT_VERSION_NUMBER%TYPE;
ld_eff_start_date   DATE;  
ld_eff_end_date    DATE;
ln_comment_id     NUMBER;


BEGIN
     -- Create Employee Payment Method
     -- --------------------------------------------------
      hr_personal_pay_method_api.create_personal_pay_method
      (   -- Input data elements
          -- ------------------------------
          p_effective_date                                     => TO_DATE('21-JUN-2011'),
          p_assignment_id                                   => 33561,
          p_org_payment_method_id               => 2,
          p_priority                                                 => 50,
          p_percentage                                           => 100,
          p_territory_code                                     => 'US',
          p_segment1                                              => 'PRAJKUMAR',
          p_segment2                                              => 'S',
          p_segment3                                              => '100200300',
          p_segment4                                              => '567',
          p_segment5                                              => 'HDFC',
          p_segment6                                              => 'INDIA',
          -- Output data elements
          -- --------------------------------
          p_personal_payment_method_id   => ln_method_id,
          p_external_account_id                       => ln_ext_acc_id,
          p_object_version_number                  => ln_obj_ver_num,
          p_effective_start_date                          => ld_eff_start_date,
          p_effective_end_date                           => ld_eff_end_date,
         p_comment_id                                        => ln_comment_id
     );
 
 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