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 WF_ACTIVITY_TRANSITIONS

Line 93: /* Insert into table wf_activity_transitions */

89:
90: BEGIN
91: wf_core.session_level := 20;
92:
93: /* Insert into table wf_activity_transitions */
94: BEGIN
95:
96: SELECT 'x'
97: INTO v_dummy

Line 98: FROM wf_activity_transitions

94: BEGIN
95:
96: SELECT 'x'
97: INTO v_dummy
98: FROM wf_activity_transitions
99: WHERE from_process_activity = p_from_instance_id
100: AND result_code = p_result_code
101: AND to_process_activity = p_to_instance_id;
102:

Line 2116: /* Insert INTO table wf_activity_transitions */

2112: v_result_code := '*';
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,

Line 2163: /* Insert into table wf_activity_transitions */

2159: v_result_code := v_pre_result;
2160: END IF; /* get 'from_instance_id' */
2161:
2162:
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

Line 2230: /* Insert into table wf_activity_transitions */

2226: v_post_activity
2227: );
2228: END IF;
2229:
2230: /* Insert into table wf_activity_transitions */
2231: -- dbms_output.put_line('************* 2 **************');
2232:
2233: v_error_level := 2105;
2234: -- dbms_output.put_line('======================='||to_char(v_error_level));

Line 2327: /* Insert into table wf_activity_transitions */

2323: );
2324:
2325: END IF;
2326:
2327: /* Insert into table wf_activity_transitions */
2328: -- dbms_output.put_line('************* 9 **************'|| to_char(c2.action_id));
2329:
2330: v_error_level := 2113;
2331: v_result_code := c6.act_result;

Line 2370: /* Insert into table wf_activity_transitions */

2366: c4.proc_name,
2367: c4.act_name_t,
2368: c4.instance_label
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: (

Line 2413: /* Insert into table wf_activity_transitions */

2409: );
2410:
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,

Line 2476: from wf_activity_transitions

2472: and cycle_id = p_cycle_id;
2473:
2474: cursor c3 is
2475: select from_process_activity, result_code
2476: from wf_activity_transitions
2477: where to_process_activity = v_instance_id;
2478:
2479: BEGIN
2480: wf_core.session_level := 20;

Line 2497: from wf_activity_transitions

2493: -- find out the post activity instance_id
2494: -- we know there is only 1 transition coming out of fulfillment
2495: -- fulfillment is a seeded upgrade activity
2496: select to_process_activity into v_to_instance_id
2497: from wf_activity_transitions
2498: where from_process_activity = v_instance_id
2499: and rownum = 1;
2500:
2501:

Line 2558: from wf_activity_transitions

2554: where cycle_id in (select cycle_id from so_cycle_actions
2555: where action_id = 15);
2556: cursor c3 is
2557: select to_process_activity
2558: from wf_activity_transitions
2559: where from_process_activity = v_instance_id;
2560:
2561: cursor c5 is
2562: select from_process_activity, result_code

Line 2563: from wf_activity_transitions

2559: where from_process_activity = v_instance_id;
2560:
2561: cursor c5 is
2562: select from_process_activity, result_code
2563: from wf_activity_transitions
2564: where to_process_activity = v_instance_id;
2565:
2566:
2567: BEGIN

Line 2726: from wf_activity_transitions

2722:
2723: cursor c3 is
2724: -- find out the previous activity instance_id
2725: select from_process_activity, result_code
2726: from wf_activity_transitions
2727: where to_process_activity = v_shipping_instance_id;
2728:
2729: -- find out the previous activity instance_id
2730: cursor c5 is

Line 2732: from wf_activity_transitions

2728:
2729: -- find out the previous activity instance_id
2730: cursor c5 is
2731: select from_process_activity, result_code
2732: from wf_activity_transitions
2733: where to_process_activity = v_rma_instance_id;
2734:
2735: BEGIN
2736: wf_core.session_level := 20;

Line 2781: delete from wf_activity_transitions

2777: v_and_instance_id1,
2778: c4.result_code,
2779: v_level_error
2780: );
2781: delete from wf_activity_transitions
2782: where from_process_activity = c4.from_process_activity
2783: and to_process_activity = v_shipping_instance_id;
2784:
2785: end loop;

Line 2839: delete from wf_activity_transitions

2835: v_and_instance_id2,
2836: c6.result_code,
2837: v_level_error
2838: );
2839: delete from wf_activity_transitions
2840: where from_process_activity =c6.from_process_activity
2841: and to_process_activity = v_rma_instance_id;
2842: end loop;
2843:

Line 2932: FROM wf_activity_transitions t, wf_process_activities b

2928: IS
2929: -- cursor c1 selects those activities do not have a default transition
2930: CURSOR c1 IS
2931: SELECT b.process_item_type,b.process_name,b.activity_name, t.from_process_activity
2932: FROM wf_activity_transitions t, wf_process_activities b
2933: WHERE b.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
2934: AND t.from_process_activity = b.instance_id
2935: AND b.activity_name like 'UPG_AN%'
2936: AND b.activity_name not like 'UPG_AN%WAIT_FOR_H'

Line 2944: FROM wf_activity_transitions

2940: and c.activity_name = b.activity_name )
2941: AND t.from_process_activity not in
2942: (
2943: SELECT from_process_activity
2944: FROM wf_activity_transitions
2945: WHERE result_code = '*'
2946: )
2947: GROUP BY b.process_item_type,b.process_name, b.activity_name,t.from_process_activity;
2948:

Line 2963: FROM wf_activity_transitions

2959: v_error_level := 2131;
2960: /* Insert into transtion table */
2961: SELECT count(distinct result_code)
2962: INTO v_transitions
2963: FROM wf_activity_transitions
2964: WHERE from_process_activity = c2.from_process_activity;
2965:
2966: IF v_transitions = 0 THEN -- no transitions exists, take it to the 'AND' b4 close
2967: SELECT t.from_process_activity

Line 2969: FROM wf_activity_transitions t, wf_process_activities b

2965:
2966: IF v_transitions = 0 THEN -- no transitions exists, take it to the 'AND' b4 close
2967: SELECT t.from_process_activity
2968: INTO v_and_upg_close_instance_id
2969: FROM wf_activity_transitions t, wf_process_activities b
2970: WHERE b.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'
2971: ||to_char(p_cycle_id)
2972: AND b.activity_name = 'UPG_CLOSE_' || decode(p_item_type, 'OEOH',
2973: 'HEADER', 'OEOL', 'LINE', '') || '_PROCESS'

Line 3090: FROM wf_activity_transitions

3086:
3087: IS
3088: CURSOR c1 IS
3089: SELECT distinct from_process_activity
3090: FROM wf_activity_transitions
3091: WHERE from_process_activity IN
3092: (
3093: SELECT instance_id
3094: FROM wf_process_activities

Line 3102: FROM wf_activity_transitions a,

3098: )
3099: AND from_process_activity NOT IN
3100: (
3101: SELECT to_process_activity
3102: FROM wf_activity_transitions a,
3103: wf_process_activities b
3104: WHERE a.to_process_activity = b.instance_id
3105: AND b.process_name = 'UPG_PN_OEOL_'||p_line_type
3106: ||'_'||to_char(p_cycle_id)

Line 3181: FROM wf_activity_transitions

3177: AND attr_value1.text_value = attr_value2.text_value;
3178:
3179: Cursor c3 is
3180: SELECT from_process_activity, result_code
3181: FROM wf_activity_transitions
3182: WHERE to_process_activity = v_delete_wait_instance;
3183:
3184: Cursor c5 is
3185: SELECT to_process_activity, result_code

Line 3186: FROM wf_activity_transitions

3182: WHERE to_process_activity = v_delete_wait_instance;
3183:
3184: Cursor c5 is
3185: SELECT to_process_activity, result_code
3186: FROM wf_activity_transitions
3187: WHERE from_process_activity = v_delete_wait_instance;
3188:
3189:
3190:

Line 3216: FROM wf_activity_transitions

3212: for c4 in c3 loop
3213: BEGIN
3214: SELECT 1
3215: INTO v_tmp
3216: FROM wf_activity_transitions
3217: WHERE from_process_activity = c4.from_process_activity
3218: AND to_process_activity = v_cont_act_instance_id
3219: AND result_code = c4.result_code;
3220: EXCEPTION

Line 3222: update wf_activity_transitions

3218: AND to_process_activity = v_cont_act_instance_id
3219: AND result_code = c4.result_code;
3220: EXCEPTION
3221: WHEN NO_DATA_FOUND THEN
3222: update wf_activity_transitions
3223: set to_process_activity = v_cont_act_instance_id
3224: where from_process_activity = c4.from_process_activity
3225: and to_process_activity = v_delete_wait_instance;
3226: END;

Line 3234: FROM wf_activity_transitions

3230: for c6 in c5 loop
3231: BEGIN
3232: SELECT 1
3233: INTO v_tmp
3234: FROM wf_activity_transitions
3235: WHERE from_process_activity = v_cont_act_instance_id
3236: AND to_process_activity = c6.to_process_activity
3237: AND result_code = c6.result_code;
3238: EXCEPTION

Line 3240: update wf_activity_transitions

3236: AND to_process_activity = c6.to_process_activity
3237: AND result_code = c6.result_code;
3238: EXCEPTION
3239: WHEN NO_DATA_FOUND THEN
3240: update wf_activity_transitions
3241: set from_process_activity = v_cont_act_instance_id
3242: where from_process_activity = v_delete_wait_instance
3243: and to_process_activity = c6.to_process_activity;
3244: END;

Line 3267: FROM wf_activity_transitions wat,

3263:
3264: CURSOR c1 IS
3265: SELECT max(wpa2.icon_geometry) icon,
3266: wpa.instance_id id
3267: FROM wf_activity_transitions wat,
3268: wf_process_activities wpa,
3269: wf_process_activities wpa2
3270: WHERE wat.to_process_activity = wpa.instance_id
3271: AND wpa.process_name = 'UPG_PN_'||p_item_type||'_'

Line 3293: wf_activity_transitions c

3289: b.icon_geometry icon_to,
3290: b.instance_id to_id
3291: FROM wf_process_activities a,
3292: wf_process_activities b,
3293: wf_activity_transitions c
3294: WHERE a.instance_id = c.from_process_activity
3295: AND b.instance_id = c.to_process_activity
3296: AND a.process_name = 'UPG_PN_'||p_item_type||'_'
3297: ||p_line_type||'_'||to_char(p_cycle_id);

Line 3380: UPDATE wf_activity_transitions

3376: END;
3377:
3378: FOR c8 in c7 LOOP
3379: v_error_level := 2157;
3380: UPDATE wf_activity_transitions
3381: SET arrow_geometry = '1;0;0;0;0.30000;'||c8.icon_from||':'||c8.icon_to||':'
3382: WHERE from_process_activity = c8.from_id
3383: AND to_process_activity = c8.to_id;
3384: END LOOP;

Line 3425: wf_activity_transitions WAT,

3421: to_process_activity ,
3422: process_name,
3423: process_item_type
3424: FROM
3425: wf_activity_transitions WAT,
3426: wf_process_activities
3427: WHERE
3428: process_name = 'UPG_PN_'||p_item_type||'_'
3429: ||p_line_type||'_'||to_char(p_cycle_id)

Line 3433: FROM wf_activity_transitions

3429: ||p_line_type||'_'||to_char(p_cycle_id)
3430: AND wat.to_process_activity NOT IN
3431: (
3432: SELECT from_process_activity
3433: FROM wf_activity_transitions
3434: )
3435: AND instance_id = to_process_activity
3436: AND to_process_activity IN
3437: (

Line 3915: from wf_activity_transitions

3911: v_notn_instance_id number;
3912:
3913: cursor c3 is
3914: select to_process_activity, result_code
3915: from wf_activity_transitions
3916: where from_process_activity = v_notn_instance_id;
3917:
3918: cursor c5 is
3919: select from_process_activity, result_code

Line 3920: from wf_activity_transitions

3916: where from_process_activity = v_notn_instance_id;
3917:
3918: cursor c5 is
3919: select from_process_activity, result_code
3920: from wf_activity_transitions
3921: where to_process_activity = v_notn_instance_id;
3922:
3923: v_activity_name varchar2(50);
3924: v_process_name varchar2(50);

Line 4168: update wf_activity_transitions

4164: x_user_comment => null,
4165: x_level_error => v_api_error_code
4166: );
4167: /* update notification to point to the OR just created */
4168: update wf_activity_transitions
4169: set to_process_activity = v_or_instance_id2
4170: where from_process_activity = v_notn_instance_id
4171: and to_process_activity = c4.to_process_activity;
4172: