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_ACTIVITY_ATTRIBUTES_PKG dependencies on WF_ACTIVITY_ATTRIBUTES_TL

Line 70: from WF_ACTIVITY_ATTRIBUTES_TL WAA

66: -- Note: Use _VL instead of base table to prevent _tl integrity errors
67: -- from propagating.
68: select max(WAA.ACTIVITY_VERSION)
69: into old_version
70: from WF_ACTIVITY_ATTRIBUTES_TL WAA
71: where WAA.NAME = X_NAME
72: and WAA.ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
73: and WAA.ACTIVITY_NAME = X_ACTIVITY_NAME
74: and WAA.ACTIVITY_VERSION < X_ACTIVITY_VERSION;

Line 78: insert into WF_ACTIVITY_ATTRIBUTES_TL (

74: and WAA.ACTIVITY_VERSION < X_ACTIVITY_VERSION;
75:
76: if (old_version is not null) then
77:
78: insert into WF_ACTIVITY_ATTRIBUTES_TL (
79: ACTIVITY_ITEM_TYPE,
80: ACTIVITY_NAME,
81: ACTIVITY_VERSION,
82: NAME,

Line 106: from WF_LANGUAGES L, WF_ACTIVITY_ATTRIBUTES_TL OLD

102: L.CODE,
103: decode(L.CODE,
104: userenv('LANG'), L.CODE,
105: OLD.SOURCE_LANG)
106: from WF_LANGUAGES L, WF_ACTIVITY_ATTRIBUTES_TL OLD
107: where L.INSTALLED_FLAG = 'Y'
108: and OLD.ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
109: and OLD.ACTIVITY_NAME = X_ACTIVITY_NAME
110: and OLD.ACTIVITY_VERSION = old_version

Line 115: from WF_ACTIVITY_ATTRIBUTES_TL T

111: and OLD.NAME = X_NAME
112: and OLD.LANGUAGE = L.CODE
113: and not exists
114: (select NULL
115: from WF_ACTIVITY_ATTRIBUTES_TL T
116: where T.ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
117: and T.ACTIVITY_NAME = X_ACTIVITY_NAME
118: and T.ACTIVITY_VERSION = X_ACTIVITY_VERSION
119: and T.NAME = X_NAME

Line 124: insert into WF_ACTIVITY_ATTRIBUTES_TL (

120: and T.LANGUAGE = L.CODE);
121:
122: else
123:
124: insert into WF_ACTIVITY_ATTRIBUTES_TL (
125: ACTIVITY_ITEM_TYPE,
126: ACTIVITY_NAME,
127: ACTIVITY_VERSION,
128: NAME,

Line 150: from WF_ACTIVITY_ATTRIBUTES_TL T

146: from WF_LANGUAGES L
147: where L.INSTALLED_FLAG = 'Y'
148: and not exists
149: (select NULL
150: from WF_ACTIVITY_ATTRIBUTES_TL T
151: where T.ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
152: and T.ACTIVITY_NAME = X_ACTIVITY_NAME
153: and T.ACTIVITY_VERSION = X_ACTIVITY_VERSION
154: and T.NAME = X_NAME

Line 215: from WF_ACTIVITY_ATTRIBUTES_TL

211:
212: cursor c1 is select
213: DISPLAY_NAME,
214: DESCRIPTION
215: from WF_ACTIVITY_ATTRIBUTES_TL
216: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
217: and ACTIVITY_NAME = X_ACTIVITY_NAME
218: and ACTIVITY_VERSION = X_ACTIVITY_VERSION
219: and NAME = X_NAME

Line 318: update WF_ACTIVITY_ATTRIBUTES_TL set

314: if (sql%notfound) then
315: raise no_data_found;
316: end if;
317:
318: update WF_ACTIVITY_ATTRIBUTES_TL set
319: DISPLAY_NAME = X_DISPLAY_NAME,
320: DESCRIPTION = X_DESCRIPTION,
321: SOURCE_LANG = userenv('LANG')
322: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE

Line 347: delete from WF_ACTIVITY_ATTRIBUTES_TL

343: X_ACTIVITY_VERSION in NUMBER,
344: X_NAME in VARCHAR2
345: ) is
346: begin
347: delete from WF_ACTIVITY_ATTRIBUTES_TL
348: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
349: and ACTIVITY_NAME = X_ACTIVITY_NAME
350: and ACTIVITY_VERSION = X_ACTIVITY_VERSION
351: and NAME = X_NAME;

Line 384: delete from WF_ACTIVITY_ATTRIBUTES_TL T

380: /* as a quick workaround to fix the time-consuming table handler issue */
381: /* Eventually we'll need to turn them into a separate fix_language procedure */
382: /*
383:
384: delete from WF_ACTIVITY_ATTRIBUTES_TL T
385: where not exists
386: (select NULL
387: from WF_ACTIVITY_ATTRIBUTES B
388: where B.ACTIVITY_ITEM_TYPE = T.ACTIVITY_ITEM_TYPE

Line 394: update WF_ACTIVITY_ATTRIBUTES_TL T set (

390: and B.ACTIVITY_VERSION = T.ACTIVITY_VERSION
391: and B.NAME = T.NAME
392: );
393:
394: update WF_ACTIVITY_ATTRIBUTES_TL T set (
395: DISPLAY_NAME,
396: DESCRIPTION
397: ) = (select
398: B.DISPLAY_NAME,

Line 400: from WF_ACTIVITY_ATTRIBUTES_TL B

396: DESCRIPTION
397: ) = (select
398: B.DISPLAY_NAME,
399: B.DESCRIPTION
400: from WF_ACTIVITY_ATTRIBUTES_TL B
401: where B.ACTIVITY_ITEM_TYPE = T.ACTIVITY_ITEM_TYPE
402: and B.ACTIVITY_NAME = T.ACTIVITY_NAME
403: and B.ACTIVITY_VERSION = T.ACTIVITY_VERSION
404: and B.NAME = T.NAME

Line 418: from WF_ACTIVITY_ATTRIBUTES_TL SUBB, WF_ACTIVITY_ATTRIBUTES_TL SUBT

414: SUBT.ACTIVITY_NAME,
415: SUBT.ACTIVITY_VERSION,
416: SUBT.NAME,
417: SUBT.LANGUAGE
418: from WF_ACTIVITY_ATTRIBUTES_TL SUBB, WF_ACTIVITY_ATTRIBUTES_TL SUBT
419: where SUBB.ACTIVITY_ITEM_TYPE = SUBT.ACTIVITY_ITEM_TYPE
420: and SUBB.ACTIVITY_NAME = SUBT.ACTIVITY_NAME
421: and SUBB.ACTIVITY_VERSION = SUBT.ACTIVITY_VERSION
422: and SUBB.NAME = SUBT.NAME

Line 431: insert /+ append parallel / into WF_ACTIVITY_ATTRIBUTES_TL (

427: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
428: ));
429: */
430:
431: insert /*+ append parallel */ into WF_ACTIVITY_ATTRIBUTES_TL (
432: ACTIVITY_ITEM_TYPE,
433: ACTIVITY_NAME,
434: ACTIVITY_VERSION,
435: NAME,

Line 453: from WF_ACTIVITY_ATTRIBUTES_TL B, WF_LANGUAGES L

449: B.CUSTOM_LEVEL,
450: B.DESCRIPTION,
451: L.CODE,
452: B.SOURCE_LANG
453: from WF_ACTIVITY_ATTRIBUTES_TL B, WF_LANGUAGES L
454: where L.INSTALLED_FLAG = 'Y'
455: and B.LANGUAGE = userenv('LANG')
456: and (B.ACTIVITY_ITEM_TYPE, B.ACTIVITY_NAME, B.ACTIVITY_VERSION , B.NAME,
457: L.CODE) NOT IN

Line 458: (select /+ hash_aj index_ffs(T,WF_ACTIVITY_ATTRIBUTES_TL_PK) /

454: where L.INSTALLED_FLAG = 'Y'
455: and B.LANGUAGE = userenv('LANG')
456: and (B.ACTIVITY_ITEM_TYPE, B.ACTIVITY_NAME, B.ACTIVITY_VERSION , B.NAME,
457: L.CODE) NOT IN
458: (select /*+ hash_aj index_ffs(T,WF_ACTIVITY_ATTRIBUTES_TL_PK) */
459: T.ACTIVITY_ITEM_TYPE ,T.ACTIVITY_NAME ,T.ACTIVITY_VERSION , T.NAME , T.LANGUAGE from WF_ACTIVITY_ATTRIBUTES_TL T );
460: end ADD_LANGUAGE;
461:
462: end WF_ACTIVITY_ATTRIBUTES_PKG;

Line 459: T.ACTIVITY_ITEM_TYPE ,T.ACTIVITY_NAME ,T.ACTIVITY_VERSION , T.NAME , T.LANGUAGE from WF_ACTIVITY_ATTRIBUTES_TL T );

455: and B.LANGUAGE = userenv('LANG')
456: and (B.ACTIVITY_ITEM_TYPE, B.ACTIVITY_NAME, B.ACTIVITY_VERSION , B.NAME,
457: L.CODE) NOT IN
458: (select /*+ hash_aj index_ffs(T,WF_ACTIVITY_ATTRIBUTES_TL_PK) */
459: T.ACTIVITY_ITEM_TYPE ,T.ACTIVITY_NAME ,T.ACTIVITY_VERSION , T.NAME , T.LANGUAGE from WF_ACTIVITY_ATTRIBUTES_TL T );
460: end ADD_LANGUAGE;
461:
462: end WF_ACTIVITY_ATTRIBUTES_PKG;