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);
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);