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_ENGINE dependencies on WF_ACTIVITY

Line 31: from WF_ACTIVITY_ATTR_VALUES WAAV

27: -- Optimizing the code using a single cursor with binds
28: cursor curs_activityattr (c_actid NUMBER, c_aname VARCHAR2) is
29: select WAAV.PROCESS_ACTIVITY_ID, WAAV.NAME, WAAV.VALUE_TYPE,
30: WAAV.TEXT_VALUE, WAAV.NUMBER_VALUE, WAAV.DATE_VALUE
31: from WF_ACTIVITY_ATTR_VALUES WAAV
32: where WAAV.PROCESS_ACTIVITY_ID = c_actid
33: and WAAV.NAME = c_aname;
34:
35: --

Line 2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

2158: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2159: WF_CACHE.ProcessActivities(actid).START_END,
2160: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2161:
2162: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2163: WF_ACTIVITIES WA
2164:
2165: where WPA.INSTANCE_ID = actid
2166: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE

Line 2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,

2327: WF_CACHE.ProcessActivities(actid).PERFORM_ROLE_TYPE,
2328: WF_CACHE.ProcessActivities(actid).START_END,
2329: WF_CACHE.ProcessActivities(actid).DEFAULT_RESULT
2330:
2331: from WF_ACTIVITY_ATTRIBUTES WAA, WF_PROCESS_ACTIVITIES WPA,
2332: WF_ACTIVITIES WA
2333:
2334: where WPA.INSTANCE_ID = actid
2335: and WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE

Line 3344: Wf_Activity.Notification_Info(itemtype, itemkey, actid,

3340:
3341: -- For TRANSFER mode only, reset the assigned user, but only
3342: -- if not a voting activity
3343: if (command = 'TRANSFER') then
3344: Wf_Activity.Notification_Info(itemtype, itemkey, actid,
3345: message, msgtype, expand_role);
3346: if (expand_role = 'N') then
3347: Wf_Item_Activity_Status.Update_Notification(itemtype, itemkey, actid,
3348: number_value, text_value);

Line 4100: typ := Wf_Activity.Type(itemtype, root, actdate);

4096: -- calling create_item to avoid foreign key problems during the insert.
4097: -- The check that the process is runnable can't be done until AFTER
4098: -- create_item so the date has been established.
4099: actdate := sysdate;
4100: typ := Wf_Activity.Type(itemtype, root, actdate);
4101: if ((typ is null) or (typ <> wf_engine.eng_process)) then
4102: Wf_Core.Token('TYPE', itemtype);
4103: Wf_Core.Token('NAME', root);
4104: Wf_Core.Raise('WFENG_PROCESS_NAME');

Line 4319: if (Wf_Activity.Instance_Type(procid, actdate) <>

4315: end if;
4316:
4317: -- Check that activity is a PROCESS-type.
4318: -- Only PROCESS activities may be suspended.
4319: if (Wf_Activity.Instance_Type(procid, actdate) <>
4320: wf_engine.eng_process) then
4321: Wf_Core.Token('NAME', proc);
4322: Wf_Core.Token('TYPE', itemtype);
4323: Wf_Core.Raise('WFENG_PROCESS_NAME');

Line 4485: if (Wf_Activity.Instance_Type(procid, actdate) <>

4481: end if;
4482:
4483: -- Check that activity is a PROCESS-type.
4484: -- Only PROCESS activities may be aborted.
4485: if (Wf_Activity.Instance_Type(procid, actdate) <>
4486: wf_engine.eng_process) then
4487: Wf_Core.Token('NAME', proc);
4488: Wf_Core.Token('TYPE', itemtype);
4489: Wf_Core.Raise('WFENG_PROCESS_NAME');

Line 4655: if (Wf_Activity.Instance_Type(procid, actdate) <>

4651: end if;
4652:
4653: -- Check that activity is a PROCESS-type.
4654: -- Only PROCESS activities may be resumed.
4655: if (Wf_Activity.Instance_Type(procid, actdate) <>
4656: wf_engine.eng_process) then
4657: Wf_Core.Token('NAME', proc);
4658: Wf_Core.Token('TYPE', itemtype);
4659: Wf_Core.Raise('WFENG_PROCESS_NAME');

Line 5280: act_fname:= Wf_Activity.activity_function

5276:
5277: elsif act.activity_status = wf_engine.eng_deferred then
5278:
5279: --process defered activity
5280: act_fname:= Wf_Activity.activity_function
5281: (act.item_type,act.item_key,act.process_activity);
5282: act_ftype:= Wf_Activity.activity_function_type
5283: (act.item_type,act.item_key,act.process_activity);
5284:

Line 5282: act_ftype:= Wf_Activity.activity_function_type

5278:
5279: --process defered activity
5280: act_fname:= Wf_Activity.activity_function
5281: (act.item_type,act.item_key,act.process_activity);
5282: act_ftype:= Wf_Activity.activity_function_type
5283: (act.item_type,act.item_key,act.process_activity);
5284:
5285: if act_ftype = 'PL/SQL' then
5286:

Line 5857: acttype := Wf_Activity.Type(itemtype, activity, actdate);

5853: Wf_Core.Raise('WFENG_ITEM_ACTIVITY');
5854: end if;
5855:
5856: -- Check if this activity is a notification type of activity
5857: acttype := Wf_Activity.Type(itemtype, activity, actdate);
5858: if (acttype <> wf_engine.eng_notification) then
5859: Wf_Core.Token('NAME', activity);
5860: Wf_Core.Raise('WFENG_NOTIFICATION_NAME');
5861: end if;

Line 5878: Wf_Activity.Notification_Info(itemtype, itemkey, actid, msg, msgtype,

5874: '', performer);
5875: elsif (status in (wf_engine.eng_notified, wf_engine.eng_error)) then
5876: -- Check this is not a voting activity.
5877: -- Voting activities cannot be re-assigned.
5878: Wf_Activity.Notification_Info(itemtype, itemkey, actid, msg, msgtype,
5879: expand_role);
5880: if (expand_role = 'Y') then
5881: Wf_Core.Token('NAME', activity);
5882: Wf_Core.Raise('WFENG_VOTE_REASSIGN');

Line 5988: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);

5984: begin
5985: savepoint wf_savepoint;
5986:
5987: -- execute the activity function with SKIP command (bug 2425229)
5988: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);
5989:
5990: if (funcname is not null) then -- <6636968>
5991:
5992: Wf_Engine_Util.Function_Call(funcname, itemtype, itemkey, actid, wf_engine.eng_skip,

Line 6932: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,

6928: AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
6929: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
6930: AND WPA.ACTIVITY_NAME = WA.NAME
6931: AND EXISTS
6932: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,
6933: WF_ITEM_ATTRIBUTE_VALUES WIAV
6934: WHERE WAAV.PROCESS_ACTIVITY_ID = WIAS.PROCESS_ACTIVITY
6935: AND WAAV.NAME = '#BUSINESS_KEY'
6936: AND WAAV.VALUE_TYPE = 'ITEMATTR'