[Home] [Help]
662: THEN
663: IF (l_debug = 1) THEN
664: mydebug('consolidate mtlt 33: lot/serial controlled and allocate to serial ON', l_api_name);
665: END IF;
666: SELECT mtl_material_transactions_s.NEXTVAL
667: INTO l_new_serial_temp_id
668: FROM dual;
669: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
670: l_sum_same_lot_pri_qty := 0;
694: THEN
695: IF (l_debug = 1) THEN
696: mydebug('consolidate mtlt 44: lot controlled only OR lot/serial controlled but Allocate to serial OFF', l_api_name);
697: END IF;
698: SELECT mtl_material_transactions_s.NEXTVAL
699: INTO l_new_serial_temp_id
700: FROM dual;
701: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
702: begin
2004:
2005: -- Update MMTT record with a new header
2006: l_user_id := fnd_global.user_id;
2007:
2008: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2009: INTO l_txn_hdr_id
2010: FROM DUAL;
2011:
2012: UPDATE mtl_material_transactions_temp
2626: mydebug ('First Index is ' , g_start_over_tempid.FIRST);
2627: END IF;
2628:
2629: UPDATE mtl_material_transactions_temp
2630: SET transaction_header_id = mtl_material_transactions_s.NEXTVAL,
2631: last_update_date = Sysdate,
2632: last_updated_by = l_user_id
2633: WHERE transaction_temp_id = l_next_transaction_temp_id
2634: returning wms_task_type INTO x_task_type_id;
3140: mydebug('Device Request ID: ' || l_request_id, l_api_name);
3141: END IF;
3142:
3143: UPDATE mtl_material_transactions_temp
3144: SET transaction_header_id = mtl_material_transactions_s.NEXTVAL
3145: , last_update_date = Sysdate
3146: , last_updated_by = l_user_id
3147: , posting_flag = 'Y' -- Bug4185621: this will change the parent posting flag to 'Y' for bulking picking
3148: -- If not bulking picking, this has not effect
3634: mydebug(' SAVEPOINT wms_split_task established', 'split_task');
3635: END IF;
3636: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
3637: LOOP
3638: SELECT mtl_material_transactions_s.NEXTVAL
3639: INTO l_new_transaction_header_id
3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3637: LOOP
3638: SELECT mtl_material_transactions_s.NEXTVAL
3639: INTO l_new_transaction_header_id
3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3643: FROM dual;
3644: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
3645: IF g_debug = 1 THEN
4888: x_msg_data ,
4889: x_msg_count );
4890:
4891: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
4892: SELECT mtl_material_transactions_s.NEXTVAL
4893: INTO l_new_serial_txn_temp_id
4894: FROM dual;
4895: UPDATE mtl_transaction_lots_temp
4896: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,