55: AND CGI_SERVER = l_web_search_rec.cgi_server;
56:
57: CURSOR c_query_seq IS
58: SELECT IEX_QUERY_STRINGS_S.NEXTVAL
59: FROM SYS.DUAL;
60:
61: BEGIN
62: -- Standard begin of API savepoint
63: SAVEPOINT Create_WebAssist_PVT;
129: IF c_web_assist%NOTFOUND THEN
130: DECLARE
131: CURSOR c_web_assist_seq IS
132: SELECT IEX_WEB_ASSISTS_S.NEXTVAL
133: FROM SYS.DUAL;
134: BEGIN
135: CLOSE c_web_assist;
136: OPEN c_web_assist_seq;
137: FETCH c_web_assist_seq INTO l_web_assist_id;
150: IF c_web_search%NOTFOUND THEN
151: DECLARE
152: CURSOR c_search_seq IS
153: SELECT IEX_WEB_SEARCHES_S.NEXTVAL
154: FROM SYS.DUAL;
155: BEGIN
156: CLOSE c_web_search;
157: OPEN c_search_seq;
158: FETCH c_search_seq INTO l_search_id;