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_PROCESS_ACTIVITY dependencies on WF_PROCESS_ACTIVITIES

Line 39: -- WF_PROCESS_ACTIVITIES. It assumes there will be exactly 1 row

35: -- Return the instance id for the process activity under the given item
36: -- type. If there is no row found, returns null.
37: -- NOTE
38: -- This function only returns the 'ROOT' row for a process in
39: -- WF_PROCESS_ACTIVITIES. It assumes there will be exactly 1 row
40: -- looking like:
41: -- PROCESS_ITEM_TYPE = itemtype
42: -- PROCESS_NAME = 'ROOT'
43: -- PROCESS_VERSION = version

Line 45: -- for each process in WF_PROCESS_ACTIVITIES.

41: -- PROCESS_ITEM_TYPE = itemtype
42: -- PROCESS_NAME = 'ROOT'
43: -- PROCESS_VERSION = version
44: -- INSTANCE_LABEL = process
45: -- for each process in WF_PROCESS_ACTIVITIES.
46: -- IN
47: -- itemtype - Item type of process
48: -- itemkey - Item key
49: -- process - Process name

Line 70: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A

66: actdate := Wf_Item.Active_Date(itemtype, itemkey);
67:
68: select INSTANCE_ID
69: into instid
70: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
71: where A.ITEM_TYPE = itemtype
72: and A.NAME = 'ROOT'
73: and actdate >= A.BEGIN_DATE
74: and actdate < NVL(A.END_DATE, actdate+1)

Line 123: from WF_PROCESS_ACTIVITIES WPA

119: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
120: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
121: WPA.START_END, WPA.DEFAULT_RESULT
122: into WF_CACHE.ProcessActivities(actid)
123: from WF_PROCESS_ACTIVITIES WPA
124: where WPA.INSTANCE_ID = actid;
125:
126: end if;
127:

Line 174: from WF_PROCESS_ACTIVITIES WPA

170:
171: select
172: WPA.INSTANCE_ID
173: into instid
174: from WF_PROCESS_ACTIVITIES WPA
175: where WPA.INSTANCE_LABEL = StartInstanceId.label
176: and WPA.PROCESS_ITEM_TYPE = StartInstanceId.itemtype
177: and WPA.PROCESS_NAME = StartInstanceId.process
178: and WPA.PROCESS_VERSION = StartInstanceId.version

Line 263: from WF_PROCESS_ACTIVITIES WPA

259:
260: -- Check that activity label passed in matched the current actid
261: select WPA.INSTANCE_ID
262: into instid
263: from WF_PROCESS_ACTIVITIES WPA
264: where WPA.INSTANCE_LABEL = activeinstanceid.label
265: and WPA.PROCESS_NAME = nvl(activeinstanceid.process, WPA.PROCESS_NAME)
266: and WPA.INSTANCE_ID = activeinstanceid.cur_actid;
267: else

Line 271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

267: else
268: -- NORMAL mode
269: select WPA.INSTANCE_ID
270: into instid
271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
272: where WIAS.ITEM_TYPE = activeinstanceid.itemtype
273: and WIAS.ITEM_KEY = activeinstanceid.itemkey
274: and WIAS.ACTIVITY_STATUS = nvl(activeinstanceid.status,
275: WIAS.ACTIVITY_STATUS)

Line 324: from WF_PROCESS_ACTIVITIES WPA1,

320: return boolean
321: is
322: cursor curs(parentid in pls_integer, actdate in date) is
323: select WPA2.INSTANCE_ID, WPA2.ACTIVITY_ITEM_TYPE, WPA2.ACTIVITY_NAME
324: from WF_PROCESS_ACTIVITIES WPA1,
325: WF_ACTIVITIES WA,
326: WF_PROCESS_ACTIVITIES WPA2
327: where WPA1.INSTANCE_ID = parentid
328: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE

Line 326: WF_PROCESS_ACTIVITIES WPA2

322: cursor curs(parentid in pls_integer, actdate in date) is
323: select WPA2.INSTANCE_ID, WPA2.ACTIVITY_ITEM_TYPE, WPA2.ACTIVITY_NAME
324: from WF_PROCESS_ACTIVITIES WPA1,
325: WF_ACTIVITIES WA,
326: WF_PROCESS_ACTIVITIES WPA2
327: where WPA1.INSTANCE_ID = parentid
328: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
329: and WPA2.PROCESS_NAME = WA.NAME
330: and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE

Line 387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

383: WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
384: WF_CACHE.ProcessActivities(rootid).START_END,
385: WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT
386:
387: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
388:
389: where WPA.INSTANCE_ID = rootid
390: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
391: and WA.NAME = WPA.ACTIVITY_NAME

Line 419: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

415: -- Get root id for the error process
416: begin
417: select WPA.INSTANCE_ID
418: into errid
419: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
420: where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE
421: and WPA.PROCESS_NAME = 'ROOT'
422: and WPA.PROCESS_VERSION = WA.VERSION
423: and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE

Line 513: from WF_PROCESS_ACTIVITIES WPA1,

509: status PLS_INTEGER;
510:
511: cursor curs(parentid in pls_integer, actdate in date) is
512: select WPA2.PROCESS_NAME, WPA2.INSTANCE_ID, WPA2.INSTANCE_LABEL
513: from WF_PROCESS_ACTIVITIES WPA1,
514: WF_ACTIVITIES WA,
515: WF_PROCESS_ACTIVITIES WPA2
516: where WPA1.INSTANCE_ID = parentid
517: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE

Line 515: WF_PROCESS_ACTIVITIES WPA2

511: cursor curs(parentid in pls_integer, actdate in date) is
512: select WPA2.PROCESS_NAME, WPA2.INSTANCE_ID, WPA2.INSTANCE_LABEL
513: from WF_PROCESS_ACTIVITIES WPA1,
514: WF_ACTIVITIES WA,
515: WF_PROCESS_ACTIVITIES WPA2
516: where WPA1.INSTANCE_ID = parentid
517: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
518: and WPA2.PROCESS_NAME = WA.NAME
519: and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE

Line 553: from WF_PROCESS_ACTIVITIES WPA

549: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
550: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
551: WPA.START_END, WPA.DEFAULT_RESULT
552: into WF_CACHE.ProcessActivities(parentid)
553: from WF_PROCESS_ACTIVITIES WPA
554: where WPA.INSTANCE_ID = parentid;
555:
556: end if;
557: