1032: IF (p_rel_abs='R') THEN
1033: v_end_date := TRUNC(SYSDATE)-p_rel_end_date;
1034: v_start_date := TRUNC(SYSDATE)-p_rel_start_date;
1035: ELSIF (p_rel_abs='A') THEN
1036: v_end_date := fnd_date.canonical_to_date(p_abs_end_date);
1037: v_start_date := fnd_date.canonical_to_date(p_abs_start_date);
1038: END IF;
1039:
1040: IF ( v_start_date is null
1033: v_end_date := TRUNC(SYSDATE)-p_rel_end_date;
1034: v_start_date := TRUNC(SYSDATE)-p_rel_start_date;
1035: ELSIF (p_rel_abs='A') THEN
1036: v_end_date := fnd_date.canonical_to_date(p_abs_end_date);
1037: v_start_date := fnd_date.canonical_to_date(p_abs_start_date);
1038: END IF;
1039:
1040: IF ( v_start_date is null
1041: or v_end_date is null