[Home] [Help]
2575: IF (l_debug = 1) THEN
2576: print_debug('create_po_rcvtxn_intf_rec 65.3: serial_control_code IS 6, need TO NULL OUT mtli', 4);
2577: END IF;
2578: BEGIN
2579: UPDATE mtl_transaction_lots_interface
2580: SET serial_transaction_temp_id = NULL
2581: WHERE product_transaction_id = p_transaction_temp_id
2582: AND product_code = 'RCV';
2583: EXCEPTION
3244: IF (l_debug = 1) THEN
3245: print_debug('create_int_shp_rcvtxn_intf_rec 127.7: serial_control_code IS 6, need TO NULL OUT mtli', 4);
3246: END IF;
3247: IF l_msni_count <= 0 THEN
3248: UPDATE mtl_transaction_lots_interface
3249: SET serial_transaction_temp_id = NULL
3250: WHERE product_transaction_id = p_transaction_temp_id
3251: AND product_code = 'RCV';
3252: END IF;
5598: SELECT SUM(primary_quantity)
5599: , SUM(transaction_quantity)
5600: INTO l_processed_lot_prim_qty
5601: , l_processed_lot_qty
5602: FROM mtl_transaction_lots_interface
5603: WHERE product_code = 'RCV'
5604: AND product_transaction_id
5605: IN (SELECT interface_transaction_id
5606: FROM rcv_transactions_interface
5819: print_debug('QTY TO INSERT3: = ' || L_QTY_TO_INSERT , 1);
5820: END IF;
5821:
5822: IF (p_lot_control_code = 2) THEN
5823: UPDATE mtl_transaction_lots_interface
5824: SET product_transaction_id = l_new_intf_id
5825: WHERE product_transaction_id = p_transaction_temp_id
5826: AND product_code = 'RCV';
5827: END IF;
6216: -- CASE FOR BOTH LOT AND SERIAL CONTROLLED ITEM
6217: BEGIN
6218: select secondary_transaction_quantity
6219: into l_original_lot_sec_qty
6220: from mtl_transaction_lots_interface mtli
6221: where mtli.lot_number = p_lot_number
6222: and mtli.product_code = 'RCV'
6223: and mtli.product_transaction_id = p_transaction_temp_id ;
6224: EXCEPTION