DBA Data[Home] [Help]

APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on FND_DATE

Line 1072: l_horizon_start := fnd_date.canonical_to_date(p_horizon_start);

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

Line 1080: l_horizon_end := fnd_date.canonical_to_date(p_horizon_end);

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