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

2385:
2386: -- ContinueDetailFlow
2387: -- Signal Detail Flows to continue
2388: -- IN
2389: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
2390: -- itemkey - A string generated from the application object's primary key.
2391: -- actid - The process activity(instance id).
2392: -- waiting_activity - The Name of the activity that in waiting
2393: -- OUT

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

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

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

2531:
2532: -- Check if this is the first or second execution of this activity.
2533: -- First -> result_code will be null (really null).
2534: -- Second -> result_code will be '#NULL' (set that way by execution 1).
2535: Wf_Item_Activity_Status.Result(itemtype, itemkey, actid, status, result);
2536:
2537: if (result = wf_engine.eng_null) then
2538: -- Second execution.
2539: -- ContinueFlow() completed and was deferred.

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:

Line 2805: from WF_ITEM_ACTIVITY_STATUSES WIAS

2801: status VARCHAR2(30);
2802:
2803: cursor activity_status (litemtype varchar2, litemkey varchar2, lactid number ) is
2804: select WIAS.ACTIVITY_STATUS
2805: from WF_ITEM_ACTIVITY_STATUSES WIAS
2806: where WIAS.ITEM_TYPE = litemtype
2807: and WIAS.ITEM_KEY = litemkey
2808: and WIAS.PROCESS_ACTIVITY = lactid;
2809:

Line 3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;

3907: l_itemtype WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
3908: l_itemkey WF_NOTIFICATIONS.ITEM_KEY%TYPE;
3909: l_context WF_NOTIFICATIONS.CONTEXT%TYPE;
3910: l_actid number;
3911: l_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3912: l_result varchar2(20);
3913: l_err_nid number;
3914:
3915: wf_incomplete_ntf exception;

Line 3932: WF_ITEM_ACTIVITY_STATUS.Notification_Status(itemtype, itemkey, actid, l_err_nid, l_user);

3928: -- Get the parent notification id
3929: l_nid := l_event_t.getValueForParameter('NOTIFICATION_ID');
3930:
3931: -- Get the error notification id from Notification_Status() API by passing itemtype, itemkey and activity id
3932: WF_ITEM_ACTIVITY_STATUS.Notification_Status(itemtype, itemkey, actid, l_err_nid, l_user);
3933:
3934: l_result := Wf_Notification.GetAttrText(l_err_nid, 'RESULT');
3935:
3936: -- If the result attribute value is 'RESOLVED', then get the activity status of parent notification

Line 3948: WF_ITEM_ACTIVITY_STATUS.status(l_itemtype, l_itemkey, l_actid, l_status);

3944: where notification_id = l_nid;
3945:
3946: -- extract the activity id
3947: l_actid := to_number(SubStr(l_context, instr(l_context,':',1,2)+1));
3948: WF_ITEM_ACTIVITY_STATUS.status(l_itemtype, l_itemkey, l_actid, l_status);
3949:
3950: exception
3951: when others then
3952: SELECT activity_status into l_status FROM wf_item_activity_statuses WHERE notification_id = l_nid;

Line 3952: SELECT activity_status into l_status FROM wf_item_activity_statuses WHERE notification_id = l_nid;

3948: WF_ITEM_ACTIVITY_STATUS.status(l_itemtype, l_itemkey, l_actid, l_status);
3949:
3950: exception
3951: when others then
3952: SELECT activity_status into l_status FROM wf_item_activity_statuses WHERE notification_id = l_nid;
3953: end;
3954:
3955: -- close the error notification only if the parent notification activity is complete,
3956: -- otherwise raise the WFNTF_NOT_COMPLETE error on screen