DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on WMS_GLOBALS

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

347: FROM mtl_parameters mp, mtl_material_transactions_temp mmtt
348: WHERE mp.organization_id = mmtt.organization_id
349: AND mmtt.transaction_temp_id = p_temp_id;
350:
351: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
352: -- We need to do this for staging move as staging move will
353: -- have no MSNT/MTLT lines
354: v_lot_control_code := 0;
355: v_serial_control_code := 0;

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

499: IF (l_debug = 1) THEN
500: mydebug('deleted WDT with temp_id ' || p_temp_id);
501: END IF;
502:
503: IF l_wms_task_types IN(wms_globals.g_wms_task_type_stg_move) THEN
504: DELETE FROM mtl_material_transactions_temp
505: WHERE transaction_temp_id = p_temp_id;
506: END IF;
507: END IF;

Line 514: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick

510: -- lpn is unloaded with a context of packaging and update the context to
511: -- inventory if the entire lpn is picked
512: -- this happens only if there are no more allocations for that lpn and
513: -- the last line IS being unloaded
514: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
515: , wms_globals.g_wms_task_type_replenish
516: , wms_globals.g_wms_task_type_moxfer
517: )
518: THEN

Line 515: , wms_globals.g_wms_task_type_replenish

511: -- inventory if the entire lpn is picked
512: -- this happens only if there are no more allocations for that lpn and
513: -- the last line IS being unloaded
514: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
515: , wms_globals.g_wms_task_type_replenish
516: , wms_globals.g_wms_task_type_moxfer
517: )
518: THEN
519: SELECT COUNT(1)

Line 516: , wms_globals.g_wms_task_type_moxfer

512: -- this happens only if there are no more allocations for that lpn and
513: -- the last line IS being unloaded
514: IF l_wms_task_types IN ( wms_globals.g_wms_task_type_pick
515: , wms_globals.g_wms_task_type_replenish
516: , wms_globals.g_wms_task_type_moxfer
517: )
518: THEN
519: SELECT COUNT(1)
520: INTO l_count

Line 586: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN

582: END IF;
583:
584: END IF;
585:
586: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
587:
588: IF (l_debug = 1) THEN
589: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
590: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );