APPS.WF_MONITOR dependencies on WF_ITEMS

Line 273: from wf_items

269: begin_date
270: into rt_activity,
271: rt_activity_version,
272: bg_date
273: from wf_items
274: where item_type = x_item_type
275: and item_key = x_item_key;
276:
277: exception

Line 1309: from wf_items

1305: bg_date,
1306: ed_date,
1307: ukey,
1308: owner
1309: from wf_items
1310: where item_type = x_item_type
1311: and item_key = x_item_key;
1312:
1313: exception

Line 2297: from wf_items wi,

2293: wi.begin_date,
2294: wi.item_type,
2295: wi.end_date,
2296: wa.display_name process_name
2297: from wf_items wi,
2298: wf_item_types_vl wit,
2299: wf_activities_vl wa
2300: where wi.item_type = wit.name
2301: and wa.item_type = wi.item_type

Line 2796: l_child_item_list wf_monitor.wf_items_tbl_type;

2792: x_nls_lang VARCHAR2
2793: ) is
2794:
2795: username varchar2(320);
2796: l_child_item_list wf_monitor.wf_items_tbl_type;
2797: l_number_of_children NUMBER :=0;
2798: begin
2799:
2800: /*

Line 3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it

3093: -- do the fetch here.
3094: -- This is to avoid sending spaces throught web server
3095: select i.begin_date, i.end_date, a.display_name, it.display_name, i.root_activity
3096: into x_begin_date, x_end_date, proc_dispname, item_type_dispname, x_root_activity
3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it
3098: where i.item_type = x_item_type
3099: and i.item_key = x_item_key
3100: and i.item_type = it.name
3101: and i.root_activity = a.name

Line 3115: select user_key into u_key from wf_items

3111: status_flag := 'FNDIDONE.gif';
3112: end if;
3113:
3114: -- Get User Key
3115: select user_key into u_key from wf_items
3116: where item_type=x_item_type and item_key = x_item_key;
3117: if u_key is null then
3118: u_key := x_item_key;
3119: end if;

Line 4044: wf_items i

4040: from wf_item_activity_statuses ias,
4041: wf_process_activities pa,
4042: wf_activities_vl ac,
4043: wf_activities_vl ap,
4044: wf_items i
4045: where ias.item_type = c_item_type
4046: and ias.item_key = c_item_key
4047: and ias.activity_status = 'ERROR'
4048: and ias.process_activity = pa.instance_id

Line 4140: p_child_item_list OUT NOCOPY wf_monitor.wf_items_tbl_type,

4136:
4137: procedure get_process_children (
4138: p_parent_item_type IN VARCHAR2,
4139: p_parent_item_key IN VARCHAR2,
4140: p_child_item_list OUT NOCOPY wf_monitor.wf_items_tbl_type,
4141: p_number_of_children OUT NOCOPY NUMBER) IS
4142:
4143: cursor c_get_process_children IS
4144: SELECT item_type,

Line 4152: FROM wf_items

4148: user_key,
4149: owner_role,
4150: begin_date,
4151: end_date
4152: FROM wf_items
4153: WHERE parent_item_type = p_parent_item_type
4154: AND parent_item_key = p_parent_item_key;
4155:
4156: l_record_num NUMBER := 0;

Line 4202: l_child_item_list wf_monitor.wf_items_tbl_type;

4198: p_nls_lang IN VARCHAR2) IS
4199:
4200: username VARCHAR2(320);
4201: access_key VARCHAR2(240);
4202: l_child_item_list wf_monitor.wf_items_tbl_type;
4203: l_number_of_children NUMBER :=0;
4204: l_record_num NUMBER := 0;
4205: ii NUMBER := 0;
4206: l_indent_str VARCHAR2(240) := NULL;