APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_CALENDAR

Line 1258: l_time_fence_end_date := msc_calendar.date_offset(l_calendar_code,

1254: /* total intransit time */
1255:
1256: l_total_lead_time:= p_lead_time+l_transit_time;
1257:
1258: l_time_fence_end_date := msc_calendar.date_offset(l_calendar_code,
1259: l_calendar_inst_id,
1260: sysdate, l_total_lead_time,
1261: 99999);
1262: --dbms_output.put_line('time fence end date is ' ||l_time_fence_end_date);

Line 2006: l_time_fence_end_date := msc_calendar.date_offset(p_calendar_code, p_calendar_inst_id, p_graph(l_current_record).graph_date, p_lead_time, 99999);

2002: l_index NUMBER;
2003: l_quantity NUMBER := 0;
2004: l_time_fence_end_date DATE;
2005: BEGIN
2006: l_time_fence_end_date := msc_calendar.date_offset(p_calendar_code, p_calendar_inst_id, p_graph(l_current_record).graph_date, p_lead_time, 99999);
2007: FOR l_index IN l_current_record..p_graph.LAST LOOP
2008: IF p_graph(l_index).graph_date <= l_time_fence_end_date THEN
2009: l_quantity := l_quantity + p_graph(l_index).req;
2010: END IF;

Line 2042: l_time_fence_end_date := msc_calendar.date_offset(p_calendar_code, p_calendar_inst_id, p_graph(l_current_record).graph_date, p_lead_time, 99999);

2038: l_supply_within_lead_time := getSupplyWithinLeadTime(p_graph, l_current_record, p_lead_time, p_calendar_code, p_calendar_inst_id);
2039: -- Refuel
2040: IF p_graph(l_current_record).projected_onhand + l_supply_within_lead_time <= p_graph(l_current_record).MIN THEN
2041: l_replenish := p_graph(l_current_record).max - (l_supply_within_lead_time + p_graph(l_current_record).projected_onhand);
2042: l_time_fence_end_date := msc_calendar.date_offset(p_calendar_code, p_calendar_inst_id, p_graph(l_current_record).graph_date, p_lead_time, 99999);
2043: IF l_time_fence_end_date <= p_graph(p_graph.LAST).graph_date THEN
2044: l_nr_of_days := l_time_fence_end_date - p_graph(l_current_record).graph_date;
2045: p_graph(l_current_record + l_nr_of_days).req := p_graph(l_current_record + l_nr_of_days).req + l_replenish;
2046: END IF;

Line 2384: l_time_fence_end_date := msc_calendar.date_offset(l_calendar_code, l_calendar_inst_id, l_start_date, l_forecast_horizon, 99999);

2380: , p_sr_instance_id ) ;
2381:
2382:
2383: msc_x_util.get_calendar_code(p_supplier_id,p_supplier_site_id,p_customer_id,p_customer_site_id,l_calendar_code,l_calendar_inst_id);
2384: l_time_fence_end_date := msc_calendar.date_offset(l_calendar_code, l_calendar_inst_id, l_start_date, l_forecast_horizon, 99999);
2385:
2386: l_graph := vmiCustomerGraphInit(l_start_date, l_time_fence_end_date);
2387:
2388: IF l_min_minmax_days IS NOT NULL OR l_max_minmax_days IS NOT NULL THEN

Line 2832: l_time_fence_end_date:=MSC_CALENDAR.DATE_OFFSET(

2828:
2829: IF t_table_sim_pab(v_index) 2830: THEN
2831:
2832: l_time_fence_end_date:=MSC_CALENDAR.DATE_OFFSET(
2833: lv_calendar_code -- arg_calendar_code IN varchar2,
2834: , lv_instance_id -- arg_instance_id IN NUMBER,
2835: , SYSDATE+v_index-1 -- arg_date IN DATE,
2836: , l_total_lead_time -- arg_offset IN NUMBER