[Home] [Help]
587: 'p_split_sec_qty'||p_split_sec_qty ,l_api_name);
588: END IF;
589: -- 8197506
590: -- insert into mtlt and update the qty for old line
591: INSERT INTO mtl_transaction_lots_temp
592: (
593: transaction_temp_id
594: , last_update_date
595: , last_updated_by
773: , n_attribute8
774: , n_attribute9
775: , n_attribute10
776: , vendor_name
777: FROM mtl_transaction_lots_temp
778: WHERE transaction_temp_id = p_child_temp_id
779: AND lot_number = p_child_lot_number); --v1 Bug 3902766
780:
781: -- update the old line with remaining qty
778: WHERE transaction_temp_id = p_child_temp_id
779: AND lot_number = p_child_lot_number); --v1 Bug 3902766
780:
781: -- update the old line with remaining qty
782: update mtl_transaction_lots_temp
783: set primary_quantity = primary_quantity-p_split_pri_qty, -- UOM
784: secondary_quantity = decode(secondary_quantity,NULL,NULL,secondary_quantity-p_split_sec_qty), --bug 8197506
785: transaction_quantity = transaction_quantity-p_split_pri_qty -- UOM
786: where transaction_temp_id = p_child_temp_id
862: p_sec_qty NUMBER, --12747184
863: p_lot_controlled VARCHAR2
864: ) IS
865: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
866: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
867: l_new_temp_id NUMBER;
868: l_api_name VARCHAR2(30) := 'create_sub_transfer';
869: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
870:
929: IF (p_lot_controlled = 'Y') THEN -- lot controlled
930: FOR lot_line in over_picked_lots(p_from_temp_id) LOOP
931: select *
932: into l_mtlt_rec
933: from mtl_transaction_lots_temp
934: where transaction_temp_id = p_from_temp_id
935: and lot_number = lot_line.lot_number;
936:
937: l_mtlt_rec.transaction_temp_id := l_new_temp_id;
965: l_api_name VARCHAR2(30) := 'bulk_pick';
966: BEGIN
967: x_return_status := fnd_api.g_ret_sts_success;
968: mydebug('FlexibleLotAlloc: Inside insert mtlt',l_api_name );
969: INSERT INTO mtl_transaction_lots_temp
970: (
971: transaction_temp_id
972: , last_update_date
973: , last_updated_by
1207: , mtlt.lot_number
1208: , mtlt.transaction_quantity lot_trx_qty
1209: , mtlt.primary_quantity lot_primary_qty
1210: , mtlt.secondary_quantity lot_sec_qty --bug 8197506
1211: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
1212: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1213: AND mmtt.organization_id = p_org_id
1214: AND mmtt.transaction_quantity > 0
1215: AND mmtt.parent_line_id = mmtt.transaction_temp_id
1222: , mtlt.lot_number
1223: , mtlt.transaction_quantity lot_trx_qty
1224: , mtlt.primary_quantity lot_primary_qty
1225: , mtlt.secondary_quantity lot_sec_qty --bug 8197506
1226: FROM mtl_material_transactions_temp mmtt,mtl_transaction_lots_temp mtlt
1227: WHERE mmtt.transaction_header_id = p_txn_hdr_id
1228: AND mmtt.organization_id = p_org_id
1229: AND mmtt.transaction_quantity > 0
1230: AND mmtt.parent_line_id <> p_temp_id
1292: mtlt.lot_number
1293: , mtlt.transaction_quantity
1294: , mtlt.primary_quantity
1295: , mtlt.secondary_quantity -- bug 8197506
1296: FROM mtl_transaction_lots_temp mtlt
1297: WHERE
1298: mtlt.transaction_temp_id = p_child_transaction_temp_id;
1299:
1300:
1350:
1351: CURSOR c_child_lot_allocation_exists
1352: IS
1353: SELECT 'Y'
1354: FROM mtl_transaction_lots_temp
1355: WHERE transaction_temp_id IN (SELECT mmtt.transaction_temp_id
1356: FROM mtl_material_transactions_temp mmtt
1357: WHERE mmtt.parent_line_id = p_temp_id
1358: AND mmtt.parent_line_id <> mmtt.transaction_temp_id);
1708: IF (l_debug = 1) THEN
1709: mydebug('update the lot qty for temp id:'
1710: ||c_mmtt_line.transaction_temp_id, l_api_name);
1711: END IF;
1712: UPDATE mtl_transaction_lots_temp
1713: SET transaction_Temp_id = l_child_txn_temp_id
1714: WHERE transaction_temp_id = c_mmtt_line.transaction_temp_id
1715: AND lot_number = c_child_lots_rec.lot_number;
1716: