APPS.WF_STANDARD dependencies on WF_ACTIVITY

Line 160: FROM WF_ACTIVITY_TRANSITIONS WAT

156: -- The And fails if there is at least one in-transition which is either
157: -- incomplete or complete with the wrong result.
158: SELECT count(1)
159: into cnt
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

Line 174: FROM WF_ACTIVITY_TRANSITIONS WAT2

170: wf_engine.eng_trans_any)
171: OR (WAT.RESULT_CODE = wf_engine.eng_trans_default
172: AND NOT EXISTS
173: (SELECT NULL
174: FROM WF_ACTIVITY_TRANSITIONS WAT2
175: WHERE WAT2.FROM_PROCESS_ACTIVITY =
176: WAT.FROM_PROCESS_ACTIVITY
177: AND WAT2.RESULT_CODE = WIAS.ACTIVITY_RESULT_CODE)
178: )

Line 740: from WF_ACTIVITY_ATTR_VALUES WAAV

736:
737: -- First get the name of the Item Attribute that EVENT points to
738: select WAAV.VALUE_TYPE, substrb(WAAV.TEXT_VALUE, 1, 30)
739: into LRefflag, LAName
740: from WF_ACTIVITY_ATTR_VALUES WAAV
741: where WAAV.PROCESS_ACTIVITY_ID = actid
742: and WAAV.NAME = 'EVENT';
743:
744: /* Should be able to use the GetActivityAttrEvent to do this

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

1255: end if;
1256:
1257:
1258: -- lookup notification base info
1259: Wf_Activity.Notification_Info(itemtype, itemkey, actid, msg, msgtype,
1260: expand_role);
1261:
1262: -- see if this activity is already assigned to a role
1263: prole := Wf_Activity.Perform_Role(itemtype, itemkey, actid);

Line 1263: prole := Wf_Activity.Perform_Role(itemtype, itemkey, actid);

1259: Wf_Activity.Notification_Info(itemtype, itemkey, actid, msg, msgtype,
1260: expand_role);
1261:
1262: -- see if this activity is already assigned to a role
1263: prole := Wf_Activity.Perform_Role(itemtype, itemkey, actid);
1264:
1265: -- if it isnt then use the value from activity attribute
1266: if prole is null then
1267: prole := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PERFORMER');

Line 1644: FROM wf_activity_transitions wat,

1640: SELECT wat.to_process_activity,
1641: wpa.activity_name,
1642: wpa.perform_role,
1643: wpa.perform_role_type
1644: FROM wf_activity_transitions wat,
1645: wf_process_activities wpa
1646: WHERE wat.from_process_activity = actid
1647: AND wat.result_code = wf_engine.eng_trans_default
1648: AND wat.to_process_activity = wpa.instance_id;

Line 1700: if (Wf_Activity.Type(itemtype, trans_rec.activity_name, actdate) =

1696: min_begin_date date;
1697: assigned_performer varchar2(320);
1698: begin
1699: --
1700: if (Wf_Activity.Type(itemtype, trans_rec.activity_name, actdate) =
1701: wf_engine.eng_notification) then
1702: -- Get perform_role from constant or itemattr value
1703: if (trans_rec.perform_role_type = 'CONSTANT') then
1704: prole := trans_rec.perform_role;