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.PAY_ES_TWR_CALC_PKG dependencies on FND_DATE

Line 1355: vXMLTable(vCtr).TagValue := fnd_date.date_to_displaydate(i.effective_date);

1351: END IF;
1352: l_no := l_no + 1;
1353:
1354: vXMLTable(vCtr).TagName := 'TWR_EFFECTIVE_DATE';
1355: vXMLTable(vCtr).TagValue := fnd_date.date_to_displaydate(i.effective_date);
1356: vCtr := vCtr + 1;
1357:
1358: OPEN csr_get_emp_detail(i.assignment_id, i.effective_date);
1359: FETCH csr_get_emp_detail INTO l_emp_detail_rec;

Line 1430: vXMLTable(vCtr).TagValue := fnd_date.date_to_displaydate(i.effective_date);

1426: FETCH csr_get_twr_override_values into l_otwr_rec;
1427: CLOSE csr_get_twr_override_values;*/
1428:
1429: vXMLTable(vCtr).TagName := 'TWR_EFFECTIVE_DATE';
1430: vXMLTable(vCtr).TagValue := fnd_date.date_to_displaydate(i.effective_date);
1431: vCtr := vCtr + 1;
1432:
1433: vXMLTable(vCtr).TagName := 'TWR_ASSIGNMENT_NO';
1434: vXMLTable(vCtr).TagValue := l_emp_rec.Assignment_Number;

Line 1895: SELECT NVL(fnd_date.canonical_to_date(CTR_INFORMATION4),to_date('31-12-4712','dd-mm-yyyy')) Contract_End_Date

1891: ,p_effective_date IN DATE) RETURN DATE
1892: IS
1893: CURSOR csr_get_contract_end_date(c_assignment_id NUMBER
1894: ,c_effective_date DATE) IS
1895: SELECT NVL(fnd_date.canonical_to_date(CTR_INFORMATION4),to_date('31-12-4712','dd-mm-yyyy')) Contract_End_Date
1896: FROM PER_CONTRACTS_f pcf
1897: ,per_all_assignments_f paaf
1898: WHERE paaf.assignment_id = c_assignment_id
1899: AND paaf.contract_id = pcf.contract_id

Line 2022: l_co_start_date := fnd_date.canonical_to_date(i.start_date);

2018: FOR l_rec in csr_get_work_centers(l_work_center) LOOP
2019: hr_utility.trace(' Work Center ID : '||l_rec.work_center);
2020: FOR i IN csr_get_assignment_id(l_person_id,p_calculation_date,l_rec.work_center) LOOP
2021: --
2022: l_co_start_date := fnd_date.canonical_to_date(i.start_date);
2023: l_co_end_date := fnd_date.canonical_to_date(i.end_date);
2024: l_amt := 0;
2025: l_start_date := GREATEST(p_period_start_date,nvl(l_co_start_date,p_period_start_date));
2026: l_end_date := LEAST(l_end_year,nvl(l_co_end_date,l_end_year));

Line 2023: l_co_end_date := fnd_date.canonical_to_date(i.end_date);

2019: hr_utility.trace(' Work Center ID : '||l_rec.work_center);
2020: FOR i IN csr_get_assignment_id(l_person_id,p_calculation_date,l_rec.work_center) LOOP
2021: --
2022: l_co_start_date := fnd_date.canonical_to_date(i.start_date);
2023: l_co_end_date := fnd_date.canonical_to_date(i.end_date);
2024: l_amt := 0;
2025: l_start_date := GREATEST(p_period_start_date,nvl(l_co_start_date,p_period_start_date));
2026: l_end_date := LEAST(l_end_year,nvl(l_co_end_date,l_end_year));
2027: IF i.Period_type = 'A' THEN