APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1007: FROM mtl_material_transactions_temp

1003: , l_transaction_quantity
1004: , l_lpn_id
1005: , l_content_lpn_id
1006: , l_transfer_lpn_id
1007: FROM mtl_material_transactions_temp
1008: WHERE transaction_temp_id = l_temp_id
1009: AND ROWNUM < 2;
1010: EXCEPTION
1011: WHEN NO_DATA_FOUND THEN

Line 1110: UPDATE mtl_material_transactions_temp

1106: mydebug(' content_lpn_id ' || l_content_lpn_id);
1107: mydebug(' transfer_lpn_id ' || l_transfer_lpn_id);
1108: END IF;
1109:
1110: UPDATE mtl_material_transactions_temp
1111: SET move_order_line_id = NULL
1112: , transaction_status = 1
1113: , primary_quantity = l_primary_quantity
1114: , transaction_quantity = l_transaction_quantity

Line 1125: -- UPDATE mtl_material_transactions_temp

1121: IF (l_debug = 1) THEN
1122: mydebug('update - complete');
1123: END IF;
1124:
1125: -- UPDATE mtl_material_transactions_temp
1126: -- SET
1127: --transaction_source_type_id = 5,
1128: --transaction_type_id = 35,
1129: --transaction_action_id = 1,

Line 1167: UPDATE mtl_material_transactions_temp

1163: WHEN OTHERS THEN
1164: NULL;
1165: END;
1166:
1167: UPDATE mtl_material_transactions_temp
1168: SET lpn_id = l_lpn_id
1169: , content_lpn_id = l_content_lpn_id
1170: , transfer_lpn_id = l_transfer_lpn_id
1171: WHERE transaction_temp_id = l_new_temp_id;

Line 1244: --UPDATE mtl_material_transactions_temp

1240: END IF;
1241: --Nothing to do
1242: /* Back FLUSH */
1243:
1244: --UPDATE mtl_material_transactions_temp
1245: -- SET
1246: -- transaction_source_type_id = 5,
1247: -- transaction_type_id = 35,
1248: -- transaction_action_id = 1,

Line 1392: SUBTYPE mmtt_type IS mtl_material_transactions_temp%ROWTYPE;

1388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1389: END mark_wip;
1390:
1391: PROCEDURE insert_new_mmtt_row_like(p_txn_temp_id IN NUMBER, x_new_temp_id OUT NOCOPY NUMBER, x_new_hdr_id OUT NOCOPY NUMBER) IS
1392: SUBTYPE mmtt_type IS mtl_material_transactions_temp%ROWTYPE;
1393:
1394: mmtt_row mmtt_type;
1395:
1396: SUBTYPE mtlt_type IS mtl_transaction_lots_temp%ROWTYPE;

Line 1436: FROM mtl_material_transactions_temp

1432: x_new_hdr_id := l_new_txn_hdr_id;
1433:
1434: SELECT *
1435: INTO mmtt_row
1436: FROM mtl_material_transactions_temp
1437: WHERE transaction_temp_id = p_txn_temp_id;
1438:
1439: mmtt_row.transaction_temp_id := new_txn_temp_id;
1440: mmtt_row.transaction_header_id := l_new_txn_hdr_id;