DBA Data[Home] [Help]

APPS.WF_PROCESS_ACTIVITY dependencies on WF_ITEM

Line 66: actdate := Wf_Item.Active_Date(itemtype, itemkey);

62: return(wf_process_activity.c_rootid);
63: end if;
64:
65: -- No joy. Select a new value.
66: actdate := Wf_Item.Active_Date(itemtype, itemkey);
67:
68: select INSTANCE_ID
69: into instid
70: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A

Line 252: Wf_Item_Activity_Status.LastResult(itemtype, itemkey,

248: -- because synch processes can only operate on the current activity.
249: --
250: if (itemkey = wf_engine.eng_synch) then
251: -- Get the current item and status in the cache
252: Wf_Item_Activity_Status.LastResult(itemtype, itemkey,
253: cur_actid, cur_status, cur_result);
254:
255: -- If status doesn't match one asked for, immediate trouble
256: if (nvl(status, '1') <> nvl(cur_status, '2')) then

Line 271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA

267: else
268: -- NORMAL mode
269: select WPA.INSTANCE_ID
270: into instid
271: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
272: where WIAS.ITEM_TYPE = activeinstanceid.itemtype
273: and WIAS.ITEM_KEY = activeinstanceid.itemkey
274: and WIAS.ACTIVITY_STATUS = nvl(activeinstanceid.status,
275: WIAS.ACTIVITY_STATUS)