DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on INV_CACHE

Line 12433: If NOT INV_CACHE.set_mtrh_rec(p_move_order_header_id) THEN

12429: -- check if the delivery is checked in the bulk picking rule-------------
12430: IF p_move_order_header_id <> -1 THEN
12431:
12432: -- cache the move order header info first
12433: If NOT INV_CACHE.set_mtrh_rec(p_move_order_header_id) THEN
12434: Raise g_exc_unexpected_error;
12435: END IF;
12436:
12437: IF p_move_order_header_id = g_move_order_header_id THEN

Line 12464: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;

12460: -- check to see if the picking methodology is bulk picking disabled (including order picking)---
12461: SELECT spg.bulk_pick_control
12462: into l_bulk_pick_control
12463: FROM wsh_pick_grouping_rules spg
12464: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
12465:
12466: g_move_order_header_id := p_move_order_header_id;
12467: g_delivery_flag := l_delivery_flag;
12468: g_bulk_pick_control := l_bulk_pick_control;

Line 12481: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;

12477: return;
12478: END IF;
12479: END IF;
12480:
12481: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
12482:
12483: IF l_move_order_type <> g_move_order_pick_wave THEN
12484: IF (l_debug = 1) THEN
12485: print_debug('Consolidating Tasks are not pick wave mo',4);

Line 13152: If NOT INV_CACHE.set_mtrh_rec(l_task_rec_old_wct.move_order_header_id) THEN

13148: WHERE transaction_temp_id = p_task_id;
13149:
13150: IF (l_task_rec_old_wct.parent_line_id is null) THEN -- not bulk task
13151: -- cache the move order header info first
13152: If NOT INV_CACHE.set_mtrh_rec(l_task_rec_old_wct.move_order_header_id) THEN
13153: Raise g_exc_unexpected_error;
13154: END IF;
13155: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
13156: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4); end if;

Line 13155: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;

13151: -- cache the move order header info first
13152: If NOT INV_CACHE.set_mtrh_rec(l_task_rec_old_wct.move_order_header_id) THEN
13153: Raise g_exc_unexpected_error;
13154: END IF;
13155: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
13156: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4); end if;
13157: ELSE
13158: -- IF (l_debug = 1) THEN print_debug('PATCHSET J-- BULK PICKING --START',4); END IF;
13159: l_move_order_type := G_MOVE_ORDER_PICK_WAVE; -- calling for parent task, WIP doesn't call this for patchset J