[Home] [Help]
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2163: WF_ACTIVITIES WA
2164:
2165: where WPA.INSTANCE_ID = actid
2166: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
2167: and WA.NAME = WPA.ACTIVITY_NAME
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2332: WF_ACTIVITIES WA
2333:
2334: where WPA.INSTANCE_ID = actid
2335: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
2336: and WA.NAME = WPA.ACTIVITY_NAME
2404: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2405: WF_CACHE.ProcessActivities(actid).START_END,
2406: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2407:
2408: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
2409:
2410: where WPA.INSTANCE_ID = actid
2411: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
2412: and WA.NAME = WPA.ACTIVITY_NAME
3659: WIASP.ROWID ROW_ID
3660: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3661: WF_ITEMS WI,
3662: WF_PROCESS_ACTIVITIES WPAP,
3663: WF_ACTIVITIES WAP
3664: where WIASP.ITEM_TYPE = itemtype
3665: and WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3666: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3667: and WPAP.ACTIVITY_NAME = WAP.NAME
3690: WIASP.ROWID ROW_ID
3691: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3692: WF_ITEMS WI,
3693: WF_PROCESS_ACTIVITIES WPAP,
3694: WF_ACTIVITIES WAP
3695: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3696: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3697: and WPAP.ACTIVITY_NAME = WAP.NAME
3698: and WIASP.ITEM_TYPE = WI.ITEM_TYPE
3753: WIASP.ITEM_TYPE, WIASP.ITEM_KEY, WIASP.PROCESS_ACTIVITY
3754: into l_itemtype, l_itemkey, l_actid
3755: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3756: WF_PROCESS_ACTIVITIES WPAP,
3757: WF_ACTIVITIES WAP,
3758: WF_ITEMS WI
3759: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3760: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3761: and WPAP.ACTIVITY_NAME = WAP.NAME
5384: and activity_status = 'ACTIVE'
5385: and activity_status = wf_engine.eng_active
5386: and exists (select 'its a function, not subprocess'
5387: from wf_process_activities pa,
5388: wf_activities ac
5389: where pa.activity_name = ac.name
5390: and pa.activity_item_type = ac.item_type
5391: and pa.activity_item_type = ias.item_type
5392: and pa.instance_id = ias.process_activity
6393: ntf.status,
6394: ias.performed_by
6395: from wf_item_activity_statuses ias,
6396: wf_process_activities pa,
6397: wf_activities ac,
6398: wf_activities ap,
6399: wf_items i,
6400: wf_notifications ntf
6401: where ias.item_type = p_itemtype
6394: ias.performed_by
6395: from wf_item_activity_statuses ias,
6396: wf_process_activities pa,
6397: wf_activities ac,
6398: wf_activities ap,
6399: wf_items i,
6400: wf_notifications ntf
6401: where ias.item_type = p_itemtype
6402: and ias.item_key = p_itemkey
6559:
6560: cursor actcur(ver number) is
6561: select WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME
6562: from WF_PROCESS_ACTIVITIES WPA,
6563: WF_ACTIVITIES WA
6564: where WPA.PROCESS_ITEM_TYPE = p_process_item_type
6565: and WPA.PROCESS_NAME = p_process_name
6566: and WPA.PROCESS_VERSION = ver
6567: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
6578:
6579: -- then get the active version
6580: begin
6581: select VERSION into m_version
6582: from WF_ACTIVITIES
6583: where ITEM_TYPE = p_process_item_type
6584: and NAME = p_process_name
6585: and active_date >= BEGIN_DATE
6586: and active_date < nvl(END_DATE, active_date + 1);
6662: -- Blocked activities waiting for event (if existing process)
6663: cursor evtacts is
6664: SELECT WIAS.PROCESS_ACTIVITY actid
6665: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
6666: WF_ACTIVITIES WA
6667: WHERE WIAS.ITEM_TYPE = event.itemtype
6668: AND WIAS.ITEM_KEY = event.itemkey
6669: AND WIAS.ACTIVITY_STATUS = 'NOTIFIED'
6670: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
6904: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
6905: WF_PROCESS_ACTIVITIES WPA,
6906: (
6907: SELECT /*+ NO_MERGE */ WA.*
6908: FROM WF_ACTIVITIES WA
6909: where WA.TYPE = 'EVENT'
6910: AND WA.DIRECTION = 'RECEIVE'
6911: AND ( WA.EVENT_NAME IS NULL OR
6912: WA.EVENT_NAME = event2.event_name OR