API创建员工支付方式

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;