118: IF l_query_result <> 0 THEN
119:
120:
121: --Get value from sequence for next transaction_header_id
122: SELECT mtl_material_transactions_s.NEXTVAL
123: INTO l_next_transaction_header_id
124: FROM dual ;
125:
126: IF (l_debug = 1) THEN
136:
137: -- Insert into mtl_material_transactions_temp
138:
139: --Get value from sequence for next transaction_temp_id
140: SELECT mtl_material_transactions_s.NEXTVAL
141: INTO l_next_transaction_temp_id
142: FROM dual ;
143:
144: IF (l_debug = 1) THEN
654:
655: -- FOR LOT and SERIAL controlled items
656:
657: --Get value from sequence for next serial_transaction_temp_id
658: SELECT mtl_material_transactions_s.NEXTVAL
659: INTO l_next_ser_tran_temp_id
660: FROM dual;
661:
662: --Update MTLT line