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

Line 185: from WF_PROCESS_ACTIVITIES WPA

181: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
182: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
183: WPA.START_END, WPA.DEFAULT_RESULT
184: into WF_CACHE.ProcessActivities(activity_parent_process.actid)
185: from WF_PROCESS_ACTIVITIES WPA
186: where WPA.INSTANCE_ID = activity_parent_process.actid;
187:
188: end if;
189:

Line 237: WF_PROCESS_ACTIVITIES WPA

233: SELECT /*+ leading(wias) index(wias,WF_ITEM_ACTIVITY_STATUSES_PK) */
234: WPA.INSTANCE_ID
235: INTO parentid
236: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
237: WF_PROCESS_ACTIVITIES WPA
238: WHERE WPA.ACTIVITY_ITEM_TYPE =
239: WF_CACHE.ProcessActivities(actid).PROCESS_ITEM_TYPE
240: AND WPA.ACTIVITY_NAME = WF_CACHE.ProcessActivities(actid).PROCESS_NAME
241: AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY

Line 449: from WF_PROCESS_ACTIVITIES WPA

445: WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
446: WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
447: WPA.START_END, WPA.DEFAULT_RESULT
448: into WF_CACHE.ProcessActivities(complete_activity.actid)
449: from WF_PROCESS_ACTIVITIES WPA
450: where WPA.INSTANCE_ID = complete_activity.actid;
451:
452: end if;
453:

Line 605: FROM WF_PROCESS_ACTIVITIES WPA

601: SELECT PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION,
602: ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, INSTANCE_ID,
603: INSTANCE_LABEL, PERFORM_ROLE, PERFORM_ROLE_TYPE,
604: START_END, DEFAULT_RESULT
605: FROM WF_PROCESS_ACTIVITIES WPA
606: WHERE WPA.PROCESS_ITEM_TYPE = itemtype
607: AND WPA.PROCESS_NAME = process
608: AND WPA.PROCESS_VERSION = version
609: AND WPA.START_END = wf_engine.eng_start

Line 914: FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C,

910:
911: -- Select all the start activities in a process with no in-transitions.
912: cursor starter_children(parent in pls_integer) is
913: SELECT C.INSTANCE_ID
914: FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C,
915: WF_ACTIVITIES A
916: WHERE P.INSTANCE_ID = parent
917: AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE
918: AND P.ACTIVITY_NAME = C.PROCESS_NAME

Line 1148: FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C,

1144:
1145: -- Select all the start activities for this parent process
1146: cursor starter_children(parent in pls_integer) is
1147: SELECT C.INSTANCE_ID
1148: FROM WF_PROCESS_ACTIVITIES P, WF_PROCESS_ACTIVITIES C,
1149: WF_ACTIVITIES A
1150: WHERE P.INSTANCE_ID = parent
1151: AND P.ACTIVITY_ITEM_TYPE = C.PROCESS_ITEM_TYPE
1152: AND P.ACTIVITY_NAME = C.PROCESS_NAME

Line 1383: from WF_PROCESS_ACTIVITIES WPA1,

1379:
1380: -- Cursor to select children of activity
1381: cursor children(parentid in pls_integer, actdate in date) is
1382: select WPA2.INSTANCE_ID
1383: from WF_PROCESS_ACTIVITIES WPA1,
1384: WF_ACTIVITIES WA,
1385: WF_PROCESS_ACTIVITIES WPA2
1386: where WPA1.INSTANCE_ID = parentid
1387: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE

Line 1385: WF_PROCESS_ACTIVITIES WPA2

1381: cursor children(parentid in pls_integer, actdate in date) is
1382: select WPA2.INSTANCE_ID
1383: from WF_PROCESS_ACTIVITIES WPA1,
1384: WF_ACTIVITIES WA,
1385: WF_PROCESS_ACTIVITIES WPA2
1386: where WPA1.INSTANCE_ID = parentid
1387: and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
1388: and WPA2.PROCESS_NAME = WA.NAME
1389: and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE

Line 2205: from WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP,

2201: actdate := sysdate;
2202: begin
2203: select WPAP.ACTIVITY_NAME
2204: into root
2205: from WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP,
2206: WF_PROCESS_ACTIVITIES WPAC, WF_ACTIVITIES WAC
2207: where WAP.ITEM_TYPE = get_root_process.itemtype
2208: and WAP.NAME = 'ROOT'
2209: and actdate >= WAP.BEGIN_DATE

Line 2206: WF_PROCESS_ACTIVITIES WPAC, WF_ACTIVITIES WAC

2202: begin
2203: select WPAP.ACTIVITY_NAME
2204: into root
2205: from WF_PROCESS_ACTIVITIES WPAP, WF_ACTIVITIES WAP,
2206: WF_PROCESS_ACTIVITIES WPAC, WF_ACTIVITIES WAC
2207: where WAP.ITEM_TYPE = get_root_process.itemtype
2208: and WAP.NAME = 'ROOT'
2209: and actdate >= WAP.BEGIN_DATE
2210: and actdate < nvl(WAP.END_DATE, get_root_process.actdate+1)

Line 2322: FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1,

2318:
2319: cursor children_to_kill (pid in pls_integer) is
2320: SELECT
2321: WIAS.PROCESS_ACTIVITY, WIAS.ACTIVITY_STATUS
2322: FROM WF_PROCESS_ACTIVITIES PA, WF_PROCESS_ACTIVITIES PA1,
2323: WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS
2324: WHERE PA.INSTANCE_ID = pid
2325: AND PA.ACTIVITY_ITEM_TYPE = PA1.PROCESS_ITEM_TYPE
2326: AND PA.ACTIVITY_NAME = PA1.PROCESS_NAME

Line 2435: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,

2431: -- Select all the active children process(es) under this parent process
2432: cursor children_be_suspended(parent in pls_integer) is
2433: SELECT
2434: WIAS.PROCESS_ACTIVITY
2435: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2436: WF_ACTIVITIES WA1, WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA2
2437: WHERE WPA1.INSTANCE_ID = processid
2438: AND WPA1.ACTIVITY_ITEM_TYPE = WA1.ITEM_TYPE
2439: AND WPA1.ACTIVITY_NAME = WA1.NAME

Line 2436: WF_ACTIVITIES WA1, WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA2

2432: cursor children_be_suspended(parent in pls_integer) is
2433: SELECT
2434: WIAS.PROCESS_ACTIVITY
2435: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2436: WF_ACTIVITIES WA1, WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA2
2437: WHERE WPA1.INSTANCE_ID = processid
2438: AND WPA1.ACTIVITY_ITEM_TYPE = WA1.ITEM_TYPE
2439: AND WPA1.ACTIVITY_NAME = WA1.NAME
2440: AND actdate >= WA1.BEGIN_DATE

Line 2503: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,

2499: -- Select all the suspended children processes under this parent process
2500: cursor children_be_resumed(parent in pls_integer) is
2501: SELECT
2502: WIAS.PROCESS_ACTIVITY
2503: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2504: WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA
2505: WHERE WPA1.INSTANCE_ID = processid
2506: AND WPA1.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2507: AND WPA1.ACTIVITY_NAME = WA.NAME

Line 2504: WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA

2500: cursor children_be_resumed(parent in pls_integer) is
2501: SELECT
2502: WIAS.PROCESS_ACTIVITY
2503: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA1,
2504: WF_PROCESS_ACTIVITIES WPA2, WF_ACTIVITIES WA
2505: WHERE WPA1.INSTANCE_ID = processid
2506: AND WPA1.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2507: AND WPA1.ACTIVITY_NAME = WA.NAME
2508: AND actdate >= WA.BEGIN_DATE