APPS.OE_UPGRADE_WF2 dependencies on DUAL

Line 808: FROM dual;

804: null;
805: WHEN NO_DATA_FOUND THEN
806: SELECT wf_process_activities_s.nextval
807: INTO v_instance_id
808: FROM dual;
809:
810: -- dbms_output.put_line('will be loading the Pr.Act. ');
811: v_error_level := 2142;
812: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 1036: FROM dual;

1032: to_Char(v_group_number);
1033:
1034: SELECT wf_process_activities_s.nextval
1035: INTO v_last_instance_id
1036: FROM dual;
1037:
1038: -- dbms_output.put_line('In the stage 7.1..');
1039: -- dbms_output.put_line(v_process_name||'- 1 '||v_instance_label
1040: -- ||'- '||to_char(v_last_instance_id));

Line 1383: FROM dual;

1379: SELECT
1380: wf_process_activities_s.nextval
1381: INTO
1382: v_instance_id
1383: FROM dual;
1384:
1385: -- dbms_output.put_line('seq okay');
1386:
1387: wf_load.upload_process_activity

Line 1616: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;

1612: IF v_check_duplicate_flag = 'N' THEN
1613: v_error_level := 2075;
1614: -- dbms_output.put_line('duplicate - 002');
1615:
1616: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1617:
1618: -- dbms_output.put_line('before insertion of activity:='
1619: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1620:

Line 1748: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;

1744: and process_name = v_lin_process_name
1745: and instance_label = 'ENTER';
1746: exception
1747: when no_data_found then
1748: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1749: wf_load.upload_process_activity
1750: (
1751: x_process_item_type => 'OEOL',
1752: x_process_name => v_lin_process_name,

Line 1940: FROM dual;

1936: WHERE cycle_action_id = c2.cycle_action_id;
1937:
1938: SELECT wf_process_activities_s.nextval
1939: INTO v_last_instance_id
1940: FROM dual;
1941:
1942: v_api_error_level := 0;
1943:
1944: -- dbms_output.put_line('Stage 2');

Line 2610: from dual;

2606: -- upload the configuration_line subprocess
2607:
2608: select wf_process_activities_s.nextval
2609: into v_new_instance_id
2610: from dual;
2611:
2612: WF_LOAD.UPLOAD_PROCESS_ACTIVITY ( x_process_item_type => 'OEOL',
2613: x_process_name => 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id),
2614: x_process_version => 1,

Line 2752: FROM dual;

2748:
2749:
2750: SELECT wf_process_activities_s.nextval
2751: INTO v_and_instance_id1
2752: FROM dual;
2753:
2754: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2755: x_process_item_type => 'OEOL',
2756: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 2811: FROM dual;

2807:
2808:
2809: SELECT wf_process_activities_s.nextval
2810: INTO v_and_instance_id2
2811: FROM dual;
2812:
2813: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2814: x_process_item_type => 'OEOL',
2815: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 2865: FROM dual;

2861: order by process_version desc;
2862:
2863: SELECT wf_process_activities_s.nextval
2864: INTO v_get_category_instance_id
2865: FROM dual;
2866:
2867: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2868: x_process_item_type => 'OEOL',
2869: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 3002: FROM dual;

2998:
2999: IF v_transitions < v_lookup_count THEN -- some transitions are missing
3000: SELECT wf_process_activities_s.nextval
3001: INTO v_instance_id
3002: FROM dual;
3003:
3004: wf_load.upload_process_activity
3005: (
3006: x_process_item_type => p_item_type,

Line 3470: FROM dual;

3466: IF v_end_found_flag = 'N' THEN
3467: v_error_level := 2162;
3468: SELECT wf_process_activities_s.nextval
3469: INTO v_and_activity_id
3470: FROM dual;
3471:
3472: v_error_level := 2163;
3473: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3474: x_process_item_type => c2.process_item_type,

Line 4044: from dual;

4040:
4041: -- dbms_output.put_line('033');
4042: select
4043: wf_process_activities_s.nextval into v_instance_id
4044: from dual;
4045:
4046: -- dbms_output.put_line('043');
4047: v_api_error_code := 0;
4048:

Line 4089: from dual;

4085: /* Insert process activity OR - */
4086:
4087: select
4088: wf_process_activities_s.nextval into v_or_instance_id
4089: from dual;
4090:
4091: -- dbms_output.put_line('073');
4092: v_activity_name := 'OR';
4093:

Line 4145: from dual;

4141:
4142: for c4 in c3 loop
4143: /* for the same result_code from the PreNot and the Not, go to the OR-n */
4144: select wf_process_activities_s.nextval into v_or_instance_id2
4145: from dual;
4146:
4147: v_activity_name := 'OR';
4148:
4149: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (