APPS.OE_UPGRADE_WF dependencies on DUAL

Line 782: FROM dual;

778: null;
779: WHEN NO_DATA_FOUND THEN
780: SELECT wf_process_activities_s.nextval
781: INTO v_instance_id
782: FROM dual;
783:
784: -- dbms_output.put_line('will be loading the Pr.Act. ');
785: v_error_level := 2142;
786: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 1022: FROM dual;

1018: to_Char(v_group_number);
1019:
1020: SELECT wf_process_activities_s.nextval
1021: INTO v_last_instance_id
1022: FROM dual;
1023:
1024: -- dbms_output.put_line('In the stage 7.1..');
1025: -- dbms_output.put_line(v_process_name||'- 1 '||v_instance_label
1026: -- ||'- '||to_char(v_last_instance_id));

Line 1371: FROM dual;

1367: SELECT
1368: wf_process_activities_s.nextval
1369: INTO
1370: v_instance_id
1371: FROM dual;
1372:
1373: -- dbms_output.put_line('seq okay');
1374:
1375: wf_load.upload_process_activity

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

1600: IF v_check_duplicate_flag = 'N' THEN
1601: v_error_level := 2075;
1602: -- dbms_output.put_line('duplicate - 002');
1603:
1604: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1605:
1606: -- dbms_output.put_line('before insertion of activity:='
1607: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1608:

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

1732: and process_name = v_lin_process_name
1733: and instance_label = 'ENTER';
1734: exception
1735: when no_data_found then
1736: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1737: wf_load.upload_process_activity
1738: (
1739: x_process_item_type => 'OEOL',
1740: x_process_name => v_lin_process_name,

Line 1928: FROM dual;

1924: WHERE cycle_action_id = c2.cycle_action_id;
1925:
1926: SELECT wf_process_activities_s.nextval
1927: INTO v_last_instance_id
1928: FROM dual;
1929:
1930: v_api_error_level := 0;
1931:
1932: -- dbms_output.put_line('Stage 2');

Line 2595: from dual;

2591: -- upload the configuration_line subprocess
2592:
2593: select wf_process_activities_s.nextval
2594: into v_new_instance_id
2595: from dual;
2596:
2597: WF_LOAD.UPLOAD_PROCESS_ACTIVITY ( x_process_item_type => 'OEOL',
2598: x_process_name => 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id),
2599: x_process_version => 1,

Line 2737: FROM dual;

2733:
2734:
2735: SELECT wf_process_activities_s.nextval
2736: INTO v_and_instance_id1
2737: FROM dual;
2738:
2739: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2740: x_process_item_type => 'OEOL',
2741: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 2796: FROM dual;

2792:
2793:
2794: SELECT wf_process_activities_s.nextval
2795: INTO v_and_instance_id2
2796: FROM dual;
2797:
2798: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2799: x_process_item_type => 'OEOL',
2800: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 2850: FROM dual;

2846: order by process_version desc;
2847:
2848: SELECT wf_process_activities_s.nextval
2849: INTO v_get_category_instance_id
2850: FROM dual;
2851:
2852: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2853: x_process_item_type => 'OEOL',
2854: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),

Line 2987: FROM dual;

2983:
2984: IF v_transitions < v_lookup_count THEN -- some transitions are missing
2985: SELECT wf_process_activities_s.nextval
2986: INTO v_instance_id
2987: FROM dual;
2988:
2989: wf_load.upload_process_activity
2990: (
2991: x_process_item_type => p_item_type,

Line 3455: FROM dual;

3451: IF v_end_found_flag = 'N' THEN
3452: v_error_level := 2162;
3453: SELECT wf_process_activities_s.nextval
3454: INTO v_and_activity_id
3455: FROM dual;
3456:
3457: v_error_level := 2163;
3458: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3459: x_process_item_type => c2.process_item_type,

Line 4136: from dual;

4132:
4133: -- dbms_output.put_line('033');
4134: select
4135: wf_process_activities_s.nextval into v_instance_id
4136: from dual;
4137:
4138: -- dbms_output.put_line('043');
4139: v_api_error_code := 0;
4140:

Line 4181: from dual;

4177: /* Insert process activity OR - */
4178:
4179: select
4180: wf_process_activities_s.nextval into v_or_instance_id
4181: from dual;
4182:
4183: -- dbms_output.put_line('073');
4184: v_activity_name := 'OR';
4185:

Line 4237: from dual;

4233:
4234: for c4 in c3 loop
4235: /* for the same result_code from the PreNot and the Not, go to the OR-n */
4236: select wf_process_activities_s.nextval into v_or_instance_id2
4237: from dual;
4238:
4239: v_activity_name := 'OR';
4240:
4241: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (