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 683: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);

679: l_rate := to_number(l_cur_element.screen_entry_value);
680: ELSIF l_cur_element.ipv_name = 'Status' then
681: l_tsp_status := substr(l_cur_element.screen_entry_value,1,1);
682: ELSIF l_cur_element.ipv_name = 'Status Date' then
683: l_tsp_status_date := fnd_date.canonical_to_date(l_cur_element.screen_entry_value);
684: ELSIF l_cur_element.ipv_name = 'Amount' then
685: l_amount := to_number(l_cur_element.screen_entry_value);
686: END IF;
687: END LOOP;

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

857: -- Validation only if person is employee
858: IF l_assignment_type = 'E' THEN
859: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
860: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
861: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);

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

858: IF l_assignment_type = 'E' THEN
859: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
860: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
861: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);

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

859: FOR l_cur_per_ei IN c_per_ei(p_person_extra_info_id,p_information_type) LOOP
860: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
861: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
867: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN

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

860: IF p_information_type = 'GHR_US_PER_BENEFIT_INFO' THEN
861: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
867: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
868: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);

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

861: l_date_fehb_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information4);
862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
867: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
868: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
869: END IF;

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

862: l_date_temp_elig := fnd_date.canonical_to_date(l_cur_per_ei.pei_information5);
863: l_fegli_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information3);
864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
867: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
868: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
869: END IF;
870: END LOOP;

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

864: l_fers_elig_exp_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information11);
865: l_agency_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information14);
866: l_emp_contrib_date := fnd_date.canonical_to_date(l_cur_per_ei.pei_information15);
867: ELSIF p_information_type = 'GHR_US_PER_SCD_INFORMATION' THEN
868: l_tsp_scd := fnd_date.canonical_to_date(l_cur_per_ei.pei_information6);
869: END IF;
870: END LOOP;
871: -- Get Annuitant indicator
872: ghr_history_fetch.fetch_asgei