DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on FND_DATE

Line 379: l_rpa_nte_date := fnd_date.canonical_to_date(l_cur_rpa_dtl.first_noa_information1);

375: l_information_type := 'GHR_US_PAR_LWOP_INFO';
376: END IF;
377: FOR l_cur_rpa_dtl IN cur_rpa_dtl(p_pa_request_id) LOOP
378: l_rpa_eff_date := l_cur_rpa_dtl.effective_date;
379: l_rpa_nte_date := fnd_date.canonical_to_date(l_cur_rpa_dtl.first_noa_information1);
380: END LOOP;
381: --Begin Bug# 14403219
382: IF p_noa_action IN ('471') THEN
383: ghr_history_fetch.fetch_peopleei

Line 415: l_eit_poi_dt := fnd_date.date_to_canonical(p_effective_date);

411: ELSIF p_noa_action IN ('800') and l_target_agency_code_subelmt IS NOT NULL THEN
412: l_information_type := 'GHR_US_PAR_CHG_DATA_ELEMENT';
413: l_eit_agency := l_target_agency_code_subelmt;
414: l_eit_poi := l_p_personnel_office_id;
415: l_eit_poi_dt := fnd_date.date_to_canonical(p_effective_date);
416: --Bug# 14456039
417: FOR l_cur_rpa_dtl IN cur_rpa_dtl(p_pa_request_id) LOOP
418: l_rpa_position_id := l_cur_rpa_dtl.from_position_id;
419: END LOOP;

Line 1084: l_old_furlough_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information9);

1080: p_date_effective => p_effective_date,
1081: p_asg_ei_data => l_asg_extra_info_rec
1082: );
1083:
1084: l_old_furlough_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information9);
1085: l_old_furlough_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information10);
1086: l_old_lwop_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information5);
1087: l_old_lwop_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information6);
1088: l_asg_extra_info_rec := NULL;

Line 1085: l_old_furlough_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information10);

1081: p_asg_ei_data => l_asg_extra_info_rec
1082: );
1083:
1084: l_old_furlough_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information9);
1085: l_old_furlough_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information10);
1086: l_old_lwop_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information5);
1087: l_old_lwop_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information6);
1088: l_asg_extra_info_rec := NULL;
1089: IF l_noa_code = '460' THEN

Line 1086: l_old_lwop_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information5);

1082: );
1083:
1084: l_old_furlough_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information9);
1085: l_old_furlough_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information10);
1086: l_old_lwop_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information5);
1087: l_old_lwop_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information6);
1088: l_asg_extra_info_rec := NULL;
1089: IF l_noa_code = '460' THEN
1090: l_new_lwop_nte_start_date := p_effective_date;

Line 1087: l_old_lwop_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information6);

1083:
1084: l_old_furlough_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information9);
1085: l_old_furlough_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information10);
1086: l_old_lwop_nte_start_date := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information5);
1087: l_old_lwop_nte := fnd_date.canonical_to_date(l_asg_extra_info_rec.aei_information6);
1088: l_asg_extra_info_rec := NULL;
1089: IF l_noa_code = '460' THEN
1090: l_new_lwop_nte_start_date := p_effective_date;
1091: l_new_lwop_nte := l_nte_date;

Line 2971: l_sf52_rec.first_noa_information1 := fnd_date.date_to_canonical (l_nte_date);

2967: , nvl(l_target_duty_station_desc,l_duty_station_desc), l_pay_rate_determinant
2968: , l_pay_calc_out_data.pay_table_id, l_pay_calc_out_data.calculation_pay_table_id
2969: , l_lac_sf52_rec, l_sf52_rec);
2970:
2971: l_sf52_rec.first_noa_information1 := fnd_date.date_to_canonical (l_nte_date);
2972:
2973: BEGIN
2974: ghr_mass_actions_pkg.pay_calc_rec_to_sf52_rec (l_pay_calc_out_data, l_sf52_rec);
2975: EXCEPTION