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

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

337:
338: IF l_special_info.object_version_number IS NOT NULL THEN
339: p_rating_of_record_level := l_special_info.segment5;
340: p_rating_of_record_pattern := l_special_info.segment4;
341: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
342: ELSE -- Added select for bug# 1389262
343: DECLARE
344: l_effective_date DATE;
345: BEGIN

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

356: l_effective_date, l_special_info);
357: IF l_special_info.object_version_number IS NOT NULL THEN
358: p_rating_of_record_level := l_special_info.segment5;
359: p_rating_of_record_pattern := l_special_info.segment4;
360: p_rating_of_record_period := fnd_date.canonical_to_date(l_special_info.segment6);
361: /* Pradeep commented this for the Bug 4005811
362: ELSE
363: raise NO_DATA_FOUND;
364: End of Bug 4005811*/

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

2048: END LOOP;
2049:
2050: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2051: LOOP
2052: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2053: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2054: -- Added date conversion for bug#3808473-EHRI reports
2055: END LOOP;
2056:

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

2049:
2050: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2051: LOOP
2052: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2053: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2054: -- Added date conversion for bug#3808473-EHRI reports
2055: END LOOP;
2056:
2057: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

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

2064: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2065: p_per_ei_data => ll_per_ei_data
2066: );
2067:
2068: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2069: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2070:
2071: EXCEPTION
2072: WHEN OTHERS THEN

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

2065: p_per_ei_data => ll_per_ei_data
2066: );
2067:
2068: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2069: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2070:
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073: l_message_name := 'fetch_peopleei';