[Home] [Help]
10751: ));
10752:
10753:
10754:
10755: INSERT INTO MTL_SERIAL_NUMBERS_TEMP
10756: (TRANSACTION_TEMP_ID,
10757: LAST_UPDATE_DATE,
10758: LAST_UPDATED_BY,
10759: CREATION_DATE,
12074: CURSOR msnt_serials_csr (l_serial_transaction_temp_id IN NUMBER)
12075: IS
12076: SELECT fm_serial_number
12077: , transaction_temp_id
12078: FROM mtl_serial_numbers_temp
12079: WHERE transaction_temp_id = l_serial_transaction_temp_id
12080: FOR UPDATE NOWAIT;
12081:
12082: CURSOR mtli_parent_lots_csr (l_transaction_interface_id IN NUMBER)
13026: THEN
13027: mydebug ('Inserting into MSNT', 'tmpinsert2');
13028: END IF;
13029:
13030: INSERT INTO mtl_serial_numbers_temp
13031: (transaction_temp_id
13032: , last_update_date
13033: , last_updated_by
13034: , creation_date
13219: , 'tmpinsert2'
13220: );
13221: END IF;
13222:
13223: INSERT INTO mtl_serial_numbers_temp
13224: (transaction_temp_id
13225: , last_update_date
13226: , last_updated_by
13227: , creation_date
13553: , 'tmpinsert2'
13554: );
13555: END IF;
13556:
13557: INSERT INTO mtl_serial_numbers_temp
13558: (transaction_temp_id
13559: , last_update_date
13560: , last_updated_by
13561: , creation_date
13822: , 'tmpinsert2'
13823: );
13824: END IF;
13825: /*The behaviour here is taken from LotTrxManager.Bit Strange!*/
13826: UPDATE mtl_serial_numbers_temp
13827: SET parent_object_number2 = l_mtli_csr.lot_number
13828: , parent_object_number = fm_serial_number
13829: , object_number2 = l_parent_object_number2
13830: , object_type2 = 1
13850: , 'tmpinsert2'
13851: );
13852: END IF;
13853:
13854: UPDATE mtl_serial_numbers_temp
13855: SET parent_object_number2 = l_parent_object_number2
13856: , parent_object_number = fm_serial_number
13857: , object_number2 = l_mtli_csr.lot_number
13858: , object_type2 = 1