Line 22: CURSOR C2 IS SELECT JTF_TERR_QTYPE_USGS_s.nextval FROM sys.dual;
18: x_ORG_ID IN NUMBER
19: ) IS
20: CURSOR C IS SELECT rowid FROM JTF_TERR_QTYPE_USGS_all
21: WHERE TERR_QTYPE_USG_ID = x_TERR_QTYPE_USG_ID; 22: CURSOR C2 IS SELECT JTF_TERR_QTYPE_USGS_s.nextval FROM sys.dual; 23: BEGIN
24: If (x_TERR_QTYPE_USG_ID IS NULL) then
25: OPEN C2;
26: FETCH C2 INTO x_TERR_QTYPE_USG_ID;