APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on AMS_LIST_QUERIES_ALL

Line 34: cursor C is select ROWID from AMS_LIST_QUERIES_ALL

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: cursor C is select ROWID from AMS_LIST_QUERIES_ALL
35: where LIST_QUERY_ID = X_LIST_QUERY_ID
36: ;
37: begin
38: insert into AMS_LIST_QUERIES_ALL (

Line 38: insert into AMS_LIST_QUERIES_ALL (

34: cursor C is select ROWID from AMS_LIST_QUERIES_ALL
35: where LIST_QUERY_ID = X_LIST_QUERY_ID
36: ;
37: begin
38: insert into AMS_LIST_QUERIES_ALL (
39: QUERY_TEMPLATE_ID,
40: OWNER_USER_ID,
41: QUERY_TYPE,
42: ACT_LIST_QUERY_USED_BY_ID,

Line 184: from AMS_LIST_QUERIES_ALL

180: PRIMARY_KEY,
181: PUBLIC_FLAG,
182: COMMENTS,
183: SECURITY_GROUP_ID
184: from AMS_LIST_QUERIES_ALL
185: where LIST_QUERY_ID = X_LIST_QUERY_ID
186: for update of LIST_QUERY_ID nowait;
187: recinfo c%rowtype;
188:

Line 298: update AMS_LIST_QUERIES_ALL set

294: X_LAST_UPDATED_BY in NUMBER,
295: X_LAST_UPDATE_LOGIN in NUMBER
296: ) is
297: begin
298: update AMS_LIST_QUERIES_ALL set
299: QUERY_TEMPLATE_ID = X_QUERY_TEMPLATE_ID,
300: OWNER_USER_ID = X_OWNER_USER_ID,
301: QUERY_TYPE = X_QUERY_TYPE,
302: ACT_LIST_QUERY_USED_BY_ID = X_ACT_LIST_QUERY_USED_BY_ID,

Line 357: delete from AMS_LIST_QUERIES_ALL

353: if (sql%notfound) then
354: raise no_data_found;
355: end if;
356:
357: delete from AMS_LIST_QUERIES_ALL
358: where LIST_QUERY_ID = X_LIST_QUERY_ID;
359:
360: if (sql%notfound) then
361: raise no_data_found;

Line 401: FROM AMS_LIST_QUERIES_ALL

397: l_last_updated_by number;
398:
399: CURSOR c_obj_verno IS
400: SELECT object_version_number, last_updated_by
401: FROM AMS_LIST_QUERIES_ALL
402: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
403:
404: CURSOR c_chk_exists is
405: SELECT 'x'

Line 406: FROM AMS_LIST_QUERIES_ALL

402: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
403:
404: CURSOR c_chk_exists is
405: SELECT 'x'
406: FROM AMS_LIST_QUERIES_ALL
407: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
408:
409: CURSOR c_get_id is
410: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL

Line 410: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL

406: FROM AMS_LIST_QUERIES_ALL
407: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
408:
409: CURSOR c_get_id is
410: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL
411: FROM DUAL;
412: BEGIN
413: if X_OWNER = 'SEED' then
414: l_user_id := 1;

Line 516: from AMS_LIST_QUERIES_ALL B

512: begin
513: delete from AMS_LIST_QUERIES_TL T
514: where not exists
515: (select NULL
516: from AMS_LIST_QUERIES_ALL B
517: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
518: );
519:
520: update AMS_LIST_QUERIES_TL T set (