[Home] [Help]
661: 1 process_version,
662: nvl(oemap.activity_item_type,p_item_type) activity_item_type,
663: nvl(oemap.activity_name,
664: 'UPG_AN_'||to_char(soac.action_id)) activity_name,
665: wf_process_activities_s.nextval instance_id,
666: nvl(oemap.activity_name,
667: 'UPG_ILN_'||to_char(sca.cycle_action_id)) instance_label,
668:
669: decode(nvl(oemap.activity_name,
802: EXCEPTION
803: WHEN TOO_MANY_ROWS THEN
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. ');
1030: v_group_number := c2.group_number;
1031: v_instance_label := 'AND_'||to_Char(v_cycle_action_id)||'_'||
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..');
1376:
1377: v_error_level := 2066;
1378: -- dbms_output.put_line('Stage D15 Flag = N');
1379: SELECT
1380: wf_process_activities_s.nextval
1381: INTO
1382: v_instance_id
1383: FROM dual;
1384:
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:
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,
1934: v_cycle_id
1935: FROM so_cycle_actions
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;
2604: order by process_version desc;
2605:
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',
2746: order by process_version desc;
2747:
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 (
2805: order by process_version desc;
2806:
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 (
2859: and activity_name = 'START'
2860: and rownum = 1
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 (
2996: AND rownum = 1);
2997:
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
3464: END;
3465:
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;
4039: );
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;
4084: -- dbms_output.put_line('063');
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';
4140:
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: