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

Line 1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)

1967: If p_pa_request_rec.service_comp_date is not null then
1968: hr_utility.set_location(l_proc,85);
1969:
1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1973: hr_utility.set_location(l_proc,95);
1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1975: p_per_scd_info.per_scd_info_flag := 'Y';

Line 1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then

1968: hr_utility.set_location(l_proc,85);
1969:
1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1973: hr_utility.set_location(l_proc,95);
1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1975: p_per_scd_info.per_scd_info_flag := 'Y';
1976: End if;

Line 1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);

1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1973: hr_utility.set_location(l_proc,95);
1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1975: p_per_scd_info.per_scd_info_flag := 'Y';
1976: End if;
1977: End if;
1978:

Line 2297: and fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei_information6),p_pa_request_rec.effective_date) )

2293: Select *
2294: from ghr_pa_request_extra_info
2295: where pa_request_id = p_pa_request_rec.pa_request_id
2296: and information_type = l_information_type
2297: and fnd_date.canonical_to_date(rei_information6) = (select MIN (NVL(fnd_date.canonical_to_date(rei_information6),p_pa_request_rec.effective_date) )
2298: FROM ghr_pa_request_extra_info
2299: WHERE pa_request_id = p_pa_request_rec.pa_request_id
2300: AND information_type = l_information_type);
2301:

Line 3756: p_gov_awards.date_award_earned := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

3752: (NVL(p_pa_request_rec.second_action_la_code1,'111') = 'RBM' or NVL(p_pa_request_rec.second_action_la_code2,'111') = 'RBM')) then
3753: hr_utility.set_location('Entering ' ||l_proc,55);
3754: p_gov_awards.award_agency := l_pa_request_ei_rec.rei_information3;
3755: p_gov_awards.award_type := '07';
3756: p_gov_awards.date_award_earned := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
3757:
3758: If l_session.noa_id_correct is null then
3759: p_gov_awards.award_flag := 'Y';
3760: elsIf l_session.noa_id_correct is not null and -- for correction fetch the existing values

Line 4893: fnd_date.canonical_to_date(l_pa_request_ei_rec.rei_information12),

4889: p_mddds_special_pay.mddds_special_pay_flag,
4890: 'Y' );
4891:
4892: set_extra_info(p_mddds_special_pay.mddds_special_pay_date,
4893: fnd_date.canonical_to_date(l_pa_request_ei_rec.rei_information12),
4894: p_mddds_special_pay.mddds_special_pay_flag,
4895: 'Y' );
4896: set_extra_info(p_mddds_special_pay.premium_pay_ind,
4897: l_pa_request_ei_rec.rei_information13,

Line 5588: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5584: If l_noa_code in ('108','115','117','122','148','149','153',
5585: '154','171','190','508','515','517','522','548',
5586: '549','553','554','571','590','741') then
5587: --Bug# 4602352 703 is removed from the list
5588: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5589: hr_utility.set_location('inside asg nte dates ',1);
5590: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5591: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5592: --Begin Bug# 4602352

Line 5594: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5590: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5591: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5592: --Begin Bug# 4602352
5593: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5594: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5595: hr_utility.set_location('inside asg nte dates for 703 ',111);
5596: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5597: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5598: --End Bug# 4602352

Line 5600: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5596: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5597: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5598: --End Bug# 4602352
5599: Elsif l_noa_code = '472' then
5600: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5601: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5602: Elsif l_noa_code = '462' then
5603: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5604: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

Line 5604: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5600: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5601: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5602: Elsif l_noa_code = '462' then
5603: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5604: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5605: Elsif l_noa_code = '460' then
5606: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5607: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5608: Elsif l_noa_code = '480' then

Line 5606: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5602: Elsif l_noa_code = '462' then
5603: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5604: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5605: Elsif l_noa_code = '460' then
5606: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5607: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5608: Elsif l_noa_code = '480' then
5609: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5610: p_asg_nte_dates.asg_nte_dates_flag := 'Y';

Line 5609: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5605: Elsif l_noa_code = '460' then
5606: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5607: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5608: Elsif l_noa_code = '480' then
5609: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5610: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5611: Elsif l_noa_code = '450' then
5612: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5613: p_asg_nte_dates.suspension_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

Line 5613: p_asg_nte_dates.suspension_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5609: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5610: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5611: Elsif l_noa_code = '450' then
5612: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5613: p_asg_nte_dates.suspension_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5614: End if;
5615:
5616:
5617: -- NTE dates processing

Line 5741: p_asg_detail_info.detail_begin_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

5737: p_asg_nte_dates.sabatical_nte_start_date := null;
5738: end if;
5739: --Begin Bug# 10182526
5740: IF l_noa_code IN ('730','930') THEN
5741: p_asg_detail_info.detail_begin_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5742: IF l_session.noa_id_correct IS NOT NULL THEN
5743: FOR c_detail_second_nte_date_rec in c_detail_second_nte_date LOOP
5744: l_detail_nte_date := c_detail_second_nte_date_rec.second_noa_information1;
5745: END LOOP;

Line 5779: fnd_date.date_to_canonical(p_pa_request_rec.effective_date),p_asg_detail_info.asg_detail_info_flag,'Y');

5775: ELSIF l_noa_code IN ('732','932') THEN
5776: set_extra_info(p_asg_detail_info.detail_begin_date,
5777: p_asg_detail_info.detail_begin_date,p_asg_detail_info.asg_detail_info_flag,'Y');
5778: set_extra_info(p_asg_detail_info.detail_end_date,
5779: fnd_date.date_to_canonical(p_pa_request_rec.effective_date),p_asg_detail_info.asg_detail_info_flag,'Y');
5780: END IF;
5781: --End Bug# 10182526
5782: --Begin Bug# 13942237
5783: --Bug# 14514445 commented below code since we are getting promotion_eligibility_date from RPA EITs

Line 5806: set_extra_info(p_per_group1.promotion_eligibility_date,fnd_date.date_to_canonical(p_pa_request_rec.effective_date+365),

5802:
5803: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
5804: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
5805: hr_utility.set_location('promotion_eligibility_date update '|| l_valid_grade_name,353);
5806: set_extra_info(p_per_group1.promotion_eligibility_date,fnd_date.date_to_canonical(p_pa_request_rec.effective_date+365),
5807: p_per_group1.per_group1_flag);
5808: END IF;
5809:
5810: END IF;*/