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 451: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);

447: p_sr_ghr_cpdf_temp.emrgncy_cntct_middle_name1 := cur_contacts_rec.middle_names;
448: p_sr_ghr_cpdf_temp.emrgncy_cntct_suffix1 := l_suffix;
449: --End Bug# 4648811
450: p_sr_ghr_cpdf_temp.emrgncy_cntct_phone1 := cur_contacts_rec.phone_number;
451: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);
452: p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt1 := cur_contacts_rec.date_start;
453: ELSIF l_contact_cnt = 2 THEN
454: -- Bug# 4648811 extracting the suffix from the lastname and also removing suffix from lastname
455: get_suffix_lname(p_last_name => cur_contacts_rec.last_name,

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

461: p_sr_ghr_cpdf_temp.emrgncy_cntct_middle_name2 := cur_contacts_rec.middle_names;
462: p_sr_ghr_cpdf_temp.emrgncy_cntct_suffix2 := l_suffix;
463: --End Bug# 4648811
464: p_sr_ghr_cpdf_temp.emrgncy_cntct_phone2 := cur_contacts_rec.phone_number;
465: --p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt2 := fnd_date.canonical_to_date(cur_contacts_rec.date_start);
466: p_sr_ghr_cpdf_temp.emrgncy_cntct_infrm_upd_dt2 := cur_contacts_rec.date_start;
467: END IF;
468: END LOOP;
469:

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

757: l_lang_cnt := 0;
758: FOR special_info IN c_sit_latest LOOP
759: p_sr_ghr_cpdf_temp.rating_of_record_pattern := special_info.segment4;
760: p_sr_ghr_cpdf_temp.rating_of_record_level := special_info.segment5;
761: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(special_info.segment6);
762: --Bug# 4753117 05-MAR-07 Veeramani adding Appraisal start date
763: p_sr_ghr_cpdf_temp.rating_of_record_period_starts := fnd_date.canonical_to_date(special_info.segment17);
764: l_lang_cnt := l_lang_cnt + 1;
765: exit;

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

759: p_sr_ghr_cpdf_temp.rating_of_record_pattern := special_info.segment4;
760: p_sr_ghr_cpdf_temp.rating_of_record_level := special_info.segment5;
761: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(special_info.segment6);
762: --Bug# 4753117 05-MAR-07 Veeramani adding Appraisal start date
763: p_sr_ghr_cpdf_temp.rating_of_record_period_starts := fnd_date.canonical_to_date(special_info.segment17);
764: l_lang_cnt := l_lang_cnt + 1;
765: exit;
766: END LOOP;
767:

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

816: );
817: p_sr_ghr_cpdf_temp.creditable_military_service := l_PEOPEI_DATA.PEI_INFORMATION5;
818: --Begin Bug# 4672725
819: IF l_PEOPEI_DATA.PEI_INFORMATION20 IS NOT NULL THEN
820: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
821: ELSE
822: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
823: END IF;
824: --end Bug# 4672725

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

818: --Begin Bug# 4672725
819: IF l_PEOPEI_DATA.PEI_INFORMATION20 IS NOT NULL THEN
820: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
821: ELSE
822: p_sr_ghr_cpdf_temp.mil_svc_end_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
823: END IF;
824: --end Bug# 4672725
825: p_sr_ghr_cpdf_temp.act_svc_indicator := l_PEOPEI_DATA.PEI_INFORMATION12;
826: p_sr_ghr_cpdf_temp.mil_char_svc_code := l_PEOPEI_DATA.PEI_INFORMATION13;

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

824: --end Bug# 4672725
825: p_sr_ghr_cpdf_temp.act_svc_indicator := l_PEOPEI_DATA.PEI_INFORMATION12;
826: p_sr_ghr_cpdf_temp.mil_char_svc_code := l_PEOPEI_DATA.PEI_INFORMATION13;
827: p_sr_ghr_cpdf_temp.mil_svc_sno := l_PEOPEI_DATA.PEI_INFORMATION14;
828: p_sr_ghr_cpdf_temp.mil_svc_start_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION15);
829: p_sr_ghr_cpdf_temp.mil_branch_code := l_PEOPEI_DATA.PEI_INFORMATION16;
830: p_sr_ghr_cpdf_temp.mil_discharge_code := l_PEOPEI_DATA.PEI_INFORMATION17;
831: --Bug# 15999091
832: p_sr_ghr_cpdf_temp.slct_serv_regi_indicator := l_PEOPEI_DATA.PEI_INFORMATION18;

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

843: p_per_ei_data => l_PEOPEI_DATA
844: );
845: p_sr_ghr_cpdf_temp.frozen_service := l_PEOPEI_DATA.PEI_INFORMATION5;
846: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
847: p_sr_ghr_cpdf_temp.fers_elect_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION18);
848: p_sr_ghr_cpdf_temp.fers_elect_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
849: p_sr_ghr_cpdf_temp.disability_retire_notify := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
850:
851: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;

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

845: p_sr_ghr_cpdf_temp.frozen_service := l_PEOPEI_DATA.PEI_INFORMATION5;
846: p_sr_ghr_cpdf_temp.fers_coverage := l_PEOPEI_DATA.PEI_INFORMATION3;
847: p_sr_ghr_cpdf_temp.fers_elect_date := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION18);
848: p_sr_ghr_cpdf_temp.fers_elect_indicator := l_PEOPEI_DATA.PEI_INFORMATION19;
849: p_sr_ghr_cpdf_temp.disability_retire_notify := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION20);
850:
851: l_PEOPEI_DATA := l_PEOPEI_DATA_INIT;
852: -- Begin Bug# 4753092
853: g_message_name := 'Person EIT: Person RPA';

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

945: p_per_ei_data => l_PEOPEI_DATA
946: );
947: -- SVC may be changed w/ resolution of type/length conversion
948: p_sr_ghr_cpdf_temp.service_comp_date :=
949: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
950:
951: -- SCD RIF and Retirement dates
952: p_sr_ghr_cpdf_temp.SCD_rif :=
953: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);

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

949: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
950:
951: -- SCD RIF and Retirement dates
952: p_sr_ghr_cpdf_temp.SCD_rif :=
953: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
954: p_sr_ghr_cpdf_temp.SCD_retirement :=
955: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);

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

951: -- SCD RIF and Retirement dates
952: p_sr_ghr_cpdf_temp.SCD_rif :=
953: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
954: p_sr_ghr_cpdf_temp.SCD_retirement :=
955: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
958: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
959: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);

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

953: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
954: p_sr_ghr_cpdf_temp.SCD_retirement :=
955: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
958: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
959: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
960: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
961:

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

954: p_sr_ghr_cpdf_temp.SCD_retirement :=
955: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
958: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
959: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
960: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
961:
962: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION

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

955: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
958: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
959: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
960: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
961:
962: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION
963: l_cnt := 0;

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

956:
957: p_sr_ghr_cpdf_temp.leave_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
958: p_sr_ghr_cpdf_temp.tsp_scd := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION6);
959: p_sr_ghr_cpdf_temp.scd_ses := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION8);
960: p_sr_ghr_cpdf_temp.scd_spcl_retire := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION9);
961:
962: -- JH EHRI Multiple Entries!!! GHR_US_PER_SERVICE_OBLIGATION
963: l_cnt := 0;
964: --Bug # 9817051 initialize the l_peopei_data with initial values

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

984: );
985:
986: IF l_cnt = 1 THEN
987: p_sr_ghr_cpdf_temp.svc_oblig_type_code1 := l_PEOPEI_DATA.PEI_INFORMATION3;
988: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date1 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
989: ELSIF l_cnt = 2 THEN
990: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
991: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
992: ELSIF l_cnt = 3 THEN

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

987: p_sr_ghr_cpdf_temp.svc_oblig_type_code1 := l_PEOPEI_DATA.PEI_INFORMATION3;
988: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date1 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
989: ELSIF l_cnt = 2 THEN
990: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
991: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
992: ELSIF l_cnt = 3 THEN
993: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
994: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
995: ELSIF l_cnt = 4 THEN

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

990: p_sr_ghr_cpdf_temp.svc_oblig_type_code2 := l_PEOPEI_DATA.PEI_INFORMATION3;
991: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date2 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
992: ELSIF l_cnt = 3 THEN
993: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
994: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
995: ELSIF l_cnt = 4 THEN
996: p_sr_ghr_cpdf_temp.svc_oblig_type_code4 := l_PEOPEI_DATA.PEI_INFORMATION3;
997: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date4 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
998: END IF;

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

993: p_sr_ghr_cpdf_temp.svc_oblig_type_code3 := l_PEOPEI_DATA.PEI_INFORMATION3;
994: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date3 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
995: ELSIF l_cnt = 4 THEN
996: p_sr_ghr_cpdf_temp.svc_oblig_type_code4 := l_PEOPEI_DATA.PEI_INFORMATION3;
997: p_sr_ghr_cpdf_temp.svc_oblig_type_end_date4 := fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION4);
998: END IF;
999: End if;
1000: End loop;
1001:

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

1137: );
1138:
1139:
1140: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1141: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1142: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1143: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);

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

1138:
1139:
1140: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1141: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1142: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1143: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;

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

1140: p_sr_ghr_cpdf_temp.fegli_indicator := l_peopei_data.pei_information1;
1141: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1142: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1143: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);

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

1141: p_sr_ghr_cpdf_temp.fegli_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information2);
1142: p_sr_ghr_cpdf_temp.fegli_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information3);
1143: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1149: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);

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

1143: p_sr_ghr_cpdf_temp.fehb_indicator := l_peopei_data.pei_information4;
1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1149: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1150: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1151: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;

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

1144: p_sr_ghr_cpdf_temp.fehb_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information5);
1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1149: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1150: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1151: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1152:

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

1145: p_sr_ghr_cpdf_temp.fehb_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information6);
1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1149: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1150: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1151: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1152:
1153: -- End Bug#6158983

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

1146: p_sr_ghr_cpdf_temp.retire_indicator := l_peopei_data.pei_information7;
1147: p_sr_ghr_cpdf_temp.retire_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information12);
1148: p_sr_ghr_cpdf_temp.retire_notify_date := fnd_date.canonical_to_date(l_peopei_data.pei_information8);
1149: p_sr_ghr_cpdf_temp.cont_term_elect_date := fnd_date.canonical_to_date(l_peopei_data.pei_information9);
1150: p_sr_ghr_cpdf_temp.cont_ins_pay_notify_date:= fnd_date.canonical_to_date(l_peopei_data.pei_information10);
1151: p_sr_ghr_cpdf_temp.cont_pay_type_code:= l_peopei_data.pei_information11;
1152:
1153: -- End Bug#6158983
1154:

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

1590: ,p_value => l_value
1591: ,p_effective_start_date => l_effective_start_date
1592: ,p_business_group_id => g_business_group_id);
1593:
1594: p_sr_ghr_cpdf_temp.tsp_eligibility_date := fnd_date.canonical_to_date(l_value);
1595:
1596:
1597: l_value := null;
1598: l_effective_start_date := null;

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

3421: AND person_id = g_person_id
3422: AND to_position_id = g_position_id
3423: AND noa_family_code = 'APP'
3424: AND first_noa_information1 like '____%__%__ __:__:__'
3425: AND fnd_date.canonical_to_date(first_noa_information1) >= g_report_date;*/
3426:
3427: Cursor nte_date
3428: is
3429: SELECT aei_information4

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

3436: AND (code LIKE '1%' OR code LIKE '5%' OR code IN ('750','760','761','762','765'))
3437: AND aei_information4 IS NOT NULL
3438: AND assignment_id = g_assignment_id
3439: AND person_id = g_person_id)
3440: AND fnd_date.canonical_to_date(aei_information4) >= g_report_date;
3441: --Bug# 6477035
3442:
3443: --Bug# 6158983
3444:

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

3721:
3722: --Bug# 6158983
3723: FOR nte_date_rec in nte_date
3724: LOOP
3725: g_ghr_cpdf_temp.appointment_nte_date := fnd_date.canonical_to_date(nte_date_rec.aei_information4);
3726: END LOOP;
3727: -- Bug# 6158983
3728:
3729: --Start of BUG# 6631879

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

3820: --
3821: BEGIN
3822:
3823: ghr_mto_int.set_log_program_name('GHR_CPDF_EHRI_STATRPT');
3824: l_report_date := fnd_date.canonical_to_date(p_report_date);
3825: --l_report_date := sysdate;
3826: --dbms_output.enable(100000000);
3827: --dbms_output.put_line(p_agency_code||' '||p_agency_subelement||' '||l_report_date);
3828: --8486208 added the following condition