[Home] [Help]
11961: -- check if the delivery is checked in the bulk picking rule-------------
11962: IF p_move_order_header_id <> -1 THEN
11963:
11964: -- cache the move order header info first
11965: If NOT INV_CACHE.set_mtrh_rec(p_move_order_header_id) THEN
11966: Raise g_exc_unexpected_error;
11967: END IF;
11968:
11969: IF p_move_order_header_id = g_move_order_header_id THEN
11984: -- check to see if the picking methodology is bulk picking disabled (including order picking)---
11985: SELECT spg.bulk_pick_control
11986: into l_bulk_pick_control
11987: FROM wsh_pick_grouping_rules spg
11988: WHERE spg.pick_grouping_rule_id = INV_CACHE.mtrh_rec.grouping_rule_id;
11989:
11990: g_move_order_header_id := p_move_order_header_id;
11991: g_delivery_flag := l_delivery_flag;
11992: g_bulk_pick_control := l_bulk_pick_control;
12001: return;
12002: END IF;
12003: END IF;
12004:
12005: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
12006:
12007: IF l_move_order_type <> g_move_order_pick_wave THEN
12008: IF (l_debug = 1) THEN
12009: print_debug('Consolidating Tasks are not pick wave mo',4);
12623: WHERE transaction_temp_id = p_task_id;
12624:
12625: IF (l_task_rec_old_wct.parent_line_id is null) THEN -- not bulk task
12626: -- cache the move order header info first
12627: If NOT INV_CACHE.set_mtrh_rec(l_task_rec_old_wct.move_order_header_id) THEN
12628: Raise g_exc_unexpected_error;
12629: END IF;
12630: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
12631: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4); end if;
12626: -- cache the move order header info first
12627: If NOT INV_CACHE.set_mtrh_rec(l_task_rec_old_wct.move_order_header_id) THEN
12628: Raise g_exc_unexpected_error;
12629: END IF;
12630: l_move_order_type := INV_CACHE.mtrh_rec.move_order_type;
12631: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4); end if;
12632: ELSE
12633: -- IF (l_debug = 1) THEN print_debug('PATCHSET J-- BULK PICKING --START',4); END IF;
12634: l_move_order_type := G_MOVE_ORDER_PICK_WAVE; -- calling for parent task, WIP doesn't call this for patchset J