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 183: from AMS_LIST_QUERIES_ALL

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

Line 297: update AMS_LIST_QUERIES_ALL set

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

Line 355: delete from AMS_LIST_QUERIES_ALL

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

Line 399: FROM AMS_LIST_QUERIES_ALL

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

Line 404: FROM AMS_LIST_QUERIES_ALL

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

Line 408: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL

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

Line 514: from AMS_LIST_QUERIES_ALL B

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