APPS.WF_STANDARD dependencies on WF_PROCESS_ACTIVITIES

Line 1645: wf_process_activities wpa

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;
1649: --

Line 1655: wf_process_activities wpa

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
1659: and wpa.activity_name = act_name

Line 1667: wf_process_activities wpa

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
1671: and wias.assigned_user = user;

Line 1772: from wf_process_activities wpa

1768: -- Retreieve instance_label for activity
1769: --
1770: select wpa.instance_label
1771: into label
1772: from wf_process_activities wpa
1773: where wpa.instance_id = trans_rec.to_process_activity;
1774:
1775: wf_engine.AssignActivity(itemtype,itemkey,label,
1776: assigned_performer);

Line 2027: wf_process_activities wfpa,

2023: cursor result_codes is
2024: select wfl.lookup_code result_code
2025: from wf_lookups wfl,
2026: wf_activities wfa,
2027: wf_process_activities wfpa,
2028: wf_items wfi
2029: where wfl.lookup_type = wfa.result_type
2030: and wfa.name = wfpa.activity_name
2031: and wfi.begin_date >= wfa.begin_date

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 2284: from wf_process_activities

2280: and wias.activity_status in (wf_engine.eng_completed, wf_engine.eng_active);
2281:
2282: cursor current_process (p_actid number) is
2283: select instance_label
2284: from wf_process_activities
2285: where instance_id = p_actid;
2286:
2287: colon pls_integer;
2288: process varchar2(30);

Line 2475: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,

2471: and end_date is null;
2472:
2473: cursor child_activities2 is
2474: select count(1)
2475: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA,
2476: WF_ITEMS WI
2477: where WIAS.ITEM_TYPE = itemtype
2478: and WIAS.ITEM_KEY = WI.item_key
2479: and WI.parent_item_type = l_parent_itemtype

Line 2506: from wf_process_activities

2502: and item_key = ContinueMasterFlow.itemkey;
2503:
2504: select instance_label
2505: into label
2506: from wf_process_activities
2507: where instance_id = actid;
2508:
2509: -- Check if this is the first or second execution of this activity.
2510: -- First -> result_code will be null (really null).