APPS.AMS_QUERY_TEMPLATE_PKG dependencies on AMS_QUERY_TEMPLATE_TL

Line 91: insert into AMS_QUERY_TEMPLATE_TL (

87: X_PROGRAM_APPLICATION_ID,
88: X_PROGRAM_UPDATE_DATE
89: );
90:
91: insert into AMS_QUERY_TEMPLATE_TL (
92: TEMPLATE_ID,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY,
95: CREATION_DATE,

Line 117: from AMS_QUERY_TEMPLATE_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from AMS_QUERY_TEMPLATE_TL T
118: where T.TEMPLATE_ID = X_TEMPLATE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 182: from AMS_QUERY_TEMPLATE_TL

178: cursor c1 is select
179: TEMPLATE_NAME,
180: DESCRIPTION,
181: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
182: from AMS_QUERY_TEMPLATE_TL
183: where TEMPLATE_ID = X_TEMPLATE_ID
184: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
185: for update of TEMPLATE_ID nowait;
186: begin

Line 312: update AMS_QUERY_TEMPLATE_TL set

308: if (sql%notfound) then
309: raise no_data_found;
310: end if;
311:
312: update AMS_QUERY_TEMPLATE_TL set
313: TEMPLATE_NAME = X_TEMPLATE_NAME,
314: DESCRIPTION = X_DESCRIPTION,
315: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
316: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 331: delete from AMS_QUERY_TEMPLATE_TL

327: procedure DELETE_ROW (
328: X_TEMPLATE_ID in NUMBER
329: ) is
330: begin
331: delete from AMS_QUERY_TEMPLATE_TL
332: where TEMPLATE_ID = X_TEMPLATE_ID;
333:
334: if (sql%notfound) then
335: raise no_data_found;

Line 479: delete from AMS_QUERY_TEMPLATE_TL T

475:
476: procedure ADD_LANGUAGE
477: is
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

Line 486: update AMS_QUERY_TEMPLATE_TL T set (

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 (
487: TEMPLATE_NAME,
488: DESCRIPTION
489: ) = (select
490: B.TEMPLATE_NAME,

Line 492: from AMS_QUERY_TEMPLATE_TL B

488: DESCRIPTION
489: ) = (select
490: B.TEMPLATE_NAME,
491: B.DESCRIPTION
492: from AMS_QUERY_TEMPLATE_TL B
493: where B.TEMPLATE_ID = T.TEMPLATE_ID
494: and B.LANGUAGE = T.SOURCE_LANG)
495: where (
496: T.TEMPLATE_ID,

Line 501: from AMS_QUERY_TEMPLATE_TL SUBB, AMS_QUERY_TEMPLATE_TL SUBT

497: T.LANGUAGE
498: ) in (select
499: SUBT.TEMPLATE_ID,
500: SUBT.LANGUAGE
501: from AMS_QUERY_TEMPLATE_TL SUBB, AMS_QUERY_TEMPLATE_TL SUBT
502: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
503: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
504: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
505: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 510: insert into AMS_QUERY_TEMPLATE_TL (

506: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
507: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
508: ));
509:
510: insert into AMS_QUERY_TEMPLATE_TL (
511: TEMPLATE_ID,
512: LAST_UPDATE_DATE,
513: LAST_UPDATED_BY,
514: CREATION_DATE,

Line 532: from AMS_QUERY_TEMPLATE_TL B, FND_LANGUAGES L

528: B.TEMPLATE_NAME,
529: B.DESCRIPTION,
530: L.LANGUAGE_CODE,
531: B.SOURCE_LANG
532: from AMS_QUERY_TEMPLATE_TL B, FND_LANGUAGES L
533: where L.INSTALLED_FLAG in ('I', 'B')
534: and B.LANGUAGE = userenv('LANG')
535: and not exists
536: (select NULL

Line 537: from AMS_QUERY_TEMPLATE_TL T

533: where L.INSTALLED_FLAG in ('I', 'B')
534: and B.LANGUAGE = userenv('LANG')
535: and not exists
536: (select NULL
537: from AMS_QUERY_TEMPLATE_TL T
538: where T.TEMPLATE_ID = B.TEMPLATE_ID
539: and T.LANGUAGE = L.LANGUAGE_CODE);
540: end ADD_LANGUAGE;
541:

Line 553: from AMS_QUERY_TEMPLATE_TL

549: ) is
550:
551: cursor c_last_updated_by is
552: select last_updated_by
553: from AMS_QUERY_TEMPLATE_TL
554: where TEMPLATE_ID = x_TEMPLATE_ID
555: and USERENV('LANG') = LANGUAGE;
556:
557: l_luby number; --last updated by

Line 568: update AMS_QUERY_TEMPLATE_TL set

564:
565: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
566: then
567:
568: update AMS_QUERY_TEMPLATE_TL set
569: TEMPLATE_NAME= nvl(x_TEMPLATE_NAME, TEMPLATE_NAME),
570: description = nvl(x_description, description),
571: source_lang = userenv('LANG'),
572: last_update_date = sysdate,