[Home] [Help]
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
1302: -- ------ ---- --------------
1359: from mtl_transaction_lots_temp
1360: where transaction_temp_id = p_transaction_temp_id;
1361:
1362: Cursor l_Get_Serial_Temp_Csr(l_transaction_temp_id NUMBER) IS
1363: select transaction_temp_id, fm_serial_number, to_serial_number, serial_prefix from mtl_serial_numbers_temp
1364: where transaction_temp_id = l_transaction_temp_id;
1365:
1366: Cursor l_Get_txn_header_id_csr IS
1367: SELECT mtl_material_transactions_s.nextval