603: x_return_status OUT NOCOPY NUMBER) IS
604:
605: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
606:
607: l_available_inv_tbl WMS_SEARCH_ORDER_GLOBALS_PVT.available_inventory_tbl;
608: l_count number ;
609:
610:
611: BEGIN
620: ELSE
621: x_return_status :=0;
622: END IF;
623:
624: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
625:
626: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
627:
628: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
622: END IF;
623:
624: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
625:
626: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
627:
628: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
629: l_count := l_count + 1 ;
630: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
626: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
627:
628: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
629: l_count := l_count + 1 ;
630: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
631: END LOOP ;
632:
633: ELSE
634: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;
630: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
631: END LOOP ;
632:
633: ELSE
634: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;
635: END IF ;
636: ELSE
637: x_return_status:=0;
638: END IF;