Line 61: CURSOR C2 IS SELECT JTF_TERR_s.nextval FROM sys.dual;
57: x_NUM_QUAL IN NUMBER
58: ) IS
59: CURSOR C IS SELECT rowid FROM JTF_TERR_ALL
60: WHERE TERR_ID = x_TERR_ID; 61: CURSOR C2 IS SELECT JTF_TERR_s.nextval FROM sys.dual; 62: BEGIN
63: If (x_TERR_ID IS NULL) then
64: OPEN C2;
65: FETCH C2 INTO x_TERR_ID;