DBA Data[Home] [Help]

APPS.HXC_ARCHIVE_RESTORE_PROCESS dependencies on FND_DATE

Line 28: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));

24: BEGIN
25:
26:
27: -- set the canonical start data and stop date of the data seto
28: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
29: l_stop_date := trunc(fnd_date.canonical_to_date(p_stop_date)) + 1 - (1 / (24 * 60 * 60));
30:
31: fnd_file.put_line(fnd_file.LOG,'--- >Parameters:');
32: fnd_file.put_line(fnd_file.LOG,'--- >Data Set Name :' || p_data_set_name);

Line 29: l_stop_date := trunc(fnd_date.canonical_to_date(p_stop_date)) + 1 - (1 / (24 * 60 * 60));

25:
26:
27: -- set the canonical start data and stop date of the data seto
28: l_start_date := trunc(fnd_date.canonical_to_date(p_start_date));
29: l_stop_date := trunc(fnd_date.canonical_to_date(p_stop_date)) + 1 - (1 / (24 * 60 * 60));
30:
31: fnd_file.put_line(fnd_file.LOG,'--- >Parameters:');
32: fnd_file.put_line(fnd_file.LOG,'--- >Data Set Name :' || p_data_set_name);
33: fnd_file.put_line(fnd_file.LOG,'--- >Description :' || p_description);