Wednesday, July 22, 2009

Create Employee API Sample Script


DECLARE
ip_p_person_id NUMBER;
ip_p_assignment_id NUMBER;
ip_p_per_object_version_number NUMBER;
ip_p_asg_object_version_number NUMBER;
ip_p_per_effective_start_date DATE;
ip_p_per_effective_end_date DATE;
ip_p_full_name VARCHAR2 (1000);
ip_p_per_comment_id NUMBER;
ip_p_assignment_sequence NUMBER;
ip_p_assignment_number VARCHAR2 (1000);
ip_p_name_combination_warning BOOLEAN;
ip_p_assign_payroll_warning BOOLEAN;
ip_p_orig_hire_warning BOOLEAN;
ip_employee_number VARCHAR2 (1000);
BEGIN
ip_employee_number := 'Test-102';
hr_employee_api.create_employee
(p_hire_date => SYSDATE
,p_business_group_id => 0
,p_last_name => 'TEST_API1'
,p_sex => 'M'
,p_employee_number => ip_employee_number
,p_attribute1 => '123456789'
,p_global_person_id => NULL
,p_party_id => NULL
,p_person_id => ip_p_person_id
,p_assignment_id => ip_p_assignment_id
,p_per_object_version_number => ip_p_per_object_version_number
,p_asg_object_version_number => ip_p_asg_object_version_number
,p_per_effective_start_date => ip_p_per_effective_start_date
,p_per_effective_end_date => ip_p_per_effective_end_date
,p_full_name => ip_p_full_name
,p_per_comment_id => ip_p_per_comment_id
,p_assignment_sequence => ip_p_assignment_sequence
,p_assignment_number => ip_p_assignment_number
,p_name_combination_warning => ip_p_name_combination_warning
,p_assign_payroll_warning => ip_p_assign_payroll_warning
,p_orig_hire_warning => ip_p_orig_hire_warning
);
DBMS_OUTPUT.put_line (SQLERRM);
COMMIT;
END;

No comments:

Post a Comment