DBA Data[Home] [Help]

APPS.WF_ENGINE_UTIL dependencies on WF_ITEMS

Line 2260: FROM WF_ITEMS WI

2256:
2257: --First select all Child Processes to be aborted
2258: CURSOR child_proc (p_itemtype varchar2, p_itemkey varchar2) is
2259: SELECT wi.item_type, wi.item_key
2260: FROM WF_ITEMS WI
2261: WHERE END_DATE IS NULL
2262: AND (WI.ITEM_TYPE <> p_itemtype
2263: or WI.ITEM_KEY <> p_itemkey)
2264: START WITH WI.ITEM_TYPE = p_itemtype

Line 2274: FROM WF_ITEMS WI

2270: --We only kill the child process
2271: --Select all masters
2272: CURSOR master_proc (p_itemtype varchar2, p_itemkey varchar2) is
2273: SELECT wi.item_type, wi.item_key
2274: FROM WF_ITEMS WI
2275: WHERE END_DATE IS NULL
2276: AND WI.ITEM_TYPE <> p_itemtype
2277: AND WI.ITEM_KEY <> p_itemkey
2278: START WITH WI.ITEM_TYPE = p_itemtype