Line 28: CURSOR C2 IS SELECT JTF_QUAL_TYPES_s.nextval FROM sys.dual;
24: x_ORG_ID IN NUMBER
25: ) IS
26: CURSOR C IS SELECT rowid FROM JTF_QUAL_TYPES_ALL
27: WHERE QUAL_TYPE_ID = x_QUAL_TYPE_ID; 28: CURSOR C2 IS SELECT JTF_QUAL_TYPES_s.nextval FROM sys.dual; 29: BEGIN
30: If (x_QUAL_TYPE_ID IS NULL) then
31: OPEN C2;
32: FETCH C2 INTO x_QUAL_TYPE_ID;