[Home] [Help]
3529: begin
3530: select
3531: S.ITEM_TYPE, S.ITEM_KEY, S.PROCESS_ACTIVITY
3532: into l_itemtype, l_itemkey, l_actid
3533: from WF_ITEM_ACTIVITY_STATUSES S , WF_ITEMS WI
3534: where S.DUE_DATE < SYSDATE
3535: and S.ACTIVITY_STATUS in ('WAITING','NOTIFIED','SUSPEND',
3536: 'DEFERRED','ACTIVE')
3537: and S.ROWID = idarr(i)
3660: select /*+ ORDERED USE_NL (WIASP WI WPAP WAP)
3661: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
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
3691: select /*+ ORDERED USE_NL (WIASP WI WPAP WAP)
3692: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
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
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
3765: and WIASP.ITEM_TYPE = WI.ITEM_TYPE
4816: p_process in varchar2) is
4817:
4818: cursor Open_Items(p_itemType in varchar2) is
4819: SELECT item_key
4820: FROM wf_items
4821: WHERE item_type = p_itemType
4822: AND end_date is NULL;
4823:
4824: cursor All_Open_Items is
4822: AND end_date is NULL;
4823:
4824: cursor All_Open_Items is
4825: SELECT item_type, item_key
4826: FROM wf_items
4827: WHERE end_date is NULL;
4828:
4829: begin
4830:
4984:
4985: --Place row-lock on this item and retrieve parent process info:
4986: select parent_item_type, parent_item_key, parent_context
4987: into l_parent_itemType, l_parent_itemKey, l_parent_context
4988: from wf_items
4989: where item_type = copy_itemtype
4990: and item_key = copy_itemkey
4991: for update of item_type;
4992:
4991: for update of item_type;
4992:
4993: --Create the process
4994: if same_version then
4995: insert into wf_items(
4996: ITEM_TYPE, ITEM_KEY,
4997: ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
4998: OWNER_ROLE, USER_KEY,
4999: PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
5003: ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
5004: OWNER_ROLE, USER_KEY,
5005: PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
5006: BEGIN_DATE, null
5007: from wf_items
5008: where item_type = copy_itemtype
5009: and item_key = copy_itemkey;
5010: else
5011:
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
6472: and ias.activity_status = wf_engine.eng_completed
6570: begin
6571: begin
6572: select ROOT_ACTIVITY, BEGIN_DATE
6573: into rootactivity, active_date
6574: from WF_ITEMS
6575: where ITEM_TYPE = p_item_type
6576: and ITEM_KEY = p_item_key;
6577: exception
6578: -- if itemtype/itemkey combination not exists, treats it as not exists
6855: -- Bug 2255002 - if the parent item type and parent item key
6856: -- already exist do nothing
6857: SELECT parent_item_type, parent_item_key
6858: INTO parent_itemtype, parent_itemkey
6859: FROM wf_items
6860: WHERE item_type = itemtype
6861: AND item_key = itemkey;
6862:
6863: if (parent_itemtype is null and parent_itemkey is null ) then
6991: AND GRP.NAME = WA.EVENT_NAME
6992: )
6993: )
6994: ) WA,
6995: WF_ITEMS WI
6996: WHERE WIAS.ACTIVITY_STATUS = 'NOTIFIED'
6997: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
6998: AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
6999: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE