APPS.AMS_LIST_QUERY_PVT dependencies on AMS_LIST_QUERIES_ALL_S

Line 57: SELECT AMS_LIST_QUERIES_ALL_s.NEXTVAL

53: l_parent_list_query_id number;
54: l_dummy NUMBER;
55:
56: CURSOR c_id IS
57: SELECT AMS_LIST_QUERIES_ALL_s.NEXTVAL
58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual

Line 495: update ams_list_queries_all set parameterized_flag = 'Y'

491: x_parent_list_query_id := l_parent_list_query_id ;
492: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
493: RAISE FND_API.G_EXC_ERROR;
494: END IF;
495: update ams_list_queries_all set parameterized_flag = 'Y'
496: where parent_list_query_id = l_parent_list_query_id;
497: delete from ams_list_queries_param
498: where list_query_id = l_parent_list_query_id ;
499: FOR I in p_query_param.first .. p_query_param.last