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 572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);

568:
569: FOR c_chk_ast_status IN chk_susp_asg_status
570: LOOP
571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

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

569: FOR c_chk_ast_status IN chk_susp_asg_status
570: LOOP
571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

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

570: LOOP
571: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
572: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
573: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
574: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
575: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
576: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
577: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);
578: IF (nvl(l_lwop_nte_date,p_empl_as_of_date) > p_empl_as_of_date + 30 ) or

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

1656: l_susp_flag := 'N';
1657: FOR c_chk_ast_status IN chk_susp_asg_status
1658: LOOP
1659: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1660: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);

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

1657: FOR c_chk_ast_status IN chk_susp_asg_status
1658: LOOP
1659: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1660: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);

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

1658: LOOP
1659: GHR_HISTORY_FETCH.fetch_asgei(l_assignment_id,'GHR_US_ASG_NTE_DATES',p_rpt_date, l_asgn_hist_data);
1660: l_lwop_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information6);
1661: l_susp_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information8);
1662: l_furlough_nte_date := fnd_date.canonical_to_date(l_asgn_hist_data.aei_information10);
1663:
1664: hr_utility.set_location(' lwop date is ' || l_lwop_nte_date, 1);
1665: hr_utility.set_location(' susp date is ' || l_susp_nte_date, 1);
1666: hr_utility.set_location(' furlough date is ' || l_furlough_nte_date, 1);

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

2116: --
2117: BEGIN
2118: --
2119: hr_utility.set_location('Entering: '||l_proc,10);
2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2124: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);

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

2117: BEGIN
2118: --
2119: hr_utility.set_location('Entering: '||l_proc,10);
2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2124: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2125: l_last_rpt_date := l_previous_report_date - 1;

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

2118: --
2119: hr_utility.set_location('Entering: '||l_proc,10);
2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2124: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2125: l_last_rpt_date := l_previous_report_date - 1;
2126: l_agency_code := p_agency_code || p_agency_subelement || '%';

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

2119: hr_utility.set_location('Entering: '||l_proc,10);
2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2124: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2125: l_last_rpt_date := l_previous_report_date - 1;
2126: l_agency_code := p_agency_code || p_agency_subelement || '%';
2127: --

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

2120: l_rpt_date := fnd_date.canonical_to_date(p_rpt_date);
2121: l_pay_to := fnd_date.canonical_to_date(p_pay_to);
2122: l_pay_from := fnd_date.canonical_to_date(p_pay_from);
2123: l_emp_as_of_date := fnd_date.canonical_to_date(p_employment_as_of_date);
2124: l_previous_report_date := fnd_date.canonical_to_date(p_previous_report_date);
2125: l_last_rpt_date := l_previous_report_date - 1;
2126: l_agency_code := p_agency_code || p_agency_subelement || '%';
2127: --
2128: ghr_sf113_payroll(p_pay_from => l_pay_from,