eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_QUERY_COND_DISP_STRUCT_PKG dependencies on AMS_QUERY_COND_DISP_STRUCT_TL

Line 84: insert into AMS_QUERY_COND_DISP_STRUCT_TL (

80: X_PROGRAM_APPLICATION_ID,
81: X_PROGRAM_UPDATE_DATE
82: );
83:
84: insert into AMS_QUERY_COND_DISP_STRUCT_TL (
85: QUERY_COND_DISP_STRUCT_ID,
86: DISPLAY_TEXT,
87: LAST_UPDATE_DATE,
88: LAST_UPDATED_BY,

Line 108: from AMS_QUERY_COND_DISP_STRUCT_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from AMS_QUERY_COND_DISP_STRUCT_TL T
109: where T.QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID
110: and T.LANGUAGE = L.LANGUAGE_CODE);
111:
112: open c;

Line 166: from AMS_QUERY_COND_DISP_STRUCT_TL

162:
163: cursor c1 is select
164: DISPLAY_TEXT,
165: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
166: from AMS_QUERY_COND_DISP_STRUCT_TL
167: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID
168: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
169: for update of QUERY_COND_DISP_STRUCT_ID nowait;
170: begin

Line 281: update AMS_QUERY_COND_DISP_STRUCT_TL set

277: if (sql%notfound) then
278: raise no_data_found;
279: end if;
280:
281: update AMS_QUERY_COND_DISP_STRUCT_TL set
282: DISPLAY_TEXT = X_DISPLAY_TEXT,
283: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
284: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
285: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 428: delete from AMS_QUERY_COND_DISP_STRUCT_TL

424: procedure DELETE_ROW (
425: X_QUERY_COND_DISP_STRUCT_ID in NUMBER
426: ) is
427: begin
428: delete from AMS_QUERY_COND_DISP_STRUCT_TL
429: where QUERY_COND_DISP_STRUCT_ID = X_QUERY_COND_DISP_STRUCT_ID;
430:
431: if (sql%notfound) then
432: raise no_data_found;

Line 446: delete from AMS_QUERY_COND_DISP_STRUCT_TL T

442:
443: procedure ADD_LANGUAGE
444: is
445: begin
446: delete from AMS_QUERY_COND_DISP_STRUCT_TL T
447: where not exists
448: (select NULL
449: from AMS_QUERY_COND_DISP_STRUCT_ALL B
450: where B.QUERY_COND_DISP_STRUCT_ID = T.QUERY_COND_DISP_STRUCT_ID

Line 453: update AMS_QUERY_COND_DISP_STRUCT_TL T set (

449: from AMS_QUERY_COND_DISP_STRUCT_ALL B
450: where B.QUERY_COND_DISP_STRUCT_ID = T.QUERY_COND_DISP_STRUCT_ID
451: );
452:
453: update AMS_QUERY_COND_DISP_STRUCT_TL T set (
454: DISPLAY_TEXT
455: ) = (select
456: B.DISPLAY_TEXT
457: from AMS_QUERY_COND_DISP_STRUCT_TL B

Line 457: from AMS_QUERY_COND_DISP_STRUCT_TL B

453: update AMS_QUERY_COND_DISP_STRUCT_TL T set (
454: DISPLAY_TEXT
455: ) = (select
456: B.DISPLAY_TEXT
457: from AMS_QUERY_COND_DISP_STRUCT_TL B
458: where B.QUERY_COND_DISP_STRUCT_ID = T.QUERY_COND_DISP_STRUCT_ID
459: and B.LANGUAGE = T.SOURCE_LANG)
460: where (
461: T.QUERY_COND_DISP_STRUCT_ID,

Line 466: from AMS_QUERY_COND_DISP_STRUCT_TL SUBB, AMS_QUERY_COND_DISP_STRUCT_TL SUBT

462: T.LANGUAGE
463: ) in (select
464: SUBT.QUERY_COND_DISP_STRUCT_ID,
465: SUBT.LANGUAGE
466: from AMS_QUERY_COND_DISP_STRUCT_TL SUBB, AMS_QUERY_COND_DISP_STRUCT_TL SUBT
467: where SUBB.QUERY_COND_DISP_STRUCT_ID = SUBT.QUERY_COND_DISP_STRUCT_ID
468: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
469: and (SUBB.DISPLAY_TEXT <> SUBT.DISPLAY_TEXT
470: or (SUBB.DISPLAY_TEXT is null and SUBT.DISPLAY_TEXT is not null)

Line 474: insert into AMS_QUERY_COND_DISP_STRUCT_TL (

470: or (SUBB.DISPLAY_TEXT is null and SUBT.DISPLAY_TEXT is not null)
471: or (SUBB.DISPLAY_TEXT is not null and SUBT.DISPLAY_TEXT is null)
472: ));
473:
474: insert into AMS_QUERY_COND_DISP_STRUCT_TL (
475: QUERY_COND_DISP_STRUCT_ID,
476: DISPLAY_TEXT,
477: LAST_UPDATE_DATE,
478: LAST_UPDATED_BY,

Line 494: from AMS_QUERY_COND_DISP_STRUCT_TL B, FND_LANGUAGES L

490: B.CREATED_BY,
491: B.LAST_UPDATE_LOGIN,
492: L.LANGUAGE_CODE,
493: B.SOURCE_LANG
494: from AMS_QUERY_COND_DISP_STRUCT_TL B, FND_LANGUAGES L
495: where L.INSTALLED_FLAG in ('I', 'B')
496: and B.LANGUAGE = userenv('LANG')
497: and not exists
498: (select NULL

Line 499: from AMS_QUERY_COND_DISP_STRUCT_TL T

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

Line 514: from AMS_QUERY_COND_DISP_STRUCT_TL

510: ) is
511:
512: cursor c_last_updated_by is
513: select last_updated_by
514: from AMS_QUERY_COND_DISP_STRUCT_TL
515: where QUERY_COND_DISP_STRUCT_ID = x_QUERY_COND_DISP_STRUCT_ID
516: and USERENV('LANG') = LANGUAGE;
517:
518: l_luby number; --last updated by

Line 528: update AMS_QUERY_COND_DISP_STRUCT_TL set

524: close c_last_updated_by;
525:
526: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
527: then
528: update AMS_QUERY_COND_DISP_STRUCT_TL set
529: DISPLAY_TEXT = nvl(x_DISPLAY_TEXT, DISPLAY_TEXT),
530: source_lang = userenv('LANG'),
531: last_update_date = sysdate,
532: last_updated_by = decode(x_owner, 'SEED', 1, 'ORACLE', 2, 'SYSADMIN', 0, -1),