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

Line 1: package body WF_ACTIVITIES_PKG as

1: package body WF_ACTIVITIES_PKG as
2: /* $Header: wfactb.pls 120.3 2006/08/24 06:59:16 hgandiko ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ITEM_TYPE in VARCHAR2,

Line 32: cursor C is select ROWID from WF_ACTIVITIES

28: X_RUNNABLE_FLAG in VARCHAR2,
29: X_EVENT_FILTER in VARCHAR2 ,
30: X_EVENT_TYPE in VARCHAR2
31: ) is
32: cursor C is select ROWID from WF_ACTIVITIES
33: where ITEM_TYPE = X_ITEM_TYPE
34: and NAME = X_NAME
35: and VERSION = X_VERSION
36: ;

Line 40: insert into WF_ACTIVITIES (

36: ;
37: old_version number default '';
38: dummy number;
39: begin
40: insert into WF_ACTIVITIES (
41: ITEM_TYPE,
42: NAME,
43: VERSION,
44: TYPE,

Line 100: from WF_ACTIVITIES_VL WA

96: -- Note: Use _VL instead of base table to prevent _tl integrity errors
97: -- from propagating.
98: select max(WA.VERSION)
99: into old_version
100: from WF_ACTIVITIES_VL WA
101: where WA.ITEM_TYPE = X_ITEM_TYPE
102: and WA.NAME = X_NAME
103: and WA.VERSION < X_VERSION;
104:

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 190: from WF_ACTIVITIES NEW, WF_ACTIVITIES OLD,

186: begin
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

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 225: wf_core.context('Wf_Activities_Pkg', 'Insert_Row', x_item_type,

221: close c;
222:
223: exception
224: when others then
225: wf_core.context('Wf_Activities_Pkg', 'Insert_Row', x_item_type,
226: x_name, to_char(x_version));
227: raise;
228: end INSERT_ROW;
229:

Line 270: from WF_ACTIVITIES

266: EXECUTE_ROLE,
267: ICON_NAME,
268: MESSAGE,
269: ERROR_PROCESS
270: from WF_ACTIVITIES
271: where ITEM_TYPE = X_ITEM_TYPE
272: and NAME = X_NAME
273: and VERSION = X_VERSION
274: for update of ITEM_TYPE nowait;

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 348: wf_core.context('Wf_Activities_Pkg', 'Lock_Row', x_item_type,

344: return;
345:
346: exception
347: when others then
348: wf_core.context('Wf_Activities_Pkg', 'Lock_Row', x_item_type,
349: x_name, to_char(x_version));
350: raise;
351: end LOCK_ROW;
352:

Line 377: update WF_ACTIVITIES set

373: X_DISPLAY_NAME in VARCHAR2,
374: X_DESCRIPTION in VARCHAR2
375: ) is
376: begin
377: update WF_ACTIVITIES set
378: TYPE = X_TYPE,
379: RERUN = X_RERUN,
380: EXPAND_ROLE = X_EXPAND_ROLE,
381: PROTECT_LEVEL = X_PROTECT_LEVEL,

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 417: wf_core.context('Wf_Activities_Pkg', 'Update_Row', x_item_type,

413: end if;
414:
415: exception
416: when others then
417: wf_core.context('Wf_Activities_Pkg', 'Update_Row', x_item_type,
418: x_name, to_char(x_version));
419: raise;
420: end UPDATE_ROW;
421:

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 437: delete from WF_ACTIVITIES

433: if (sql%notfound) then
434: raise no_data_found;
435: end if;
436:
437: delete from WF_ACTIVITIES
438: where ITEM_TYPE = X_ITEM_TYPE
439: and NAME = X_NAME
440: and VERSION = X_VERSION;
441:

Line 448: wf_core.context('Wf_Activities_Pkg', 'Delete_Row', x_item_type,

444: end if;
445:
446: exception
447: when others then
448: wf_core.context('Wf_Activities_Pkg', 'Delete_Row', x_item_type,
449: x_name, to_char(x_version));
450: raise;
451: end DELETE_ROW;
452:

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 465: from WF_ACTIVITIES B

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
467: and B.NAME = T.NAME
468: and B.VERSION = T.VERSION
469: );

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;

Line 532: end WF_ACTIVITIES_PKG;

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;