APPS.IEX_WEBDIR_PKG dependencies on IEX_WEB_SEARCHES

Line 37: CURSOR c2 IS SELECT 'X' FROM IEX_WEB_SEARCHES

33:
34: CURSOR c1 IS SELECT 'X' FROM IEX_WEB_ASSISTS
35: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
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;

Line 143: INSERT INTO IEX_WEB_SEARCHES(

139: THEN
140: OPEN c2;
141: FETCH c2 INTO P_DUMMY;
142: IF c2%notfound THEN
143: INSERT INTO IEX_WEB_SEARCHES(
144: search_id,
145: web_assist_id,
146: object_version_number,
147: enabled_flag,

Line 380: FROM IEX_WEB_searches

376:
377: DECLARE
378: v_dummy char(1);
379: CURSOR c1 IS SELECT 'X'
380: FROM IEX_WEB_searches
381: WHERE search_id = p_web_search_rec.search_id
382: FOR UPDATE;
383: BEGIN
384: OPEN c1;

Line 519: UPDATE IEX_WEB_searches

515: attribute14 = p_web_assist_rec.attribute14,
516: attribute15 = p_web_assist_rec.attribute15
517: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
518:
519: UPDATE IEX_WEB_searches
520: SET
521: enabled_flag = p_web_search_rec.enabled_flag,
522: search_url = p_web_search_rec.search_url,
523: cgi_server = p_web_search_rec.cgi_server,

Line 681: DELETE FROM IEX_WEB_searches

677: WHERE query_string_id = p_query_string_rec.query_string_id;
678: END IF;
679:
680: IF p_web_search_rec.search_id IS NOT NULL THEN
681: DELETE FROM IEX_WEB_searches
682: WHERE search_id = p_web_search_rec.search_id;
683: END IF;
684:
685: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN