[Home] [Help]
1121: );
1122: END IF;
1123:
1124: IF p_serial_number IS NOT NULL THEN
1125: INSERT INTO mtl_serial_numbers_interface
1126: ( transaction_interface_id
1127: , fm_serial_number
1128: , to_serial_number
1129: , last_update_date
1293: -- Purpose : This procedure copies the data from the given mtl_material_transactions_temp record to the
1294: -- mtl_transactions_temp_interface table. It will also analyzed whether the item associated with the
1295: -- the given temp id is under serial or lot control. If the item is under under lot or serial control, this
1296: -- procedure inserts the necessary data into the mtl_lot_transactions_interface table or the
1297: -- mtl_serial_numbers_interface table. After the insertion completes, it deletes the existing record from
1298: -- the mtl_material_transactions_temp, mtl_transaction_lots_temp or the mtl_serial_numbers_temp tables.
1299: --
1300: -- History :
1301: -- Person Date Descriptions