eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_STANDARD dependencies on WF_ITEM

Line 164: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

160: FROM WF_ACTIVITY_TRANSITIONS WAT
161: WHERE WAT.TO_PROCESS_ACTIVITY = actid
162: AND NOT EXISTS
163: (SELECT NULL
164: FROM WF_ITEM_ACTIVITY_STATUSES WIAS
165: WHERE WIAS.PROCESS_ACTIVITY = WAT.FROM_PROCESS_ACTIVITY
166: AND WIAS.ITEM_TYPE = itemtype
167: AND WIAS.ITEM_KEY = itemkey
168: AND WIAS.ACTIVITY_STATUS = 'COMPLETE'

Line 429: from wf_item_activity_statuses

425:
426: cursor GetRunningTime (itemtype in varchar2,
427: itemkey in varchar2, actid in number) is
428: select (sysdate - nvl(begin_date,sysdate))*86400
429: from wf_item_activity_statuses
430: where item_type = itemtype
431: and item_key = itemkey
432: and process_activity = actid;
433:

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 1066: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);

1062: if deferit = 'Y' then
1063: -- Check if this is the first or second execution of this activity.
1064: -- First -> result_code will be null (really null).
1065: -- Second -> result_code will be '#NULL' (set that way by execution 1).
1066: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
1067:
1068: if (result = wf_engine.eng_null) then
1069: -- Second execution.
1070: -- Defer must have been picked up by the background engine,

Line 1364: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);

1360:
1361: -- Check if this is the first or second execution of this activity.
1362: -- First -> result_code will be null (really null).
1363: -- Second -> result_code will be '#NULL' (set that way by execution 1).
1364: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
1365:
1366: if (result = wf_engine.eng_null) then
1367: -- Second execution.
1368: -- Defer must have been picked up by the background engine,

Line 1453: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);

1449:
1450: -- Check if this is the first or second execution of this activity.
1451: -- First -> result_code will be null (really null).
1452: -- Second -> result_code will be '#NULL' (set that way by execution 1).
1453: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
1454:
1455: if (result = wf_engine.eng_null) then
1456: -- Second execution.
1457: -- Wait is completed, return complete result.

Line 1654: from wf_item_activity_statuses wias,

1650: -- select number of activities the user currently has in worklist
1651: --
1652: cursor load_balance(user in varchar2, act_name varchar2 ) is
1653: select count(1)
1654: from wf_item_activity_statuses wias,
1655: wf_process_activities wpa
1656: where wias.item_type = itemtype
1657: and wias.activity_status = 'NOTIFIED'
1658: and wias.process_activity = wpa.instance_id

Line 1666: from wf_item_activity_statuses wias,

1662: -- select the date of the last time the user was notified
1663: --
1664: cursor round_robin(user in varchar2, act_name varchar2 ) is
1665: select max(begin_date)
1666: from wf_item_activity_statuses wias,
1667: wf_process_activities wpa
1668: where wias.item_type = itemtype
1669: and wias.process_activity = wpa.instance_id
1670: and wpa.activity_name = act_name

Line 1688: actdate := wf_item.active_date(itemtype, itemkey);

1684: Wf_Core.Token('OPERATION', 'Wf_Standard.AndJoin');
1685: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
1686: end if;
1687:
1688: actdate := wf_item.active_date(itemtype, itemkey);
1689: cmd := Wf_Engine.GetActivityAttrText(itemtype,itemkey,actid,'METHOD');
1690:
1691: -- loop thru all out-transiations of role resolution activity
1692: for trans_rec in out_transitions loop

Line 1974: -- itemtype - A valid item type from (WF_ITEM_TYPES table).

1970:
1971: -- VoteForResultType
1972: -- Standard Voting Function
1973: -- IN
1974: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1975: -- itemkey - A string generated from the application object's primary key.
1976: -- actid - The process activity(instance id).
1977: -- funcmode - Run/Cancel
1978: -- OUT

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 2065: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,

2061: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
2062: end if;
2063:
2064: -- Get Notifications group_id for activity
2065: Wf_Item_Activity_Status.Notification_Status(itemtype,itemkey,actid,
2066: l_group_id,l_user);
2067: l_voting_option := Wf_Engine.GetActivityAttrText(itemtype,itemkey,
2068: actid,'VOTING_OPTION');
2069: if (l_voting_option not in ('REQUIRE_ALL_VOTES', 'WAIT_FOR_ALL_VOTES',

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 2229: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

2225:
2226: begin
2227: select 'master activity not complete'
2228: into dummy
2229: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
2230: where WIAS.ITEM_TYPE = l_parent_itemtype
2231: and WIAS.ITEM_KEY = l_parent_itemkey
2232: and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
2233: and WPA.INSTANCE_LABEL = label

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 2271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

2267:
2268: cursor child_activities (itemtype varchar2, itemkey varchar2,
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

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 2374: -- itemtype - A valid item type from (WF_ITEM_TYPES table).

2370:
2371: -- ContinueDetailFlow
2372: -- Signal Detail Flows to continue
2373: -- IN
2374: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
2375: -- itemkey - A string generated from the application object's primary key.
2376: -- actid - The process activity(instance id).
2377: -- waiting_activity - The Name of the activity that in waiting
2378: -- OUT

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 2475: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,

2471: and end_date is null;
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

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 2512: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);

2508:
2509: -- Check if this is the first or second execution of this activity.
2510: -- First -> result_code will be null (really null).
2511: -- Second -> result_code will be '#NULL' (set that way by execution 1).
2512: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
2513:
2514: if (result = wf_engine.eng_null) then
2515: -- Second execution.
2516: -- ContinueFlow() completed and was deferred.

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:

Line 2774: from WF_ITEM_ACTIVITY_STATUSES WIAS

2770: status VARCHAR2(30);
2771:
2772: cursor activity_status (litemtype varchar2, litemkey varchar2, lactid number ) is
2773: select WIAS.ACTIVITY_STATUS
2774: from WF_ITEM_ACTIVITY_STATUSES WIAS
2775: where WIAS.ITEM_TYPE = litemtype
2776: and WIAS.ITEM_KEY = litemkey
2777: and WIAS.PROCESS_ACTIVITY = lactid;
2778: