Line 250: SET TRANSACTION_INTERFACE_ID = QA_TXN_INTERFACE_S.NEXTVAL
246: -- if transaction interface id for the current row is left blank,
247: -- assign it a unique value
248:
249: UPDATE QA_RESULTS_INTERFACE 250: SET TRANSACTION_INTERFACE_ID = QA_TXN_INTERFACE_S.NEXTVAL 251: WHERE ROWID = ROWID_TABLE(I)
252: AND TRANSACTION_INTERFACE_ID IS NULL;
253:
254: -- if we've reached the maximum number of worker rows, launch