APPS.AMS_LIST_QUERIES_PKG dependencies on AMS_LIST_QUERIES_TL

Line 125: insert into AMS_LIST_QUERIES_TL (

121: DECODE( p_parent_list_query_id, FND_API.g_miss_num, NULL, p_parent_list_query_id),
122: DECODE( p_sequence_order, FND_API.g_miss_num, NULL, p_sequence_order));
123:
124:
125: insert into AMS_LIST_QUERIES_TL (
126: LANGUAGE,
127: SOURCE_LANG,
128: NAME,
129: DESCRIPTION,

Line 151: from AMS_LIST_QUERIES_TL T

147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from AMS_LIST_QUERIES_TL T
152: where T.list_query_id = px_list_query_id
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: END Insert_Row;

Line 439: delete from AMS_LIST_QUERIES_TL T

435: --added for bug 5086232
436: procedure ADD_LANGUAGE
437: is
438: begin
439: delete from AMS_LIST_QUERIES_TL T
440: where not exists
441: (select NULL
442: from AMS_LIST_QUERIES_ALL B
443: where B.LIST_QUERY_ID = T.LIST_QUERY_ID

Line 446: update AMS_LIST_QUERIES_TL T set (

442: from AMS_LIST_QUERIES_ALL B
443: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
444: );
445:
446: update AMS_LIST_QUERIES_TL T set (
447: NAME,
448: DESCRIPTION
449: ) = (select
450: B.NAME,

Line 452: from AMS_LIST_QUERIES_TL B

448: DESCRIPTION
449: ) = (select
450: B.NAME,
451: B.DESCRIPTION
452: from AMS_LIST_QUERIES_TL B
453: where B.LIST_QUERY_ID = T.LIST_QUERY_ID
454: and B.LANGUAGE = T.SOURCE_LANG)
455: where (
456: T.LIST_QUERY_ID,

Line 461: from AMS_LIST_QUERIES_TL SUBB, AMS_LIST_QUERIES_TL SUBT

457: T.LANGUAGE
458: ) in (select
459: SUBT.LIST_QUERY_ID,
460: SUBT.LANGUAGE
461: from AMS_LIST_QUERIES_TL SUBB, AMS_LIST_QUERIES_TL SUBT
462: where SUBB.LIST_QUERY_ID = SUBT.LIST_QUERY_ID
463: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
464: and (SUBB.NAME <> SUBT.NAME
465: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 470: insert into AMS_LIST_QUERIES_TL (

466: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
467: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
468: ));
469:
470: insert into AMS_LIST_QUERIES_TL (
471: CREATION_DATE,
472: CREATED_BY,
473: LAST_UPDATE_LOGIN,
474: NAME,

Line 492: from AMS_LIST_QUERIES_TL B, FND_LANGUAGES L

488: B.LAST_UPDATE_DATE,
489: B.LAST_UPDATED_BY,
490: L.LANGUAGE_CODE,
491: B.SOURCE_LANG
492: from AMS_LIST_QUERIES_TL B, FND_LANGUAGES L
493: where L.INSTALLED_FLAG in ('I', 'B')
494: and B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL

Line 497: from AMS_LIST_QUERIES_TL T

493: where L.INSTALLED_FLAG in ('I', 'B')
494: and B.LANGUAGE = userenv('LANG')
495: and not exists
496: (select NULL
497: from AMS_LIST_QUERIES_TL T
498: where T.LIST_QUERY_ID = B.LIST_QUERY_ID
499: and T.LANGUAGE = L.LANGUAGE_CODE);
500: end ADD_LANGUAGE;
501:

Line 511: FROM AMS_LIST_QUERIES_TL

507: ) is
508:
509: cursor c_last_updated_by is
510: select last_updated_by
511: FROM AMS_LIST_QUERIES_TL
512: where LIST_QUERY_ID = p_list_query_id
513: and USERENV('LANG') = LANGUAGE;
514:
515: l_last_updated_by number;

Line 526: update ams_list_queries_tl

522: close c_last_updated_by;
523:
524: if (l_last_updated_by in (1,2,0) OR
525: NVL(p_custom_mode,'PRESERVE')='FORCE') THEN
526: update ams_list_queries_tl
527: set name= nvl(p_name, name),
528: source_lang = userenv('LANG'),
529: last_update_date = sysdate,
530: last_updated_by = decode(p_owner, 'SEED', 1, 'ORACLE',2, 'SYSADMIN',0, -1),