APPS.IEX_WEBDIR_PKG dependencies on IEX_QUERY_STRINGS

Line 40: CURSOR c3 IS SELECT 'X' FROM IEX_QUERY_STRINGS

36:
37: CURSOR c2 IS SELECT 'X' FROM IEX_WEB_SEARCHES
38: WHERE search_id = p_web_search_rec.search_id;
39:
40: CURSOR c3 IS SELECT 'X' FROM IEX_QUERY_STRINGS
41: WHERE query_string_id = p_query_string_rec.query_string_id;
42:
43: p_dummy CHAR(1);
44:

Line 216: INSERT INTO IEX_QUERY_STRINGS(

212: THEN
213: OPEN c3;
214: FETCH c3 INTO P_DUMMY;
215: IF c3%notfound THEN
216: INSERT INTO IEX_QUERY_STRINGS(
217: query_string_id,
218: search_id,
219: object_version_number,
220: switch_separator,

Line 392: FROM iex_query_strings

388:
389: DECLARE
390: v_dummy char(1);
391: CURSOR c1 IS SELECT 'X'
392: FROM iex_query_strings
393: WHERE query_string_id = p_query_string_rec.query_string_id
394: FOR UPDATE;
395: BEGIN
396: OPEN c1;

Line 548: UPDATE iex_query_strings

544: attribute14 = p_web_search_rec.attribute14,
545: attribute15 = p_web_search_rec.attribute15
546: WHERE search_id = p_web_search_rec.search_id;
547:
548: UPDATE iex_query_strings
549: SET
550: switch_separator = p_query_string_rec.switch_separator,
551: url_separator = p_query_string_rec.url_separator,
552: header_const = p_query_string_rec.header_const,