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

Line 424: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);

420: END IF;
421: --Begin Bug 12637350
422: IF p_noa_family_code IN ('APP','CONV_APP','EXT_NTE') THEN
423: FOR l_first_nte_date IN c_first_nte_date LOOP
424: l_nte_date := fnd_date.canonical_to_date(l_first_nte_date.first_noa_information1);
425: END LOOP;
426: IF p_noa_family_code IN ('APP') THEN
427: l_asg_start_date := p_effective_date+365;
428: ELSIF p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN

Line 931: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);

927: l_rate := to_number(l_cur_element.screen_entry_value);
928: ELSIF l_cur_element.ipv_name = 'Status' then
929: l_tsp_status := substr(l_cur_element.screen_entry_value,1,1);
930: ELSIF l_cur_element.ipv_name = 'Status Date' then
931: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);
932: ELSIF l_cur_element.ipv_name = 'Amount' then
933: l_amount := to_number(l_cur_element.screen_entry_value);
934: END IF;
935: END LOOP;

Line 1083: fnd_date.date_to_displaydate(p_effective_date)

1079: ,p_input_value_name6 => 'Status'
1080: ,p_value6 => 'Y'
1081: ,p_input_value_name7 => 'Status Date'
1082: ,p_value7 =>
1083: fnd_date.date_to_displaydate(p_effective_date)
1084: ,p_effective_date => p_effective_date
1085: ,p_process_warning => l_warning
1086: );
1087: END IF;

Line 1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);

1284: -- Validation only if person is employee
1285: IF l_assignment_type = 'E' THEN
1286: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
1287: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);

Line 1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);

1285: IF l_assignment_type = 'E' THEN
1286: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
1287: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);

Line 1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);

1286: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
1287: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
1294: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN

Line 1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);

1287: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
1294: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
1295: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);

Line 1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);

1288: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
1294: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
1295: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
1296: END IF;

Line 1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);

1289: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
1290: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
1294: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
1295: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
1296: END IF;
1297: END LOOP;

Line 1295: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);

1291: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
1292: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
1293: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
1294: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
1295: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
1296: END IF;
1297: END LOOP;
1298: -- Get Annuitant indicator
1299: ghr_history_fetch.fetch_asgei