479: p_date_effective => l_effective_date,
480: p_per_ei_data => l_people_ei_data2
481: );
482:
483: l_rif_reg.service_comp_date_rif := fnd_date.canonical_to_date(l_people_ei_data2.pei_information5);
484: l_rif_reg.service_comp_date_civilian := fnd_date.canonical_to_date(l_people_ei_data2.pei_information4);
485:
486: -- Series (Occ_code)
487: hr_utility.set_location('Getting OCC Code' ,8);
480: p_per_ei_data => l_people_ei_data2
481: );
482:
483: l_rif_reg.service_comp_date_rif := fnd_date.canonical_to_date(l_people_ei_data2.pei_information5);
484: l_rif_reg.service_comp_date_civilian := fnd_date.canonical_to_date(l_people_ei_data2.pei_information4);
485:
486: -- Series (Occ_code)
487: hr_utility.set_location('Getting OCC Code' ,8);
488:
533: p_value => l_value,
534: p_multiple_error_flag => l_multiple_error_flag
535: );
536: hr_utility.set_location('After Getting WGI Due Date',9);
537: l_rif_reg.wgi_due_date := fnd_date.canonical_to_date(l_value);
538:
539: -- Ratings 1
540:
541: hr_utility.set_location('Getting return ratings',10);
549: p_special_info3 => l_perf_appraisal3
550: );
551:
552: l_rif_reg.rating_of_record1 := l_perf_appraisal1.segment2;
553: l_rif_reg.rating_of_record1_date := fnd_date.canonical_to_date(l_perf_appraisal1.segment3);
554:
555: l_rif_reg.rating_of_record2 := l_perf_appraisal2.segment2;
556: l_rif_reg.rating_of_record2_date := fnd_date.canonical_to_date(l_perf_appraisal2.segment3);
557:
552: l_rif_reg.rating_of_record1 := l_perf_appraisal1.segment2;
553: l_rif_reg.rating_of_record1_date := fnd_date.canonical_to_date(l_perf_appraisal1.segment3);
554:
555: l_rif_reg.rating_of_record2 := l_perf_appraisal2.segment2;
556: l_rif_reg.rating_of_record2_date := fnd_date.canonical_to_date(l_perf_appraisal2.segment3);
557:
558: l_rif_reg.rating_of_record3 := l_perf_appraisal3.segment2;
559: l_rif_reg.rating_of_record3_date := fnd_date.canonical_to_date(l_perf_appraisal3.segment3);
560:
555: l_rif_reg.rating_of_record2 := l_perf_appraisal2.segment2;
556: l_rif_reg.rating_of_record2_date := fnd_date.canonical_to_date(l_perf_appraisal2.segment3);
557:
558: l_rif_reg.rating_of_record3 := l_perf_appraisal3.segment2;
559: l_rif_reg.rating_of_record3_date := fnd_date.canonical_to_date(l_perf_appraisal3.segment3);
560:
561: -- Rating Description 1
562:
563: get_lookup_meaning_desc (
647: p_pos_ei_data => l_pos_ei_data3
648: );
649:
650: l_rif_reg.obligated_posn_type := l_pos_ei_data3.poei_information4;
651: l_rif_reg.obligated_expiration_date := fnd_date.canonical_to_date(l_pos_ei_data3.poei_information3);
652:
653: -- Obligated Postition Description
654:
655: get_lookup_meaning_desc (