APPS.OE_UPGRADE_WF2 dependencies on WF_ACTIVITIES

Line 178: FROM wf_activities

174:
175: BEGIN
176:
177: SELECT 'x' INTO v_dummy
178: FROM wf_activities
179: WHERE item_type = p_item_type
180: AND version = 1
181: AND name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id);
182:

Line 203: from wf_activities

199: /* check if already inserted */
200:
201: begin
202: select 'x' into v_dummy
203: from wf_activities
204: where item_Type = P_ITEM_TYPE
205: AND NAME = v_process_name
206: and version = v_version;
207: exception

Line 209: /* Insert data into WF_ACTIVITIES */

205: AND NAME = v_process_name
206: and version = v_version;
207: exception
208: when no_data_found then
209: /* Insert data into WF_ACTIVITIES */
210: wf_load.upload_activity (
211: x_item_type => p_item_type,
212: x_name => v_process_name,
213: x_display_name => v_display_name,

Line 509: FROM wf_activities

505: -- dbms_output.put_line('Starting : '||v_name);
506:
507: BEGIN
508: SELECT 'x' INTO v_dummy
509: FROM wf_activities
510: WHERE item_type = p_item_type
511: AND version = 1
512: AND name = c2.activity_name;
513:

Line 1261: FROM WF_ACTIVITIES

1257:
1258: IF v_book_flag = 'N' THEN
1259: BEGIN
1260: SELECT 0 INTO v_error_level
1261: FROM WF_ACTIVITIES
1262: WHERE NAME = v_hdr_activity_name
1263: AND ITEM_TYPE = 'OEOH'
1264: AND VERSION = 1;
1265: EXCEPTION

Line 1513: FROM WF_ACTIVITIES

1509:
1510: IF v_book_flag = 'N' THEN
1511: BEGIN
1512: SELECT 0 INTO v_error_level
1513: FROM WF_ACTIVITIES
1514: WHERE NAME = v_lin_activity_name
1515: AND ITEM_TYPE = 'OEOL'
1516: AND VERSION = 1;
1517: EXCEPTION

Line 2993: FROM wf_activities

2989: SELECT count(*)
2990: INTO v_lookup_count
2991: FROM wf_lookups
2992: WHERE lookup_type = (SELECT result_type
2993: FROM wf_activities
2994: WHERE name = c2.activity_name
2995: AND item_type = p_item_type
2996: AND rownum = 1);
2997:

Line 3906: wf_activities wa

3902: wa.name,
3903: wa.result_type
3904: from
3905: wf_process_activities wpa,
3906: wf_activities wa
3907: where wpa.activity_name = wa.name
3908: and wpa.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3909: and wa.type = 'NOTICE';
3910: