[Home] [Help]
827: THEN
828: IF (l_debug = 1) THEN
829: mydebug('consolidate mtlt 33: lot/serial controlled and allocate to serial ON', l_api_name);
830: END IF;
831: SELECT mtl_material_transactions_s.NEXTVAL
832: INTO l_new_serial_temp_id
833: FROM dual;
834: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
835: l_sum_same_lot_pri_qty := 0;
859: THEN
860: IF (l_debug = 1) THEN
861: mydebug('consolidate mtlt 44: lot controlled only OR lot/serial controlled but Allocate to serial OFF', l_api_name);
862: END IF;
863: SELECT mtl_material_transactions_s.NEXTVAL
864: INTO l_new_serial_temp_id
865: FROM dual;
866: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
867: begin
2264:
2265: -- Update MMTT record with a new header
2266: l_user_id := fnd_global.user_id;
2267:
2268: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2269: INTO l_txn_hdr_id
2270: FROM DUAL;
2271:
2272: UPDATE mtl_material_transactions_temp
2999: mydebug ('First Index is ' , g_start_over_tempid.FIRST);
3000: END IF;
3001:
3002: UPDATE mtl_material_transactions_temp
3003: SET transaction_header_id = mtl_material_transactions_s.NEXTVAL,
3004: last_update_date = Sysdate,
3005: last_updated_by = l_user_id
3006: WHERE transaction_temp_id = l_next_transaction_temp_id
3007: returning wms_task_type INTO x_task_type_id;
3516: mydebug('Device Request ID: ' || l_request_id, l_api_name);
3517: END IF; */
3518:
3519: UPDATE mtl_material_transactions_temp
3520: SET transaction_header_id = mtl_material_transactions_s.NEXTVAL
3521: , last_update_date = Sysdate
3522: , last_updated_by = l_user_id
3523: , posting_flag = 'Y' -- Bug4185621: this will change the parent posting flag to 'Y' for bulking picking
3524: -- If not bulking picking, this has not effect
4062: mydebug(' SAVEPOINT wms_split_task established', 'split_task');
4063: END IF;
4064: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
4065: LOOP
4066: SELECT mtl_material_transactions_s.NEXTVAL
4067: INTO l_new_transaction_header_id
4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4065: LOOP
4066: SELECT mtl_material_transactions_s.NEXTVAL
4067: INTO l_new_transaction_header_id
4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4071: FROM dual;
4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
4073: IF g_debug = 1 THEN
5318: x_msg_data ,
5319: x_msg_count );
5320:
5321: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
5322: SELECT mtl_material_transactions_s.NEXTVAL
5323: INTO l_new_serial_txn_temp_id
5324: FROM dual;
5325: UPDATE mtl_transaction_lots_temp
5326: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,