APPS.WF_STANDARD dependencies on WF_ITEMS

Line 437: from wf_items

433:
434: cursor GetExecutionTime (itemtype in varchar2,
435: itemkey in varchar2) is
436: select (sysdate - begin_date)*86400
437: from wf_items
438: where item_type = itemtype
439: and item_key = itemkey;
440:
441: begin

Line 2028: wf_items wfi

2024: select wfl.lookup_code result_code
2025: from wf_lookups wfl,
2026: wf_activities wfa,
2027: wf_process_activities wfpa,
2028: wf_items wfi
2029: where wfl.lookup_type = wfa.result_type
2030: and wfa.name = wfpa.activity_name
2031: and wfi.begin_date >= wfa.begin_date
2032: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)

Line 2221: from wf_items

2217: end if;
2218:
2219: select parent_item_type, parent_item_key
2220: into l_parent_itemtype, l_parent_itemkey
2221: from wf_items
2222: where item_type = WaitForMasterFlow.itemtype
2223: and item_key = WaitForMasterFlow.itemkey;
2224:
2225:

Line 2263: from wf_items

2259: resultout out nocopy varchar2) is
2260: cursor child_flows is
2261: -- select all active children of parent flow
2262: select count(1)
2263: from wf_items
2264: where parent_item_type = itemtype
2265: and parent_item_key = itemkey
2266: and end_date is null;
2267:

Line 2273: from wf_items

2269: pname varchar2, plabel varchar2) is
2270: select count(1)
2271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
2272: where (WIAS.ITEM_TYPE, WIAS.ITEM_KEY) in (select item_type,item_key
2273: from wf_items
2274: where parent_item_type =itemtype
2275: and parent_item_key =itemkey
2276: and end_date is null)
2277: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 2392: from wf_items

2388: --
2389: -- select all active children of parent flow
2390: --
2391: select item_type, item_key
2392: from wf_items
2393: where parent_item_type = itemtype
2394: and parent_item_key = itemkey
2395: and end_date is null;
2396: --

Line 2455: from wf_items

2451: -- This cursor is used if there are multiple WaitForFlow Activities in the
2452: -- parent flow (the parent_context must be set). CTILLEY bug 1941013
2453: -- select all active children of parent flow excluding current work item
2454: select count(1)
2455: from wf_items
2456: where parent_item_type = l_parent_itemtype
2457: and parent_item_key = l_parent_itemkey
2458: and parent_context = l_parent_context
2459: and (item_type <> ContinueMasterFlow.itemtype

Line 2466: from wf_items

2462:
2463: cursor child_flows2 is
2464: -- select all active children of parent flow excluding current work item
2465: select count(1)
2466: from wf_items
2467: where parent_item_type = l_parent_itemtype
2468: and parent_item_key = l_parent_itemkey
2469: and (item_type <> ContinueMasterFlow.itemtype
2470: or item_key <> ContinueMasterFlow.itemkey)

Line 2476: WF_ITEMS WI

2472:
2473: cursor child_activities2 is
2474: select count(1)
2475: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
2476: WF_ITEMS WI
2477: where WIAS.ITEM_TYPE = itemtype
2478: and WIAS.ITEM_KEY = WI.item_key
2479: and WI.parent_item_type = l_parent_itemtype
2480: and WI.parent_item_key = l_parent_itemkey

Line 2500: from wf_items

2496: -- select parent details
2497: --
2498: select parent_item_type, parent_item_key, parent_context
2499: into l_parent_itemtype, l_parent_itemkey, l_parent_context
2500: from wf_items
2501: where item_type = ContinueMasterFlow.itemtype
2502: and item_key = ContinueMasterFlow.itemkey;
2503:
2504: select instance_label

Line 2525: from wf_items

2521:
2522: -- lock the parent item, so only one child can execute this at the time.
2523: select item_key
2524: into dummy
2525: from wf_items
2526: where item_type = l_parent_itemtype
2527: and item_key = l_parent_itemkey
2528: for update;
2529: