APPS.OE_UPGRADE_WF dependencies on WF_ACTIVITIES

Line 173: FROM wf_activities

169:
170: BEGIN
171:
172: SELECT 'x' INTO v_dummy
173: FROM wf_activities
174: WHERE item_type = p_item_type
175: AND version = 1
176: AND name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id);
177:

Line 198: from wf_activities

194: /* check if already inserted */
195:
196: begin
197: select 'x' into v_dummy
198: from wf_activities
199: where item_Type = P_ITEM_TYPE
200: AND NAME = v_process_name
201: and version = v_version;
202: exception

Line 204: /* Insert data into WF_ACTIVITIES */

200: AND NAME = v_process_name
201: and version = v_version;
202: exception
203: when no_data_found then
204: /* Insert data into WF_ACTIVITIES */
205: wf_load.upload_activity (
206: x_item_type => p_item_type,
207: x_name => v_process_name,
208: x_display_name => v_display_name,

Line 504: FROM wf_activities

500: -- dbms_output.put_line('Starting : '||v_name);
501:
502: BEGIN
503: SELECT 'x' INTO v_dummy
504: FROM wf_activities
505: WHERE item_type = p_item_type
506: AND version = 1
507: AND name = c2.activity_name;
508:

Line 1249: FROM WF_ACTIVITIES

1245:
1246: IF v_book_flag = 'N' THEN
1247: BEGIN
1248: SELECT 0 INTO v_error_level
1249: FROM WF_ACTIVITIES
1250: WHERE NAME = v_hdr_activity_name
1251: AND ITEM_TYPE = 'OEOH'
1252: AND VERSION = 1;
1253: EXCEPTION

Line 1501: FROM WF_ACTIVITIES

1497:
1498: IF v_book_flag = 'N' THEN
1499: BEGIN
1500: SELECT 0 INTO v_error_level
1501: FROM WF_ACTIVITIES
1502: WHERE NAME = v_lin_activity_name
1503: AND ITEM_TYPE = 'OEOL'
1504: AND VERSION = 1;
1505: EXCEPTION

Line 2978: FROM wf_activities

2974: SELECT count(*)
2975: INTO v_lookup_count
2976: FROM wf_lookups
2977: WHERE lookup_type = (SELECT result_type
2978: FROM wf_activities
2979: WHERE name = c2.activity_name
2980: AND item_type = p_item_type
2981: AND rownum = 1);
2982:

Line 3998: wf_activities wa

3994: wa.name,
3995: wa.result_type
3996: from
3997: wf_process_activities wpa,
3998: wf_activities wa
3999: where wpa.activity_name = wa.name
4000: and wpa.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
4001: and wa.type = 'NOTICE';
4002: