183: , MIN_ORD_QTY
184: , MAX_ORD_QTY
185: , FIX_MULT
186: , REORD_QTY
187: FROM INV_MIN_MAX_TEMP;
188:
189: l_minmax_rslts_rec minmax_rslts_cur%ROWTYPE;
190:
191: CURSOR item_attr_cur(p_item_Segments VARCHAR2,
774: END IF;
775: END IF;
776: END IF;
777: END LOOP;
778: -- cleanup INV_MIN_MAX_TEMP table
779: delete from INV_MIN_MAX_TEMP;
780: END IF;
781:
782: -- create notifications for excess on order
775: END IF;
776: END IF;
777: END LOOP;
778: -- cleanup INV_MIN_MAX_TEMP table
779: delete from INV_MIN_MAX_TEMP;
780: END IF;
781:
782: -- create notifications for excess on order
783:
822: , p_exception_set_id => l_exception_set_id
823: , x_return_status => l_Return_status
824: , x_msg_data => l_msg_data);
825:
826: -- for all records in inv_min_max_temp with supply qty > 0
827: -- create EOO notifications
828: declare
829: l_item_id NUMBER;
830: l_planner VARCHAR2(30);
954: END IF;
955: END LOOP;
956: end;
957: -- cleanup minmax temp tbl
958: DELETE FROM INV_MIN_MAX_TEMP;
959:
960: -- For all IO/PO/WIP notifs in notifications tbl,
961: -- create recommendations for excess, repair and new buy/make
962: -- For all EOO notifications,
2139: ELSE
2140: BEGIN
2141: SELECT (tot_avail_qty - max_qty) excess_qty
2142: INTO l_excess_qty
2143: FROM INV_MIN_MAX_TEMP
2144: WHERE item_Segments = l_item;
2145:
2146: EXCEPTION
2147: WHEN NO_DATA_FOUND THEN
2149: WHEN OTHERS THEN
2150: l_Excess_qty := -2;
2151: END;
2152:
2153: -- cleanup inv_min_max_Temp
2154: DELETE FROM INV_MIN_MAX_TEMP;
2155: END IF;
2156: END IF;
2157: IF (nvl(l_excess_qty, 0) > 0) THEN
2150: l_Excess_qty := -2;
2151: END;
2152:
2153: -- cleanup inv_min_max_Temp
2154: DELETE FROM INV_MIN_MAX_TEMP;
2155: END IF;
2156: END IF;
2157: IF (nvl(l_excess_qty, 0) > 0) THEN
2158: x_excess_parts_tbl(idx).quantity := l_excess_qty;
2235: ELSE
2236: BEGIN
2237: SELECT (tot_avail_qty - max_qty) excess_qty
2238: INTO l_excess_qty
2239: FROM INV_MIN_MAX_TEMP
2240: WHERE item_Segments = l_item;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: l_Excess_qty := -1;
2243: l_Excess_qty := -1;
2244: WHEN OTHERS THEN
2245: l_Excess_qty := -1;
2246: END;
2247: -- cleanup inv_min_max_Temp
2248: DELETE FROM INV_MIN_MAX_TEMP;
2249: END If;
2250: ELSE
2251: INV_Quantity_Tree_PUB.Query_Quantities
2244: WHEN OTHERS THEN
2245: l_Excess_qty := -1;
2246: END;
2247: -- cleanup inv_min_max_Temp
2248: DELETE FROM INV_MIN_MAX_TEMP;
2249: END If;
2250: ELSE
2251: INV_Quantity_Tree_PUB.Query_Quantities
2252: ( p_api_version_number => 1.0