APPS.AMS_QUERY_TEMPLATE_PKG dependencies on AMS_QUERY_TEMPLATE_ALL_S

Line 283: update AMS_QUERY_TEMPLATE_ALL set

279: X_PROGRAM_APPLICATION_ID in NUMBER,
280: X_PROGRAM_UPDATE_DATE in DATE
281: ) is
282: begin
283: update AMS_QUERY_TEMPLATE_ALL set
284: AQE_ID = X_AQE_ID,
285: ENABLED_FLAG = X_ENABLED_FLAG,
286: TEMPLATE_TYPE = X_TEMPLATE_TYPE,
287: IN_USE_FLAG = X_IN_USE_FLAG,

Line 379: SELECT AMS_QUERY_TEMPLATE_ALL_s.NEXTVAL

375: FROM AMS_QUERY_TEMPLATE_ALL
376: WHERE TEMPLATE_ID = X_TEMPLATE_ID;
377:
378: CURSOR c_get_id is
379: SELECT AMS_QUERY_TEMPLATE_ALL_s.NEXTVAL
380: FROM DUAL;
381: BEGIN
382: if X_OWNER = 'SEED' then
383: l_user_id := 1;