Line 24: CURSOR C2 IS SELECT JTF_TERR_TYPE_USGS_s.nextval FROM sys.dual;
20: ) IS
21: CURSOR C IS SELECT rowid FROM JTF_TERR_TYPE_USGS
22: WHERE TERR_TYPE_USG_ID = x_TERR_TYPE_USG_ID;
23: 24: CURSOR C2 IS SELECT JTF_TERR_TYPE_USGS_s.nextval FROM sys.dual; 25: BEGIN
26: If (x_TERR_TYPE_USG_ID IS NULL) then
27: OPEN C2;
28: FETCH C2 INTO x_TERR_TYPE_USG_ID;