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

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

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

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

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

2188: END LOOP;
2189:
2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2191: LOOP
2192: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2194: -- Added date conversion for bug#3808473-EHRI reports
2195: END LOOP;
2196:

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

2189:
2190: FOR scd_dates IN cur_scd_dates(l_ghr_pa_requests_rec.pa_request_id)
2191: LOOP
2192: l_ghr_cpdf_temp_rec.SCD_rif := fnd_date.canonical_to_date(scd_dates.rif);
2193: l_ghr_cpdf_temp_rec.SCD_retirement := fnd_date.canonical_to_date(scd_dates.ret);
2194: -- Added date conversion for bug#3808473-EHRI reports
2195: END LOOP;
2196:
2197: IF (l_ghr_cpdf_temp_rec.SCD_rif IS NULL

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

2204: p_date_effective => nvl(l_ghr_pa_requests_rec.effective_date,trunc(sysdate)),
2205: p_per_ei_data => ll_per_ei_data
2206: );
2207:
2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2209: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2210:
2211: EXCEPTION
2212: WHEN OTHERS THEN

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

2205: p_per_ei_data => ll_per_ei_data
2206: );
2207:
2208: l_ghr_cpdf_temp_rec.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
2209: l_ghr_cpdf_temp_rec.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
2210:
2211: EXCEPTION
2212: WHEN OTHERS THEN
2213: l_message_name := 'fetch_peopleei';