[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
3662: WIASP.ROWID ROW_ID
3663: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3664: WF_ITEMS WI,
3665: WF_PROCESS_ACTIVITIES WPAP,
3666: WF_ACTIVITIES WAP
3667: where WIASP.ITEM_TYPE = itemtype
3668: and WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3669: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3670: and WPAP.ACTIVITY_NAME = WAP.NAME
3693: WIASP.ROWID ROW_ID
3694: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3695: WF_ITEMS WI,
3696: WF_PROCESS_ACTIVITIES WPAP,
3697: WF_ACTIVITIES WAP
3698: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3699: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3700: and WPAP.ACTIVITY_NAME = WAP.NAME
3701: and WIASP.ITEM_TYPE = WI.ITEM_TYPE
3756: WIASP.ITEM_TYPE, WIASP.ITEM_KEY, WIASP.PROCESS_ACTIVITY
3757: into l_itemtype, l_itemkey, l_actid
3758: from WF_ITEM_ACTIVITY_STATUSES WIASP,
3759: WF_PROCESS_ACTIVITIES WPAP,
3760: WF_ACTIVITIES WAP,
3761: WF_ITEMS WI
3762: where WIASP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID
3763: and WPAP.ACTIVITY_ITEM_TYPE = WAP.ITEM_TYPE
3764: and WPAP.ACTIVITY_NAME = WAP.NAME
5438: and activity_status = 'ACTIVE'
5439: and activity_status = wf_engine.eng_active
5440: and exists (select 'its a function, not subprocess'
5441: from wf_process_activities pa,
5442: wf_activities ac
5443: where pa.activity_name = ac.name
5444: and pa.activity_item_type = ac.item_type
5445: and pa.activity_item_type = ias.item_type
5446: and pa.instance_id = ias.process_activity
6462: ntf.status,
6463: ias.performed_by
6464: from wf_item_activity_statuses ias,
6465: wf_process_activities pa,
6466: wf_activities ac,
6467: wf_activities ap,
6468: wf_items i,
6469: wf_notifications ntf
6470: where ias.item_type = p_itemtype
6463: ias.performed_by
6464: from wf_item_activity_statuses ias,
6465: wf_process_activities pa,
6466: wf_activities ac,
6467: wf_activities ap,
6468: wf_items i,
6469: wf_notifications ntf
6470: where ias.item_type = p_itemtype
6471: and ias.item_key = p_itemkey
6628:
6629: cursor actcur(ver number) is
6630: select WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME
6631: from WF_PROCESS_ACTIVITIES WPA,
6632: WF_ACTIVITIES WA
6633: where WPA.PROCESS_ITEM_TYPE = p_process_item_type
6634: and WPA.PROCESS_NAME = p_process_name
6635: and WPA.PROCESS_VERSION = ver
6636: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
6647:
6648: -- then get the active version
6649: begin
6650: select VERSION into m_version
6651: from WF_ACTIVITIES
6652: where ITEM_TYPE = p_process_item_type
6653: and NAME = p_process_name
6654: and active_date >= BEGIN_DATE
6655: and active_date < nvl(END_DATE, active_date + 1);
6731: -- Blocked activities waiting for event (if existing process)
6732: cursor evtacts is
6733: SELECT WIAS.PROCESS_ACTIVITY actid
6734: FROM WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
6735: WF_ACTIVITIES WA
6736: WHERE WIAS.ITEM_TYPE = event.itemtype
6737: AND WIAS.ITEM_KEY = event.itemkey
6738: AND WIAS.ACTIVITY_STATUS = 'NOTIFIED'
6739: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
6974: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
6975: WF_PROCESS_ACTIVITIES WPA,
6976: (
6977: SELECT /*+ NO_MERGE */ WA.*
6978: FROM WF_ACTIVITIES WA
6979: where WA.TYPE = 'EVENT'
6980: AND WA.DIRECTION = 'RECEIVE'
6981: AND ( WA.EVENT_NAME IS NULL OR
6982: WA.EVENT_NAME = event2.event_name OR