[Home] [Help]
30: x_ORG_ID IN NUMBER
31: ) IS
32: CURSOR C IS SELECT rowid FROM JTF_TERR_QUAL_ALL
33: WHERE TERR_QUAL_ID = x_TERR_QUAL_ID;
34: CURSOR C2 IS SELECT JTF_TERR_QUAL_s.nextval FROM sys.dual;
35: BEGIN
36: If (x_TERR_QUAL_ID IS NULL) then
37: OPEN C2;
38: FETCH C2 INTO x_TERR_QUAL_ID;