[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)
3657: select /*+ ORDERED USE_NL (WIASP WI WPAP WAP)
3658: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
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
3688: select /*+ ORDERED USE_NL (WIASP WI WPAP WAP)
3689: INDEX (WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */
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
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
3762: and WIASP.ITEM_TYPE = WI.ITEM_TYPE
4765: p_process in varchar2) is
4766:
4767: cursor Open_Items(p_itemType in varchar2) is
4768: SELECT item_key
4769: FROM wf_items
4770: WHERE item_type = p_itemType
4771: AND end_date is NULL;
4772:
4773: cursor All_Open_Items is
4771: AND end_date is NULL;
4772:
4773: cursor All_Open_Items is
4774: SELECT item_type, item_key
4775: FROM wf_items
4776: WHERE end_date is NULL;
4777:
4778: begin
4779:
4930:
4931: --Place row-lock on this item and retrieve parent process info:
4932: select parent_item_type, parent_item_key, parent_context
4933: into l_parent_itemType, l_parent_itemKey, l_parent_context
4934: from wf_items
4935: where item_type = copy_itemtype
4936: and item_key = copy_itemkey
4937: for update of item_type;
4938:
4937: for update of item_type;
4938:
4939: --Create the process
4940: if same_version then
4941: insert into wf_items(
4942: ITEM_TYPE, ITEM_KEY,
4943: ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
4944: OWNER_ROLE, USER_KEY,
4945: PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
4949: ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
4950: OWNER_ROLE, USER_KEY,
4951: PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
4952: BEGIN_DATE, null
4953: from wf_items
4954: where item_type = copy_itemtype
4955: and item_key = copy_itemkey;
4956: else
4957:
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
6403: and ias.activity_status = wf_engine.eng_completed
6501: begin
6502: begin
6503: select ROOT_ACTIVITY, BEGIN_DATE
6504: into rootactivity, active_date
6505: from WF_ITEMS
6506: where ITEM_TYPE = p_item_type
6507: and ITEM_KEY = p_item_key;
6508: exception
6509: -- if itemtype/itemkey combination not exists, treats it as not exists
6785: -- Bug 2255002 - if the parent item type and parent item key
6786: -- already exist do nothing
6787: SELECT parent_item_type, parent_item_key
6788: INTO parent_itemtype, parent_itemkey
6789: FROM wf_items
6790: WHERE item_type = itemtype
6791: AND item_key = itemkey;
6792:
6793: if (parent_itemtype is null and parent_itemkey is null ) then
6921: AND GRP.NAME = WA.EVENT_NAME
6922: )
6923: )
6924: ) WA,
6925: WF_ITEMS WI
6926: WHERE WIAS.ACTIVITY_STATUS = 'NOTIFIED'
6927: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
6928: AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
6929: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE