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 2407: from wf_items

2403: --
2404: -- select all active children of parent flow
2405: --
2406: select item_type, item_key
2407: from wf_items
2408: where parent_item_type = itemtype
2409: and parent_item_key = itemkey
2410: and end_date is null;
2411: --

Line 2470: from wf_items

2466: -- This cursor is used if there are multiple WaitForFlow Activities in the
2467: -- parent flow (the parent_context must be set). CTILLEY bug 1941013
2468: -- select all active children of parent flow excluding current work item
2469: select count(1)
2470: from wf_items
2471: where parent_item_type = l_parent_itemtype
2472: and parent_item_key = l_parent_itemkey
2473: and parent_context = l_parent_context
2474: and (item_type <> ContinueMasterFlow.itemtype

Line 2481: from wf_items

2477:
2478: cursor child_flows2 is
2479: -- select all active children of parent flow excluding current work item
2480: select count(1)
2481: from wf_items
2482: where parent_item_type = l_parent_itemtype
2483: and parent_item_key = l_parent_itemkey
2484: and (item_type <> ContinueMasterFlow.itemtype
2485: or item_key <> ContinueMasterFlow.itemkey)

Line 2491: WF_ITEMS WI

2487:
2488: cursor child_activities2 is
2489: select count(1)
2490: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
2491: WF_ITEMS WI
2492: where WIAS.ITEM_TYPE = itemtype
2493: and WIAS.ITEM_KEY = WI.item_key
2494: and WI.parent_item_type = l_parent_itemtype
2495: and WI.parent_item_key = l_parent_itemkey

Line 2523: from wf_items

2519: -- select parent details
2520: --
2521: select parent_item_type, parent_item_key, parent_context
2522: into l_parent_itemtype, l_parent_itemkey, l_parent_context
2523: from wf_items
2524: where item_type = ContinueMasterFlow.itemtype
2525: and item_key = ContinueMasterFlow.itemkey;
2526:
2527: select instance_label

Line 2548: from wf_items

2544:
2545: -- lock the parent item, so only one child can execute this at the time.
2546: select item_key
2547: into dummy
2548: from wf_items
2549: where item_type = l_parent_itemtype
2550: and item_key = l_parent_itemkey
2551: for update;
2552: