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

Line 361: between fnd_date.canonical_to_date(AEI_INFORMATION1)

357: from per_assignment_extra_info
358: where assignment_id = p_pa_request_rec.employee_assignment_id
359: and information_type='GHR_US_ASG_DET_INFO'
360: and g_effective_date
361: between fnd_date.canonical_to_date(AEI_INFORMATION1)
362: and fnd_date.canonical_to_date(AEI_INFORMATION2);
363: --End Bug# 9898968
364: --Begin Bug# 11781477
365: CURSOR c_get_pos_avl_status (p_position_id number,g_effective_date DATE) IS

Line 362: and fnd_date.canonical_to_date(AEI_INFORMATION2);

358: where assignment_id = p_pa_request_rec.employee_assignment_id
359: and information_type='GHR_US_ASG_DET_INFO'
360: and g_effective_date
361: between fnd_date.canonical_to_date(AEI_INFORMATION1)
362: and fnd_date.canonical_to_date(AEI_INFORMATION2);
363: --End Bug# 9898968
364: --Begin Bug# 11781477
365: CURSOR c_get_pos_avl_status (p_position_id number,g_effective_date DATE) IS
366: SELECT HR_GENERAL.DECODE_AVAILABILITY_STATUS(hap.availability_status_id) status

Line 822: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);

818: /* Check whether Service Obligation Information is entered for GHR_INCENTIVE Family or Not */
819: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
820: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
821: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
822: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
823: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
824:
825: IF (l_noa_family_code = 'GHR_INCENTIVE' OR
826: (p_pa_request_rec.first_noa_code = '002' AND p_pa_request_rec.second_noa_code IN ('815','816','827'))

Line 823: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);

819: l_serv_oblig_code := p_per_service_oblig.service_oblig_type_code;
820: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_start_date,10);
821: hr_utility.set_location('RRR 0'||p_per_service_oblig.service_oblig_end_date,10);
822: l_serv_oblig_stdt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_start_date);
823: l_serv_oblig_enddt := fnd_date.canonical_to_date(p_per_service_oblig.service_oblig_end_date);
824:
825: IF (l_noa_family_code = 'GHR_INCENTIVE' OR
826: (p_pa_request_rec.first_noa_code = '002' AND p_pa_request_rec.second_noa_code IN ('815','816','827'))
827: ) THEN

Line 1141: ,p_effective_date => fnd_date.canonical_to_date(l_special_info_type.segment6)

1137: if l_special_info_type.segment6 is not null then
1138: ghr_api.retrieve_element_entry_value (p_element_name => 'Adjusted Basic Pay'
1139: ,p_input_value_name => 'Amount'
1140: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1141: ,p_effective_date => fnd_date.canonical_to_date(l_special_info_type.segment6)
1142: ,p_value => l_value
1143: ,p_multiple_error_flag=> l_multi_error_flag);
1144: l_adj_basic_pay_amt := l_value;
1145: end if;

Line 1440: l_review_date := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(cur_repay_sch_rec.review_date));

1436:
1437: FOR cur_repay_sch_rec in cur_repay_sch
1438: LOOP
1439: l_repay_sch := cur_repay_sch_rec.repay_sch;
1440: l_review_date := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(cur_repay_sch_rec.review_date));
1441: END LOOP;
1442:
1443: IF ( p_pa_request_rec.award_amount > 10000 ) then
1444: hr_utility.set_message(8301,'GHR_38862_AMT_EXCEEDS_LIMIT');

Line 1553: l_mddds_specia_pay_nte_date := fnd_date.canonical_to_date(cur_mddds_pay_rec.nte_date);

1549:
1550: FOR cur_mddds_pay_rec in cur_mddds_pay
1551: LOOP
1552: l_mddds_special_pay_amount := cur_mddds_pay_rec.amount;
1553: l_mddds_specia_pay_nte_date := fnd_date.canonical_to_date(cur_mddds_pay_rec.nte_date);
1554: l_premium_pay_ind := cur_mddds_pay_rec.premium_pay_ind;
1555: END LOOP;
1556:
1557: IF l_premium_pay_ind IS NULL THEN

Line 1837: l_detail_nte_date := fnd_date.canonical_to_date(c_detail_second_nte_date_rec.second_noa_information1);

1833: --End Bug# 9898968
1834: END IF;
1835: IF l_session.noa_id_correct IS NOT NULL THEN
1836: FOR c_detail_second_nte_date_rec in c_detail_second_nte_date LOOP
1837: l_detail_nte_date := fnd_date.canonical_to_date(c_detail_second_nte_date_rec.second_noa_information1);
1838: END LOOP;
1839:
1840: ELSE
1841: FOR c_detail_first_nte_date_rec in c_detail_first_nte_date LOOP

Line 1842: l_detail_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);

1838: END LOOP;
1839:
1840: ELSE
1841: FOR c_detail_first_nte_date_rec in c_detail_first_nte_date LOOP
1842: l_detail_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);
1843: END LOOP;
1844: END IF;
1845: IF l_detail_nte_date <= p_pa_request_rec.effective_date THEN
1846: hr_utility.set_message(8301,'GHR_37754_DETAIL_POS_CHK');

Line 2564: l_noa_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);

2560: --Begin Bug 12637350
2561: IF p_pa_request_rec.noa_family_code IN ('APP','CONV_APP','EXT_NTE') THEN
2562: hr_utility.set_location('Fehb Elig Exp Date '||p_pa_request_rec.first_noa_code , 11);
2563: FOR c_detail_first_nte_date_rec in c_detail_first_nte_date LOOP
2564: l_noa_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);
2565: END LOOP;
2566: FOR c_cur_fehb_elg_exp_date in cur_fehb_elg_exp_date LOOP
2567: l_fehb_elig_exp_date := fnd_date.canonical_to_date(c_cur_fehb_elg_exp_date.rei_information3);
2568: END LOOP;

Line 2567: l_fehb_elig_exp_date := fnd_date.canonical_to_date(c_cur_fehb_elg_exp_date.rei_information3);

2563: FOR c_detail_first_nte_date_rec in c_detail_first_nte_date LOOP
2564: l_noa_nte_date := fnd_date.canonical_to_date(c_detail_first_nte_date_rec.first_noa_information1);
2565: END LOOP;
2566: FOR c_cur_fehb_elg_exp_date in cur_fehb_elg_exp_date LOOP
2567: l_fehb_elig_exp_date := fnd_date.canonical_to_date(c_cur_fehb_elg_exp_date.rei_information3);
2568: END LOOP;
2569: IF p_pa_request_rec.noa_family_code IN ('APP') THEN
2570: l_asg_start_date := p_pa_request_rec.effective_date+365;
2571: ELSIF p_pa_request_rec.noa_family_code IN ('CONV_APP','EXT_NTE') THEN