API创建员工

[sql]  view plain copy

1. DECLARE   
2.   
3.     
4.  lc_employee_number                       PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE    := 'PRAJ_01';   
5.  ln_person_id                                      PER_ALL_PEOPLE_F.PERSON_ID%TYPE;   
6.  ln_assignment_id                             PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;   
7.  ln_object_ver_number                     PER_ALL_ASSIGNMENTS_F.OBJECT_VERSION_NUMBER%TYPE;   
8.  ln_asg_ovn                                          NUMBER;   
9.     
10.  ld_per_effective_start_date             PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;   
11.  ld_per_effective_end_date              PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;   
12.  lc_full_name                                        PER_ALL_PEOPLE_F.FULL_NAME%TYPE;   
13.  ln_per_comment_id                          PER_ALL_PEOPLE_F.COMMENT_ID%TYPE;   
14.  ln_assignment_sequence                 PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE;   
15.  lc_assignment_number                    PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;   
16.     
17.  lb_name_combination_warning   BOOLEAN;   
18.  lb_assign_payroll_warning           BOOLEAN;   
19.  lb_orig_hire_warning                       BOOLEAN;   
20.    
21.   
22.     
23.   
24. BEGIN    
25.            hr_employee_api.create_employee   
26.            (   -- Input data elements    
27.                -- ------------------------------   
28.                p_hire_date                                         => TO_DATE('08-JUN-2011'),   
29.                p_business_group_id                      => fnd_profile.value_specific('PER_BUSINESS_GROUP_ID'),   
30.                p_last_name                                       => 'TEST',   
31.                p_first_name                                       => 'PRAJKUMAR',   
32.                p_middle_names                              => NULL,   
33.                p_sex                                                     => 'M',   
34.                p_national_identifier                       => '183-09-6723',   
35.                p_date_of_birth                                 => TO_DATE('03-DEC-1988'),   
36.                p_known_as                                       => 'PRAJ',    
37.                -- Output data elements    
38.                -- --------------------------------   
39.                p_employee_number                         => lc_employee_number,   
40.                p_person_id                                         => ln_person_id,   
41.                p_assignment_id                                => ln_assignment_id,   
42.                p_per_object_version_number       => ln_object_ver_number,   
43.                p_asg_object_version_number       => ln_asg_ovn,   
44.                p_per_effective_start_date               => ld_per_effective_start_date,   
45.                p_per_effective_end_date                => ld_per_effective_end_date,   
46.                p_full_name                                         => lc_full_name,   
47.                p_per_comment_id                            => ln_per_comment_id,   
48.                p_assignment_sequence                  => ln_assignment_sequence,   
49.                p_assignment_number                     => lc_assignment_number,   
50.                p_name_combination_warning    => lb_name_combination_warning,   
51.                p_assign_payroll_warning            => lb_assign_payroll_warning,   
52.                p_orig_hire_warning                        => lb_orig_hire_warning    
53.         );   
54.     
55.     COMMIT;    
56.   
57.     
58.   
59. EXCEPTION   
60.       WHEN OTHERS THEN   
61.                     ROLLBACK;   
62.                     dbms_output.put_line(SQLERRM);   
63. END;