APPS.AMS_QUERY_TEMPLATE_PKG dependencies on AMS_QUERY_TEMPLATE_ALL

Line 33: cursor C is select ROWID from AMS_QUERY_TEMPLATE_ALL

29: X_PROGRAM_ID in NUMBER,
30: X_PROGRAM_APPLICATION_ID in NUMBER,
31: X_PROGRAM_UPDATE_DATE in DATE
32: ) is
33: cursor C is select ROWID from AMS_QUERY_TEMPLATE_ALL
34: where TEMPLATE_ID = X_TEMPLATE_ID
35: ;
36: begin
37: insert into AMS_QUERY_TEMPLATE_ALL (

Line 37: insert into AMS_QUERY_TEMPLATE_ALL (

33: cursor C is select ROWID from AMS_QUERY_TEMPLATE_ALL
34: where TEMPLATE_ID = X_TEMPLATE_ID
35: ;
36: begin
37: insert into AMS_QUERY_TEMPLATE_ALL (
38: AQE_ID,
39: ENABLED_FLAG,
40: TEMPLATE_TYPE,
41: IN_USE_FLAG,

Line 173: from AMS_QUERY_TEMPLATE_ALL

169: OBJECT_VERSION_NUMBER,
170: REQUEST_ID,
171: VIEW_APPLICATION_ID,
172: SEEDED_FLAG
173: from AMS_QUERY_TEMPLATE_ALL
174: where TEMPLATE_ID = X_TEMPLATE_ID
175: for update of TEMPLATE_ID nowait;
176: recinfo c%rowtype;
177:

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 338: delete from AMS_QUERY_TEMPLATE_ALL

334: if (sql%notfound) then
335: raise no_data_found;
336: end if;
337:
338: delete from AMS_QUERY_TEMPLATE_ALL
339: where TEMPLATE_ID = X_TEMPLATE_ID;
340:
341: if (sql%notfound) then
342: raise no_data_found;

Line 370: FROM AMS_QUERY_TEMPLATE_ALL

366: l_db_luby_id number;
367:
368: CURSOR c_obj_verno IS
369: SELECT object_version_number, last_updated_by
370: FROM AMS_QUERY_TEMPLATE_ALL
371: WHERE template_id = X_TEMPLATE_ID;
372:
373: CURSOR c_chk_exists is
374: SELECT 'x'

Line 375: FROM AMS_QUERY_TEMPLATE_ALL

371: WHERE template_id = X_TEMPLATE_ID;
372:
373: CURSOR c_chk_exists is
374: SELECT 'x'
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

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;

Line 482: from AMS_QUERY_TEMPLATE_ALL B

478: begin
479: delete from AMS_QUERY_TEMPLATE_TL T
480: where not exists
481: (select NULL
482: from AMS_QUERY_TEMPLATE_ALL B
483: where B.TEMPLATE_ID = T.TEMPLATE_ID
484: );
485:
486: update AMS_QUERY_TEMPLATE_TL T set (