APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on AMS_LIST_QUERIES_TL

Line 98: insert into AMS_LIST_QUERIES_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into AMS_LIST_QUERIES_TL (
99: CREATION_DATE,
100: CREATED_BY,
101: LAST_UPDATE_LOGIN,
102: NAME,

Line 124: from AMS_LIST_QUERIES_TL T

120: from FND_LANGUAGES L
121: where L.INSTALLED_FLAG in ('I', 'B')
122: and not exists
123: (select NULL
124: from AMS_LIST_QUERIES_TL T
125: where T.LIST_QUERY_ID = X_LIST_QUERY_ID
126: and T.LANGUAGE = L.LANGUAGE_CODE);
127:
128: open c;

Line 193: from AMS_LIST_QUERIES_TL

189: cursor c1 is select
190: NAME,
191: DESCRIPTION,
192: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
193: from AMS_LIST_QUERIES_TL
194: where LIST_QUERY_ID = X_LIST_QUERY_ID
195: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
196: for update of LIST_QUERY_ID nowait;
197: begin

Line 330: update AMS_LIST_QUERIES_TL set

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: update AMS_LIST_QUERIES_TL set
331: NAME = X_NAME,
332: DESCRIPTION = X_DESCRIPTION,
333: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
334: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 350: delete from AMS_LIST_QUERIES_TL

346: procedure DELETE_ROW (
347: X_LIST_QUERY_ID in NUMBER
348: ) is
349: begin
350: delete from AMS_LIST_QUERIES_TL
351: where LIST_QUERY_ID = X_LIST_QUERY_ID;
352:
353: if (sql%notfound) then
354: raise no_data_found;

Line 513: delete from AMS_LIST_QUERIES_TL T

509:
510: procedure ADD_LANGUAGE
511: is
512: begin
513: delete from AMS_LIST_QUERIES_TL T
514: where not exists
515: (select NULL
516: from AMS_LIST_QUERIES_ALL B
517: where B.LIST_QUERY_ID = T.LIST_QUERY_ID

Line 520: update AMS_LIST_QUERIES_TL T set (

516: from AMS_LIST_QUERIES_ALL B
517: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
518: );
519:
520: update AMS_LIST_QUERIES_TL T set (
521: NAME,
522: DESCRIPTION
523: ) = (select
524: B.NAME,

Line 526: from AMS_LIST_QUERIES_TL B

522: DESCRIPTION
523: ) = (select
524: B.NAME,
525: B.DESCRIPTION
526: from AMS_LIST_QUERIES_TL B
527: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
528: and B.LANGUAGE = T.SOURCE_LANG)
529: where (
530: T.LIST_QUERY_ID,

Line 535: from AMS_LIST_QUERIES_TL SUBB, AMS_LIST_QUERIES_TL SUBT

531: T.LANGUAGE
532: ) in (select
533: SUBT.LIST_QUERY_ID,
534: SUBT.LANGUAGE
535: from AMS_LIST_QUERIES_TL SUBB, AMS_LIST_QUERIES_TL SUBT
536: where SUBB.LIST_QUERY_ID = SUBT.LIST_QUERY_ID
537: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
538: and (SUBB.NAME <> SUBT.NAME
539: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 544: insert into AMS_LIST_QUERIES_TL (

540: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
541: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
542: ));
543:
544: insert into AMS_LIST_QUERIES_TL (
545: CREATION_DATE,
546: CREATED_BY,
547: LAST_UPDATE_LOGIN,
548: NAME,

Line 566: from AMS_LIST_QUERIES_TL B, FND_LANGUAGES L

562: B.LAST_UPDATE_DATE,
563: B.LAST_UPDATED_BY,
564: L.LANGUAGE_CODE,
565: B.SOURCE_LANG
566: from AMS_LIST_QUERIES_TL B, FND_LANGUAGES L
567: where L.INSTALLED_FLAG in ('I', 'B')
568: and B.LANGUAGE = userenv('LANG')
569: and not exists
570: (select NULL

Line 571: from AMS_LIST_QUERIES_TL T

567: where L.INSTALLED_FLAG in ('I', 'B')
568: and B.LANGUAGE = userenv('LANG')
569: and not exists
570: (select NULL
571: from AMS_LIST_QUERIES_TL T
572: where T.LIST_QUERY_ID = B.LIST_QUERY_ID
573: and T.LANGUAGE = L.LANGUAGE_CODE);
574: end ADD_LANGUAGE;
575:

Line 586: FROM AMS_LIST_QUERIES_TL

582: ) is
583:
584: cursor c_last_updated_by is
585: select last_updated_by
586: FROM AMS_LIST_QUERIES_TL
587: where LIST_QUERY_ID = x_LIST_QUERY_ID
588: and USERENV('LANG') = LANGUAGE;
589:
590: l_last_updated_by number;

Line 602: update AMS_LIST_QUERIES_TL set

598:
599: if (l_last_updated_by in (1,2,0) OR
600: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
601:
602: update AMS_LIST_QUERIES_TL set
603: NAME= nvl(X_NAME, NAME),
604: DESCRIPTION= nvl(X_DESCRIPTION, DESCRIPTION),
605: source_lang = userenv('LANG'),
606: last_update_date = sysdate,