[Home] [Help]
1068: select sysdate
1069: into l_horizon_start
1070: from dual;
1071: else
1072: l_horizon_start := fnd_date.canonical_to_date(p_horizon_start);
1073: end if;
1074:
1075: if (p_horizon_end is null) then
1076: select sysdate +365
1076: select sysdate +365
1077: into l_horizon_end
1078: from dual;
1079: else
1080: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);
1081: end if;
1082:
1083:
1084: log_message('l_horizon_start: '||l_horizon_start);