Oracle HRMS Employee Medical Assessment & Qualification API

--Create Qualification
--
BEGIN
per_qualifications_api.create_qualification
( p_validate => FALSE
,p_effective_date => TRUNC(sysdate)
,p_qualification_type_id => edu_qual_rec.qual_type_id
,p_business_group_id => p_business_group_id
,p_person_id => edu_qual_rec.person_id
,p_title => edu_qual_rec.title
,p_status => edu_qual_rec.status
,p_awarded_date => edu_qual_rec.awarded_date
,p_start_date => edu_qual_rec.start_date
,p_attendance_id => edu_qual_rec.attendance_id
,p_awarding_body => l_awarding_body
,p_attribute1 => edu_qual_rec.area_of_study
,p_qualification_id => l_qualification_id
,p_object_version_number => l_object_version_number
);
END;
--Create Medical Assessment
--
BEGIN
per_medical_assessment_api.create_medical_assessment
( p_validate => TRUE
,p_effective_date => TRUNC(SYSDATE)
,p_person_id => med_ass_det_rec.person_id
,p_consultation_date => med_ass_det_rec.consultation_date
,p_consultation_type => nvl(med_ass_det_rec.consultation_type,'AM')
,p_consultation_result => med_ass_det_rec.consultation_result
,p_examiner_name => med_ass_det_rec.examiner_name
,p_organization_id => med_ass_det_rec.service_provider_id
,p_next_consultation_date => med_ass_det_rec.next_consultation_date
,p_description => med_ass_det_rec.description
,p_medical_assessment_id => l_medical_assessment_id
,p_object_version_number => l_object_version_number
);
END;