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 4147: typ := Wf_Activity.Type(itemtype, root, actdate);

4143: -- calling create_item to avoid foreign key problems during the insert.
4144: -- The check that the process is runnable can't be done until AFTER
4145: -- create_item so the date has been established.
4146: actdate := sysdate;
4147: typ := Wf_Activity.Type(itemtype, root, actdate);
4148: if ((typ is null) or (typ <> wf_engine.eng_process)) then
4149: Wf_Core.Token('TYPE', itemtype);
4150: Wf_Core.Token('NAME', root);
4151: Wf_Core.Raise('WFENG_PROCESS_NAME');

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

4364: end if;
4365:
4366: -- Check that activity is a PROCESS-type.
4367: -- Only PROCESS activities may be suspended.
4368: if (Wf_Activity.Instance_Type(procid, actdate) <>
4369: wf_engine.eng_process) then
4370: Wf_Core.Token('NAME', proc);
4371: Wf_Core.Token('TYPE', itemtype);
4372: Wf_Core.Raise('WFENG_PROCESS_NAME');

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

4530: end if;
4531:
4532: -- Check that activity is a PROCESS-type.
4533: -- Only PROCESS activities may be aborted.
4534: if (Wf_Activity.Instance_Type(procid, actdate) <>
4535: wf_engine.eng_process) then
4536: Wf_Core.Token('NAME', proc);
4537: Wf_Core.Token('TYPE', itemtype);
4538: Wf_Core.Raise('WFENG_PROCESS_NAME');

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

4702: end if;
4703:
4704: -- Check that activity is a PROCESS-type.
4705: -- Only PROCESS activities may be resumed.
4706: if (Wf_Activity.Instance_Type(procid, actdate) <>
4707: wf_engine.eng_process) then
4708: Wf_Core.Token('NAME', proc);
4709: Wf_Core.Token('TYPE', itemtype);
4710: Wf_Core.Raise('WFENG_PROCESS_NAME');

Line 5334: act_fname:= Wf_Activity.activity_function

5330:
5331: elsif act.activity_status = wf_engine.eng_deferred then
5332:
5333: --process defered activity
5334: act_fname:= Wf_Activity.activity_function
5335: (act.item_type,act.item_key,act.process_activity);
5336: act_ftype:= Wf_Activity.activity_function_type
5337: (act.item_type,act.item_key,act.process_activity);
5338:

Line 5336: act_ftype:= Wf_Activity.activity_function_type

5332:
5333: --process defered activity
5334: act_fname:= Wf_Activity.activity_function
5335: (act.item_type,act.item_key,act.process_activity);
5336: act_ftype:= Wf_Activity.activity_function_type
5337: (act.item_type,act.item_key,act.process_activity);
5338:
5339: if act_ftype = 'PL/SQL' then
5340:

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

5918: Wf_Core.Raise('WFENG_ITEM_ACTIVITY');
5919: end if;
5920:
5921: -- Check if this activity is a notification type of activity
5922: acttype := Wf_Activity.Type(itemtype, activity, actdate);
5923: if (acttype <> wf_engine.eng_notification) then
5924: Wf_Core.Token('NAME', activity);
5925: Wf_Core.Raise('WFENG_NOTIFICATION_NAME');
5926: end if;

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

5939: '', performer);
5940: elsif (status in (wf_engine.eng_notified, wf_engine.eng_error)) then
5941: -- Check this is not a voting activity.
5942: -- Voting activities cannot be re-assigned.
5943: Wf_Activity.Notification_Info(itemtype, itemkey, actid, msg, msgtype,
5944: expand_role);
5945: if (expand_role = 'Y') then
5946: Wf_Core.Token('NAME', activity);
5947: Wf_Core.Raise('WFENG_VOTE_REASSIGN');

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

6050: begin
6051: savepoint wf_savepoint;
6052:
6053: -- execute the activity function with SKIP command (bug 2425229)
6054: funcname := Wf_Activity.Activity_Function(itemtype, itemkey, actid);
6055:
6056: if (funcname is not null) then -- <6636968>
6057:
6058: Wf_Engine_Util.Function_Call(funcname, itemtype, itemkey, actid, wf_engine.eng_skip,

Line 7002: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,

6998: AND WIAS.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
6999: AND WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
7000: AND WPA.ACTIVITY_NAME = WA.NAME
7001: AND EXISTS
7002: ( SELECT 1 FROM WF_ACTIVITY_ATTR_VALUES WAAV,
7003: WF_ITEM_ATTRIBUTE_VALUES WIAV
7004: WHERE WAAV.PROCESS_ACTIVITY_ID = WIAS.PROCESS_ACTIVITY
7005: AND WAAV.NAME = '#BUSINESS_KEY'
7006: AND WAAV.VALUE_TYPE = 'ITEMATTR'