eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CPDF_EHRIS dependencies on FND_DATE

Line 438: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);

434: p_sr_ghr_cpdf_temp.emrgncy_cntct_middle_name1 := cur_contacts_rec.middle_names;
435: p_sr_ghr_cpdf_temp.emrgncy_cntct_suffix1 := l_suffix;
436: --End Bug# 4648811
437: p_sr_ghr_cpdf_temp.emrgncy_cntct_phone1 := cur_contacts_rec.phone_number;
438: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);
439: p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := cur_contacts_rec.date_start;
440: ELSIF l_contact_cnt = 2 THEN
441: -- Bug# 4648811 extracting the suffix from the lastname and also removing suffix from lastname
442: get_suffix_lname(p_last_name => cur_contacts_rec.last_name,

Line 452: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt2 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);

448: p_sr_ghr_cpdf_temp.emrgncy_cntct_middle_name2 := cur_contacts_rec.middle_names;
449: p_sr_ghr_cpdf_temp.emrgncy_cntct_suffix2 := l_suffix;
450: --End Bug# 4648811
451: p_sr_ghr_cpdf_temp.emrgncy_cntct_phone2 := cur_contacts_rec.phone_number;
452: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt2 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);
453: p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt2 := cur_contacts_rec.date_start;
454: END IF;
455: END LOOP;
456:

Line 748: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(special_info.segment6);

744: l_lang_cnt := 0;
745: FOR special_info IN c_sit_latest LOOP
746: p_sr_ghr_cpdf_temp.rating_of_record_pattern := special_info.segment4;
747: p_sr_ghr_cpdf_temp.rating_of_record_level := special_info.segment5;
748: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(special_info.segment6);
749: --Bug# 4753117 05-MAR-07 Veeramani adding Appraisal start date
750: p_sr_ghr_cpdf_temp.rating_of_record_period_starts := fnd_date.canonical_to_date(special_info.segment17);
751: l_lang_cnt := l_lang_cnt + 1;
752: exit;

Line 750: p_sr_ghr_cpdf_temp.rating_of_record_period_starts := fnd_date.canonical_to_date(special_info.segment17);

746: p_sr_ghr_cpdf_temp.rating_of_record_pattern := special_info.segment4;
747: p_sr_ghr_cpdf_temp.rating_of_record_level := special_info.segment5;
748: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(special_info.segment6);
749: --Bug# 4753117 05-MAR-07 Veeramani adding Appraisal start date
750: p_sr_ghr_cpdf_temp.rating_of_record_period_starts := fnd_date.canonical_to_date(special_info.segment17);
751: l_lang_cnt := l_lang_cnt + 1;
752: exit;
753: END LOOP;
754:

Line 807: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);

803: );
804: p_sr_ghr_cpdf_temp.creditable_military_service := l_PEOPEI_DATA.PEI_INFORMATION5;
805: --Begin Bug# 4672725
806: IF l_PEOPEI_DATA.PEI_INFORMATION20 IS NOT NULL THEN
807: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
808: ELSE
809: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
810: END IF;
811: --end Bug# 4672725

Line 809: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);

805: --Begin Bug# 4672725
806: IF l_PEOPEI_DATA.PEI_INFORMATION20 IS NOT NULL THEN
807: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
808: ELSE
809: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
810: END IF;
811: --end Bug# 4672725
812: p_sr_ghr_cpdf_temp.act_svc_indicator := l_PEOPEI_DATA.PEI_INFORMATION12;
813: p_sr_ghr_cpdf_temp.mil_char_svc_code := l_PEOPEI_DATA.PEI_INFORMATION13;

Line 815: p_sr_ghr_cpdf_temp.mil_svc_start_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION15);

811: --end Bug# 4672725
812: p_sr_ghr_cpdf_temp.act_svc_indicator := l_PEOPEI_DATA.PEI_INFORMATION12;
813: p_sr_ghr_cpdf_temp.mil_char_svc_code := l_PEOPEI_DATA.PEI_INFORMATION13;
814: p_sr_ghr_cpdf_temp.mil_svc_sno := l_PEOPEI_DATA.PEI_INFORMATION14;
815: p_sr_ghr_cpdf_temp.mil_svc_start_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION15);
816: p_sr_ghr_cpdf_temp.mil_branch_code := l_PEOPEI_DATA.PEI_INFORMATION16;
817: p_sr_ghr_cpdf_temp.mil_discharge_code := l_PEOPEI_DATA.PEI_INFORMATION17;
818:
819:

Line 832: p_sr_ghr_cpdf_temp.fers_elect_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION18);

828: p_per_ei_data => l_PEOPEI_DATA
829: );
830: p_sr_ghr_cpdf_temp.frozen_service := l_PEOPEI_DATA.PEI_INFORMATION5;
831: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
832: p_sr_ghr_cpdf_temp.fers_elect_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION18);
833: p_sr_ghr_cpdf_temp.fers_elect_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
834: p_sr_ghr_cpdf_temp.disability_retire_notify := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
835:
836: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;

Line 834: p_sr_ghr_cpdf_temp.disability_retire_notify := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);

830: p_sr_ghr_cpdf_temp.frozen_service := l_PEOPEI_DATA.PEI_INFORMATION5;
831: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
832: p_sr_ghr_cpdf_temp.fers_elect_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION18);
833: p_sr_ghr_cpdf_temp.fers_elect_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
834: p_sr_ghr_cpdf_temp.disability_retire_notify := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
835:
836: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
837: -- Begin Bug# 4753092
838: g_message_name := 'Person EIT: Person RPA';

Line 930: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);

926: p_per_ei_data => l_PEOPEI_DATA
927: );
928: -- SVC may be changed w/ resolution of type/length conversion
929: p_sr_ghr_cpdf_temp.service_comp_date :=
930: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
931:
932: -- SCD RIF and Retirement dates
933: p_sr_ghr_cpdf_temp.SCD_rif :=
934: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);

Line 934: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);

930: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
931:
932: -- SCD RIF and Retirement dates
933: p_sr_ghr_cpdf_temp.SCD_rif :=
934: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
935: p_sr_ghr_cpdf_temp.SCD_retirement :=
936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);

Line 936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);

932: -- SCD RIF and Retirement dates
933: p_sr_ghr_cpdf_temp.SCD_rif :=
934: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
935: p_sr_ghr_cpdf_temp.SCD_retirement :=
936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);

Line 938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);

934: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
935: p_sr_ghr_cpdf_temp.SCD_retirement :=
936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
941: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
942:

Line 939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);

935: p_sr_ghr_cpdf_temp.SCD_retirement :=
936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
941: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
942:
943: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION

Line 940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);

936: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
941: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
942:
943: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION
944: l_cnt := 0;

Line 941: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);

937:
938: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
939: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
940: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
941: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
942:
943: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION
944: l_cnt := 0;
945: -- Begin Bug# 4753092

Line 966: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date1 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);

962: );
963:
964: IF l_cnt = 1 THEN
965: p_sr_ghr_cpdf_temp.svc_oblig_type_code1 := l_PEOPEI_DATA.PEI_INFORMATION3;
966: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date1 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
967: ELSIF l_cnt = 2 THEN
968: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
969: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
970: ELSIF l_cnt = 3 THEN

Line 969: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);

965: p_sr_ghr_cpdf_temp.svc_oblig_type_code1 := l_PEOPEI_DATA.PEI_INFORMATION3;
966: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date1 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
967: ELSIF l_cnt = 2 THEN
968: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
969: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
970: ELSIF l_cnt = 3 THEN
971: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
972: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
973: ELSIF l_cnt = 4 THEN

Line 972: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);

968: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
969: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
970: ELSIF l_cnt = 3 THEN
971: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
972: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
973: ELSIF l_cnt = 4 THEN
974: p_sr_ghr_cpdf_temp.svc_oblig_type_code4 := l_PEOPEI_DATA.PEI_INFORMATION3;
975: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date4 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
976: END IF;

Line 975: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date4 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);

971: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
972: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
973: ELSIF l_cnt = 4 THEN
974: p_sr_ghr_cpdf_temp.svc_oblig_type_code4 := l_PEOPEI_DATA.PEI_INFORMATION3;
975: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date4 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
976: END IF;
977: End if;
978: End loop;
979:

Line 1106: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);

1102: );
1103:
1104:
1105: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1106: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1107: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1108: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);

Line 1107: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);

1103:
1104:
1105: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1106: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1107: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1108: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;

Line 1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);

1105: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1106: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1107: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1108: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);

Line 1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);

1106: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1107: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1108: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);

Line 1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);

1108: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1115: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1116: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;

Line 1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);

1109: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1115: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1116: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1117:

Line 1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);

1110: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1115: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1116: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1117:
1118: -- End Bug#6158983

Line 1115: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);

1111: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1112: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1113: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1114: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1115: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1116: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1117:
1118: -- End Bug#6158983
1119:

Line 1517: p_sr_ghr_cpdf_temp.tsp_eligibility_date := fnd_date.canonical_to_date(l_value);

1513: ,p_value => l_value
1514: ,p_effective_start_date => l_effective_start_date
1515: ,p_business_group_id => g_business_group_id);
1516:
1517: p_sr_ghr_cpdf_temp.tsp_eligibility_date := fnd_date.canonical_to_date(l_value);
1518:
1519:
1520: l_value := null;
1521: l_effective_start_date := null;

Line 3284: AND fnd_date.canonical_to_date(first_noa_information1) >= g_report_date;*/

3280: AND person_id = g_person_id
3281: AND to_position_id = g_position_id
3282: AND noa_family_code = 'APP'
3283: AND first_noa_information1 like '____%__%__ __:__:__'
3284: AND fnd_date.canonical_to_date(first_noa_information1) >= g_report_date;*/
3285:
3286: Cursor nte_date
3287: is
3288: SELECT aei_information4

Line 3299: AND fnd_date.canonical_to_date(aei_information4) >= g_report_date;

3295: AND (code LIKE '1%' OR code LIKE '5%' OR code IN ('750','760','761','762','765'))
3296: AND aei_information4 IS NOT NULL
3297: AND assignment_id = g_assignment_id
3298: AND person_id = g_person_id)
3299: AND fnd_date.canonical_to_date(aei_information4) >= g_report_date;
3300: --Bug# 6477035
3301:
3302: --Bug# 6158983
3303:

Line 3572: g_ghr_cpdf_temp.appointment_nte_date := fnd_date.canonical_to_date(nte_date_rec.aei_information4);

3568:
3569: --Bug# 6158983
3570: FOR nte_date_rec in nte_date
3571: LOOP
3572: g_ghr_cpdf_temp.appointment_nte_date := fnd_date.canonical_to_date(nte_date_rec.aei_information4);
3573: END LOOP;
3574: -- Bug# 6158983
3575:
3576: --Start of BUG# 6631879

Line 3666: l_report_date := fnd_date.canonical_to_date(p_report_date);

3662: --
3663: BEGIN
3664:
3665: ghr_mto_int.set_log_program_name('GHR_CPDF_EHRI_STATRPT');
3666: l_report_date := fnd_date.canonical_to_date(p_report_date);
3667: --l_report_date := sysdate;
3668: --dbms_output.enable(100000000);
3669: --dbms_output.put_line(p_agency_code||' '||p_agency_subelement||' '||l_report_date);
3670: