APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_VMI_GRAPH

Line 18: TYPE Graph IS TABLE OF MSC_VMI_GRAPH%ROWTYPE;

14:
15:
16:
17:
18: TYPE Graph IS TABLE OF MSC_VMI_GRAPH%ROWTYPE;
19:
20: --TYPE t_table_add_data IS TABLE OF NUMBER
21: -- INDEX BY BINARY_INTEGER;
22: -- t_table_add t_table_add_data ;

Line 1809: l_data_point MSC_VMI_GRAPH%ROWTYPE;

1805: AS
1806: l_graph_horizon NUMBER := 0;
1807: l_graph Graph;
1808: l_current_index NUMBER;
1809: l_data_point MSC_VMI_GRAPH%ROWTYPE;
1810: l_current_date DATE;
1811:
1812: BEGIN
1813:

Line 2216: INSERT INTO MSC_VMI_GRAPH

2212: IF l_debug_flag = FALSE THEN
2213: -- get the query id first
2214: SELECT msc_x_hz_ui_query_id_s.nextval INTO l_query_id FROM Dual;
2215: FOR l_current_record IN p_graph.FIRST..p_graph.LAST LOOP
2216: INSERT INTO MSC_VMI_GRAPH
2217: (query_id, graph_date, onhand, order_forecast, req, po, asn, receipt,
2218: projected_onhand, supply_within_lead_time,
2219: MIN, max, safety_stock, recommended_replenishment)
2220: VALUES (l_query_id,p_graph(l_current_record).graph_date,p_graph(l_current_record).onhand,

Line 2904: delete from msc_vmi_graph;

2900: /**
2901: * Prior to populating the data delete all the records
2902: */
2903:
2904: delete from msc_vmi_graph;
2905:
2906: /**
2907: *Check the value of replenishment code and populate the data accordingly
2908: */

Line 2915: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)

2911: IF l_replenishment_method=1
2912: THEN
2913: FOR v_index IN 1 ..(l_forecast_horizon+1)
2914: LOOP
2915: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)
2916: VALUES( v_index,(sysdate+v_index-1),t_table_pab(v_index), l_min_quantity,l_max_quantity);
2917: -- dbms_output.put_line('the graph PABS are method type1 agoel ' || t_table_pab(v_index));
2918: END LOOP;
2919:

Line 2924: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)

2920: ELSIF l_replenishment_method=3
2921: THEN
2922: FOR v_index IN 1 ..(l_forecast_horizon+1)
2923: LOOP
2924: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)
2925: VALUES(v_index,(sysdate+v_index-1), t_table_pab(v_index),l_min_quantity,l_fix_quantity);
2926: -- dbms_output.put_line('the graph PABS are method type 3 agoel ' || t_table_pab(v_index));
2927: END LOOP;
2928: ELSIF l_replenishment_method=2

Line 2932: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)

2928: ELSIF l_replenishment_method=2
2929: THEN
2930: FOR v_index IN 1 ..(l_forecast_horizon+1)
2931: LOOP
2932: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)
2933: VALUES(v_index, (sysdate+v_index-1),t_table_pab_days(v_index),l_min_days,l_max_days);
2934: -- dbms_output.put_line('the graph PABS are method type2 agoel ' || t_table_pab_days(v_index));
2935: END LOOP;
2936: ELSIF l_replenishment_method=4

Line 2940: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)

2936: ELSIF l_replenishment_method=4
2937: THEN
2938: FOR v_index IN 1 ..(l_forecast_horizon+1)
2939: LOOP
2940: INSERT INTO msc_vmi_graph(query_id,graph_date,projected_onhand,min,max)
2941: VALUES(v_index,(sysdate+v_index-1), t_table_pab_days(v_index),l_min_days,l_fix_days);
2942: -- dbms_output.put_line('the graph PABS are method type4 agoel ' || t_table_pab_days(v_index));
2943:
2944: END LOOP;