eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_UPGRADE_WF2 dependencies on OE_UPGRADE_WF2

Line 1: PACKAGE BODY OE_UPGRADE_WF2 as

1: PACKAGE BODY OE_UPGRADE_WF2 as
2: /* $Header: OEXIUWUB.pls 120.0 2005/06/01 01:02:04 appldev noship $ */
3:
4: PROCEDURE Get_Pre_Activity
5: (

Line 2117: oe_upgrade_wf2.insert_into_wf_table

2113:
2114: v_error_level := 2092;
2115: -- dbms_output.put_line('======================='||to_char(v_error_level));
2116: /* Insert INTO table wf_activity_transitions */
2117: oe_upgrade_wf2.insert_into_wf_table
2118: ( v_from_instance_id,
2119: v_to_instance_id,
2120: v_result_code,
2121: v_level_error

Line 2133: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2129: FOR c4 in c3 LOOP
2130: v_error_level := 2093;
2131: -- dbms_output.put_line('======================='||to_char(v_error_level));
2132: -- dbms_output.put_line('#######################'||c4.act_name_t);
2133: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2134: ('UPG_PN_'||p_item_type||'_'||p_line_type
2135: ||'_'||to_char(c2.cycle_id),
2136: c4.act_name_t,
2137: c4.instance_label);

Line 2149: oe_upgrade_wf2.get_pre_activity(c4.action_id_c3,c4.act_seq,

2145: ELSE
2146: v_error_level := 2095;
2147: -- dbms_output.put_line('======================='||to_char(v_error_level));
2148: -- dbms_output.put_line('#######################'||c4.act_seq);
2149: oe_upgrade_wf2.get_pre_activity(c4.action_id_c3,c4.act_seq,
2150: v_pre_activity,v_pre_result);
2151:
2152: v_error_level := 2096;
2153: -- dbms_output.put_line('======================='||to_char(v_error_level));

Line 2155: v_from_instance_id := oe_upgrade_wf2.get_instance_id

2151:
2152: v_error_level := 2096;
2153: -- dbms_output.put_line('======================='||to_char(v_error_level));
2154: -- dbms_output.put_line('#######################'||v_pre_activity);
2155: v_from_instance_id := oe_upgrade_wf2.get_instance_id
2156: ('UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(c2.cycle_id),
2157: v_pre_activity,
2158: v_pre_activity);
2159: v_result_code := v_pre_result;

Line 2167: oe_upgrade_wf2.insert_into_wf_table

2163: /* Insert into table wf_activity_transitions */
2164: v_error_level := 2097;
2165: -- dbms_output.put_line('======================='||to_char(v_error_level));
2166: -- dbms_output.put_line('************* 1 **************');
2167: oe_upgrade_wf2.insert_into_wf_table
2168: (
2169: v_from_instance_id,
2170: v_to_instance_id,
2171: v_result_code,

Line 2195: v_from_instance_id := oe_upgrade_wf2.get_instance_id

2191:
2192: v_error_level := 2101;
2193: -- dbms_output.put_line('======================='||to_char(v_error_level));
2194: -- dbms_output.put_line('*************** = '||c2.cycle_id||'__'||c6.act_name_f || 'label:'||c6.instance_label || ' ' || p_item_type || p_line_type || to_char(c2.cycle_id));
2195: v_from_instance_id := oe_upgrade_wf2.get_instance_id
2196: ( 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'
2197: ||to_char(c2.cycle_id),
2198: c6.act_name_f,
2199: c6.instance_label

Line 2211: v_post_activity := oe_upgrade_wf2.get_post_activity

2207: ELSE
2208: v_error_level := 2103;
2209: -- dbms_output.put_line('======================='||to_char(v_error_level));
2210: -- dbms_output.put_line('*************** = '||c6.act_seq);
2211: v_post_activity := oe_upgrade_wf2.get_post_activity
2212: (
2213: c6.action_id_c5,
2214: c6.act_seq
2215: );

Line 2220: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2216:
2217: v_error_level := 2104;
2218: -- dbms_output.put_line('======================='||to_char(v_error_level));
2219: -- dbms_output.put_line('*************** = '||v_post_activity);
2220: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2221: (
2222: 'UPG_PN_'||p_item_type||'_'
2223: ||p_line_type||'_'
2224: ||to_char(c2.cycle_id),

Line 2249: oe_upgrade_wf2.insert_into_wf_table

2245: v_result_code := '*';
2246: END;
2247: END IF;
2248:
2249: oe_upgrade_wf2.insert_into_wf_table
2250: (
2251: v_from_instance_id,
2252: v_to_instance_id,
2253: v_result_code,

Line 2281: v_from_instance_id := oe_upgrade_wf2.get_instance_id

2277:
2278: v_error_level := 2109;
2279: -- dbms_output.put_line('======================='||to_char(v_error_level));
2280: -- dbms_output.put_line('======================='||c6.act_name_f);
2281: v_from_instance_id := oe_upgrade_wf2.get_instance_id
2282: (
2283: c4.proc_name,
2284: c6.act_name_f,
2285: c6.instance_label

Line 2298: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2294: IF (c6.act_seq = 0 OR c6.act_seq = v_max_seq) THEN
2295: v_error_level := 2111;
2296: -- dbms_output.put_line('======================='||to_char(v_error_level));
2297: -- dbms_output.put_line('======================='||c4.act_name_t);
2298: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2299: (
2300: c4.proc_name,
2301: c4.act_name_t,
2302: c4.instance_label

Line 2310: v_post_activity := oe_upgrade_wf2.get_post_activity

2306: --dbms_output.put_line('c6.act_seq:' || to_char(c6.act_seq) || to_char(v_max_seq));
2307: --dbms_output.put_line('xxxx ' || c6.action_id_c5 || 'and c4 ' || c4.act_name_t);
2308: v_error_level := 2111;
2309: --dbms_output.put_line('======================='||to_char(v_error_level));
2310: v_post_activity := oe_upgrade_wf2.get_post_activity
2311: (
2312: c6.action_id_c5,
2313: c6.act_seq
2314: );

Line 2318: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2314: );
2315:
2316: v_error_level := 2112;
2317: --dbms_output.put_line('======================='||to_char(v_error_level));
2318: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2319: (
2320: c4.proc_name,
2321: v_post_activity,
2322: v_post_activity

Line 2346: oe_upgrade_wf2.insert_into_wf_table

2342: v_result_code := '*';
2343: END;
2344: END IF;
2345: -- dbms_output.put_line('from: ' || v_from_instance_id || 'to: ' || v_to_instance_id || ' result: ' || v_result_code);
2346: oe_upgrade_wf2.insert_into_wf_table
2347: (
2348: v_from_instance_id,
2349: v_to_instance_id,
2350: v_result_code,

Line 2357: v_from_instance_id := oe_upgrade_wf2.get_instance_id

2353: --dbms_output.put_line('sam: inserted ' || to_char(v_from_instance_id) || ' to ' || v_to_instance_id || ' result ' || v_result_code);
2354: --dbms_output.put_line('------- level_error'||v_level_error);
2355: END LOOP; /* for c6 in c5 ... */
2356: IF (c2.action_id = -1) THEN
2357: v_from_instance_id := oe_upgrade_wf2.get_instance_id
2358: ( 'UPG_PN_'||p_item_type||'_'
2359: || p_line_type||'_'
2360: || to_char(c2.cycle_id),
2361: 'START',

Line 2364: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2360: || to_char(c2.cycle_id),
2361: 'START',
2362: 'START'
2363: );
2364: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2365: (
2366: c4.proc_name,
2367: c4.act_name_t,
2368: c4.instance_label

Line 2373: oe_upgrade_wf2.insert_into_wf_table

2369: );
2370: /* Insert into table wf_activity_transitions */
2371: -- dbms_output.put_line('************* 5 **************');
2372: v_level_error := 21133;
2373: oe_upgrade_wf2.insert_into_wf_table
2374: (
2375: v_from_instance_id,
2376: v_to_instance_id,
2377: '*',

Line 2384: oe_upgrade_wf2.get_pre_activity

2380: END IF;
2381: ELSE
2382: v_error_level := 2114;
2383: /* it's not first activity on 'to' side */
2384: oe_upgrade_wf2.get_pre_activity
2385: (
2386: c4.action_id_c3,
2387: c4.act_seq,
2388: v_pre_activity,

Line 2393: v_from_instance_id := oe_upgrade_wf2.get_instance_id

2389: v_pre_result
2390: );
2391:
2392: v_error_level := 2115;
2393: v_from_instance_id := oe_upgrade_wf2.get_instance_id
2394: (
2395: 'UPG_PN_'||p_item_type||'_'
2396: ||p_line_type||'_'
2397: ||to_char(c2.cycle_id),

Line 2404: v_to_instance_id := oe_upgrade_wf2.get_instance_id

2400: );
2401:
2402: v_error_level := 2116;
2403: v_result_code := v_pre_result;
2404: v_to_instance_id := oe_upgrade_wf2.get_instance_id
2405: (
2406: c4.proc_name,
2407: c4.act_name_t,
2408: c4.instance_label

Line 2415: oe_upgrade_wf2.insert_into_wf_table

2411: v_error_level := 2117;
2412:
2413: /* Insert into table wf_activity_transitions */
2414: -- dbms_output.put_line('************* 5 **************');
2415: oe_upgrade_wf2.insert_into_wf_table
2416: (
2417: v_from_instance_id,
2418: v_to_instance_id,
2419: v_result_code,

Line 2505: oe_upgrade_wf2.insert_into_wf_table

2501:
2502: -- For the previous activity(s) , add the new transition
2503: For c4 in c3 loop
2504:
2505: oe_upgrade_wf2.insert_into_wf_table
2506: (
2507: c4.from_process_activity,
2508: v_to_instance_id,
2509: c4.result_code,

Line 2632: oe_upgrade_wf2.insert_into_wf_table

2628: );
2629:
2630: for c6 in c5 loop
2631: -- insert new transition to wf_activity_transition table
2632: oe_upgrade_wf2.insert_into_wf_table
2633: (
2634: c6.from_process_activity,
2635: v_new_instance_id,
2636: c6.result_code,

Line 2642: oe_upgrade_wf2.insert_into_wf_table

2638: );
2639: end loop;
2640:
2641: -- insert transition from shipping to mfg release
2642: oe_upgrade_wf2.insert_into_wf_table
2643: (
2644: v_mfg_shipping_instance_id,
2645: v_mfg_instance_id,
2646: 'UNRESERVE',

Line 2651: oe_upgrade_wf2.insert_into_wf_table

2647: v_level_error
2648: );
2649:
2650: -- insert transition from shipping to config line activity
2651: oe_upgrade_wf2.insert_into_wf_table
2652: (
2653: v_cfg_shipping_instance_id,
2654: v_new_instance_id,
2655: 'UNRESERVE',

Line 2663: oe_upgrade_wf2.insert_into_wf_table

2659:
2660: -- it may go out to multiple destinations while it should only come from 1
2661: -- place, as there are AND's and OR's for the inbound transition
2662: for c4 in c3 loop
2663: oe_upgrade_wf2.insert_into_wf_table
2664: (
2665: v_new_instance_id,
2666: c4.to_process_activity,
2667: '*',

Line 2775: oe_upgrade_wf2.insert_into_wf_table

2771: );
2772:
2773: for c4 in c3 loop
2774: -- transit from previous act to AND
2775: oe_upgrade_wf2.insert_into_wf_table
2776: ( c4.from_process_activity,
2777: v_and_instance_id1,
2778: c4.result_code,
2779: v_level_error

Line 2788: oe_upgrade_wf2.insert_into_wf_table

2784:
2785: end loop;
2786:
2787: -- transit from AND to UPG_SHIPPING_SUB
2788: oe_upgrade_wf2.insert_into_wf_table
2789: ( v_and_instance_id1,
2790: v_shipping_instance_id,
2791: '*',
2792: v_level_error

Line 2833: oe_upgrade_wf2.insert_into_wf_table

2829: x_level_error => v_api_error_level
2830: );
2831: for c6 in c5 loop
2832: -- transit from previous act to AND
2833: oe_upgrade_wf2.insert_into_wf_table
2834: ( c6.from_process_activity,
2835: v_and_instance_id2,
2836: c6.result_code,
2837: v_level_error

Line 2845: oe_upgrade_wf2.insert_into_wf_table

2841: and to_process_activity = v_rma_instance_id;
2842: end loop;
2843:
2844: -- transit from AND to UPG_RMA_RECEIVING_SUB
2845: oe_upgrade_wf2.insert_into_wf_table
2846: ( v_and_instance_id2,
2847: v_rma_instance_id,
2848: '*',
2849: v_level_error

Line 2886: oe_upgrade_wf2.insert_into_wf_table

2882: x_user_comment => null,
2883: x_level_error => v_api_error_level
2884: );
2885: -- transit from START to new activity
2886: oe_upgrade_wf2.insert_into_wf_table
2887: ( v_start_instance_id,
2888: v_get_category_instance_id,
2889: '*',
2890: v_level_error

Line 2893: oe_upgrade_wf2.insert_into_wf_table

2889: '*',
2890: v_level_error
2891: );
2892: -- transit from new activity to the 2 ANDs created earlier in procedure
2893: oe_upgrade_wf2.insert_into_wf_table
2894: ( v_get_category_instance_id,
2895: v_and_instance_id1,
2896: 'ORDER',
2897: v_level_error

Line 2899: oe_upgrade_wf2.insert_into_wf_table

2895: v_and_instance_id1,
2896: 'ORDER',
2897: v_level_error
2898: );
2899: oe_upgrade_wf2.insert_into_wf_table
2900: ( v_get_category_instance_id,
2901: v_and_instance_id2,
2902: 'RETURN',
2903: v_level_error

Line 2981: oe_upgrade_wf2.insert_into_wf_table

2977: and c.activity_name = b.activity_name )
2978: AND t.to_process_activity = b.instance_id;
2979:
2980:
2981: oe_upgrade_wf2.insert_into_wf_table
2982: (
2983: c2.from_process_activity,
2984: v_and_upg_close_instance_id,
2985: '*',

Line 3046: oe_upgrade_wf2.insert_into_wf_table

3042: x_effective_date => sysdate - 1,
3043: x_level_error => v_api_error_code
3044: );
3045:
3046: oe_upgrade_wf2.insert_into_wf_table
3047: (
3048: c2.from_process_activity,
3049: v_instance_id,
3050: '*',

Line 3053: oe_upgrade_wf2.insert_into_wf_table

3049: v_instance_id,
3050: '*',
3051: v_level_error
3052: );
3053: oe_upgrade_wf2.insert_into_wf_table
3054: (
3055: v_instance_id,
3056: c2.from_process_activity,
3057: '*',

Line 3120: v_instance_id := oe_upgrade_wf2.get_instance_id

3116:
3117: wf_core.session_level := 20;
3118: -- dbms_output.put_line('Entered program');
3119:
3120: v_instance_id := oe_upgrade_wf2.get_instance_id
3121: ('UPG_PN_OEOL'||'_'||p_line_type
3122: ||'_'||to_char(p_cycle_id),
3123: 'START',
3124: 'START');

Line 3129: oe_upgrade_wf2.insert_into_wf_table

3125: FOR c2 in c1 LOOP
3126:
3127: v_error_level := 2143;
3128: /* Insert into transtion table */
3129: oe_upgrade_wf2.insert_into_wf_table
3130: (
3131: v_instance_id,
3132: c2.from_process_activity,
3133: '*',

Line 3326: oe_upgrade_wf2.get_icon_x_value

3322:
3323: FOR c2 IN c1 LOOP
3324: v_error_level := 2152;
3325: v_flag := 'Y';
3326: oe_upgrade_wf2.get_icon_x_value
3327: (
3328: c2.icon,
3329: v_icon_row
3330: );

Line 3359: oe_upgrade_wf2.get_icon_x_value

3355: v_icon_col := 0;
3356: FOR c6 in c5 LOOP
3357: v_error_level := 2156;
3358: v_icon_x_value := 0;
3359: oe_upgrade_wf2.get_icon_x_value
3360: (
3361: c4.icon,
3362: v_icon_x_value
3363: );

Line 3603: OE_UPGRADE_WF2.Create_Lookup_Type('OEOH');

3599: --dbms_output.enable('999999999999');
3600:
3601: -- dbms_output.put_line('************* FLAG1 = '||v_error_flag);
3602: IF V_ERROR_FLAG = 'N' THEN
3603: OE_UPGRADE_WF2.Create_Lookup_Type('OEOH');
3604: COMMIT;
3605: END IF;
3606:
3607: -- dbms_output.put_line('************* FLAG2 = '||v_error_flag);

Line 3609: OE_UPGRADE_WF2.Create_Lookup_Type('OEOL');

3605: END IF;
3606:
3607: -- dbms_output.put_line('************* FLAG2 = '||v_error_flag);
3608: IF V_ERROR_FLAG = 'N' THEN
3609: OE_UPGRADE_WF2.Create_Lookup_Type('OEOL');
3610: COMMIT;
3611: END IF;
3612:
3613: -- dbms_output.put_line('************* FLAG3 = '||v_error_flag);

Line 3615: OE_UPGRADE_WF2.Create_Lookup_Code('OEOH');

3611: END IF;
3612:
3613: -- dbms_output.put_line('************* FLAG3 = '||v_error_flag);
3614: IF V_ERROR_FLAG = 'N' THEN
3615: OE_UPGRADE_WF2.Create_Lookup_Code('OEOH');
3616: COMMIT;
3617: END IF;
3618:
3619: -- dbms_output.put_line('************* FLAG4 = '||v_error_flag);

Line 3621: OE_UPGRADE_WF2.Create_Lookup_Code('OEOL');

3617: END IF;
3618:
3619: -- dbms_output.put_line('************* FLAG4 = '||v_error_flag);
3620: IF V_ERROR_FLAG = 'N' THEN
3621: OE_UPGRADE_WF2.Create_Lookup_Code('OEOL');
3622: COMMIT;
3623: END IF;
3624:
3625: -- dbms_output.put_line('************* FLAG5 = '||v_error_flag);

Line 3627: OE_UPGRADE_WF2.Create_activity_name('OEOH');

3623: END IF;
3624:
3625: -- dbms_output.put_line('************* FLAG5 = '||v_error_flag);
3626: IF V_ERROR_FLAG = 'N' THEN
3627: OE_UPGRADE_WF2.Create_activity_name('OEOH');
3628: COMMIT;
3629: END IF;
3630:
3631: -- dbms_output.put_line('************* FLAG6 = '||v_error_flag);

Line 3633: OE_UPGRADE_WF2.Create_activity_name('OEOL');

3629: END IF;
3630:
3631: -- dbms_output.put_line('************* FLAG6 = '||v_error_flag);
3632: IF V_ERROR_FLAG = 'N' THEN
3633: OE_UPGRADE_WF2.Create_activity_name('OEOL');
3634: COMMIT;
3635: END IF;
3636:
3637: for c4 in c3 loop

Line 3640: OE_UPGRADE_WF2.Create_process_name ('OEOH','REG',c4.cycle_id);

3636:
3637: for c4 in c3 loop
3638: --dbms_output.put_line('************* FLAG10 = '||v_error_flag);
3639: IF V_ERROR_FLAG = 'N' THEN
3640: OE_UPGRADE_WF2.Create_process_name ('OEOH','REG',c4.cycle_id);
3641: END IF;
3642:
3643: --dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3644: IF V_ERROR_FLAG = 'N' THEN

Line 3645: OE_UPGRADE_WF2.Create_process_name ('OEOL','REG',c4.cycle_id);

3641: END IF;
3642:
3643: --dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3644: IF V_ERROR_FLAG = 'N' THEN
3645: OE_UPGRADE_WF2.Create_process_name ('OEOL','REG',c4.cycle_id);
3646: END IF;
3647: --create an additional CFG flow for ATO config item
3648: --action 15 is manufacturing release
3649: BEGIN

Line 3665: OE_UPGRADE_WF2.Create_process_name ('OEOL','CFG',c4.cycle_id);

3661: v_error_message := 'Error occured in cycle: ' ||to_char(c4.cycle_id)
3662: ||' Checking for Config line. Oracle error:'||to_char(v_error_code);
3663: END;
3664: IF v_cfg_item = 'Y' THEN
3665: OE_UPGRADE_WF2.Create_process_name ('OEOL','CFG',c4.cycle_id);
3666: END IF;
3667: v_cfg_item := 'N';
3668:
3669: end loop;

Line 3677: OE_UPGRADE_WF2.Create_process_activity ('OEOH',c2.cycle_id,'REG');

3673: FOR c2 IN c1 LOOP
3674: V_ERROR_FLAG := 'N';
3675: -- dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3676: IF V_ERROR_FLAG = 'N' THEN
3677: OE_UPGRADE_WF2.Create_process_activity ('OEOH',c2.cycle_id,'REG');
3678: END IF;
3679:
3680: -- dbms_output.put_line('************* FLAG12 = '||v_error_flag);
3681: IF V_ERROR_FLAG = 'N' THEN

Line 3682: OE_UPGRADE_WF2.Create_activity_and ('OEOH','REG',c2.cycle_id);

3678: END IF;
3679:
3680: -- dbms_output.put_line('************* FLAG12 = '||v_error_flag);
3681: IF V_ERROR_FLAG = 'N' THEN
3682: OE_UPGRADE_WF2.Create_activity_and ('OEOH','REG',c2.cycle_id);
3683: END IF;
3684:
3685: BEGIN
3686: SELECT 'Y'

Line 3702: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'REG');

3698: ||' Checking for Config line. Oracle error:'||to_char(v_error_code);
3699: END;
3700: -- dbms_output.put_line('************* FLAG14 = '||v_error_flag);
3701: IF V_ERROR_FLAG = 'N' THEN
3702: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'REG');
3703: IF v_cfg_item = 'Y' THEN
3704: -- dbms_output.put_line('create process activity for cfg');
3705: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'CFG');
3706: END IF;

Line 3705: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'CFG');

3701: IF V_ERROR_FLAG = 'N' THEN
3702: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'REG');
3703: IF v_cfg_item = 'Y' THEN
3704: -- dbms_output.put_line('create process activity for cfg');
3705: OE_UPGRADE_WF2.Create_process_activity ('OEOL',c2.cycle_id,'CFG');
3706: END IF;
3707:
3708: END IF;
3709:

Line 3712: OE_UPGRADE_WF2.Create_activity_and ('OEOL','REG',c2.cycle_id);

3708: END IF;
3709:
3710: -- dbms_output.put_line('************* FLAG15 = '||v_error_flag);
3711: IF V_ERROR_FLAG = 'N' THEN
3712: OE_UPGRADE_WF2.Create_activity_and ('OEOL','REG',c2.cycle_id);
3713: IF v_cfg_item = 'Y' THEN
3714: -- dbms_output.put_line('create activity and for cfg ' || to_char(c2.cycle_id));
3715: OE_UPGRADE_WF2.Create_activity_and ('OEOL','CFG',c2.cycle_id);
3716: END IF;

Line 3715: OE_UPGRADE_WF2.Create_activity_and ('OEOL','CFG',c2.cycle_id);

3711: IF V_ERROR_FLAG = 'N' THEN
3712: OE_UPGRADE_WF2.Create_activity_and ('OEOL','REG',c2.cycle_id);
3713: IF v_cfg_item = 'Y' THEN
3714: -- dbms_output.put_line('create activity and for cfg ' || to_char(c2.cycle_id));
3715: OE_UPGRADE_WF2.Create_activity_and ('OEOL','CFG',c2.cycle_id);
3716: END IF;
3717: END IF;
3718:
3719: -- -2 is for ENTERED/PARTIAL for the line action

Line 3729: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'REG');

3725:
3726: -- dbms_output.put_line('************* FLAG16 = '||v_error_flag);
3727: IF V_ERROR_FLAG = 'N' THEN
3728: -- dbms_output.put_line('going in dependency');
3729: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'REG');
3730: IF v_cfg_item = 'Y' THEN
3731: -- dbms_output.put_line('create dependency for cfg ' || to_char(c2.cycle_id));
3732: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'CFG');
3733: END IF;

Line 3732: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'CFG');

3728: -- dbms_output.put_line('going in dependency');
3729: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'REG');
3730: IF v_cfg_item = 'Y' THEN
3731: -- dbms_output.put_line('create dependency for cfg ' || to_char(c2.cycle_id));
3732: OE_UPGRADE_WF2.Create_header_line_dependency (c2.cycle_id,'CFG');
3733: END IF;
3734: END IF;
3735:
3736: -- dbms_output.put_line('************* FLAG17 = '||v_error_flag);

Line 3738: OE_UPGRADE_WF2.Create_activity_or ('OEOH','REG',c2.cycle_id);

3734: END IF;
3735:
3736: -- dbms_output.put_line('************* FLAG17 = '||v_error_flag);
3737: IF V_ERROR_FLAG = 'N' THEN
3738: OE_UPGRADE_WF2.Create_activity_or ('OEOH','REG',c2.cycle_id);
3739: END IF;
3740:
3741: -- dbms_output.put_line('************* FLAG18 = '||v_error_flag);
3742: IF V_ERROR_FLAG = 'N' THEN

Line 3750: OE_UPGRADE_WF2.Create_activity_transition ('OEOH',c2.cycle_id,'REG');

3746: where action_id = 1
3747: and type = 'OEOH'
3748: and result_id in (5, 15);
3749:
3750: OE_UPGRADE_WF2.Create_activity_transition ('OEOH',c2.cycle_id,'REG');
3751: END IF;
3752:
3753: IF V_ERROR_FLAG = 'N' THEN
3754: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOH');

Line 3754: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOH');

3750: OE_UPGRADE_WF2.Create_activity_transition ('OEOH',c2.cycle_id,'REG');
3751: END IF;
3752:
3753: IF V_ERROR_FLAG = 'N' THEN
3754: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOH');
3755: END IF;
3756:
3757: -- dbms_output.put_line('************* FLAG19 = '||v_error_flag);
3758: IF V_ERROR_FLAG = 'N' THEN

Line 3759: OE_UPGRADE_WF2.Create_default_transition ('OEOH','REG',c2.cycle_id);

3755: END IF;
3756:
3757: -- dbms_output.put_line('************* FLAG19 = '||v_error_flag);
3758: IF V_ERROR_FLAG = 'N' THEN
3759: OE_UPGRADE_WF2.Create_default_transition ('OEOH','REG',c2.cycle_id);
3760: END IF;
3761:
3762: -- dbms_output.put_line('************* FLAG20 = '||v_error_flag);
3763: IF V_ERROR_FLAG = 'N' THEN

Line 3764: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'REG','OEOH');

3760: END IF;
3761:
3762: -- dbms_output.put_line('************* FLAG20 = '||v_error_flag);
3763: IF V_ERROR_FLAG = 'N' THEN
3764: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'REG','OEOH');
3765: END IF;
3766:
3767: -- dbms_output.put_line('************* FLAG21 = '||v_error_flag);
3768: IF V_ERROR_FLAG = 'N' THEN

Line 3769: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOH','REG',c2.cycle_id);

3765: END IF;
3766:
3767: -- dbms_output.put_line('************* FLAG21 = '||v_error_flag);
3768: IF V_ERROR_FLAG = 'N' THEN
3769: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOH','REG',c2.cycle_id);
3770: END IF;
3771:
3772: -- dbms_output.put_line('************* FLAG22 = '||v_error_flag);
3773: IF V_ERROR_FLAG = 'N' THEN

Line 3774: OE_UPGRADE_WF2.Create_activity_or ('OEOL','REG',c2.cycle_id);

3770: END IF;
3771:
3772: -- dbms_output.put_line('************* FLAG22 = '||v_error_flag);
3773: IF V_ERROR_FLAG = 'N' THEN
3774: OE_UPGRADE_WF2.Create_activity_or ('OEOL','REG',c2.cycle_id);
3775: IF v_cfg_item = 'Y' THEN
3776: --dbms_output.put_line('create activity or for cfg');
3777: OE_UPGRADE_WF2.Create_activity_or ('OEOL','CFG',c2.cycle_id);
3778: END IF;

Line 3777: OE_UPGRADE_WF2.Create_activity_or ('OEOL','CFG',c2.cycle_id);

3773: IF V_ERROR_FLAG = 'N' THEN
3774: OE_UPGRADE_WF2.Create_activity_or ('OEOL','REG',c2.cycle_id);
3775: IF v_cfg_item = 'Y' THEN
3776: --dbms_output.put_line('create activity or for cfg');
3777: OE_UPGRADE_WF2.Create_activity_or ('OEOL','CFG',c2.cycle_id);
3778: END IF;
3779: END IF;
3780:
3781:

Line 3785: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'REG');

3781:
3782:
3783: -- dbms_output.put_line('************* FLAG23 = '||v_error_flag);
3784: IF V_ERROR_FLAG = 'N' THEN
3785: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'REG');
3786: IF v_cfg_item = 'Y' THEN
3787: -- dbms_output.put_line('create activity transition for cfg');
3788: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');
3789: END IF;

Line 3788: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');

3784: IF V_ERROR_FLAG = 'N' THEN
3785: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'REG');
3786: IF v_cfg_item = 'Y' THEN
3787: -- dbms_output.put_line('create activity transition for cfg');
3788: OE_UPGRADE_WF2.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');
3789: END IF;
3790: END IF;
3791:
3792:

Line 3796: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOL');

3792:
3793:
3794: --dbms_output.put_line('************* FLAG23+ = '||v_error_flag);
3795: IF V_ERROR_FLAG = 'N' THEN
3796: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOL');
3797: IF v_cfg_item = 'Y' THEN
3798: --dbms_output.put_line('create notification for cfg');
3799: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'CFG','OEOL');
3800: END IF;

Line 3799: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'CFG','OEOL');

3795: IF V_ERROR_FLAG = 'N' THEN
3796: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'REG','OEOL');
3797: IF v_cfg_item = 'Y' THEN
3798: --dbms_output.put_line('create notification for cfg');
3799: OE_UPGRADE_WF2.Create_notification (c2.cycle_id,'CFG','OEOL');
3800: END IF;
3801: END IF;
3802:
3803: -- dbms_output.put_line('************* FLAG24 = '||v_error_flag|| ' cycle_id:' || to_char(c2.cycle_id));

Line 3805: OE_UPGRADE_WF2.Create_default_transition ('OEOL','REG',c2.cycle_id);

3801: END IF;
3802:
3803: -- dbms_output.put_line('************* FLAG24 = '||v_error_flag|| ' cycle_id:' || to_char(c2.cycle_id));
3804: IF V_ERROR_FLAG = 'N' THEN
3805: OE_UPGRADE_WF2.Create_default_transition ('OEOL','REG',c2.cycle_id);
3806: IF v_cfg_item = 'Y' THEN
3807: -- dbms_output.put_line('create default end for cfg');
3808: OE_UPGRADE_WF2.Create_default_transition ('OEOL','CFG',c2.cycle_id);
3809: END IF;

Line 3808: OE_UPGRADE_WF2.Create_default_transition ('OEOL','CFG',c2.cycle_id);

3804: IF V_ERROR_FLAG = 'N' THEN
3805: OE_UPGRADE_WF2.Create_default_transition ('OEOL','REG',c2.cycle_id);
3806: IF v_cfg_item = 'Y' THEN
3807: -- dbms_output.put_line('create default end for cfg');
3808: OE_UPGRADE_WF2.Create_default_transition ('OEOL','CFG',c2.cycle_id);
3809: END IF;
3810: END IF;
3811:
3812: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);

Line 3814: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'REG');

3810: END IF;
3811:
3812: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);
3813: IF V_ERROR_FLAG = 'N' THEN
3814: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'REG');
3815: IF v_cfg_item = 'Y' THEN
3816: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'CFG');
3817: END IF;
3818: END IF;

Line 3816: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'CFG');

3812: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);
3813: IF V_ERROR_FLAG = 'N' THEN
3814: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'REG');
3815: IF v_cfg_item = 'Y' THEN
3816: OE_UPGRADE_WF2.Create_line_start (c2.cycle_id,'CFG');
3817: END IF;
3818: END IF;
3819:
3820: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);

Line 3822: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'REG','OEOL');

3818: END IF;
3819:
3820: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);
3821: IF V_ERROR_FLAG = 'N' THEN
3822: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'REG','OEOL');
3823: IF v_cfg_item = 'Y' THEN
3824: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'CFG','OEOL');
3825: END IF;
3826: END IF;

Line 3824: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'CFG','OEOL');

3820: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);
3821: IF V_ERROR_FLAG = 'N' THEN
3822: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'REG','OEOL');
3823: IF v_cfg_item = 'Y' THEN
3824: OE_UPGRADE_WF2.Close_Open_End (c2.cycle_id,'CFG','OEOL');
3825: END IF;
3826: END IF;
3827:
3828: -- dbms_output.put_line('************* FLAG26+ = '||v_error_flag);

Line 3830: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'REG');

3826: END IF;
3827:
3828: -- dbms_output.put_line('************* FLAG26+ = '||v_error_flag);
3829: IF V_ERROR_FLAG = 'N' THEN
3830: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'REG');
3831: IF v_cfg_item = 'Y' THEN
3832: -- dbms_output.put_line('adjust ship confirm for cfg');
3833: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');
3834: END IF;

Line 3833: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');

3829: IF V_ERROR_FLAG = 'N' THEN
3830: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'REG');
3831: IF v_cfg_item = 'Y' THEN
3832: -- dbms_output.put_line('adjust ship confirm for cfg');
3833: OE_UPGRADE_WF2.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');
3834: END IF;
3835: END IF;
3836:
3837: -- dbms_output.put_line('************* FLAG26++ = '||v_error_flag);

Line 3841: OE_UPGRADE_WF2.ATO_Adjusting (c2.cycle_id);

3837: -- dbms_output.put_line('************* FLAG26++ = '||v_error_flag);
3838: IF V_ERROR_FLAG = 'N' THEN
3839: IF v_cfg_item = 'Y' THEN
3840: --dbms_output.put_line('adjust ato for cfg');
3841: OE_UPGRADE_WF2.ATO_Adjusting (c2.cycle_id);
3842: END IF;
3843: END IF;
3844:
3845: -- dbms_output.put_line('************* FLAG27 = '||v_error_flag);

Line 3847: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');

3843: END IF;
3844:
3845: -- dbms_output.put_line('************* FLAG27 = '||v_error_flag);
3846: IF V_ERROR_FLAG = 'N' THEN
3847: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3848: IF v_cfg_item = 'Y' THEN
3849: -- dbms_output.put_line('adjust ato for cfg');
3850: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3851: END IF;

Line 3850: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');

3846: IF V_ERROR_FLAG = 'N' THEN
3847: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3848: IF v_cfg_item = 'Y' THEN
3849: -- dbms_output.put_line('adjust ato for cfg');
3850: OE_UPGRADE_WF2.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3851: END IF;
3852: END IF;
3853:
3854: -- dbms_output.put_line('************* FLAG28 = '||v_error_flag);

Line 3857: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');

3853:
3854: -- dbms_output.put_line('************* FLAG28 = '||v_error_flag);
3855: -- adjust for multiple waits
3856: IF V_ERROR_FLAG = 'N' THEN
3857: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3858: IF v_cfg_item = 'Y' THEN
3859: --dbms_output.put_line('adjust ato for cfg');
3860: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3861: END IF;

Line 3860: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');

3856: IF V_ERROR_FLAG = 'N' THEN
3857: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3858: IF v_cfg_item = 'Y' THEN
3859: --dbms_output.put_line('adjust ato for cfg');
3860: OE_UPGRADE_WF2.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3861: END IF;
3862: END IF;
3863:
3864: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);

Line 3866: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);

3862: END IF;
3863:
3864: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);
3865: IF V_ERROR_FLAG = 'N' THEN
3866: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);
3867: IF v_cfg_item = 'Y' THEN
3868: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);
3869: END IF;
3870: END IF;

Line 3868: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);

3864: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);
3865: IF V_ERROR_FLAG = 'N' THEN
3866: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);
3867: IF v_cfg_item = 'Y' THEN
3868: OE_UPGRADE_WF2.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);
3869: END IF;
3870: END IF;
3871:
3872:

Line 4124: oe_upgrade_wf2.insert_into_wf_table

4120:
4121: for c6 in c5 loop
4122: -- dbms_output.put_line('093');
4123: /* Create transition between A to PreNotfn. */
4124: oe_upgrade_wf2.insert_into_wf_table
4125: (
4126: c6.from_process_activity,
4127: v_instance_id,
4128: c6.result_code,

Line 4174: oe_upgrade_wf2.insert_into_wf_table

4170: where from_process_activity = v_notn_instance_id
4171: and to_process_activity = c4.to_process_activity;
4172:
4173: /* point the PreNotification to this Or as well */
4174: oe_upgrade_wf2.insert_into_wf_table
4175: (
4176: v_instance_id,
4177: v_or_instance_id2,
4178: c4.result_code,

Line 4183: oe_upgrade_wf2.insert_into_wf_table

4179: v_level_error
4180: );
4181:
4182: /* From Or-2 to B(s) */
4183: oe_upgrade_wf2.insert_into_wf_table
4184: (
4185: v_or_instance_id2,
4186: c4.to_process_activity,
4187: '*',

Line 4196: oe_upgrade_wf2.insert_into_wf_table

4192: end loop;
4193: -- dbms_output.put_line('113');
4194: /* Create transition between Pre Notfn. to Or */
4195:
4196: oe_upgrade_wf2.insert_into_wf_table
4197: (
4198: v_instance_id,
4199: v_or_instance_id,
4200: '*',

Line 4208: oe_upgrade_wf2.insert_into_wf_table

4204:
4205: -- dbms_output.put_line('123');
4206: /* Create transition between OR to Notification */
4207:
4208: oe_upgrade_wf2.insert_into_wf_table
4209: (
4210: v_or_instance_id,
4211: c2.instance_id,
4212: '*',

Line 4221: oe_upgrade_wf2.insert_into_wf_table

4217: -- dbms_output.put_line('133');
4218: /* Create transition between Notification to OR for Not-processed code */
4219:
4220: if v_fyi_Flag = 'N' then
4221: oe_upgrade_wf2.insert_into_wf_table
4222: (
4223: c2.instance_id,
4224: v_or_instance_id,
4225: 'NOT_PROCESSED',

Line 4244: END OE_UPGRADE_WF2;

4240: --dbms_output.put_line('create_notification exception');
4241: v_error_flag := 'Y';
4242: End Create_Notification;
4243:
4244: END OE_UPGRADE_WF2;