Oracle contingent worker APIs

--Create
--
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;

--Update
--
BEGIN
--
hr_assignment_api.update_cwk_asg_criteria
(
p_validate => FALSE
,p_effective_date => TRUNC(SYSDATE)
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_seas_ass_id
,p_called_from_mass_update => FALSE
,p_object_version_number => l_asg_object_version_number
,p_grade_id => NULL
,p_position_id => NULL
,p_job_id => NULL
--
,p_location_id => l_loc_id
,p_organization_id => l_org_id
--
,p_pay_basis_id => NULL
,p_segment1 => NULL
,p_segment2 => NULL
,p_segment3 => NULL
,p_segment4 => NULL
,p_segment5 => NULL
,p_segment6 => NULL
,p_segment7 => NULL
,p_segment8 => NULL
,p_segment9 => NULL
,p_segment10 => NULL
,p_segment11 => NULL
,p_segment12 => NULL
,p_segment13 => NULL
,p_segment14 => NULL
,p_segment15 => NULL
,p_segment16 => NULL
,p_segment17 => NULL
,p_segment18 => NULL
,p_segment19 => NULL
,p_segment20 => NULL
,p_segment21 => NULL
,p_segment22 => NULL
,p_segment23 => NULL
,p_segment24 => NULL
,p_segment25 => NULL
,p_segment26 => NULL
,p_segment27 => NULL
,p_segment28 => NULL
,p_segment29 => NULL
,p_segment30 => NULL
,p_concat_segments => NULL
--
,p_people_group_name => l_group_name
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_people_group_id => l_people_group_id
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_other_manager_warning => l_other_manager_warning
,p_spp_delete_warning => l_spp_delete_warning
--
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning
);
END;