APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_GLOBALS

Line 325: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN

321: WHERE msi.inventory_item_id = mmtt.inventory_item_id
322: AND msi.organization_id = mmtt.organization_id
323: AND mmtt.transaction_temp_id = p_temp_id;
324:
325: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
326: -- We need to do this for staging move as staging move will
327: -- have no MSNT/MTLT lines
328: v_lot_control_code := 0;
329: v_serial_control_code := 0;

Line 582: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN

578: IF (l_debug = 1) THEN
579: mydebug('deleted WDT with temp_id ' || p_temp_id);
580: END IF;
581:
582: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
583: DELETE FROM mtl_material_transactions_temp
584: WHERE transaction_temp_id = p_temp_id;
585: END IF;
586: END IF;

Line 594: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick

590: -- lpn is unloaded with a context of packaging and update the context to
591: -- inventory if the entire lpn is picked
592: -- this happens only if there are no more allocations for that lpn and
593: -- the last line IS being unloaded
594: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
595: , wms_globals.g_wms_task_type_replenish
596: , wms_globals.g_wms_task_type_moxfer
597: , wms_globals.g_wms_task_type_moissue--13807883
598: )

Line 595: , wms_globals.g_wms_task_type_replenish

591: -- inventory if the entire lpn is picked
592: -- this happens only if there are no more allocations for that lpn and
593: -- the last line IS being unloaded
594: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
595: , wms_globals.g_wms_task_type_replenish
596: , wms_globals.g_wms_task_type_moxfer
597: , wms_globals.g_wms_task_type_moissue--13807883
598: )
599: THEN

Line 596: , wms_globals.g_wms_task_type_moxfer

592: -- this happens only if there are no more allocations for that lpn and
593: -- the last line IS being unloaded
594: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
595: , wms_globals.g_wms_task_type_replenish
596: , wms_globals.g_wms_task_type_moxfer
597: , wms_globals.g_wms_task_type_moissue--13807883
598: )
599: THEN
600: SELECT COUNT(1)

Line 597: , wms_globals.g_wms_task_type_moissue--13807883

593: -- the last line IS being unloaded
594: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
595: , wms_globals.g_wms_task_type_replenish
596: , wms_globals.g_wms_task_type_moxfer
597: , wms_globals.g_wms_task_type_moissue--13807883
598: )
599: THEN
600: SELECT COUNT(1)
601: INTO l_count

Line 712: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN

708: END IF;
709:
710: END IF;
711:
712: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
713:
714: IF (l_debug = 1) THEN
715: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
716: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );