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_ACTIVITY_TRANSITIONS

Line 293: FROM WF_ACTIVITY_TRANSITIONS WAT1

289: -- and result
290: cursor children (fromact pls_integer, fromact_result varchar2) is
291: SELECT WAT1.FROM_PROCESS_ACTIVITY, WAT1.RESULT_CODE,
292: WAT1.TO_PROCESS_ACTIVITY
293: FROM WF_ACTIVITY_TRANSITIONS WAT1
294: WHERE WAT1.FROM_PROCESS_ACTIVITY = fromact
295: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
296: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
297: AND NOT EXISTS

Line 299: FROM WF_ACTIVITY_TRANSITIONS WAT2

295: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
296: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
297: AND NOT EXISTS
298: (SELECT NULL
299: FROM WF_ACTIVITY_TRANSITIONS WAT2
300: WHERE WAT2.FROM_PROCESS_ACTIVITY = fromact
301: AND WAT2.RESULT_CODE = fromact_result)
302: )
303: );

Line 612: FROM WF_ACTIVITY_TRANSITIONS WAT

608: AND WPA.PROCESS_VERSION = version
609: AND WPA.START_END = wf_engine.eng_start
610: AND NOT EXISTS (
611: SELECT NULL
612: FROM WF_ACTIVITY_TRANSITIONS WAT
613: WHERE WAT.TO_PROCESS_ACTIVITY = WPA.INSTANCE_ID);
614:
615: childarr InstanceArrayTyp; -- Place holder for all the instance id
616: -- selected from starter_children cursor

Line 927: FROM WF_ACTIVITY_TRANSITIONS WAT

923: AND actdate < NVL(A.END_DATE, actdate+1)
924: AND C.START_END = wf_engine.eng_start
925: AND NOT EXISTS (
926: SELECT NULL
927: FROM WF_ACTIVITY_TRANSITIONS WAT
928: WHERE WAT.TO_PROCESS_ACTIVITY = C.INSTANCE_ID);
929:
930: rerun varchar2(8); -- Activity rerun flag
931: cost number; -- Activity cost

Line 1164: FROM WF_ACTIVITY_TRANSITIONS WAT1

1160: -- Select the to activity(ies) by given the from activity and result
1161: cursor to_activities(fromact in pls_integer, fromact_result varchar2) is
1162: SELECT WAT1.FROM_PROCESS_ACTIVITY, WAT1.RESULT_CODE,
1163: WAT1.TO_PROCESS_ACTIVITY
1164: FROM WF_ACTIVITY_TRANSITIONS WAT1
1165: WHERE WAT1.FROM_PROCESS_ACTIVITY = fromact
1166: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
1167: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
1168: AND NOT EXISTS

Line 1170: FROM WF_ACTIVITY_TRANSITIONS WAT2

1166: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
1167: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
1168: AND NOT EXISTS
1169: (SELECT NULL
1170: FROM WF_ACTIVITY_TRANSITIONS WAT2
1171: WHERE WAT2.FROM_PROCESS_ACTIVITY = fromact
1172: AND WAT2.RESULT_CODE = fromact_result)
1173: )
1174: );

Line 1402: FROM WF_ACTIVITY_TRANSITIONS WAT1

1398: -- Cursor to select following activities
1399: cursor to_activities(fromact in pls_integer, fromact_result in varchar2) is
1400: SELECT WAT1.FROM_PROCESS_ACTIVITY, WAT1.RESULT_CODE,
1401: WAT1.TO_PROCESS_ACTIVITY
1402: FROM WF_ACTIVITY_TRANSITIONS WAT1
1403: WHERE WAT1.FROM_PROCESS_ACTIVITY = fromact
1404: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
1405: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
1406: AND NOT EXISTS

Line 1408: FROM WF_ACTIVITY_TRANSITIONS WAT2

1404: AND (WAT1.RESULT_CODE in (fromact_result, wf_engine.eng_trans_any)
1405: OR (WAT1.RESULT_CODE = wf_engine.eng_trans_default
1406: AND NOT EXISTS
1407: (SELECT NULL
1408: FROM WF_ACTIVITY_TRANSITIONS WAT2
1409: WHERE WAT2.FROM_PROCESS_ACTIVITY = fromact
1410: AND WAT2.RESULT_CODE = fromact_result)
1411: )
1412: );