APPS.WF_STANDARD dependencies on WF_ITEM_ACTIVITY_STATUSES

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