596: x_return_status OUT NOCOPY NUMBER) IS
597:
598: /* Fix for Bug#8360804 . Added temp variable of type available_inventory_tbl */
599:
600: l_available_inv_tbl WMS_SEARCH_ORDER_GLOBALS_PVT.available_inventory_tbl;
601: l_count number ;
602:
603:
604: BEGIN
613: ELSE
614: x_return_status :=0;
615: END IF;
616:
617: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
618:
619: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
620:
621: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
615: END IF;
616:
617: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN
618:
619: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
620:
621: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
622: l_count := l_count + 1 ;
623: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
619: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;
620:
621: FOR i in l_available_inv_tbl.FIRST..l_available_inv_tbl.LAST LOOP
622: l_count := l_count + 1 ;
623: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
624: END LOOP ;
625:
626: ELSE
627: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;
623: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(l_count) := l_available_inv_tbl(i) ;
624: END LOOP ;
625:
626: ELSE
627: WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl := l_available_inv_tbl ;
628: END IF ;
629: ELSE
630: x_return_status:=0;
631: END IF;