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_ACTIVITY_STATUS

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 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 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 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 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 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 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 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