API创建员工支付方式

[sql]  view plain copy

1. DECLARE     
2. ln_method_id  PAY_PERSONAL_PAYMENT_METHODS_F.PERSONAL_PAYMENT_METHOD_ID%TYPE;   
3. ln_ext_acc_id        PAY_EXTERNAL_ACCOUNTS.EXTERNAL_ACCOUNT_ID%TYPE;   
4. ln_obj_ver_num    PAY_PERSONAL_PAYMENT_METHODS_F.OBJECT_VERSION_NUMBER%TYPE;   
5. ld_eff_start_date   DATE;     
6. ld_eff_end_date    DATE;   
7. ln_comment_id     NUMBER;   
8.   
9.    
10. BEGIN   
11.      -- Create Employee Payment Method   
12.      -- --------------------------------------------------   
13.       hr_personal_pay_method_api.create_personal_pay_method   
14.       (   -- Input data elements   
15.           -- ------------------------------   
16.           p_effective_date                                     => TO_DATE('21-JUN-2011'),   
17.           p_assignment_id                                   => 33561,   
18.           p_org_payment_method_id               => 2,   
19.           p_priority                                                 => 50,   
20.           p_percentage                                           => 100,   
21.           p_territory_code                                     => 'US',   
22.           p_segment1                                              => 'PRAJKUMAR',   
23.           p_segment2                                              => 'S',   
24.           p_segment3                                              => '100200300',   
25.           p_segment4                                              => '567',   
26.           p_segment5                                              => 'HDFC',   
27.           p_segment6                                              => 'INDIA',   
28.           -- Output data elements   
29.           -- --------------------------------   
30.           p_personal_payment_method_id   => ln_method_id,   
31.           p_external_account_id                       => ln_ext_acc_id,   
32.           p_object_version_number                  => ln_obj_ver_num,   
33.           p_effective_start_date                          => ld_eff_start_date,   
34.           p_effective_end_date                           => ld_eff_end_date,   
35.          p_comment_id                                        => ln_comment_id   
36.      );   
37.     
38.  COMMIT;   
39.   
40.   
41. EXCEPTION   
42.           WHEN OTHERS THEN   
43.                           ROLLBACK;   
44.                            dbms_output.put_line(SQLERRM);   
45. END;