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_WF dependencies on OE_UPGRADE_WF

Line 1: PACKAGE BODY OE_UPGRADE_WF as

1: PACKAGE BODY OE_UPGRADE_WF as
2: /* $Header: OEXIUWFB.pls 115.35 2003/10/20 06:58:42 appldev ship $ */
3:
4: PROCEDURE Get_Pre_Activity
5: (

Line 22: FROM oe_upgrade_wf_act_map

18:
19: SELECT activity_name,activity_result
20: INTO v_pre_activity,
21: v_pre_result
22: FROM oe_upgrade_wf_act_map
23: WHERE activity_seq = p_sequence_id - 1
24: AND action_id = p_action_id;
25: END IF;
26:

Line 43: FROM oe_upgrade_wf_act_map

39:
40: BEGIN
41: SELECT activity_name
42: INTO r_post_activity_name
43: FROM oe_upgrade_wf_act_map
44: WHERE activity_seq = p_sequence_id + 1
45: AND action_id = p_action_id;
46:
47: RETURN (r_post_activity_name);

Line 266: oe_upgrade_wf_act_map U

262: 20 custom_level,
263: M.description description
264: FROM
265: so_actions M,
266: oe_upgrade_wf_act_map U
267: WHERE decode(M.result_table,'SO_HEADERS','OEOH',
268: 'SO_LINES','OEOL','ERROR') = p_item_type
269: AND M.action_id not in
270: ( SELECT name from oe_upgrade_wf_obs_codes

Line 270: ( SELECT name from oe_upgrade_wf_obs_codes

266: oe_upgrade_wf_act_map U
267: WHERE decode(M.result_table,'SO_HEADERS','OEOH',
268: 'SO_LINES','OEOL','ERROR') = p_item_type
269: AND M.action_id not in
270: ( SELECT name from oe_upgrade_wf_obs_codes
271: WHERE type = 'ACTION' )
272: AND M.action_id = U.action_id(+)
273: AND U.action_id is null;
274:

Line 346: oe_upgrade_wf_act_map U

342: FROM
343: so_actions SA,
344: so_action_results SAR,
345: so_results SR,
346: oe_upgrade_wf_act_map U
347: WHERE decode(SA.result_table,'SO_HEADERS','OEOH',
348: 'SO_LINES','OEOL','ERROR') = p_item_type
349: AND SA.action_id = SAR.action_id
350: AND SAR.result_id = SR.result_id

Line 352: ( SELECT name from oe_upgrade_wf_obs_codes

348: 'SO_LINES','OEOL','ERROR') = p_item_type
349: AND SA.action_id = SAR.action_id
350: AND SAR.result_id = SR.result_id
351: AND SR.result_id not in
352: ( SELECT name from oe_upgrade_wf_obs_codes
353: WHERE type = 'RESULT' )
354: AND SA.action_id = U.action_id (+)
355: AND U.action_id is null
356: GROUP BY

Line 456: oe_upgrade_wf_act_map U

452: result_column result_column,
453: sa.action_id action_id
454: FROM
455: so_actions SA,
456: oe_upgrade_wf_act_map U
457: WHERE SA.action_id = U.action_id(+)
458: AND U.action_id is null
459: AND SA.action_id not in
460: ( SELECT name from oe_upgrade_wf_obs_codes

Line 460: ( SELECT name from oe_upgrade_wf_obs_codes

456: oe_upgrade_wf_act_map U
457: WHERE SA.action_id = U.action_id(+)
458: AND U.action_id is null
459: AND SA.action_id not in
460: ( SELECT name from oe_upgrade_wf_obs_codes
461: WHERE type = 'ACTION' )
462: AND decode(result_table,'SO_HEADERS','OEOH',
463: 'SO_LINES','OEOL','ERROR') = p_item_type
464: AND sa.action_id in (select action_id from so_cycle_actions);

Line 674: oe_upgrade_wf_act_map oemap

670: soac.action_approval approval
671: FROM
672: so_cycle_actions sca,
673: so_actions soac,
674: oe_upgrade_wf_act_map oemap
675: WHERE sca.cycle_id = p_cycle_id
676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

Line 678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

674: oe_upgrade_wf_act_map oemap
675: WHERE sca.cycle_id = p_cycle_id
676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes

Line 680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

676: AND sca.action_id = soac.action_id
677: AND sca.action_id = oemap.action_id (+)
678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes
683: WHERE type = 'ACTION' )
684: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)

Line 682: ( SELECT name FROM oe_upgrade_wf_obs_codes

678: AND ( (soac.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
679: WHERE line_type in ( p_line_type , 'BOTH')) )
680: OR (soac.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
681: AND SOAC.action_id not in
682: ( SELECT name FROM oe_upgrade_wf_obs_codes
683: WHERE type = 'ACTION' )
684: AND ( sca.action_id in (SELECT action_id from so_action_pre_reqs)
685: OR sca.cycle_action_id in (SELECT cycle_action_id from so_action_pre_reqs))
686: AND decode(soac.result_table,'SO_HEADERS','OEOH',

Line 856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )

852: AND spr.cycle_action_id IN
853: (SELECT cycle_action_id FROM so_Cycle_actions
854: WHERE cycle_id = p_cycle_id
855: AND (cycle_id, p_item_type) in
856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )
857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'

Line 859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes

855: AND (cycle_id, p_item_type) in
856: (SELECT cycle_id, item_type FROM oe_upgrade_wf_vld_cyc ) )
857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'
861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
862: AND spr.action_id NOT IN
863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b

Line 861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )

857: AND decode(sa.result_table,'SO_HEADERS','OEOH','SO_LINES','OEOL','ERROR')=p_item_type
858: AND spr.result_id NOT IN
859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'
861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
862: AND spr.action_id NOT IN
863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b
864: WHERE type = 'ACTION'
865: AND a.action_id = b.name )

Line 863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b

859: ( SELECT result_id FROM so_results, oe_upgrade_wf_obs_codes
860: WHERE type ='RESULT'
861: AND so_results.result_id = oe_upgrade_wf_obs_codes.name )
862: AND spr.action_id NOT IN
863: ( SELECT action_id FROM so_actions a, oe_upgrade_wf_obs_codes b
864: WHERE type = 'ACTION'
865: AND a.action_id = b.name )
866: /* Transition from Pick Release and Backorder Release obsoleted */
867: AND spr.action_id NOT IN (2,4)

Line 885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

881: )
882: */
883: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )

Line 887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

883: AND ( SPR.ACTION_ID NOT IN (2,3,4,11,16) or
884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;

Line 888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map

884: (spr.action_id in (2,3,4,11,16) and sca.action_id not in (2,3,4,11,16)) )
885: AND ( (sa.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;
892:

Line 890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))

886: WHERE line_type in ( p_line_type , 'BOTH')) )
887: OR (sa.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
888: AND ( (sa2.action_id in (SELECT action_id FROM oe_upgrade_wf_act_map
889: WHERE line_type in ( p_line_type , 'BOTH')) )
890: OR (sa2.action_id not in (SELECT action_id FROM oe_upgrade_wf_act_map )))
891: ORDER BY spr.cycle_action_id, spr.group_number;
892:
893: v_cycle_action_id NUMBER;
894: v_cycle_id NUMBER;

Line 941: FROM oe_upgrade_wf_mulgrp_v

937:
938: v_mul_rec_grp_flag := null;
939:
940: SELECT 'Y' INTO v_mul_rec_grp_flag
941: FROM oe_upgrade_wf_mulgrp_v
942: WHERE cycle_action_id = c2.cycle_action_id
943: AND action_id = c2.action_id;
944: EXCEPTION
945: WHEN no_data_found THEN

Line 1162: FROM oe_upgrade_wf_act_map

1158: a.group_number
1159: FROM so_action_pre_reqs a, so_Cycle_actions b
1160: WHERE b.cycle_id = p_cycle_id
1161: AND ((a.action_id IN (SELECT action_id
1162: FROM oe_upgrade_wf_act_map
1163: WHERE line_type IN ( p_line_type , 'BOTH')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id

Line 1165: FROM oe_upgrade_wf_act_map )))

1161: AND ((a.action_id IN (SELECT action_id
1162: FROM oe_upgrade_wf_act_map
1163: WHERE line_type IN ( p_line_type , 'BOTH')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id

Line 1167: FROM oe_upgrade_wf_act_map

1163: WHERE line_type IN ( p_line_type , 'BOTH')) )
1164: OR (a.action_id NOT IN (SELECT action_id
1165: FROM oe_upgrade_wf_act_map )))
1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id
1170: FROM oe_upgrade_wf_act_map )))
1171: AND a.action_id IN

Line 1170: FROM oe_upgrade_wf_act_map )))

1166: AND ((b.action_id IN (SELECT action_id
1167: FROM oe_upgrade_wf_act_map
1168: WHERE line_type IN ( p_line_type , 'BOTH')) )
1169: OR (b.action_id NOT IN (SELECT action_id
1170: FROM oe_upgrade_wf_act_map )))
1171: AND a.action_id IN
1172: (SELECT action_id
1173: FROM so_actions
1174: WHERE result_table = 'SO_HEADERS'

Line 1175: AND (action_id = 1 or action_id not in (select action_id from oe_upgrade_wf_act_map)))

1171: AND a.action_id IN
1172: (SELECT action_id
1173: FROM so_actions
1174: WHERE result_table = 'SO_HEADERS'
1175: AND (action_id = 1 or action_id not in (select action_id from oe_upgrade_wf_act_map)))
1176: AND a.cycle_action_id IN
1177: (SELECT cycle_action_id
1178: FROM so_cycle_actions
1179: WHERE action_id in

Line 1189: FROM oe_upgrade_wf_vld_cyc ) );

1185: (SELECT cycle_action_id
1186: FROM so_Cycle_actions
1187: WHERE (cycle_id, 'OEOL') IN
1188: (SELECT cycle_id,item_type
1189: FROM oe_upgrade_wf_vld_cyc ) );
1190:
1191: CURSOR c3 IS
1192: SELECT
1193: pr.instance_id,

Line 2069: oe_upgrade_wf_act_map m

2065: 'UPG_ILN_'||to_char(a.action_id)) instance_label,
2066: nvl(m.activity_seq, 0) act_seq
2067: FROM so_actions a,
2068: so_cycle_actions ca,
2069: oe_upgrade_wf_act_map m
2070: WHERE ca.cycle_id = p_cycle_id
2071: AND ca.action_id = a.action_id
2072: AND ca.cycle_action_id = c2.cycle_action_id
2073: AND a.action_id = m.action_id(+)

Line 2085: oe_upgrade_wf_act_map m

2081: nvl(m.activity_name,
2082: 'UPG_ILN_'||to_char(a.action_id)) instance_label,
2083: nvl(m.activity_result,c2.result_code) act_result
2084: FROM so_actions a,
2085: oe_upgrade_wf_act_map m
2086: WHERE a.action_id = c2.action_id
2087: AND a.action_id = m.action_id(+)
2088: ORDER BY act_seq desc;
2089:

Line 2102: oe_upgrade_wf.insert_into_wf_table

2098:
2099: v_error_level := 2092;
2100: -- dbms_output.put_line('======================='||to_char(v_error_level));
2101: /* Insert INTO table wf_activity_transitions */
2102: oe_upgrade_wf.insert_into_wf_table
2103: ( v_from_instance_id,
2104: v_to_instance_id,
2105: v_result_code,
2106: v_level_error

Line 2118: v_to_instance_id := oe_upgrade_wf.get_instance_id

2114: FOR c4 in c3 LOOP
2115: v_error_level := 2093;
2116: -- dbms_output.put_line('======================='||to_char(v_error_level));
2117: -- dbms_output.put_line('#######################'||c4.act_name_t);
2118: v_to_instance_id := oe_upgrade_wf.get_instance_id
2119: ('UPG_PN_'||p_item_type||'_'||p_line_type
2120: ||'_'||to_char(c2.cycle_id),
2121: c4.act_name_t,
2122: c4.instance_label);

Line 2134: oe_upgrade_wf.get_pre_activity(c4.action_id_c3,c4.act_seq,

2130: ELSE
2131: v_error_level := 2095;
2132: -- dbms_output.put_line('======================='||to_char(v_error_level));
2133: -- dbms_output.put_line('#######################'||c4.act_seq);
2134: oe_upgrade_wf.get_pre_activity(c4.action_id_c3,c4.act_seq,
2135: v_pre_activity,v_pre_result);
2136:
2137: v_error_level := 2096;
2138: -- dbms_output.put_line('======================='||to_char(v_error_level));

Line 2140: v_from_instance_id := oe_upgrade_wf.get_instance_id

2136:
2137: v_error_level := 2096;
2138: -- dbms_output.put_line('======================='||to_char(v_error_level));
2139: -- dbms_output.put_line('#######################'||v_pre_activity);
2140: v_from_instance_id := oe_upgrade_wf.get_instance_id
2141: ('UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(c2.cycle_id),
2142: v_pre_activity,
2143: v_pre_activity);
2144: v_result_code := v_pre_result;

Line 2152: oe_upgrade_wf.insert_into_wf_table

2148: /* Insert into table wf_activity_transitions */
2149: v_error_level := 2097;
2150: -- dbms_output.put_line('======================='||to_char(v_error_level));
2151: -- dbms_output.put_line('************* 1 **************');
2152: oe_upgrade_wf.insert_into_wf_table
2153: (
2154: v_from_instance_id,
2155: v_to_instance_id,
2156: v_result_code,

Line 2173: FROM oe_upgrade_wf_act_map

2169: -- dbms_output.put_line('======================='||to_char(v_error_level));
2170: IF c6.act_seq <> 0 THEN
2171: SELECT max(activity_seq)
2172: INTO v_max_seq
2173: FROM oe_upgrade_wf_act_map
2174: WHERE action_id = c6.action_id_c5;
2175: END IF;
2176:
2177: v_error_level := 2101;

Line 2180: v_from_instance_id := oe_upgrade_wf.get_instance_id

2176:
2177: v_error_level := 2101;
2178: -- dbms_output.put_line('======================='||to_char(v_error_level));
2179: -- 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));
2180: v_from_instance_id := oe_upgrade_wf.get_instance_id
2181: ( 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'
2182: ||to_char(c2.cycle_id),
2183: c6.act_name_f,
2184: c6.instance_label

Line 2196: v_post_activity := oe_upgrade_wf.get_post_activity

2192: ELSE
2193: v_error_level := 2103;
2194: -- dbms_output.put_line('======================='||to_char(v_error_level));
2195: -- dbms_output.put_line('*************** = '||c6.act_seq);
2196: v_post_activity := oe_upgrade_wf.get_post_activity
2197: (
2198: c6.action_id_c5,
2199: c6.act_seq
2200: );

Line 2205: v_to_instance_id := oe_upgrade_wf.get_instance_id

2201:
2202: v_error_level := 2104;
2203: -- dbms_output.put_line('======================='||to_char(v_error_level));
2204: -- dbms_output.put_line('*************** = '||v_post_activity);
2205: v_to_instance_id := oe_upgrade_wf.get_instance_id
2206: (
2207: 'UPG_PN_'||p_item_type||'_'
2208: ||p_line_type||'_'
2209: ||to_char(c2.cycle_id),

Line 2234: oe_upgrade_wf.insert_into_wf_table

2230: v_result_code := '*';
2231: END;
2232: END IF;
2233:
2234: oe_upgrade_wf.insert_into_wf_table
2235: (
2236: v_from_instance_id,
2237: v_to_instance_id,
2238: v_result_code,

Line 2259: FROM oe_upgrade_wf_act_map

2255: FOR c6 IN c5 LOOP
2256: IF c6.act_seq <> 0 THEN
2257: SELECT max(activity_seq)
2258: INTO v_max_seq
2259: FROM oe_upgrade_wf_act_map
2260: WHERE action_id = c6.action_id_c5;
2261: END IF;
2262:
2263: v_error_level := 2109;

Line 2266: v_from_instance_id := oe_upgrade_wf.get_instance_id

2262:
2263: v_error_level := 2109;
2264: -- dbms_output.put_line('======================='||to_char(v_error_level));
2265: -- dbms_output.put_line('======================='||c6.act_name_f);
2266: v_from_instance_id := oe_upgrade_wf.get_instance_id
2267: (
2268: c4.proc_name,
2269: c6.act_name_f,
2270: c6.instance_label

Line 2283: v_to_instance_id := oe_upgrade_wf.get_instance_id

2279: IF (c6.act_seq = 0 OR c6.act_seq = v_max_seq) THEN
2280: v_error_level := 2111;
2281: -- dbms_output.put_line('======================='||to_char(v_error_level));
2282: -- dbms_output.put_line('======================='||c4.act_name_t);
2283: v_to_instance_id := oe_upgrade_wf.get_instance_id
2284: (
2285: c4.proc_name,
2286: c4.act_name_t,
2287: c4.instance_label

Line 2295: v_post_activity := oe_upgrade_wf.get_post_activity

2291: --dbms_output.put_line('c6.act_seq:' || to_char(c6.act_seq) || to_char(v_max_seq));
2292: --dbms_output.put_line('xxxx ' || c6.action_id_c5 || 'and c4 ' || c4.act_name_t);
2293: v_error_level := 2111;
2294: --dbms_output.put_line('======================='||to_char(v_error_level));
2295: v_post_activity := oe_upgrade_wf.get_post_activity
2296: (
2297: c6.action_id_c5,
2298: c6.act_seq
2299: );

Line 2303: v_to_instance_id := oe_upgrade_wf.get_instance_id

2299: );
2300:
2301: v_error_level := 2112;
2302: --dbms_output.put_line('======================='||to_char(v_error_level));
2303: v_to_instance_id := oe_upgrade_wf.get_instance_id
2304: (
2305: c4.proc_name,
2306: v_post_activity,
2307: v_post_activity

Line 2331: oe_upgrade_wf.insert_into_wf_table

2327: v_result_code := '*';
2328: END;
2329: END IF;
2330: -- dbms_output.put_line('from: ' || v_from_instance_id || 'to: ' || v_to_instance_id || ' result: ' || v_result_code);
2331: oe_upgrade_wf.insert_into_wf_table
2332: (
2333: v_from_instance_id,
2334: v_to_instance_id,
2335: v_result_code,

Line 2342: v_from_instance_id := oe_upgrade_wf.get_instance_id

2338: --dbms_output.put_line('sam: inserted ' || to_char(v_from_instance_id) || ' to ' || v_to_instance_id || ' result ' || v_result_code);
2339: --dbms_output.put_line('------- level_error'||v_level_error);
2340: END LOOP; /* for c6 in c5 ... */
2341: IF (c2.action_id = -1) THEN
2342: v_from_instance_id := oe_upgrade_wf.get_instance_id
2343: ( 'UPG_PN_'||p_item_type||'_'
2344: || p_line_type||'_'
2345: || to_char(c2.cycle_id),
2346: 'START',

Line 2349: v_to_instance_id := oe_upgrade_wf.get_instance_id

2345: || to_char(c2.cycle_id),
2346: 'START',
2347: 'START'
2348: );
2349: v_to_instance_id := oe_upgrade_wf.get_instance_id
2350: (
2351: c4.proc_name,
2352: c4.act_name_t,
2353: c4.instance_label

Line 2358: oe_upgrade_wf.insert_into_wf_table

2354: );
2355: /* Insert into table wf_activity_transitions */
2356: -- dbms_output.put_line('************* 5 **************');
2357: v_level_error := 21133;
2358: oe_upgrade_wf.insert_into_wf_table
2359: (
2360: v_from_instance_id,
2361: v_to_instance_id,
2362: '*',

Line 2369: oe_upgrade_wf.get_pre_activity

2365: END IF;
2366: ELSE
2367: v_error_level := 2114;
2368: /* it's not first activity on 'to' side */
2369: oe_upgrade_wf.get_pre_activity
2370: (
2371: c4.action_id_c3,
2372: c4.act_seq,
2373: v_pre_activity,

Line 2378: v_from_instance_id := oe_upgrade_wf.get_instance_id

2374: v_pre_result
2375: );
2376:
2377: v_error_level := 2115;
2378: v_from_instance_id := oe_upgrade_wf.get_instance_id
2379: (
2380: 'UPG_PN_'||p_item_type||'_'
2381: ||p_line_type||'_'
2382: ||to_char(c2.cycle_id),

Line 2389: v_to_instance_id := oe_upgrade_wf.get_instance_id

2385: );
2386:
2387: v_error_level := 2116;
2388: v_result_code := v_pre_result;
2389: v_to_instance_id := oe_upgrade_wf.get_instance_id
2390: (
2391: c4.proc_name,
2392: c4.act_name_t,
2393: c4.instance_label

Line 2400: oe_upgrade_wf.insert_into_wf_table

2396: v_error_level := 2117;
2397:
2398: /* Insert into table wf_activity_transitions */
2399: -- dbms_output.put_line('************* 5 **************');
2400: oe_upgrade_wf.insert_into_wf_table
2401: (
2402: v_from_instance_id,
2403: v_to_instance_id,
2404: v_result_code,

Line 2490: oe_upgrade_wf.insert_into_wf_table

2486:
2487: -- For the previous activity(s) , add the new transition
2488: For c4 in c3 loop
2489:
2490: oe_upgrade_wf.insert_into_wf_table
2491: (
2492: c4.from_process_activity,
2493: v_to_instance_id,
2494: c4.result_code,

Line 2617: oe_upgrade_wf.insert_into_wf_table

2613: );
2614:
2615: for c6 in c5 loop
2616: -- insert new transition to wf_activity_transition table
2617: oe_upgrade_wf.insert_into_wf_table
2618: (
2619: c6.from_process_activity,
2620: v_new_instance_id,
2621: c6.result_code,

Line 2627: oe_upgrade_wf.insert_into_wf_table

2623: );
2624: end loop;
2625:
2626: -- insert transition from shipping to mfg release
2627: oe_upgrade_wf.insert_into_wf_table
2628: (
2629: v_mfg_shipping_instance_id,
2630: v_mfg_instance_id,
2631: 'UNRESERVE',

Line 2636: oe_upgrade_wf.insert_into_wf_table

2632: v_level_error
2633: );
2634:
2635: -- insert transition from shipping to config line activity
2636: oe_upgrade_wf.insert_into_wf_table
2637: (
2638: v_cfg_shipping_instance_id,
2639: v_new_instance_id,
2640: 'UNRESERVE',

Line 2648: oe_upgrade_wf.insert_into_wf_table

2644:
2645: -- it may go out to multiple destinations while it should only come from 1
2646: -- place, as there are AND's and OR's for the inbound transition
2647: for c4 in c3 loop
2648: oe_upgrade_wf.insert_into_wf_table
2649: (
2650: v_new_instance_id,
2651: c4.to_process_activity,
2652: '*',

Line 2760: oe_upgrade_wf.insert_into_wf_table

2756: );
2757:
2758: for c4 in c3 loop
2759: -- transit from previous act to AND
2760: oe_upgrade_wf.insert_into_wf_table
2761: ( c4.from_process_activity,
2762: v_and_instance_id1,
2763: c4.result_code,
2764: v_level_error

Line 2773: oe_upgrade_wf.insert_into_wf_table

2769:
2770: end loop;
2771:
2772: -- transit from AND to UPG_SHIPPING_SUB
2773: oe_upgrade_wf.insert_into_wf_table
2774: ( v_and_instance_id1,
2775: v_shipping_instance_id,
2776: '*',
2777: v_level_error

Line 2818: oe_upgrade_wf.insert_into_wf_table

2814: x_level_error => v_api_error_level
2815: );
2816: for c6 in c5 loop
2817: -- transit from previous act to AND
2818: oe_upgrade_wf.insert_into_wf_table
2819: ( c6.from_process_activity,
2820: v_and_instance_id2,
2821: c6.result_code,
2822: v_level_error

Line 2830: oe_upgrade_wf.insert_into_wf_table

2826: and to_process_activity = v_rma_instance_id;
2827: end loop;
2828:
2829: -- transit from AND to UPG_RMA_RECEIVING_SUB
2830: oe_upgrade_wf.insert_into_wf_table
2831: ( v_and_instance_id2,
2832: v_rma_instance_id,
2833: '*',
2834: v_level_error

Line 2871: oe_upgrade_wf.insert_into_wf_table

2867: x_user_comment => null,
2868: x_level_error => v_api_error_level
2869: );
2870: -- transit from START to new activity
2871: oe_upgrade_wf.insert_into_wf_table
2872: ( v_start_instance_id,
2873: v_get_category_instance_id,
2874: '*',
2875: v_level_error

Line 2878: oe_upgrade_wf.insert_into_wf_table

2874: '*',
2875: v_level_error
2876: );
2877: -- transit from new activity to the 2 ANDs created earlier in procedure
2878: oe_upgrade_wf.insert_into_wf_table
2879: ( v_get_category_instance_id,
2880: v_and_instance_id1,
2881: 'ORDER',
2882: v_level_error

Line 2884: oe_upgrade_wf.insert_into_wf_table

2880: v_and_instance_id1,
2881: 'ORDER',
2882: v_level_error
2883: );
2884: oe_upgrade_wf.insert_into_wf_table
2885: ( v_get_category_instance_id,
2886: v_and_instance_id2,
2887: 'RETURN',
2888: v_level_error

Line 2966: oe_upgrade_wf.insert_into_wf_table

2962: and c.activity_name = b.activity_name )
2963: AND t.to_process_activity = b.instance_id;
2964:
2965:
2966: oe_upgrade_wf.insert_into_wf_table
2967: (
2968: c2.from_process_activity,
2969: v_and_upg_close_instance_id,
2970: '*',

Line 3031: oe_upgrade_wf.insert_into_wf_table

3027: x_effective_date => sysdate - 1,
3028: x_level_error => v_api_error_code
3029: );
3030:
3031: oe_upgrade_wf.insert_into_wf_table
3032: (
3033: c2.from_process_activity,
3034: v_instance_id,
3035: '*',

Line 3038: oe_upgrade_wf.insert_into_wf_table

3034: v_instance_id,
3035: '*',
3036: v_level_error
3037: );
3038: oe_upgrade_wf.insert_into_wf_table
3039: (
3040: v_instance_id,
3041: c2.from_process_activity,
3042: '*',

Line 3105: v_instance_id := oe_upgrade_wf.get_instance_id

3101:
3102: wf_core.session_level := 20;
3103: -- dbms_output.put_line('Entered program');
3104:
3105: v_instance_id := oe_upgrade_wf.get_instance_id
3106: ('UPG_PN_OEOL'||'_'||p_line_type
3107: ||'_'||to_char(p_cycle_id),
3108: 'START',
3109: 'START');

Line 3114: oe_upgrade_wf.insert_into_wf_table

3110: FOR c2 in c1 LOOP
3111:
3112: v_error_level := 2143;
3113: /* Insert into transtion table */
3114: oe_upgrade_wf.insert_into_wf_table
3115: (
3116: v_instance_id,
3117: c2.from_process_activity,
3118: '*',

Line 3311: oe_upgrade_wf.get_icon_x_value

3307:
3308: FOR c2 IN c1 LOOP
3309: v_error_level := 2152;
3310: v_flag := 'Y';
3311: oe_upgrade_wf.get_icon_x_value
3312: (
3313: c2.icon,
3314: v_icon_row
3315: );

Line 3344: oe_upgrade_wf.get_icon_x_value

3340: v_icon_col := 0;
3341: FOR c6 in c5 LOOP
3342: v_error_level := 2156;
3343: v_icon_x_value := 0;
3344: oe_upgrade_wf.get_icon_x_value
3345: (
3346: c4.icon,
3347: v_icon_x_value
3348: );

Line 3640: AND cycle_id IN (select cycle_id from oe_upgrade_wf_vld_cyc);

3636: where p3.cycle_action_id = p2.cycle_action_id
3637: and p3.group_number = p2.group_number
3638: and p3.action_id = a1.action_id
3639: and a1.result_table = 'SO_HEADERS')))
3640: AND cycle_id IN (select cycle_id from oe_upgrade_wf_vld_cyc);
3641:
3642: cursor c3 is
3643: select cycle_id from so_cycles;
3644:

Line 3655: OE_UPGRADE_WF.Create_Lookup_Type('OEOH');

3651: --dbms_output.enable('999999999999');
3652:
3653: -- dbms_output.put_line('************* FLAG1 = '||v_error_flag);
3654: IF V_ERROR_FLAG = 'N' THEN
3655: OE_UPGRADE_WF.Create_Lookup_Type('OEOH');
3656: COMMIT;
3657: END IF;
3658:
3659: -- dbms_output.put_line('************* FLAG2 = '||v_error_flag);

Line 3661: OE_UPGRADE_WF.Create_Lookup_Type('OEOL');

3657: END IF;
3658:
3659: -- dbms_output.put_line('************* FLAG2 = '||v_error_flag);
3660: IF V_ERROR_FLAG = 'N' THEN
3661: OE_UPGRADE_WF.Create_Lookup_Type('OEOL');
3662: COMMIT;
3663: END IF;
3664:
3665: -- dbms_output.put_line('************* FLAG3 = '||v_error_flag);

Line 3667: OE_UPGRADE_WF.Create_Lookup_Code('OEOH');

3663: END IF;
3664:
3665: -- dbms_output.put_line('************* FLAG3 = '||v_error_flag);
3666: IF V_ERROR_FLAG = 'N' THEN
3667: OE_UPGRADE_WF.Create_Lookup_Code('OEOH');
3668: COMMIT;
3669: END IF;
3670:
3671: -- dbms_output.put_line('************* FLAG4 = '||v_error_flag);

Line 3673: OE_UPGRADE_WF.Create_Lookup_Code('OEOL');

3669: END IF;
3670:
3671: -- dbms_output.put_line('************* FLAG4 = '||v_error_flag);
3672: IF V_ERROR_FLAG = 'N' THEN
3673: OE_UPGRADE_WF.Create_Lookup_Code('OEOL');
3674: COMMIT;
3675: END IF;
3676:
3677: -- dbms_output.put_line('************* FLAG5 = '||v_error_flag);

Line 3679: OE_UPGRADE_WF.Create_activity_name('OEOH');

3675: END IF;
3676:
3677: -- dbms_output.put_line('************* FLAG5 = '||v_error_flag);
3678: IF V_ERROR_FLAG = 'N' THEN
3679: OE_UPGRADE_WF.Create_activity_name('OEOH');
3680: COMMIT;
3681: END IF;
3682:
3683: -- dbms_output.put_line('************* FLAG6 = '||v_error_flag);

Line 3685: OE_UPGRADE_WF.Create_activity_name('OEOL');

3681: END IF;
3682:
3683: -- dbms_output.put_line('************* FLAG6 = '||v_error_flag);
3684: IF V_ERROR_FLAG = 'N' THEN
3685: OE_UPGRADE_WF.Create_activity_name('OEOL');
3686: COMMIT;
3687: END IF;
3688:
3689: for c4 in c3 loop

Line 3692: OE_UPGRADE_WF.Create_process_name ('OEOH','REG',c4.cycle_id);

3688:
3689: for c4 in c3 loop
3690: --dbms_output.put_line('************* FLAG10 = '||v_error_flag);
3691: IF V_ERROR_FLAG = 'N' THEN
3692: OE_UPGRADE_WF.Create_process_name ('OEOH','REG',c4.cycle_id);
3693: END IF;
3694:
3695: --dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3696: IF V_ERROR_FLAG = 'N' THEN

Line 3697: OE_UPGRADE_WF.Create_process_name ('OEOL','REG',c4.cycle_id);

3693: END IF;
3694:
3695: --dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3696: IF V_ERROR_FLAG = 'N' THEN
3697: OE_UPGRADE_WF.Create_process_name ('OEOL','REG',c4.cycle_id);
3698: END IF;
3699: --create an additional CFG flow for ATO config item
3700: --action 15 is manufacturing release
3701: BEGIN

Line 3717: OE_UPGRADE_WF.Create_process_name ('OEOL','CFG',c4.cycle_id);

3713: v_error_message := 'Error occured in cycle: ' ||to_char(c4.cycle_id)
3714: ||' Checking for Config line. Oracle error:'||to_char(v_error_code);
3715: END;
3716: IF v_cfg_item = 'Y' THEN
3717: OE_UPGRADE_WF.Create_process_name ('OEOL','CFG',c4.cycle_id);
3718: END IF;
3719: v_cfg_item := 'N';
3720:
3721: end loop;

Line 3730: FROM oe_Upgrade_wf_vld_cyc

3726: V_ERROR_FLAG := 'N';
3727:
3728: BEGIN
3729: SELECT 'Y' INTO v_vld_hdr_flag
3730: FROM oe_Upgrade_wf_vld_cyc
3731: WHERE cycle_id = c2.cycle_id
3732: AND item_type = 'OEOH';
3733: EXCEPTION
3734: WHEN no_data_found THEN

Line 3744: FROM oe_Upgrade_wf_vld_cyc

3740: END;
3741:
3742: BEGIN
3743: SELECT 'Y' INTO v_vld_lin_flag
3744: FROM oe_Upgrade_wf_vld_cyc
3745: WHERE cycle_id = c2.cycle_id
3746: AND item_type = 'OEOL';
3747: EXCEPTION
3748: WHEN no_data_found THEN

Line 3758: OE_UPGRADE_WF.Create_process_activity ('OEOH',c2.cycle_id,'REG');

3754: END;
3755: IF v_vld_hdr_flag = 'Y' THEN
3756: -- dbms_output.put_line('************* FLAG11 = '||v_error_flag);
3757: IF V_ERROR_FLAG = 'N' THEN
3758: OE_UPGRADE_WF.Create_process_activity ('OEOH',c2.cycle_id,'REG');
3759: END IF;
3760:
3761: -- dbms_output.put_line('************* FLAG12 = '||v_error_flag);
3762: IF V_ERROR_FLAG = 'N' THEN

Line 3763: OE_UPGRADE_WF.Create_activity_and ('OEOH','REG',c2.cycle_id);

3759: END IF;
3760:
3761: -- dbms_output.put_line('************* FLAG12 = '||v_error_flag);
3762: IF V_ERROR_FLAG = 'N' THEN
3763: OE_UPGRADE_WF.Create_activity_and ('OEOH','REG',c2.cycle_id);
3764: END IF;
3765: END IF;
3766:
3767: IF v_vld_lin_flag = 'Y' THEN

Line 3785: OE_UPGRADE_WF.Create_process_activity ('OEOL',c2.cycle_id,'REG');

3781: ||' Checking for Config line. Oracle error:'||to_char(v_error_code);
3782: END;
3783: -- dbms_output.put_line('************* FLAG14 = '||v_error_flag);
3784: IF V_ERROR_FLAG = 'N' THEN
3785: OE_UPGRADE_WF.Create_process_activity ('OEOL',c2.cycle_id,'REG');
3786: IF v_cfg_item = 'Y' THEN
3787: -- dbms_output.put_line('create process activity for cfg');
3788: OE_UPGRADE_WF.Create_process_activity ('OEOL',c2.cycle_id,'CFG');
3789: END IF;

Line 3788: OE_UPGRADE_WF.Create_process_activity ('OEOL',c2.cycle_id,'CFG');

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

Line 3795: OE_UPGRADE_WF.Create_activity_and ('OEOL','REG',c2.cycle_id);

3791: END IF;
3792:
3793: -- dbms_output.put_line('************* FLAG15 = '||v_error_flag);
3794: IF V_ERROR_FLAG = 'N' THEN
3795: OE_UPGRADE_WF.Create_activity_and ('OEOL','REG',c2.cycle_id);
3796: IF v_cfg_item = 'Y' THEN
3797: -- dbms_output.put_line('create activity and for cfg ' || to_char(c2.cycle_id));
3798: OE_UPGRADE_WF.Create_activity_and ('OEOL','CFG',c2.cycle_id);
3799: END IF;

Line 3798: OE_UPGRADE_WF.Create_activity_and ('OEOL','CFG',c2.cycle_id);

3794: IF V_ERROR_FLAG = 'N' THEN
3795: OE_UPGRADE_WF.Create_activity_and ('OEOL','REG',c2.cycle_id);
3796: IF v_cfg_item = 'Y' THEN
3797: -- dbms_output.put_line('create activity and for cfg ' || to_char(c2.cycle_id));
3798: OE_UPGRADE_WF.Create_activity_and ('OEOL','CFG',c2.cycle_id);
3799: END IF;
3800: END IF;
3801:
3802: -- -2 is for ENTERED/PARTIAL for the line action

Line 3813: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'REG');

3809:
3810: -- dbms_output.put_line('************* FLAG16 = '||v_error_flag);
3811: IF V_ERROR_FLAG = 'N' THEN
3812: -- dbms_output.put_line('going in dependency');
3813: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'REG');
3814: IF v_cfg_item = 'Y' THEN
3815: -- dbms_output.put_line('create dependency for cfg ' || to_char(c2.cycle_id));
3816: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'CFG');
3817: END IF;

Line 3816: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'CFG');

3812: -- dbms_output.put_line('going in dependency');
3813: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'REG');
3814: IF v_cfg_item = 'Y' THEN
3815: -- dbms_output.put_line('create dependency for cfg ' || to_char(c2.cycle_id));
3816: OE_UPGRADE_WF.Create_header_line_dependency (c2.cycle_id,'CFG');
3817: END IF;
3818: END IF;
3819:
3820: -- dbms_output.put_line('************* FLAG17 = '||v_error_flag);

Line 3823: OE_UPGRADE_WF.Create_activity_or ('OEOH','REG',c2.cycle_id);

3819:
3820: -- dbms_output.put_line('************* FLAG17 = '||v_error_flag);
3821: IF v_vld_hdr_flag = 'Y' THEN
3822: IF V_ERROR_FLAG = 'N' THEN
3823: OE_UPGRADE_WF.Create_activity_or ('OEOH','REG',c2.cycle_id);
3824: END IF;
3825:
3826: -- dbms_output.put_line('************* FLAG18 = '||v_error_flag);
3827: IF V_ERROR_FLAG = 'N' THEN

Line 3835: OE_UPGRADE_WF.Create_activity_transition ('OEOH',c2.cycle_id,'REG');

3831: where action_id = 1
3832: and type = 'OEOH'
3833: and result_id in (5, 15);
3834:
3835: OE_UPGRADE_WF.Create_activity_transition ('OEOH',c2.cycle_id,'REG');
3836: END IF;
3837:
3838: IF V_ERROR_FLAG = 'N' THEN
3839: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOH');

Line 3839: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOH');

3835: OE_UPGRADE_WF.Create_activity_transition ('OEOH',c2.cycle_id,'REG');
3836: END IF;
3837:
3838: IF V_ERROR_FLAG = 'N' THEN
3839: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOH');
3840: END IF;
3841:
3842: -- dbms_output.put_line('************* FLAG19 = '||v_error_flag);
3843: IF V_ERROR_FLAG = 'N' THEN

Line 3844: OE_UPGRADE_WF.Create_default_transition ('OEOH','REG',c2.cycle_id);

3840: END IF;
3841:
3842: -- dbms_output.put_line('************* FLAG19 = '||v_error_flag);
3843: IF V_ERROR_FLAG = 'N' THEN
3844: OE_UPGRADE_WF.Create_default_transition ('OEOH','REG',c2.cycle_id);
3845: END IF;
3846:
3847: -- dbms_output.put_line('************* FLAG20 = '||v_error_flag);
3848: IF V_ERROR_FLAG = 'N' THEN

Line 3849: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'REG','OEOH');

3845: END IF;
3846:
3847: -- dbms_output.put_line('************* FLAG20 = '||v_error_flag);
3848: IF V_ERROR_FLAG = 'N' THEN
3849: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'REG','OEOH');
3850: END IF;
3851:
3852: -- dbms_output.put_line('************* FLAG21 = '||v_error_flag);
3853: IF V_ERROR_FLAG = 'N' THEN

Line 3854: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOH','REG',c2.cycle_id);

3850: END IF;
3851:
3852: -- dbms_output.put_line('************* FLAG21 = '||v_error_flag);
3853: IF V_ERROR_FLAG = 'N' THEN
3854: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOH','REG',c2.cycle_id);
3855: END IF;
3856:
3857:
3858: END IF;

Line 3863: OE_UPGRADE_WF.Create_activity_or ('OEOL','REG',c2.cycle_id);

3859:
3860: -- dbms_output.put_line('************* FLAG22 = '||v_error_flag);
3861: IF v_vld_lin_flag = 'Y' THEN
3862: IF V_ERROR_FLAG = 'N' THEN
3863: OE_UPGRADE_WF.Create_activity_or ('OEOL','REG',c2.cycle_id);
3864: IF v_cfg_item = 'Y' THEN
3865: --dbms_output.put_line('create activity or for cfg');
3866: OE_UPGRADE_WF.Create_activity_or ('OEOL','CFG',c2.cycle_id);
3867: END IF;

Line 3866: OE_UPGRADE_WF.Create_activity_or ('OEOL','CFG',c2.cycle_id);

3862: IF V_ERROR_FLAG = 'N' THEN
3863: OE_UPGRADE_WF.Create_activity_or ('OEOL','REG',c2.cycle_id);
3864: IF v_cfg_item = 'Y' THEN
3865: --dbms_output.put_line('create activity or for cfg');
3866: OE_UPGRADE_WF.Create_activity_or ('OEOL','CFG',c2.cycle_id);
3867: END IF;
3868: END IF;
3869:
3870:

Line 3876: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'REG');

3872: -- dbms_output.put_line('************* FLAG23 = '||v_error_flag);
3873: IF V_ERROR_FLAG = 'N' THEN
3874:
3875:
3876: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'REG');
3877: IF v_cfg_item = 'Y' THEN
3878: -- dbms_output.put_line('create activity transition for cfg');
3879: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');
3880: END IF;

Line 3879: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');

3875:
3876: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'REG');
3877: IF v_cfg_item = 'Y' THEN
3878: -- dbms_output.put_line('create activity transition for cfg');
3879: OE_UPGRADE_WF.Create_activity_transition ('OEOL',c2.cycle_id,'CFG');
3880: END IF;
3881: END IF;
3882:
3883:

Line 3887: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOL');

3883:
3884:
3885: --dbms_output.put_line('************* FLAG23+ = '||v_error_flag);
3886: IF V_ERROR_FLAG = 'N' THEN
3887: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOL');
3888: IF v_cfg_item = 'Y' THEN
3889: --dbms_output.put_line('create notification for cfg');
3890: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'CFG','OEOL');
3891: END IF;

Line 3890: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'CFG','OEOL');

3886: IF V_ERROR_FLAG = 'N' THEN
3887: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'REG','OEOL');
3888: IF v_cfg_item = 'Y' THEN
3889: --dbms_output.put_line('create notification for cfg');
3890: OE_UPGRADE_WF.Create_notification (c2.cycle_id,'CFG','OEOL');
3891: END IF;
3892: END IF;
3893:
3894: -- dbms_output.put_line('************* FLAG24 = '||v_error_flag|| ' cycle_id:' || to_char(c2.cycle_id));

Line 3896: OE_UPGRADE_WF.Create_default_transition ('OEOL','REG',c2.cycle_id);

3892: END IF;
3893:
3894: -- dbms_output.put_line('************* FLAG24 = '||v_error_flag|| ' cycle_id:' || to_char(c2.cycle_id));
3895: IF V_ERROR_FLAG = 'N' THEN
3896: OE_UPGRADE_WF.Create_default_transition ('OEOL','REG',c2.cycle_id);
3897: IF v_cfg_item = 'Y' THEN
3898: -- dbms_output.put_line('create default end for cfg');
3899: OE_UPGRADE_WF.Create_default_transition ('OEOL','CFG',c2.cycle_id);
3900: END IF;

Line 3899: OE_UPGRADE_WF.Create_default_transition ('OEOL','CFG',c2.cycle_id);

3895: IF V_ERROR_FLAG = 'N' THEN
3896: OE_UPGRADE_WF.Create_default_transition ('OEOL','REG',c2.cycle_id);
3897: IF v_cfg_item = 'Y' THEN
3898: -- dbms_output.put_line('create default end for cfg');
3899: OE_UPGRADE_WF.Create_default_transition ('OEOL','CFG',c2.cycle_id);
3900: END IF;
3901: END IF;
3902:
3903: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);

Line 3905: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'REG');

3901: END IF;
3902:
3903: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);
3904: IF V_ERROR_FLAG = 'N' THEN
3905: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'REG');
3906: IF v_cfg_item = 'Y' THEN
3907: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'CFG');
3908: END IF;
3909: END IF;

Line 3907: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'CFG');

3903: --dbms_output.put_line('************* FLAG25 = '||v_error_flag);
3904: IF V_ERROR_FLAG = 'N' THEN
3905: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'REG');
3906: IF v_cfg_item = 'Y' THEN
3907: OE_UPGRADE_WF.Create_line_start (c2.cycle_id,'CFG');
3908: END IF;
3909: END IF;
3910:
3911: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);

Line 3913: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'REG','OEOL');

3909: END IF;
3910:
3911: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);
3912: IF V_ERROR_FLAG = 'N' THEN
3913: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'REG','OEOL');
3914: IF v_cfg_item = 'Y' THEN
3915: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'CFG','OEOL');
3916: END IF;
3917: END IF;

Line 3915: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'CFG','OEOL');

3911: -- dbms_output.put_line('************* FLAG26 = '||v_error_flag);
3912: IF V_ERROR_FLAG = 'N' THEN
3913: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'REG','OEOL');
3914: IF v_cfg_item = 'Y' THEN
3915: OE_UPGRADE_WF.Close_Open_End (c2.cycle_id,'CFG','OEOL');
3916: END IF;
3917: END IF;
3918:
3919: -- dbms_output.put_line('************* FLAG26+ = '||v_error_flag);

Line 3921: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'REG');

3917: END IF;
3918:
3919: -- dbms_output.put_line('************* FLAG26+ = '||v_error_flag);
3920: IF V_ERROR_FLAG = 'N' THEN
3921: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'REG');
3922: IF v_cfg_item = 'Y' THEN
3923: -- dbms_output.put_line('adjust ship confirm for cfg');
3924: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');
3925: END IF;

Line 3924: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');

3920: IF V_ERROR_FLAG = 'N' THEN
3921: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'REG');
3922: IF v_cfg_item = 'Y' THEN
3923: -- dbms_output.put_line('adjust ship confirm for cfg');
3924: OE_UPGRADE_WF.Ship_Confirm_Adjusting (c2.cycle_id,'CFG');
3925: END IF;
3926: END IF;
3927:
3928: -- dbms_output.put_line('************* FLAG26++ = '||v_error_flag);

Line 3932: OE_UPGRADE_WF.ATO_Adjusting (c2.cycle_id);

3928: -- dbms_output.put_line('************* FLAG26++ = '||v_error_flag);
3929: IF V_ERROR_FLAG = 'N' THEN
3930: IF v_cfg_item = 'Y' THEN
3931: --dbms_output.put_line('adjust ato for cfg');
3932: OE_UPGRADE_WF.ATO_Adjusting (c2.cycle_id);
3933: END IF;
3934: END IF;
3935:
3936: -- dbms_output.put_line('************* FLAG27 = '||v_error_flag);

Line 3938: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');

3934: END IF;
3935:
3936: -- dbms_output.put_line('************* FLAG27 = '||v_error_flag);
3937: IF V_ERROR_FLAG = 'N' THEN
3938: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3939: IF v_cfg_item = 'Y' THEN
3940: -- dbms_output.put_line('adjust ato for cfg');
3941: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3942: END IF;

Line 3941: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');

3937: IF V_ERROR_FLAG = 'N' THEN
3938: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3939: IF v_cfg_item = 'Y' THEN
3940: -- dbms_output.put_line('adjust ato for cfg');
3941: OE_UPGRADE_WF.Generic_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3942: END IF;
3943: END IF;
3944:
3945: -- dbms_output.put_line('************* FLAG28 = '||v_error_flag);

Line 3948: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');

3944:
3945: -- dbms_output.put_line('************* FLAG28 = '||v_error_flag);
3946: -- adjust for multiple waits
3947: IF V_ERROR_FLAG = 'N' THEN
3948: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3949: IF v_cfg_item = 'Y' THEN
3950: --dbms_output.put_line('adjust ato for cfg');
3951: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3952: END IF;

Line 3951: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');

3947: IF V_ERROR_FLAG = 'N' THEN
3948: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'REG');
3949: IF v_cfg_item = 'Y' THEN
3950: --dbms_output.put_line('adjust ato for cfg');
3951: OE_UPGRADE_WF.Wait_Flow_Adjusting ('OEOL', c2.cycle_id,'CFG');
3952: END IF;
3953: END IF;
3954:
3955: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);

Line 3957: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);

3953: END IF;
3954:
3955: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);
3956: IF V_ERROR_FLAG = 'N' THEN
3957: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);
3958: IF v_cfg_item = 'Y' THEN
3959: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);
3960: END IF;
3961: END IF;

Line 3959: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);

3955: -- dbms_output.put_line('************* FLAG29 = '||v_error_flag);
3956: IF V_ERROR_FLAG = 'N' THEN
3957: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','REG',c2.cycle_id);
3958: IF v_cfg_item = 'Y' THEN
3959: OE_UPGRADE_WF.Adjust_arrow_geometry ('OEOL','CFG',c2.cycle_id);
3960: END IF;
3961: END IF;
3962:
3963:

Line 4216: oe_upgrade_wf.insert_into_wf_table

4212:
4213: for c6 in c5 loop
4214: -- dbms_output.put_line('093');
4215: /* Create transition between A to PreNotfn. */
4216: oe_upgrade_wf.insert_into_wf_table
4217: (
4218: c6.from_process_activity,
4219: v_instance_id,
4220: c6.result_code,

Line 4266: oe_upgrade_wf.insert_into_wf_table

4262: where from_process_activity = v_notn_instance_id
4263: and to_process_activity = c4.to_process_activity;
4264:
4265: /* point the PreNotification to this Or as well */
4266: oe_upgrade_wf.insert_into_wf_table
4267: (
4268: v_instance_id,
4269: v_or_instance_id2,
4270: c4.result_code,

Line 4275: oe_upgrade_wf.insert_into_wf_table

4271: v_level_error
4272: );
4273:
4274: /* From Or-2 to B(s) */
4275: oe_upgrade_wf.insert_into_wf_table
4276: (
4277: v_or_instance_id2,
4278: c4.to_process_activity,
4279: '*',

Line 4288: oe_upgrade_wf.insert_into_wf_table

4284: end loop;
4285: -- dbms_output.put_line('113');
4286: /* Create transition between Pre Notfn. to Or */
4287:
4288: oe_upgrade_wf.insert_into_wf_table
4289: (
4290: v_instance_id,
4291: v_or_instance_id,
4292: '*',

Line 4300: oe_upgrade_wf.insert_into_wf_table

4296:
4297: -- dbms_output.put_line('123');
4298: /* Create transition between OR to Notification */
4299:
4300: oe_upgrade_wf.insert_into_wf_table
4301: (
4302: v_or_instance_id,
4303: c2.instance_id,
4304: '*',

Line 4313: oe_upgrade_wf.insert_into_wf_table

4309: -- dbms_output.put_line('133');
4310: /* Create transition between Notification to OR for Not-processed code */
4311:
4312: if v_fyi_Flag = 'N' then
4313: oe_upgrade_wf.insert_into_wf_table
4314: (
4315: c2.instance_id,
4316: v_or_instance_id,
4317: 'NOT_PROCESSED',

Line 4336: END OE_UPGRADE_WF;

4332: --dbms_output.put_line('create_notification exception');
4333: v_error_flag := 'Y';
4334: End Create_Notification;
4335:
4336: END OE_UPGRADE_WF;