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 1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)

1864: If p_pa_request_rec.service_comp_date is not null then
1865: hr_utility.set_location(l_proc,85);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1872: p_per_scd_info.per_scd_info_flag := 'Y';

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

1865: hr_utility.set_location(l_proc,85);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1872: p_per_scd_info.per_scd_info_flag := 'Y';
1873: End if;

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

1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1872: p_per_scd_info.per_scd_info_flag := 'Y';
1873: End if;
1874: End if;
1875:

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

3324:
3325: p_gov_awards.award_agency := l_pa_request_ei_rec.rei_information3;
3326: p_gov_awards.award_type := '07';
3327: -- Venkat -- Bug #982677 -- Previously referring trunc
3328: p_gov_awards.date_award_earned := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
3329:
3330: If l_session.noa_id_correct is null then
3331: p_gov_awards.award_flag := 'Y';
3332: elsIf l_session.noa_id_correct is not null and -- for correction fetch the existing values

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

4459: p_mddds_special_pay.mddds_special_pay_flag,
4460: 'Y' );
4461:
4462: set_extra_info(p_mddds_special_pay.mddds_special_pay_date,
4463: fnd_date.canonical_to_date(l_pa_request_ei_rec.rei_information12),
4464: p_mddds_special_pay.mddds_special_pay_flag,
4465: 'Y' );
4466: set_extra_info(p_mddds_special_pay.premium_pay_ind,
4467: l_pa_request_ei_rec.rei_information13,

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

5064: If l_noa_code in ('108','115','117','122','148','149','153',
5065: '154','171','190','508','515','517','522','548',
5066: '549','553','554','571','590','741') then
5067: --Bug# 4602352 703 is removed from the list
5068: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5069: hr_utility.set_location('inside asg nte dates ',1);
5070: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5071: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5072: --Begin Bug# 4602352

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

5070: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5071: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5072: --Begin Bug# 4602352
5073: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5074: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5075: hr_utility.set_location('inside asg nte dates for 703 ',111);
5076: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5077: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5078: --End Bug# 4602352

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

5076: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5077: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5078: --End Bug# 4602352
5079: Elsif l_noa_code = '472' then
5080: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5081: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5082: Elsif l_noa_code = '462' then
5083: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5084: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

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

5080: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5081: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5082: Elsif l_noa_code = '462' then
5083: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5084: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5085: Elsif l_noa_code = '460' then
5086: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5087: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5088: Elsif l_noa_code = '480' then

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

5082: Elsif l_noa_code = '462' then
5083: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5084: p_asg_nte_dates.lwp_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5085: Elsif l_noa_code = '460' then
5086: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5087: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5088: Elsif l_noa_code = '480' then
5089: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5090: p_asg_nte_dates.asg_nte_dates_flag := 'Y';

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

5085: Elsif l_noa_code = '460' then
5086: p_asg_nte_dates.lwop_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5087: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5088: Elsif l_noa_code = '480' then
5089: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5090: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5091: Elsif l_noa_code = '450' then
5092: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5093: p_asg_nte_dates.suspension_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);

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

5089: p_asg_nte_dates.sabatical_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5090: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5091: Elsif l_noa_code = '450' then
5092: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5093: p_asg_nte_dates.suspension_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5094: End if;
5095:
5096:
5097: -- NTE dates processing