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

Line 1: package body WF_ACTIVITY_ATTRIBUTES_PKG as

1: package body WF_ACTIVITY_ATTRIBUTES_PKG as
2: /* $Header: wfacab.pls 120.2 2005/07/02 03:41:27 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ACTIVITY_ITEM_TYPE in VARCHAR2,

Line 22: cursor C is select ROWID from WF_ACTIVITY_ATTRIBUTES

18: X_DATE_DEFAULT in DATE,
19: X_DISPLAY_NAME in VARCHAR2,
20: X_DESCRIPTION in VARCHAR2
21: ) is
22: cursor C is select ROWID from WF_ACTIVITY_ATTRIBUTES
23: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
24: and ACTIVITY_NAME = X_ACTIVITY_NAME
25: and ACTIVITY_VERSION = X_ACTIVITY_VERSION
26: and NAME = X_NAME

Line 30: insert into WF_ACTIVITY_ATTRIBUTES (

26: and NAME = X_NAME
27: ;
28: old_version number default '';
29: begin
30: insert into WF_ACTIVITY_ATTRIBUTES (
31: ACTIVITY_ITEM_TYPE,
32: ACTIVITY_NAME,
33: ACTIVITY_VERSION,
34: NAME,

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 169: wf_core.context('Wf_Activity_Attributes_Pkg', 'Insert_Row',

165: close c;
166:
167: exception
168: when others then
169: wf_core.context('Wf_Activity_Attributes_Pkg', 'Insert_Row',
170: x_activity_item_type, x_activity_name, to_char(x_activity_version),
171: x_name);
172: raise;
173: end INSERT_ROW;

Line 204: from WF_ACTIVITY_ATTRIBUTES

200: FORMAT,
201: TEXT_DEFAULT,
202: NUMBER_DEFAULT,
203: DATE_DEFAULT
204: from WF_ACTIVITY_ATTRIBUTES
205: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
206: and ACTIVITY_NAME = X_ACTIVITY_NAME
207: and ACTIVITY_VERSION = X_ACTIVITY_VERSION
208: and 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 273: wf_core.context('Wf_Activity_Attributes_Pkg', 'Lock_Row',

269: return;
270:
271: exception
272: when others then
273: wf_core.context('Wf_Activity_Attributes_Pkg', 'Lock_Row',
274: x_activity_item_type, x_activity_name, to_char(x_activity_version),
275: x_name);
276: raise;
277: end LOCK_ROW;

Line 298: update WF_ACTIVITY_ATTRIBUTES set

294: X_DISPLAY_NAME in VARCHAR2,
295: X_DESCRIPTION in VARCHAR2
296: ) is
297: begin
298: update WF_ACTIVITY_ATTRIBUTES set
299: SEQUENCE = X_SEQUENCE,
300: TYPE = X_TYPE,
301: VALUE_TYPE = X_VALUE_TYPE,
302: PROTECT_LEVEL = X_PROTECT_LEVEL,

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 334: wf_core.context('Wf_Activity_Attributes_Pkg', 'Update_Row',

330: end if;
331:
332: exception
333: when others then
334: wf_core.context('Wf_Activity_Attributes_Pkg', 'Update_Row',
335: x_activity_item_type, x_activity_name, to_char(x_activity_version),
336: x_name);
337: raise;
338: end UPDATE_ROW;

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 357: delete from WF_ACTIVITY_ATTRIBUTES

353: if (sql%notfound) then
354: raise no_data_found;
355: end if;
356:
357: delete from WF_ACTIVITY_ATTRIBUTES
358: where ACTIVITY_ITEM_TYPE = X_ACTIVITY_ITEM_TYPE
359: and ACTIVITY_NAME = X_ACTIVITY_NAME
360: and ACTIVITY_VERSION = X_ACTIVITY_VERSION
361: and NAME = X_NAME;

Line 369: wf_core.context('Wf_Activity_Attributes_Pkg', 'Delete_Row',

365: end if;
366:
367: exception
368: when others then
369: wf_core.context('Wf_Activity_Attributes_Pkg', 'Delete_Row',
370: x_activity_item_type, x_activity_name, to_char(x_activity_version),
371: x_name);
372: raise;
373: end DELETE_ROW;

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 387: from WF_ACTIVITY_ATTRIBUTES B

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
389: and B.ACTIVITY_NAME = T.ACTIVITY_NAME
390: and B.ACTIVITY_VERSION = T.ACTIVITY_VERSION
391: and B.NAME = T.NAME

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;

Line 462: end WF_ACTIVITY_ATTRIBUTES_PKG;

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;