APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on AMS_LIST_QUERIES_ALL_S

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 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;