APPS.AST_WEBASSIST_PVT dependencies on AST_WEB_SEARCHES

Line 41: CURSOR c2 IS SELECT 'X' FROM ast_web_searches

37:
38: CURSOR c1 IS SELECT 'X' FROM ast_web_assists
39: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
40:
41: CURSOR c2 IS SELECT 'X' FROM ast_web_searches
42: WHERE search_id = p_web_search_rec.search_id;
43:
44: CURSOR c3 IS SELECT 'X' FROM ast_query_strings
45: WHERE query_string_id = p_query_string_rec.query_string_id;

Line 229: INSERT INTO ast_web_searches(

225: THEN
226: OPEN c2;
227: FETCH c2 INTO P_DUMMY;
228: IF c2%notfound THEN
229: INSERT INTO ast_web_searches(
230: search_id,
231: web_assist_id,
232: object_version_number,
233: enabled_flag,

Line 591: FROM ast_web_searches

587:
588: DECLARE
589: v_dummy char(1);
590: CURSOR c1 IS SELECT 'X'
591: FROM ast_web_searches
592: WHERE search_id = p_web_search_rec.search_id
593: FOR UPDATE;
594: BEGIN
595: OPEN c1;

Line 812: UPDATE ast_web_searches

808: attribute14 = p_web_assist_rec.attribute14,
809: attribute15 = p_web_assist_rec.attribute15
810: WHERE web_assist_id = p_web_assist_rec.web_assist_id;
811:
812: UPDATE ast_web_searches
813: SET
814: enabled_flag = p_web_search_rec.enabled_flag,
815: search_url = p_web_search_rec.search_url,
816: cgi_server = p_web_search_rec.cgi_server,

Line 1054: DELETE FROM ast_web_searches

1050: WHERE query_string_id = p_query_string_rec.query_string_id;
1051: END IF;
1052:
1053: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN
1054: DELETE FROM ast_web_searches
1055: WHERE search_id = p_web_search_rec.search_id;
1056: END IF;
1057:
1058: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN