204: -- Cursor for getting the org_id
205:
206: CURSOR org_csr IS
207: SELECT NVL (SUBSTRB (USERENV ('CLIENT_INFO'), 1, 10), -99)
208: FROM DUAL;
209:
210: CURSOR c_get_seq IS
211: SELECT ozf_terr_levels_all_s.NEXTVAL
212: FROM DUAL;
208: FROM DUAL;
209:
210: CURSOR c_get_seq IS
211: SELECT ozf_terr_levels_all_s.NEXTVAL
212: FROM DUAL;
213:
214:
215: -- cursor to check uniqueness
216: CURSOR c_terr_id (l_terr_id IN NUMBER) IS