APPS.HRI_OPL_SUP_STATUS_HST dependencies on FND_DATE

Line 1571: l_start_date := TRUNC(fnd_date.canonical_to_date(p_start_date));

1567: ELSE
1568: --
1569: -- Set dates
1570: --
1571: l_start_date := TRUNC(fnd_date.canonical_to_date(p_start_date));
1572: l_end_date := TRUNC(fnd_date.canonical_to_date(p_end_date));
1573: --
1574: END IF;
1575: --

Line 1572: l_end_date := TRUNC(fnd_date.canonical_to_date(p_end_date));

1568: --
1569: -- Set dates
1570: --
1571: l_start_date := TRUNC(fnd_date.canonical_to_date(p_start_date));
1572: l_end_date := TRUNC(fnd_date.canonical_to_date(p_end_date));
1573: --
1574: END IF;
1575: --
1576: dbg('start date = '||to_char(l_start_date,'DD-MON-RRRR HH24:MI:SS'));

Line 1786: l_end_date := fnd_date.canonical_to_date(p_end_date);

1782: --
1783: l_is_hr_installed := hr_general.chk_product_installed(800);
1784: l_frc_shrd_hr_prfl_val := nvl(fnd_profile.value('HRI_DBI_FORCE_SHARED_HR'),'N');
1785: --
1786: l_end_date := fnd_date.canonical_to_date(p_end_date);
1787: --
1788: IF l_is_hr_installed = 'FALSE'
1789: OR l_frc_shrd_hr_prfl_val = 'Y'
1790: THEN

Line 1862: l_start_date := fnd_date.canonical_to_date(p_start_date);

1858: l_start_date := hri_oltp_conc_param.get_date_parameter_value
1859: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1860: p_process_table_name => 'HRI_CL_WKR_SUP_STATUS_CT');
1861: ELSE
1862: l_start_date := fnd_date.canonical_to_date(p_start_date);
1863: END IF;
1864: ELSE
1865: l_full_refresh := p_full_refresh;
1866: l_start_date := fnd_date.canonical_to_date(p_start_date);

Line 1866: l_start_date := fnd_date.canonical_to_date(p_start_date);

1862: l_start_date := fnd_date.canonical_to_date(p_start_date);
1863: END IF;
1864: ELSE
1865: l_full_refresh := p_full_refresh;
1866: l_start_date := fnd_date.canonical_to_date(p_start_date);
1867: END IF;
1868: --
1869: END IF;
1870: --