DECLARE
/*Following Variables declared to hold Values returned by the API (Out Parameters) */
v_person_id NUMBER;
v_assignment_id NUMBER;
v_per_object_version_number NUMBER;
v_asg_object_version_number NUMBER;
v_per_effective_start_date DATE;
v_per_effective_end_date DATE;
v_per_comment_id NUMBER;
v_assignment_sequence NUMBER;
v_assignment_number VARCHAR2(1000);
v_name_combination_warning BOOLEAN;
v_assign_payroll_warning BOOLEAN;
v_orig_hire_warning BOOLEAN;
/*Following Variable is In and Out Parameter*/
v_eno VARCHAR2(2000);
BEGIN
hr_employee_api.create_employee
(
p_validate =>false
,p_hire_date =>'01-MAY-05'
,p_business_group_id =>202
,p_last_name =>'Gates'
,p_sex =>'M'
,p_person_type_id =>13
,p_date_of_birth =>'27-JUL-1976'
,p_employee_number =>v_eno
,p_first_name =>'Bill'
,p_coord_ben_no_cvg_flag => 'N'
,p_dpdnt_vlntry_svce_flag => 'N'
,p_person_id => v_person_id
,p_assignment_id => v_assignment_id
,p_per_object_version_number => v_per_object_version_number
,p_asg_object_version_number => v_asg_object_version_number
,p_per_effective_start_date => v_per_effective_start_date
,p_per_effective_end_date => v_per_effective_end_date
,p_full_name => v_full_name
,p_per_comment_id => v_per_comment_id
,p_assignment_sequence => V_assignment_sequence
,p_assignment_number => v_assignment_number
,p_name_combination_warning => v_name_combination_warning
,p_assign_payroll_warning => v_assign_payroll_warning
,p_orig_hire_warning => v_orig_hire_warning);
IF v_person_id is not NULL THEN
dbms_output.put_line('person_id '||v_person_id);
dbms_output.put_line('person Name '||v_full_name);
dbms_output.put_line('Person No '||v_eno);
END IF;
END;
/
commit;