DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_GLOBALS

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

276: WHERE msi.inventory_item_id = mmtt.inventory_item_id
277: AND msi.organization_id = mmtt.organization_id
278: AND mmtt.transaction_temp_id = p_temp_id;
279:
280: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
281: -- We need to do this for staging move as staging move will
282: -- have no MSNT/MTLT lines
283: v_lot_control_code := 0;
284: v_serial_control_code := 0;

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

428: IF (l_debug = 1) THEN
429: mydebug('deleted WDT with temp_id ' || p_temp_id);
430: END IF;
431:
432: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
433: DELETE FROM mtl_material_transactions_temp
434: WHERE transaction_temp_id = p_temp_id;
435: END IF;
436: END IF;

Line 444: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick

440: -- lpn is unloaded with a context of packaging and update the context to
441: -- inventory if the entire lpn is picked
442: -- this happens only if there are no more allocations for that lpn and
443: -- the last line IS being unloaded
444: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
445: , wms_globals.g_wms_task_type_replenish
446: , wms_globals.g_wms_task_type_moxfer
447: )
448: THEN

Line 445: , wms_globals.g_wms_task_type_replenish

441: -- inventory if the entire lpn is picked
442: -- this happens only if there are no more allocations for that lpn and
443: -- the last line IS being unloaded
444: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
445: , wms_globals.g_wms_task_type_replenish
446: , wms_globals.g_wms_task_type_moxfer
447: )
448: THEN
449: SELECT COUNT(1)

Line 446: , wms_globals.g_wms_task_type_moxfer

442: -- this happens only if there are no more allocations for that lpn and
443: -- the last line IS being unloaded
444: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
445: , wms_globals.g_wms_task_type_replenish
446: , wms_globals.g_wms_task_type_moxfer
447: )
448: THEN
449: SELECT COUNT(1)
450: INTO l_count

Line 517: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN

513: END IF;
514:
515: END IF;
516:
517: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
518:
519: IF (l_debug = 1) THEN
520: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
521: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );