[Home] [Help]
10180: ));
10181:
10182:
10183:
10184: INSERT INTO MTL_SERIAL_NUMBERS_TEMP
10185: (TRANSACTION_TEMP_ID,
10186: LAST_UPDATE_DATE,
10187: LAST_UPDATED_BY,
10188: CREATION_DATE,
11503: CURSOR msnt_serials_csr (l_serial_transaction_temp_id IN NUMBER)
11504: IS
11505: SELECT fm_serial_number
11506: , transaction_temp_id
11507: FROM mtl_serial_numbers_temp
11508: WHERE transaction_temp_id = l_serial_transaction_temp_id
11509: FOR UPDATE NOWAIT;
11510:
11511: CURSOR mtli_parent_lots_csr (l_transaction_interface_id IN NUMBER)
12455: THEN
12456: mydebug ('Inserting into MSNT', 'tmpinsert2');
12457: END IF;
12458:
12459: INSERT INTO mtl_serial_numbers_temp
12460: (transaction_temp_id
12461: , last_update_date
12462: , last_updated_by
12463: , creation_date
12648: , 'tmpinsert2'
12649: );
12650: END IF;
12651:
12652: INSERT INTO mtl_serial_numbers_temp
12653: (transaction_temp_id
12654: , last_update_date
12655: , last_updated_by
12656: , creation_date
12982: , 'tmpinsert2'
12983: );
12984: END IF;
12985:
12986: INSERT INTO mtl_serial_numbers_temp
12987: (transaction_temp_id
12988: , last_update_date
12989: , last_updated_by
12990: , creation_date
13251: , 'tmpinsert2'
13252: );
13253: END IF;
13254: /*The behaviour here is taken from LotTrxManager.Bit Strange!*/
13255: UPDATE mtl_serial_numbers_temp
13256: SET parent_object_number2 = l_mtli_csr.lot_number
13257: , parent_object_number = fm_serial_number
13258: , object_number2 = l_parent_object_number2
13259: , object_type2 = 1
13279: , 'tmpinsert2'
13280: );
13281: END IF;
13282:
13283: UPDATE mtl_serial_numbers_temp
13284: SET parent_object_number2 = l_parent_object_number2
13285: , parent_object_number = fm_serial_number
13286: , object_number2 = l_mtli_csr.lot_number
13287: , object_type2 = 1