Line 422: l_start_date := fnd_date.canonical_to_date(p_start_date);
418: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);
419:
420: IF p_num_days IS NULL THEN
421: IF p_start_date IS NOT NULL THEN 422: l_start_date := fnd_date.canonical_to_date(p_start_date); 423: ELSE
424: l_start_date := SYSDATE-8;
425: END IF;
426:
Line 428: l_end_date := fnd_date.canonical_to_date(p_end_date);
424: l_start_date := SYSDATE-8;
425: END IF;
426:
427: IF p_end_date IS NOT NULL THEN 428: l_end_date := fnd_date.canonical_to_date(p_end_date); 429: ELSE
430: l_end_date := TRUNC(SYSDATE-1);
431: END IF;
432: ELSE