[Home] [Help]
656: 1 process_version,
657: nvl(oemap.activity_item_type,p_item_type) activity_item_type,
658: nvl(oemap.activity_name,
659: 'UPG_AN_'||to_char(soac.action_id)) activity_name,
660: wf_process_activities_s.nextval instance_id,
661: nvl(oemap.activity_name,
662: 'UPG_ILN_'||to_char(soac.action_id)) instance_label,
663:
664: decode(nvl(oemap.activity_name,
776: EXCEPTION
777: WHEN TOO_MANY_ROWS THEN
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. ');
1016: v_group_number := c2.group_number;
1017: v_instance_label := 'AND_'||to_Char(v_cycle_action_id)||'_'||
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..');
1364:
1365: v_error_level := 2066;
1366: -- dbms_output.put_line('Stage D15 Flag = N');
1367: SELECT
1368: wf_process_activities_s.nextval
1369: INTO
1370: v_instance_id
1371: FROM dual;
1372:
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:
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,
1922: v_cycle_id
1923: FROM so_cycle_actions
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;
2589: order by process_version desc;
2590:
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',
2731: order by process_version desc;
2732:
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 (
2790: order by process_version desc;
2791:
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 (
2844: and activity_name = 'START'
2845: and rownum = 1
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 (
2981: AND rownum = 1);
2982:
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
3449: END;
3450:
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;
4131: );
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;
4176: -- dbms_output.put_line('063');
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';
4232:
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: