Tuesday 18 September 2012

Oracle HRMS Employee LEAVES & Performance Review APIs

--Organization Performance Review
--
BEGIN
HR_PERF_REVIEW_API.CREATE_PERF_REVIEW
( P_VALIDATE => FALSE
,P_PERFORMANCE_REVIEW_ID => l_PERFORMANCE_REVIEW_ID
,P_PERSON_ID => l_person_id
,P_REVIEW_DATE => rec_perf_review.review_date
,P_PERFORMANCE_RATING => rec_perf_review.performance_rating
,P_ATTRIBUTE1 => rec_perf_review.start_date
,P_ATTRIBUTE2 => rec_perf_review.end_date
,P_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
,P_NEXT_REVIEW_DATE_WARNING => l_NEXT_REVIEW_DATE_WARNING );
END;
--EMP_LEAVES
--
BEGIN
hr_person_absence_api.create_person_absence
( p_validate => FALSE
,p_effective_date => rec_abs.abs_start_date
,p_person_id => rec_abs.person_id
,p_business_group_id => p_business_group_id
,p_absence_attendance_type_id => rec_abs.absence_attendance_type_id
,p_date_start => rec_abs.abs_start_date
,p_date_end => rec_abs.abs_end_date
,p_absence_days => l_absence_days
,p_absence_hours => l_absence_hours
,p_absence_attendance_id => l_absence_attendance_id
,p_object_version_number => l_object_version_number
,p_occurrence => l_occurrence
,p_dur_dys_less_warning => l_dur_dys_less_warning
,p_dur_hrs_less_warning => l_dur_hrs_less_warning
,p_exceeds_pto_entit_warning => l_exceeds_pto_entit_warning
,p_exceeds_run_total_warning => l_exceeds_run_total_warning
,p_abs_overlap_warning => l_abs_overlap_warning
,p_abs_day_after_warning => l_abs_day_after_warning
,p_dur_overwritten_warning => l_dur_overwritten_warning
);
END;
-- SIT
--
BEGIN
hr_sit_api.create_sit
( p_validate => FALSE
,p_person_id => sit_rec.person_id
,p_business_group_id => p_business_group_id
,p_id_flex_num => l_id_flex_num
,p_effective_date => sit_rec.from_date
,p_date_from => sit_rec.from_date
,p_date_to => sit_rec.to_date
,p_segment1 => sit_rec.type_of_action_code
,p_segment2 => sit_rec.comments
,p_analysis_criteria_id => l_analysis_criteria_id
,p_person_analysis_id => l_person_analysis_id
,p_pea_object_version_number => l_pea_object_version_number );
END;

No comments:

Post a Comment