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.WF_ACTIVITIES_PKG dependencies on WF_ACTIVITIES_TL

Line 106: insert into WF_ACTIVITIES_TL (

102: and WA.NAME = X_NAME
103: and WA.VERSION < X_VERSION;
104:
105: if (old_version is not null) then
106: insert into WF_ACTIVITIES_TL (
107: ITEM_TYPE,
108: NAME,
109: VERSION,
110: DISPLAY_NAME,

Line 132: from WF_LANGUAGES L, WF_ACTIVITIES_TL OLD

128: L.CODE,
129: decode(L.CODE,
130: userenv('LANG'), L.CODE,
131: OLD.SOURCE_LANG)
132: from WF_LANGUAGES L, WF_ACTIVITIES_TL OLD
133: where L.INSTALLED_FLAG = 'Y'
134: and OLD.ITEM_TYPE = X_ITEM_TYPE
135: and OLD.NAME = X_NAME
136: and OLD.VERSION = old_version

Line 140: from WF_ACTIVITIES_TL T

136: and OLD.VERSION = old_version
137: and OLD.LANGUAGE = L.CODE
138: and not exists
139: (select NULL
140: from WF_ACTIVITIES_TL T
141: where T.ITEM_TYPE = X_ITEM_TYPE
142: and T.NAME = X_NAME
143: and T.VERSION = X_VERSION
144: and T.LANGUAGE = L.CODE);

Line 148: insert into WF_ACTIVITIES_TL (

144: and T.LANGUAGE = L.CODE);
145: else
146: -- No other versions, default translations for all languages from
147: -- the current language.
148: insert into WF_ACTIVITIES_TL (
149: ITEM_TYPE,
150: NAME,
151: VERSION,
152: DISPLAY_NAME,

Line 172: from WF_ACTIVITIES_TL T

168: from WF_LANGUAGES L
169: where L.INSTALLED_FLAG = 'Y'
170: and not exists
171: (select NULL
172: from WF_ACTIVITIES_TL T
173: where T.ITEM_TYPE = X_ITEM_TYPE
174: and T.NAME = X_NAME
175: and T.VERSION = X_VERSION
176: and T.LANGUAGE = L.CODE);

Line 184: -- It is not sufficient to rely on WF_ACTIVITIES_TL_U2 unique index,

180: -- *** VERSION CUSTOMIZATION
181: -- Check rows just inserted for duplicate display_names among activities
182: -- within this itemtype over all versions active during the time
183: -- range of the version being added.
184: -- It is not sufficient to rely on WF_ACTIVITIES_TL_U2 unique index,
185: -- because versions may mask some duplicates.
186: begin
187: select /*+ leading(NEW,NEWTL,OLDTL,OLD) use_nl(NEWTL,OLDTL,OLD) */
188: OLD.NAME||':'||OLDTL.LANGUAGE||':'||OLDTL.DISPLAY_NAME

Line 191: WF_ACTIVITIES_TL NEWTL, WF_ACTIVITIES_TL OLDTL

187: select /*+ leading(NEW,NEWTL,OLDTL,OLD) use_nl(NEWTL,OLDTL,OLD) */
188: OLD.NAME||':'||OLDTL.LANGUAGE||':'||OLDTL.DISPLAY_NAME
189: into Wf_Load.logbuf
190: from WF_ACTIVITIES NEW, WF_ACTIVITIES OLD,
191: WF_ACTIVITIES_TL NEWTL, WF_ACTIVITIES_TL OLDTL
192: where NEW.ITEM_TYPE = NEWTL.ITEM_TYPE
193: and NEW.NAME = NEWTL.NAME
194: and NEW.VERSION = NEWTL.VERSION
195: and OLD.ITEM_TYPE = OLDTL.ITEM_TYPE

Line 280: from WF_ACTIVITIES_TL

276:
277: cursor c1 is select
278: DISPLAY_NAME,
279: DESCRIPTION
280: from WF_ACTIVITIES_TL
281: where ITEM_TYPE = X_ITEM_TYPE
282: and NAME = X_NAME
283: and VERSION = X_VERSION
284: and LANGUAGE = userenv('LANG')

Line 402: update WF_ACTIVITIES_TL set

398: if (sql%notfound) then
399: raise no_data_found;
400: end if;
401:
402: update WF_ACTIVITIES_TL set
403: DISPLAY_NAME = X_DISPLAY_NAME,
404: DESCRIPTION = X_DESCRIPTION,
405: SOURCE_LANG = userenv('LANG')
406: where ITEM_TYPE = X_ITEM_TYPE

Line 428: delete from WF_ACTIVITIES_TL

424: X_NAME in VARCHAR2,
425: X_VERSION in NUMBER
426: ) is
427: begin
428: delete from WF_ACTIVITIES_TL
429: where ITEM_TYPE = X_ITEM_TYPE
430: and NAME = X_NAME
431: and VERSION = X_VERSION;
432:

Line 462: delete from WF_ACTIVITIES_TL T

458: /* as a quick workaround to fix the time-consuming table handler issue */
459: /* Eventually we'll need to turn them into a separate fix_language procedure */
460: /*
461:
462: delete from WF_ACTIVITIES_TL T
463: where not exists
464: (select NULL
465: from WF_ACTIVITIES B
466: where B.ITEM_TYPE = T.ITEM_TYPE

Line 471: update WF_ACTIVITIES_TL T set (

467: and B.NAME = T.NAME
468: and B.VERSION = T.VERSION
469: );
470:
471: update WF_ACTIVITIES_TL T set (
472: DISPLAY_NAME,
473: DESCRIPTION
474: ) = (select
475: B.DISPLAY_NAME,

Line 477: from WF_ACTIVITIES_TL B

473: DESCRIPTION
474: ) = (select
475: B.DISPLAY_NAME,
476: B.DESCRIPTION
477: from WF_ACTIVITIES_TL B
478: where B.ITEM_TYPE = T.ITEM_TYPE
479: and B.NAME = T.NAME
480: and B.VERSION = T.VERSION
481: and B.LANGUAGE = T.SOURCE_LANG)

Line 492: from WF_ACTIVITIES_TL SUBB, WF_ACTIVITIES_TL SUBT

488: SUBT.ITEM_TYPE,
489: SUBT.NAME,
490: SUBT.VERSION,
491: SUBT.LANGUAGE
492: from WF_ACTIVITIES_TL SUBB, WF_ACTIVITIES_TL SUBT
493: where SUBB.ITEM_TYPE = SUBT.ITEM_TYPE
494: and SUBB.NAME = SUBT.NAME
495: and SUBB.VERSION = SUBT.VERSION
496: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 504: insert /+ append parallel / into WF_ACTIVITIES_TL (

500: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
501: ));
502: */
503:
504: insert /*+ append parallel */ into WF_ACTIVITIES_TL (
505: ITEM_TYPE,
506: NAME,
507: VERSION,
508: DISPLAY_NAME,

Line 524: from WF_ACTIVITIES_TL B, WF_LANGUAGES L

520: B.CUSTOM_LEVEL,
521: B.DESCRIPTION,
522: L.CODE,
523: B.SOURCE_LANG
524: from WF_ACTIVITIES_TL B, WF_LANGUAGES L
525: where L.INSTALLED_FLAG = 'Y'
526: and B.LANGUAGE = userenv('LANG')
527: and (B.ITEM_TYPE , b.name, B.VERSION , l.code) NOT IN
528: (select /*+ hash_aj index_ffs(T,WF_ACTIVITIES_TL_PK) */

Line 528: (select /+ hash_aj index_ffs(T,WF_ACTIVITIES_TL_PK) /

524: from WF_ACTIVITIES_TL B, WF_LANGUAGES L
525: where L.INSTALLED_FLAG = 'Y'
526: and B.LANGUAGE = userenv('LANG')
527: and (B.ITEM_TYPE , b.name, B.VERSION , l.code) NOT IN
528: (select /*+ hash_aj index_ffs(T,WF_ACTIVITIES_TL_PK) */
529: T.ITEM_TYPE , T.NAME , T.VERSION ,T.LANGUAGE from WF_ACTIVITIES_TL T );
530: end ADD_LANGUAGE;
531:
532: end WF_ACTIVITIES_PKG;

Line 529: T.ITEM_TYPE , T.NAME , T.VERSION ,T.LANGUAGE from WF_ACTIVITIES_TL T );

525: where L.INSTALLED_FLAG = 'Y'
526: and B.LANGUAGE = userenv('LANG')
527: and (B.ITEM_TYPE , b.name, B.VERSION , l.code) NOT IN
528: (select /*+ hash_aj index_ffs(T,WF_ACTIVITIES_TL_PK) */
529: T.ITEM_TYPE , T.NAME , T.VERSION ,T.LANGUAGE from WF_ACTIVITIES_TL T );
530: end ADD_LANGUAGE;
531:
532: end WF_ACTIVITIES_PKG;