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

Line 563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);

559:
560: FOR c_chk_ast_status IN chk_susp_asg_status
561: LOOP
562: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

Line 564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);

560: FOR c_chk_ast_status IN chk_susp_asg_status
561: LOOP
562: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
568: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

Line 565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);

561: LOOP
562: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
563: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
564: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
565: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
566: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
567: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
568: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
569: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or

Line 1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);

1636: l_susp_flag := 'N';
1637: FOR c_chk_ast_status IN chk_susp_asg_status
1638: LOOP
1639: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

Line 1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);

1637: FOR c_chk_ast_status IN chk_susp_asg_status
1638: LOOP
1639: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1645: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

Line 1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);

1638: LOOP
1639: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1640: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1641: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1642: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1643:
1644: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1645: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1646: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

Line 2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);

2084: --
2085: BEGIN
2086: --
2087: hr_utility.set_location('Entering: '||l_proc,10);
2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);

Line 2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);

2085: BEGIN
2086: --
2087: hr_utility.set_location('Entering: '||l_proc,10);
2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2093: l_last_rpt_date := l_previous_report_date - 1;

Line 2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);

2086: --
2087: hr_utility.set_location('Entering: '||l_proc,10);
2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2093: l_last_rpt_date := l_previous_report_date - 1;
2094: l_agency_code := p_agency_code || p_agency_subelement || '%';

Line 2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);

2087: hr_utility.set_location('Entering: '||l_proc,10);
2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2093: l_last_rpt_date := l_previous_report_date - 1;
2094: l_agency_code := p_agency_code || p_agency_subelement || '%';
2095: --

Line 2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);

2088: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2089: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2090: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2091: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2092: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2093: l_last_rpt_date := l_previous_report_date - 1;
2094: l_agency_code := p_agency_code || p_agency_subelement || '%';
2095: --
2096: ghr_sf113_payroll(p_pay_from => l_pay_from,