APPS.AMS_LIST_QUERIES_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 80: INSERT INTO AMS_LIST_QUERIES_ALL(

76:
77: px_object_version_number := 1;
78:
79:
80: INSERT INTO AMS_LIST_QUERIES_ALL(
81: list_query_id,
82: last_update_date,
83: last_updated_by,
84: creation_date,

Line 197: Update AMS_LIST_QUERIES_ALL

193: p_parent_list_query_id number,
194: p_sequence_order in number)
195: IS
196: BEGIN
197: Update AMS_LIST_QUERIES_ALL
198: SET
199: list_query_id = DECODE( p_list_query_id, FND_API.g_miss_num, list_query_id, p_list_query_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 249: DELETE FROM AMS_LIST_QUERIES_ALL

245: PROCEDURE Delete_Row(
246: p_LIST_QUERY_ID NUMBER)
247: IS
248: BEGIN
249: DELETE FROM AMS_LIST_QUERIES_ALL
250: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: End If;

Line 299: FROM AMS_LIST_QUERIES_ALL

295:
296: IS
297: CURSOR C IS
298: SELECT *
299: FROM AMS_LIST_QUERIES_ALL
300: WHERE LIST_QUERY_ID = p_LIST_QUERY_ID
301: FOR UPDATE of LIST_QUERY_ID NOWAIT;
302: Recinfo C%ROWTYPE;
303: BEGIN

Line 350: from ams_list_queries_all

346: l_obj_verno NUMBER;
347:
348: cursor c_chk_col_exists is
349: select object_version_number
350: from ams_list_queries_all
351: where list_query_id = p_list_query_id;
352:
353: CURSOR c_obj_verno IS
354: SELECT object_version_number, last_updated_by

Line 355: FROM ams_list_queries_all

351: where list_query_id = p_list_query_id;
352:
353: CURSOR c_obj_verno IS
354: SELECT object_version_number, last_updated_by
355: FROM ams_list_queries_all
356: where list_query_id = p_list_query_id;
357:
358: begin
359: if p_OWNER = 'SEED' then

Line 442: from AMS_LIST_QUERIES_ALL B

438: begin
439: delete from AMS_LIST_QUERIES_TL T
440: where not exists
441: (select NULL
442: from AMS_LIST_QUERIES_ALL B
443: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
444: );
445:
446: update AMS_LIST_QUERIES_TL T set (