[Home] [Help]
65: , x_msg_count OUT NOCOPY NUMBER
66: , x_source_task_id OUT NOCOPY NUMBER
67: , x_error_code OUT NOCOPY NUMBER
68: , p_source_task_id IN NUMBER
69: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
70: , p_operation_type_id IN NUMBER
71: , p_revert_loc_capacity IN BOOLEAN DEFAULT FALSE
72: , p_subsequent_op_plan_id IN NUMBER DEFAULT NULL
73: ) IS
303:
304: /*Update MMTT record where transaction_temp_ID = P_source_task_ID.
305: Null out move_order_line_ID and lpn_ID.*/
306:
307: UPDATE mtl_material_transactions_temp
308: SET lpn_id = NULL,
309: move_order_line_id = NULL,
310: wms_task_type = l_wms_task_type
311: WHERE transaction_temp_id = p_source_task_id;
493: , x_msg_count OUT NOCOPY NUMBER
494: , x_error_code OUT NOCOPY NUMBER
495: , p_source_task_id IN NUMBER
496: , p_update_param_rec IN DEST_PARAM_REC_TYPE
497: , p_document_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
498: )IS
499:
500: /* CURSOR c_locator_type(v_location_id NUMBER,v_org_id NUMBER) IS
501: SELECT Nvl(inventory_location_type, 3)
511:
512: CURSOR c_orig_sugges(v_txn_temp_id NUMBER) IS
513: SELECT nvl(transfer_subinventory,subinventory_code) subinventory_code
514: ,nvl(transfer_to_location,locator_id) locator_id
515: FROM mtl_material_transactions_temp
516: WHERE transaction_temp_id=v_txn_temp_id;
517:
518: l_sub_type NUMBER := -1;
519: l_orig_sugges c_orig_sugges%ROWTYPE;
587: IF (l_debug=1) THEN
588: print_debug('Deliver transaction, update sub/loc.',l_module_name,1);
589: END IF;
590:
591: UPDATE MTL_material_transactions_temp
592: SET subinventory_code = p_update_param_rec.sug_sub_code,
593: locator_id = p_update_param_rec.sug_location_id,
594: cartonization_id = p_update_param_rec.cartonization_id
595: WHERE transaction_temp_id = p_source_task_id
599: IF (l_debug=1) THEN
600: print_debug('Transfer transaction, update transfer sub/loc.',l_module_name,1);
601: END IF;
602:
603: UPDATE MTL_material_transactions_temp
604: SET transfer_subinventory = p_update_param_rec.sug_sub_code,
605: transfer_to_location = p_update_param_rec.sug_location_id,
606: cartonization_id = p_update_param_rec.cartonization_id
607: WHERE transaction_temp_id = p_source_task_id
969: , x_msg_count OUT NOCOPY NUMBER
970: , x_source_task_id OUT NOCOPY NUMBER
971: , x_error_code OUT NOCOPY NUMBER
972: , p_source_task_id IN NUMBER
973: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
974: , p_operation_type_id IN NUMBER
975: , p_next_operation_type_id IN NUMBER
976: , p_sug_to_sub_code IN VARCHAR2 DEFAULT NULL
977: , p_sug_to_locator_id IN NUMBER DEFAULT NULL
1024: mol.crossdock_type,
1025: mol.backorder_delivery_detail_id,
1026: mmtt.transfer_to_location,
1027: mmtt.locator_id
1028: FROM mtl_material_transactions_temp mmtt,
1029: mtl_secondary_inventories msi,
1030: mtl_txn_request_lines mol
1031: WHERE mmtt.transaction_temp_id = p_source_task_id
1032: AND Nvl(mmtt.transfer_subinventory, mmtt.subinventory_code) = msi.secondary_inventory_name (+)
1449:
1450: UPDATE mtl_txn_request_lines
1451: SET quantity_detailed = quantity_detailed - l_qty_in_mol_uom,
1452: lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1453: FROM mtl_material_transactions_temp mmtt
1454: WHERE mmtt.transaction_temp_id = p_document_rec.transaction_temp_id),
1455: wms_process_flag = 1 -- Bug 4657716
1456: WHERE line_id = p_document_rec.move_order_line_id;
1457:
1601: UPDATE mtl_txn_request_lines
1602: SET line_status = g_to_status_closed,
1603: quantity_delivered = Nvl(quantity_delivered, 0) + l_qty_in_mol_uom --,
1604: -- lpn_id =(SELECT Nvl(mmtt.transfer_lpn_id, mmtt.content_lpn_id)
1605: -- FROM mtl_material_transactions_temp mmtt
1606: -- WHERE mmtt.transaction_temp_id = p_document_rec.transaction_temp_id)
1607: WHERE line_id = p_document_rec.move_order_line_id;
1608: -- No need to update lpn_id when closing the move_order_line,
1609: -- not a big deal, just be consistent with earlier patchset
2236: transaction_source_type_id,
2237: organization_id,
2238: inventory_item_id,
2239: primary_quantity
2240: FROM mtl_material_transactions_temp
2241: WHERE transaction_temp_id = p_source_task_id;
2242:
2243: l_mmtt_data_rec c_mmtt_data_rec%ROWTYPE;
2244:
2275: INTO l_mol_lpn_id
2276: FROM mtl_txn_request_lines mol
2277: WHERE mol.line_id =
2278: (SELECT move_order_line_id
2279: FROM mtl_material_transactions_temp
2280: WHERE transaction_temp_id = p_source_task_id);
2281:
2282: l_progress := 34;
2283:
2333: -- If MMTT.operation_plan_ID is null we don't need to cleanup
2334: -- transfer_to_location, transfer_subinventory, and cartonization_id,
2335: -- which were NOT suggested by ATF.
2336:
2337: UPDATE mtl_material_transactions_temp
2338: SET transfer_subinventory = Decode(operation_plan_id, NULL, transfer_subinventory, NULL),
2339: transfer_to_location = Decode(operation_plan_id, NULL, transfer_to_location, NULL),
2340: cartonization_id = Decode(operation_plan_id, NULL, cartonization_id, NULL),
2341: transfer_lpn_id = NULL,
2362: -- If MMTT.operation_plan_ID is null we don't need to cleanup
2363: -- locator_ID, subinventory_code, and cartonization_id,
2364: -- which were NOT suggested by ATF.
2365:
2366: UPDATE mtl_material_transactions_temp
2367: SET subinventory_code = Decode(operation_plan_id, NULL, subinventory_code, NULL),
2368: locator_id = Decode(operation_plan_id, NULL, locator_id, NULL),
2369: cartonization_id = Decode(operation_plan_id, NULL, cartonization_id, NULL),
2370: transfer_lpn_id = NULL,
2522: mol.crossdock_type,
2523: mmtt.repetitive_line_id,
2524: mmtt.operation_seq_num,
2525: mmtt.primary_quantity
2526: FROM mtl_material_transactions_temp mmtt,
2527: mtl_txn_request_lines mol
2528: WHERE transaction_temp_id = p_source_task_id
2529: AND mmtt.move_order_line_id = mol.line_id;
2530:
2533: nvl(transfer_to_location,locator_id) locator_id,
2534: primary_quantity,
2535: organization_id,
2536: inventory_item_id
2537: FROM mtl_material_transactions_temp
2538: WHERE transaction_temp_id=v_txn_temp_id;
2539:
2540:
2541: CURSOR c_wdt_status IS
2767: , wlpn.locator_id
2768: INTO l_subinventory_code
2769: , l_locator_id
2770: FROM wms_license_plate_numbers wlpn
2771: , mtl_material_transactions_temp mmtt
2772: WHERE mmtt.lpn_id = wlpn.lpn_id
2773: AND mmtt.transaction_temp_id = p_source_task_id;
2774: EXCEPTION
2775: WHEN OTHERS THEN
2781: AND l_locator_id IS NOT NULL THEN
2782: IF l_debug = 1 THEN
2783: print_debug('Updating MMTT:'||l_subinventory_code||':'||l_locator_id,l_module_name,4);
2784: END IF;
2785: UPDATE mtl_material_transactions_temp mmtt
2786: SET (subinventory_code,
2787: locator_id,
2788: error_code,
2789: error_explanation,
2997: (
2998: x_return_status OUT NOCOPY VARCHAR2
2999: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
3000: , x_msg_count OUT NOCOPY NUMBER
3001: , p_document_rec IN mtl_material_transactions_temp%ROWTYPE
3002: , p_plan_orig_sub_code IN VARCHAR2
3003: , p_plan_orig_loc_id IN NUMBER
3004: , p_for_manual_drop IN BOOLEAN DEFAULT FALSE
3005: )
3133: END IF;
3134:
3135: IF p_document_rec.locator_id IS NULL THEN
3136:
3137: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
3138: SET operation_plan_id = NULL ,
3139: parent_line_id = NULL,
3140: subinventory_code = p_plan_orig_sub_code,
3141: locator_id = p_plan_orig_loc_id
3142: WHERE transaction_temp_id = p_document_rec.transaction_temp_id;
3143:
3144: ELSIF p_document_rec.transfer_to_location IS NULL THEN
3145:
3146: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
3147: SET operation_plan_id = NULL ,
3148: parent_line_id = NULL,
3149: transfer_subinventory = p_plan_orig_sub_code,
3150: transfer_to_location = p_plan_orig_loc_id