23: item_key number;
24:
25: CURSOR c IS
26: SELECT qa_ss_import_workflow_s.nextval
27: FROM dual;
28: BEGIN
29: OPEN c;
30: FETCH c INTO item_key;
31: CLOSE c;
215:
216: -- if this is the first row in a group, fetch a new group id
217:
218: IF (ROW_COUNT = 1) THEN
219: SELECT QA_GROUP_S.NEXTVAL INTO X_GROUP_ID FROM DUAL;
220: END IF;
221:
222: -- assign the current group id to the current row
223: