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_EHRI_DYNRPT dependencies on FND_DATE

Line 373: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);

369:
370: IF l_special_info.object_version_number IS NOT NULL THEN
371: p_rating_of_record_level := l_special_info.segment5;
372: p_rating_of_record_pattern := l_special_info.segment4;
373: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
374: --Bug# 4753117 08-MAR-07 Veeramani adding Appraisal start date
375: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);
376: --
377: -- added for NEW EHRI CHANGES Madhuri

Line 375: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);

371: p_rating_of_record_level := l_special_info.segment5;
372: p_rating_of_record_pattern := l_special_info.segment4;
373: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
374: --Bug# 4753117 08-MAR-07 Veeramani adding Appraisal start date
375: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);
376: --
377: -- added for NEW EHRI CHANGES Madhuri
378:
379: ELSE -- Added select for bug# 1389262

Line 397: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);

393: l_effective_date, l_special_info);
394: IF l_special_info.object_version_number IS NOT NULL THEN
395: p_rating_of_record_level := l_special_info.segment5;
396: p_rating_of_record_pattern := l_special_info.segment4;
397: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
398: --Bug# 4753117 07-MAR-07 Veeramani adding Appraisal start date
399: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);
400:
401: --KFF - Personal Analysis Flexfield, US_FED_PERF_APPRAISAL

Line 399: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);

395: p_rating_of_record_level := l_special_info.segment5;
396: p_rating_of_record_pattern := l_special_info.segment4;
397: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
398: --Bug# 4753117 07-MAR-07 Veeramani adding Appraisal start date
399: p_rating_of_rec_period_starts := fnd_date.canonical_to_date(l_special_info.segment17);
400:
401: --KFF - Personal Analysis Flexfield, US_FED_PERF_APPRAISAL
402: --
403: -- added for NEW EHRI CHANGES MADHURI

Line 568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);

564: p_creditable_military_service := l_rei.rei_information5;
565: p_frozen_service := l_rei.rei_information6;
566: p_from_retirement_coverage := l_rei.rei_information7;
567: -- NEW EHRI DYNAMICS MADHURI
568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);
569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);
570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);
571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);

Line 569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);

565: p_frozen_service := l_rei.rei_information6;
566: p_from_retirement_coverage := l_rei.rei_information7;
567: -- NEW EHRI DYNAMICS MADHURI
568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);
569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);
570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);
571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);
573: --

Line 570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);

566: p_from_retirement_coverage := l_rei.rei_information7;
567: -- NEW EHRI DYNAMICS MADHURI
568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);
569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);
570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);
571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);
573: --
574: -- -- Bug 4724337 Race or National Origin changes

Line 571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);

567: -- NEW EHRI DYNAMICS MADHURI
568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);
569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);
570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);
571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);
573: --
574: -- -- Bug 4724337 Race or National Origin changes
575: ELSIF l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' THEN

Line 572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);

568: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information10);
569: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information11);
570: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information9);
571: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
572: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION8);
573: --
574: -- -- Bug 4724337 Race or National Origin changes
575: ELSIF l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' THEN
576: IF l_rei.rei_information3 IS NOT NULL OR

Line 619: l_leave_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information3);

615: p_date_effective => nvl(p_effective_date,trunc(sysdate)),
616: p_per_ei_data => l_per_ei_grp1_data
617: );
618:
619: l_leave_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information3);
620: p_leave_scd := l_leave_scd;
621: --
622: IF p_scd_rif IS NULL THEN
623: p_scd_rif := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information5);

Line 623: p_scd_rif := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information5);

619: l_leave_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information3);
620: p_leave_scd := l_leave_scd;
621: --
622: IF p_scd_rif IS NULL THEN
623: p_scd_rif := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information5);
624: END IF;
625: --
626: IF p_tsp_scd IS NULL THEN
627: p_tsp_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information6);

Line 627: p_tsp_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information6);

623: p_scd_rif := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information5);
624: END IF;
625: --
626: IF p_tsp_scd IS NULL THEN
627: p_tsp_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information6);
628: END IF;
629: --
630: IF p_scd_retirement IS NULL THEN
631: p_scd_retirement := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information7);

Line 631: p_scd_retirement := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information7);

627: p_tsp_scd := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information6);
628: END IF;
629: --
630: IF p_scd_retirement IS NULL THEN
631: p_scd_retirement := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information7);
632: END IF;
633: --
634: IF p_scd_ses IS NULL THEN
635: p_scd_ses := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information8);

Line 635: p_scd_ses := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information8);

631: p_scd_retirement := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information7);
632: END IF;
633: --
634: IF p_scd_ses IS NULL THEN
635: p_scd_ses := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information8);
636: END IF;
637: --
638: IF p_scd_spcl_retire IS NULL THEN
639: p_scd_spcl_retire := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information9);

Line 639: p_scd_spcl_retire := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information9);

635: p_scd_ses := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information8);
636: END IF;
637: --
638: IF p_scd_spcl_retire IS NULL THEN
639: p_scd_spcl_retire := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information9);
640: END IF;
641: --
642: -- bug 711711
643: -- if RNO or Handicap code was not filled then get them from HR Person EI

Line 828: l_appt_nte_date := fnd_date.canonical_to_date(l_asg_ei_data.AEI_INFORMATION4);

824: p_date_effective => p_effective_date,
825: p_asg_ei_data => l_asg_ei_data
826: );
827:
828: l_appt_nte_date := fnd_date.canonical_to_date(l_asg_ei_data.AEI_INFORMATION4);
829: --
830: p_appt_nte_date := l_appt_nte_date;
831:
832: EXCEPTION

Line 3715: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);

3711:
3712:
3713: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3714: LOOP
3715: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:

Line 3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);

3712:
3713: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3714: LOOP
3715: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3716: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3717: -- Added date conversion for bug#3808473-EHRI reports
3718: END LOOP;
3719:
3720: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

Line 3731: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);

3727: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
3728: p_per_ei_data => ll_per_ei_data
3729: );
3730:
3731: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
3732: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
3733:
3734: EXCEPTION
3735: WHEN OTHERS THEN

Line 3732: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);

3728: p_per_ei_data => ll_per_ei_data
3729: );
3730:
3731: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
3732: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
3733:
3734: EXCEPTION
3735: WHEN OTHERS THEN
3736: l_message_name := 'fetch_peopleei';

Line 4223: l_start_date := fnd_date.canonical_to_date(p_start_date);

4219: --
4220: BEGIN
4221: l_report_name := p_report_name;
4222: -- Need to convert the dates from canonical to Date
4223: l_start_date := fnd_date.canonical_to_date(p_start_date);
4224: l_end_date := fnd_date.canonical_to_date(p_end_date);
4225: l_ret_code := 0;
4226: --
4227: populate_ghr_cpdf_temp(p_agency_code||NVL(p_agency_subelement,'%'),l_start_date,l_end_date,FALSE);

Line 4224: l_end_date := fnd_date.canonical_to_date(p_end_date);

4220: BEGIN
4221: l_report_name := p_report_name;
4222: -- Need to convert the dates from canonical to Date
4223: l_start_date := fnd_date.canonical_to_date(p_start_date);
4224: l_end_date := fnd_date.canonical_to_date(p_end_date);
4225: l_ret_code := 0;
4226: --
4227: populate_ghr_cpdf_temp(p_agency_code||NVL(p_agency_subelement,'%'),l_start_date,l_end_date,FALSE);
4228: -- Generate ASCII and XML files