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_ACTIVITIES

Line 915: WF_ACTIVITIES A

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
919: AND C.PROCESS_VERSION = A.VERSION

Line 1149: WF_ACTIVITIES A

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
1153: AND C.PROCESS_VERSION = A.VERSION

Line 1384: WF_ACTIVITIES WA,

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
1388: and WPA2.PROCESS_NAME = WA.NAME

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 2323: WF_ACTIVITIES A1, WF_ITEM_ACTIVITY_STATUSES WIAS

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
2327: AND PA1.PROCESS_VERSION = A1.VERSION

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 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