Tuesday 18 September 2012

Oracle HRMS Previous Employer & Previous Job APIs

--Create Previous Employer
--
BEGIN
hr_previous_employment_api.create_previous_employer
( p_effective_date => TRUNC(SYSDATE)
,p_validate => FALSE
,p_business_group_id => p_business_group_id
,p_person_id => prev_exp_rec.person_id
,p_start_date => prev_exp_rec.start_date
,p_end_date => prev_exp_rec.end_date
,p_employer_name => prev_exp_rec.employer
,p_employer_country => prev_exp_rec.country_code
,p_employer_type => prev_exp_rec.industry_type_code
,p_all_assignments => 'N'
,p_previous_employer_id => l_previous_employer_id
,p_object_version_number => l_object_version_number
);
END;
--previous job
--
BEGIN
hr_previous_employment_api.create_previous_job
( p_effective_date => TRUNC(SYSDATE)
,p_validate => FALSE
,p_previous_employer_id => l_previous_employer_id
,p_job_name => prev_exp_rec.prev_job
,p_description => prev_exp_rec.PREV_JOB_DESC
,p_previous_job_id => l_previous_job_id
,p_object_version_number => l_pj_object_version_number
);
END;

No comments:

Post a Comment