DBA Data[Home] [Help]

APPS.GHR_CPDF_STATRPT dependencies on FND_DATE

Line 283: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(l_ANCRIT_REC.SEGMENT6);

279:
280: IF l_ancrit_rec.object_version_number IS NOT NULL THEN
281: p_sr_ghr_cpdf_temp.rating_of_record_level := l_ANCRIT_REC.SEGMENT5;
282: p_sr_ghr_cpdf_temp.rating_of_record_pattern := l_ANCRIT_REC.SEGMENT4;
283: p_sr_ghr_cpdf_temp.rating_of_record_period_ends := fnd_date.canonical_to_date(l_ANCRIT_REC.SEGMENT6);
284: ELSE -- Generate entry in PROCESS_LOG
285: OPEN c_per;
286: FETCH c_per INTO l_emp_number;
287: CLOSE c_per;

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

408: p_per_ei_data => l_PEOPEI_DATA
409: );
410: -- SVC may be changed w/ resolution of type/length conversion
411: p_sr_ghr_cpdf_temp.service_comp_date :=
412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
413:
414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
416: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);

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

412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
413:
414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
416: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
417: p_sr_ghr_cpdf_temp.SCD_retirement :=
418: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
419: -- EHRI changes
420:

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

414: -- SCD RIF and Retirement dates
415: p_sr_ghr_cpdf_temp.SCD_rif :=
416: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
417: p_sr_ghr_cpdf_temp.SCD_retirement :=
418: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
419: -- EHRI changes
420:
421: -- CPDF EDITS FOR CREDITABLE MILITARY SERVICE
422: -- October date specified per requirements

Line 1406: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);

1402: p_date_effective => nvl(g_report_date,trunc(sysdate)),
1403: p_per_ei_data => ll_per_ei_data
1404: );
1405:
1406: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1407: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1408: */
1409: --
1410: -- Bug 3671043 Handling Exceptions (madhuri)

Line 1407: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);

1403: p_per_ei_data => ll_per_ei_data
1404: );
1405:
1406: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1407: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1408: */
1409: --
1410: -- Bug 3671043 Handling Exceptions (madhuri)
1411: -- Begin Bug# 4168162