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;
Line 228: SELECT QA_GROUP_S.NEXTVAL INTO X_GROUP_ID FROM DUAL;
224:
225: -- if this is the first row in a group, fetch a new group id
226:
227: IF (ROW_COUNT = 1) THEN 228: SELECT QA_GROUP_S.NEXTVAL INTO X_GROUP_ID FROM DUAL; 229: END IF;
230:
231: -- assign the current group id to the current row
232: