APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on AMS_LIST_QUERIES_TL

Line 97: insert into AMS_LIST_QUERIES_TL (

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

Line 123: from AMS_LIST_QUERIES_TL T

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

Line 192: from AMS_LIST_QUERIES_TL

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

Line 328: update AMS_LIST_QUERIES_TL set

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

Line 348: delete from AMS_LIST_QUERIES_TL

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

Line 511: delete from AMS_LIST_QUERIES_TL T

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

Line 518: update AMS_LIST_QUERIES_TL T set (

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

Line 524: from AMS_LIST_QUERIES_TL B

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

Line 533: from AMS_LIST_QUERIES_TL SUBB, AMS_LIST_QUERIES_TL SUBT

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

Line 542: insert into AMS_LIST_QUERIES_TL (

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

Line 564: from AMS_LIST_QUERIES_TL B, FND_LANGUAGES L

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

Line 569: from AMS_LIST_QUERIES_TL T

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

Line 584: FROM AMS_LIST_QUERIES_TL

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

Line 600: update AMS_LIST_QUERIES_TL set

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