DBA Data[Home] [Help]

APPS.MSC_X_CVMI_PLANNING dependencies on MSC_CALENDAR

Line 194: l_horizon_end_date := MSC_CALENDAR.DATE_OFFSET( lv_calendar_code -- arg_calendar_code IN varchar2,

190: );
191:
192: IF (p_vmi_forecast_type = 1 OR p_vmi_forecast_type = 2) THEN
193: l_horizon_start_date := SYSDATE;
194: l_horizon_end_date := MSC_CALENDAR.DATE_OFFSET( lv_calendar_code -- arg_calendar_code IN varchar2,
195: , lv_instance_id -- arg_instance_id IN NUMBER,
196: , SYSDATE -- l_horizon_start_date -- arg_date IN DATE,
197: , p_forecast_horizon -- arg_offset IN NUMBER
198: , 99999 --arg_offset_type

Line 201: l_horizon_start_date := MSC_CALENDAR.DATE_OFFSET( lv_calendar_code -- arg_calendar_code IN varchar2,

197: , p_forecast_horizon -- arg_offset IN NUMBER
198: , 99999 --arg_offset_type
199: );
200: ELSIF (p_vmi_forecast_type = 3) THEN
201: l_horizon_start_date := MSC_CALENDAR.DATE_OFFSET( lv_calendar_code -- arg_calendar_code IN varchar2,
202: , lv_instance_id -- arg_instance_id IN NUMBER,
203: , SYSDATE -- l_horizon_start_date -- arg_date IN DATE,
204: , 0 - p_forecast_horizon -- arg_offset IN NUMBER
205: , 99999 --arg_offset_type