APPS.AST_WEBASSIST_PVT dependencies on AST_QUERY_STRINGS

Line 44: CURSOR c3 IS SELECT 'X' FROM ast_query_strings

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;
46:
47: p_dummy CHAR(1);
48:

Line 302: INSERT INTO ast_query_strings(

298: THEN
299: OPEN c3;
300: FETCH c3 INTO P_DUMMY;
301: IF c3%notfound THEN
302: INSERT INTO ast_query_strings(
303: query_string_id,
304: search_id,
305: object_version_number,
306: switch_separator,

Line 603: FROM ast_query_strings

599:
600: DECLARE
601: v_dummy char(1);
602: CURSOR c1 IS SELECT 'X'
603: FROM ast_query_strings
604: WHERE query_string_id = p_query_string_rec.query_string_id
605: FOR UPDATE;
606: BEGIN
607: OPEN c1;

Line 841: UPDATE ast_query_strings

837: attribute14 = p_web_search_rec.attribute14,
838: attribute15 = p_web_search_rec.attribute15
839: WHERE search_id = p_web_search_rec.search_id;
840:
841: UPDATE ast_query_strings
842: SET
843: switch_separator = p_query_string_rec.switch_separator,
844: url_separator = p_query_string_rec.url_separator,
845: header_const = p_query_string_rec.header_const,

Line 1049: DELETE FROM ast_query_strings

1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046:
1047: -- API body
1048: IF p_web_assist_rec.web_assist_id IS NOT NULL THEN
1049: DELETE FROM ast_query_strings
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