eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_QUERY_PVT dependencies on AMS_LIST_QUERIES_ALL

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 62: WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL

58: FROM dual;
59:
60: CURSOR c_id_exists (l_id IN NUMBER) IS
61: SELECT 1 FROM dual
62: WHERE EXISTS (SELECT 1 FROM AMS_LIST_QUERIES_ALL
63: WHERE LIST_QUERY_ID = l_id);
64:
65: BEGIN
66: -- Standard Start of API savepoint

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

Line 607: FROM AMS_LIST_QUERIES_ALL

603: IS
604:
605: CURSOR c_get_list_query(list_query_id NUMBER) IS
606: SELECT *
607: FROM AMS_LIST_QUERIES_ALL
608: WHERE list_query_id = p_list_query_rec.list_query_id;
609:
610: -- Hint: Developer need to provide Where clause
611:

Line 827: FROM AMS_LIST_QUERIES_ALL

823:
824:
825: CURSOR c_get_list_query IS
826: SELECT *
827: FROM AMS_LIST_QUERIES_ALL
828: WHERE list_query_id = p_list_query_rec_tbl.parent_list_query_id;
829: cursor c_get_list_count is
830: SELECT count(1)
831: FROM AMS_LIST_QUERIES_ALL

Line 831: FROM AMS_LIST_QUERIES_ALL

827: FROM AMS_LIST_QUERIES_ALL
828: WHERE list_query_id = p_list_query_rec_tbl.parent_list_query_id;
829: cursor c_get_list_count is
830: SELECT count(1)
831: FROM AMS_LIST_QUERIES_ALL
832: WHERE parent_list_query_id = p_list_query_rec_tbl.parent_list_query_id;
833:
834: -- Hint: Developer need to provide Where clause
835:

Line 851: from ams_list_queries_all

847: l_parent_list_query_id number;
848: cursor c_get_query_id (cur_parent_query_id number,
849: cur_sequence_order number) is
850: select list_query_id ,object_version_number
851: from ams_list_queries_all
852: where parent_list_query_id = cur_parent_query_id
853: and sequence_order = cur_sequence_order ;
854:
855: cursor c_query(cur_parent_query_id number) is

Line 857: from ams_list_queries_all

853: and sequence_order = cur_sequence_order ;
854:
855: cursor c_query(cur_parent_query_id number) is
856: select query --sql_string column is obsolete bug 4604653
857: from ams_list_queries_all
858: where parent_list_query_id = cur_parent_query_id;
859: l_sql_string varchar2(4000);
860: l_sql_string_tbl AMS_List_Query_PVT.sql_string_tbl ;
861: j number:=0 ;

Line 1036: delete from ams_list_queries_all

1032: IF (AMS_DEBUG_HIGH_ON) THEN
1033:
1034: AMS_UTILITY_PVT.debug_message( '->' || l_parent_list_query_id || '<-');
1035: END IF;
1036: delete from ams_list_queries_all
1037: where parent_list_query_id = l_parent_list_query_id
1038: and sequence_order > l_no_of_records_upd ;
1039:
1040:

Line 1242: from ams_list_queries_all

1238: l_object_version_number NUMBER;
1239:
1240: cursor c_get_child_ids
1241: is select list_query_id
1242: from ams_list_queries_all
1243: where parent_list_query_id = p_parent_list_query_id ;
1244: l_list_query_id number;
1245:
1246: BEGIN

Line 1379: FROM AMS_LIST_QUERIES_ALL

1375: l_LIST_QUERY_ID NUMBER;
1376:
1377: CURSOR c_List_Query IS
1378: SELECT LIST_QUERY_ID
1379: FROM AMS_LIST_QUERIES_ALL
1380: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
1381: AND object_version_number = p_object_version
1382: FOR UPDATE NOWAIT;
1383:

Line 1508: 'AMS_LIST_QUERIES_ALL',

1504:
1505: -- check for uniqueness of id
1506: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1507: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1508: 'AMS_LIST_QUERIES_ALL',
1509: 'LIST_QUERY_ID = ''' || p_list_query_rec.LIST_QUERY_ID ||''''
1510: );
1511: END IF;
1512:

Line 1780: FROM ams_list_queries_all

1776: )
1777: IS
1778: CURSOR c_query IS
1779: SELECT *
1780: FROM ams_list_queries_all
1781: WHERE list_query_id = p_list_query_rec.list_query_id;
1782:
1783: l_query_rec c_query%ROWTYPE;
1784: BEGIN

Line 2115: FROM ams_list_queries_all

2111: IS
2112:
2113: CURSOR c_listquery IS
2114: SELECT *
2115: FROM ams_list_queries_all
2116: WHERE list_query_id = p_listquery_rec.parent_list_query_id
2117: and sequence_order = 1;
2118:
2119: l_listquery_rec c_listquery%ROWTYPE;

Line 2230: FROM ams_list_queries_all

2226: IS
2227:
2228: CURSOR c_listquery IS
2229: SELECT *
2230: FROM ams_list_queries_all
2231: WHERE list_query_id = p_listquery_rec.list_query_id;
2232:
2233: l_listquery_rec c_listquery%ROWTYPE;
2234:

Line 2371: FROM ams_list_queries_all

2367:
2368:
2369: CURSOR fetch_list_queries (listqueryId NUMBER) IS
2370: SELECT *
2371: FROM ams_list_queries_all
2372: WHERE parent_list_query_id =listqueryId
2373: ORDER BY sequence_order;
2374:
2375: CURSOR fetch_list_select_actions(list_id NUMBER) IS