DBA Data[Home] [Help]

APPS.WMS_RULE_6 dependencies on WMS_SEARCH_ORDER_GLOBALS_PVT

Line 607: l_available_inv_tbl WMS_SEARCH_ORDER_GLOBALS_PVT.available_inventory_tbl;

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

Line 624: IF (WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.exists(1)) THEN

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

Line 626: l_count := WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.LAST ;

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) ;

Line 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 ;

Line 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;