Friday 7 September 2012

Oracle HRMS Standard employee and Contingent employee Creation APIs

----Employee

BEGIN
--
hr_employee_api.create_employee
(
p_validate => FALSE
,p_hire_date => rec_emp_dtls.date_of_hire
,p_business_group_id => 81 -- business group id
,p_last_name => rec_emp_dtls.last_name
,p_known_as => rec_emp_dtls.known_as
,p_middle_names => rec_emp_dtls.middle_names
,p_sex => rec_emp_dtls.gender
,p_person_type_id => l_person_type_id
,p_email_address => rec_emp_dtls.email_address
,p_employee_number => rec_emp_dtls.employee_number
,p_first_name => rec_emp_dtls.first_name
,p_national_identifier => rec_emp_dtls.national_identifier
,p_title => rec_emp_dtls.title
,p_date_of_birth => rec_emp_dtls.date_of_birth
,p_original_date_of_hire => l_start_date--rec_emp_dtls.original_date_of_hire
,p_person_id => l_person_id
,p_assignment_id => l_assignment_id
,p_per_object_version_number => l_per_object_version_number
,p_asg_object_version_number => l_asg_object_version_number
,p_per_effective_start_date => l_per_effective_start_date
,p_per_effective_end_date => l_per_effective_end_date
,p_full_name => l_full_name
,p_per_comment_id => l_per_comment_id
,p_assignment_sequence => l_assignment_sequence
,p_assignment_number => l_assignment_number
,p_name_combination_warning => l_name_combination_warning
,p_assign_payroll_warning => l_assign_payroll_warning
,p_orig_hire_warning => l_orig_hire_warning
);
END;

--Contingent
--
BEGIN
--
hr_contingent_worker_api.create_cwk
(
p_validate => FALSE
,p_start_date => rec_emp_dtls.date_of_hire
,p_business_group_id => 81 -- business group id
,p_last_name => rec_emp_dtls.last_name
,p_known_as => rec_emp_dtls.known_as
,p_middle_names => rec_emp_dtls.middle_names
,p_sex => rec_emp_dtls.gender
,p_person_type_id => 1139 --l_person_type_id
,p_email_address => rec_emp_dtls.email_address
,p_npw_number => rec_emp_dtls.employee_number
,p_first_name => rec_emp_dtls.first_name
,p_national_identifier => rec_emp_dtls.national_identifier
,p_title => rec_emp_dtls.title
,p_date_of_birth => rec_emp_dtls.date_of_birth
,p_original_date_of_hire => l_start_date--rec_emp_dtls.original_date_of_hire
,p_person_id => l_person_id
,p_assignment_id => l_assignment_id
,p_per_object_version_number => l_per_object_version_number
,p_asg_object_version_number => l_asg_object_version_number
,p_per_effective_start_date => l_per_effective_start_date
,p_per_effective_end_date => l_per_effective_end_date
,p_full_name => l_full_name
,p_assignment_sequence => l_assignment_sequence
,p_assignment_number => l_assignment_number
,p_name_combination_warning => l_name_combination_warning
,p_comment_id => l_commnet_id
,p_pdp_object_version_number => l_pdp_object_version_number
);
END;

No comments:

Post a Comment