DBA Data[Home] [Help]

APPS.GHR_CPDF_STATRPT dependencies on FND_DATE

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

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

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

402: p_per_ei_data => l_PEOPEI_DATA
403: );
404: -- SVC may be changed w/ resolution of type/length conversion
405: p_sr_ghr_cpdf_temp.service_comp_date :=
406: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
407:
408: -- SCD RIF and Retirement dates
409: p_sr_ghr_cpdf_temp.SCD_rif :=
410: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);

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

406: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION3);
407:
408: -- SCD RIF and Retirement dates
409: p_sr_ghr_cpdf_temp.SCD_rif :=
410: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
411: p_sr_ghr_cpdf_temp.SCD_retirement :=
412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
413: -- EHRI changes
414:

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

408: -- SCD RIF and Retirement dates
409: p_sr_ghr_cpdf_temp.SCD_rif :=
410: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION5);
411: p_sr_ghr_cpdf_temp.SCD_retirement :=
412: fnd_date.canonical_to_date(l_PEOPEI_DATA.PEI_INFORMATION7);
413: -- EHRI changes
414:
415: -- CPDF EDITS FOR CREDITABLE MILITARY SERVICE
416: -- October date specified per requirements

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

1356: p_date_effective => nvl(g_report_date,trunc(sysdate)),
1357: p_per_ei_data => ll_per_ei_data
1358: );
1359:
1360: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1361: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1362: */
1363: --
1364: -- Bug 3671043 Handling Exceptions (madhuri)

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

1357: p_per_ei_data => ll_per_ei_data
1358: );
1359:
1360: g_ghr_cpdf_temp.SCD_rif:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information5);
1361: g_ghr_cpdf_temp.SCD_retirement:= fnd_date.canonical_to_date(ll_per_ei_data.pei_information7);
1362: */
1363: --
1364: -- Bug 3671043 Handling Exceptions (madhuri)
1365: -- Begin Bug# 4168162