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 375: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);

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

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

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

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

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

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

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

Line 572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);

568: p_frozen_service := l_rei.rei_information9;
569: --p_from_retirement_coverage := l_rei.rei_information7;
570:
571: -- NEW EHRI DYNAMICS MADHURI
572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);
573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);
574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);
575: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);

Line 573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);

569: --p_from_retirement_coverage := l_rei.rei_information7;
570:
571: -- NEW EHRI DYNAMICS MADHURI
572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);
573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);
574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);
575: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);
577: --End Bug 12557463

Line 574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);

570:
571: -- NEW EHRI DYNAMICS MADHURI
572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);
573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);
574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);
575: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);
577: --End Bug 12557463
578: -- -- Bug 4724337 Race or National Origin changes

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

571: -- NEW EHRI DYNAMICS MADHURI
572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);
573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);
574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);
575: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);
577: --End Bug 12557463
578: -- -- Bug 4724337 Race or National Origin changes
579: ELSIF l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' THEN

Line 576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);

572: p_scd_ses := fnd_date.canonical_to_date(l_rei.rei_information4);
573: p_scd_spcl_retire := fnd_date.canonical_to_date(l_rei.rei_information5);
574: p_tsp_scd := fnd_date.canonical_to_date(l_rei.rei_information6);
575: p_scd_rif := fnd_date.canonical_to_date(l_rei.REI_INFORMATION3);
576: p_scd_retirement := fnd_date.canonical_to_date(l_rei.REI_INFORMATION2);
577: --End Bug 12557463
578: -- -- Bug 4724337 Race or National Origin changes
579: ELSIF l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' THEN
580: IF l_rei.rei_information3 IS NOT NULL OR

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

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

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

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

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

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

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

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

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

635: p_scd_retirement := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information7);
636: END IF;
637: --
638: IF p_scd_ses IS NULL THEN
639: p_scd_ses := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information8);
640: END IF;
641: --
642: IF p_scd_spcl_retire IS NULL THEN
643: p_scd_spcl_retire := fnd_date.canonical_to_date(l_per_ei_grp1_data.pei_information9);

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

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

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

828: p_date_effective => p_effective_date,
829: p_asg_ei_data => l_asg_ei_data
830: );
831:
832: l_appt_nte_date := fnd_date.canonical_to_date(l_asg_ei_data.AEI_INFORMATION4);
833: --
834: p_appt_nte_date := l_appt_nte_date;
835:
836: EXCEPTION

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

3983:
3984:
3985: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3986: LOOP
3987: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3988: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3989: -- Added date conversion for bug#3808473-EHRI reports
3990: END LOOP;
3991:

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

3984:
3985: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
3986: LOOP
3987: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
3988: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
3989: -- Added date conversion for bug#3808473-EHRI reports
3990: END LOOP;
3991:
3992: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

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

3999: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
4000: p_per_ei_data => ll_per_ei_data
4001: );
4002:
4003: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
4004: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
4005:
4006: EXCEPTION
4007: WHEN OTHERS THEN

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

4000: p_per_ei_data => ll_per_ei_data
4001: );
4002:
4003: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
4004: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
4005:
4006: EXCEPTION
4007: WHEN OTHERS THEN
4008: l_message_name := 'fetch_peopleei';

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

4522: --
4523: BEGIN
4524: l_report_name := p_report_name;
4525: -- Need to convert the dates from canonical to Date
4526: l_start_date := fnd_date.canonical_to_date(p_start_date);
4527: l_end_date := fnd_date.canonical_to_date(p_end_date);
4528: l_ret_code := 0;
4529: -- BUg # 8486208 added for new parameter agencies or agency subelements
4530: IF p_agency_code is NOT NULL OR p_agency_group is NULL THEN

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

4523: BEGIN
4524: l_report_name := p_report_name;
4525: -- Need to convert the dates from canonical to Date
4526: l_start_date := fnd_date.canonical_to_date(p_start_date);
4527: l_end_date := fnd_date.canonical_to_date(p_end_date);
4528: l_ret_code := 0;
4529: -- BUg # 8486208 added for new parameter agencies or agency subelements
4530: IF p_agency_code is NOT NULL OR p_agency_group is NULL THEN
4531: IF p_agency_subelement IS NULL THEN