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 WF_ACTIVITY_TRANSITIONS

Line 88: /* Insert into table wf_activity_transitions */

84:
85: BEGIN
86: wf_core.session_level := 20;
87:
88: /* Insert into table wf_activity_transitions */
89: BEGIN
90:
91: SELECT 'x'
92: INTO v_dummy

Line 93: FROM wf_activity_transitions

89: BEGIN
90:
91: SELECT 'x'
92: INTO v_dummy
93: FROM wf_activity_transitions
94: WHERE from_process_activity = p_from_instance_id
95: AND result_code = p_result_code
96: AND to_process_activity = p_to_instance_id;
97:

Line 2101: /* Insert INTO table wf_activity_transitions */

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

Line 2148: /* Insert into table wf_activity_transitions */

2144: v_result_code := v_pre_result;
2145: END IF; /* get 'from_instance_id' */
2146:
2147:
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

Line 2215: /* Insert into table wf_activity_transitions */

2211: v_post_activity
2212: );
2213: END IF;
2214:
2215: /* Insert into table wf_activity_transitions */
2216: -- dbms_output.put_line('************* 2 **************');
2217:
2218: v_error_level := 2105;
2219: -- dbms_output.put_line('======================='||to_char(v_error_level));

Line 2312: /* Insert into table wf_activity_transitions */

2308: );
2309:
2310: END IF;
2311:
2312: /* Insert into table wf_activity_transitions */
2313: -- dbms_output.put_line('************* 9 **************'|| to_char(c2.action_id));
2314:
2315: v_error_level := 2113;
2316: v_result_code := c6.act_result;

Line 2355: /* Insert into table wf_activity_transitions */

2351: c4.proc_name,
2352: c4.act_name_t,
2353: c4.instance_label
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: (

Line 2398: /* Insert into table wf_activity_transitions */

2394: );
2395:
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,

Line 2461: from wf_activity_transitions

2457: and cycle_id = p_cycle_id;
2458:
2459: cursor c3 is
2460: select from_process_activity, result_code
2461: from wf_activity_transitions
2462: where to_process_activity = v_instance_id;
2463:
2464: BEGIN
2465: wf_core.session_level := 20;

Line 2482: from wf_activity_transitions

2478: -- find out the post activity instance_id
2479: -- we know there is only 1 transition coming out of fulfillment
2480: -- fulfillment is a seeded upgrade activity
2481: select to_process_activity into v_to_instance_id
2482: from wf_activity_transitions
2483: where from_process_activity = v_instance_id
2484: and rownum = 1;
2485:
2486:

Line 2543: from wf_activity_transitions

2539: where cycle_id in (select cycle_id from so_cycle_actions
2540: where action_id = 15);
2541: cursor c3 is
2542: select to_process_activity
2543: from wf_activity_transitions
2544: where from_process_activity = v_instance_id;
2545:
2546: cursor c5 is
2547: select from_process_activity, result_code

Line 2548: from wf_activity_transitions

2544: where from_process_activity = v_instance_id;
2545:
2546: cursor c5 is
2547: select from_process_activity, result_code
2548: from wf_activity_transitions
2549: where to_process_activity = v_instance_id;
2550:
2551:
2552: BEGIN

Line 2711: from wf_activity_transitions

2707:
2708: cursor c3 is
2709: -- find out the previous activity instance_id
2710: select from_process_activity, result_code
2711: from wf_activity_transitions
2712: where to_process_activity = v_shipping_instance_id;
2713:
2714: -- find out the previous activity instance_id
2715: cursor c5 is

Line 2717: from wf_activity_transitions

2713:
2714: -- find out the previous activity instance_id
2715: cursor c5 is
2716: select from_process_activity, result_code
2717: from wf_activity_transitions
2718: where to_process_activity = v_rma_instance_id;
2719:
2720: BEGIN
2721: wf_core.session_level := 20;

Line 2766: delete from wf_activity_transitions

2762: v_and_instance_id1,
2763: c4.result_code,
2764: v_level_error
2765: );
2766: delete from wf_activity_transitions
2767: where from_process_activity = c4.from_process_activity
2768: and to_process_activity = v_shipping_instance_id;
2769:
2770: end loop;

Line 2824: delete from wf_activity_transitions

2820: v_and_instance_id2,
2821: c6.result_code,
2822: v_level_error
2823: );
2824: delete from wf_activity_transitions
2825: where from_process_activity =c6.from_process_activity
2826: and to_process_activity = v_rma_instance_id;
2827: end loop;
2828:

Line 2917: FROM wf_activity_transitions t, wf_process_activities b

2913: IS
2914: -- cursor c1 selects those activities do not have a default transition
2915: CURSOR c1 IS
2916: SELECT b.process_item_type,b.process_name,b.activity_name, t.from_process_activity
2917: FROM wf_activity_transitions t, wf_process_activities b
2918: WHERE b.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
2919: AND t.from_process_activity = b.instance_id
2920: AND b.activity_name like 'UPG_AN%'
2921: AND b.activity_name not like 'UPG_AN%WAIT_FOR_H'

Line 2929: FROM wf_activity_transitions

2925: and c.activity_name = b.activity_name )
2926: AND t.from_process_activity not in
2927: (
2928: SELECT from_process_activity
2929: FROM wf_activity_transitions
2930: WHERE result_code = '*'
2931: )
2932: GROUP BY b.process_item_type,b.process_name, b.activity_name,t.from_process_activity;
2933:

Line 2948: FROM wf_activity_transitions

2944: v_error_level := 2131;
2945: /* Insert into transtion table */
2946: SELECT count(distinct result_code)
2947: INTO v_transitions
2948: FROM wf_activity_transitions
2949: WHERE from_process_activity = c2.from_process_activity;
2950:
2951: IF v_transitions = 0 THEN -- no transitions exists, take it to the 'AND' b4 close
2952: SELECT t.from_process_activity

Line 2954: FROM wf_activity_transitions t, wf_process_activities b

2950:
2951: IF v_transitions = 0 THEN -- no transitions exists, take it to the 'AND' b4 close
2952: SELECT t.from_process_activity
2953: INTO v_and_upg_close_instance_id
2954: FROM wf_activity_transitions t, wf_process_activities b
2955: WHERE b.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'
2956: ||to_char(p_cycle_id)
2957: AND b.activity_name = 'UPG_CLOSE_' || decode(p_item_type, 'OEOH',
2958: 'HEADER', 'OEOL', 'LINE', '') || '_PROCESS'

Line 3075: FROM wf_activity_transitions

3071:
3072: IS
3073: CURSOR c1 IS
3074: SELECT distinct from_process_activity
3075: FROM wf_activity_transitions
3076: WHERE from_process_activity IN
3077: (
3078: SELECT instance_id
3079: FROM wf_process_activities

Line 3087: FROM wf_activity_transitions a,

3083: )
3084: AND from_process_activity NOT IN
3085: (
3086: SELECT to_process_activity
3087: FROM wf_activity_transitions a,
3088: wf_process_activities b
3089: WHERE a.to_process_activity = b.instance_id
3090: AND b.process_name = 'UPG_PN_OEOL_'||p_line_type
3091: ||'_'||to_char(p_cycle_id)

Line 3166: FROM wf_activity_transitions

3162: AND attr_value1.text_value = attr_value2.text_value;
3163:
3164: Cursor c3 is
3165: SELECT from_process_activity, result_code
3166: FROM wf_activity_transitions
3167: WHERE to_process_activity = v_delete_wait_instance;
3168:
3169: Cursor c5 is
3170: SELECT to_process_activity, result_code

Line 3171: FROM wf_activity_transitions

3167: WHERE to_process_activity = v_delete_wait_instance;
3168:
3169: Cursor c5 is
3170: SELECT to_process_activity, result_code
3171: FROM wf_activity_transitions
3172: WHERE from_process_activity = v_delete_wait_instance;
3173:
3174:
3175:

Line 3201: FROM wf_activity_transitions

3197: for c4 in c3 loop
3198: BEGIN
3199: SELECT 1
3200: INTO v_tmp
3201: FROM wf_activity_transitions
3202: WHERE from_process_activity = c4.from_process_activity
3203: AND to_process_activity = v_cont_act_instance_id
3204: AND result_code = c4.result_code;
3205: EXCEPTION

Line 3207: update wf_activity_transitions

3203: AND to_process_activity = v_cont_act_instance_id
3204: AND result_code = c4.result_code;
3205: EXCEPTION
3206: WHEN NO_DATA_FOUND THEN
3207: update wf_activity_transitions
3208: set to_process_activity = v_cont_act_instance_id
3209: where from_process_activity = c4.from_process_activity
3210: and to_process_activity = v_delete_wait_instance;
3211: END;

Line 3219: FROM wf_activity_transitions

3215: for c6 in c5 loop
3216: BEGIN
3217: SELECT 1
3218: INTO v_tmp
3219: FROM wf_activity_transitions
3220: WHERE from_process_activity = v_cont_act_instance_id
3221: AND to_process_activity = c6.to_process_activity
3222: AND result_code = c6.result_code;
3223: EXCEPTION

Line 3225: update wf_activity_transitions

3221: AND to_process_activity = c6.to_process_activity
3222: AND result_code = c6.result_code;
3223: EXCEPTION
3224: WHEN NO_DATA_FOUND THEN
3225: update wf_activity_transitions
3226: set from_process_activity = v_cont_act_instance_id
3227: where from_process_activity = v_delete_wait_instance
3228: and to_process_activity = c6.to_process_activity;
3229: END;

Line 3252: FROM wf_activity_transitions wat,

3248:
3249: CURSOR c1 IS
3250: SELECT max(wpa2.icon_geometry) icon,
3251: wpa.instance_id id
3252: FROM wf_activity_transitions wat,
3253: wf_process_activities wpa,
3254: wf_process_activities wpa2
3255: WHERE wat.to_process_activity = wpa.instance_id
3256: AND wpa.process_name = 'UPG_PN_'||p_item_type||'_'

Line 3278: wf_activity_transitions c

3274: b.icon_geometry icon_to,
3275: b.instance_id to_id
3276: FROM wf_process_activities a,
3277: wf_process_activities b,
3278: wf_activity_transitions c
3279: WHERE a.instance_id = c.from_process_activity
3280: AND b.instance_id = c.to_process_activity
3281: AND a.process_name = 'UPG_PN_'||p_item_type||'_'
3282: ||p_line_type||'_'||to_char(p_cycle_id);

Line 3365: UPDATE wf_activity_transitions

3361: END;
3362:
3363: FOR c8 in c7 LOOP
3364: v_error_level := 2157;
3365: UPDATE wf_activity_transitions
3366: SET arrow_geometry = '1;0;0;0;0.30000;'||c8.icon_from||':'||c8.icon_to||':'
3367: WHERE from_process_activity = c8.from_id
3368: AND to_process_activity = c8.to_id;
3369: END LOOP;

Line 3410: wf_activity_transitions WAT,

3406: to_process_activity ,
3407: process_name,
3408: process_item_type
3409: FROM
3410: wf_activity_transitions WAT,
3411: wf_process_activities
3412: WHERE
3413: process_name = 'UPG_PN_'||p_item_type||'_'
3414: ||p_line_type||'_'||to_char(p_cycle_id)

Line 3418: FROM wf_activity_transitions

3414: ||p_line_type||'_'||to_char(p_cycle_id)
3415: AND wat.to_process_activity NOT IN
3416: (
3417: SELECT from_process_activity
3418: FROM wf_activity_transitions
3419: )
3420: AND instance_id = to_process_activity
3421: AND to_process_activity IN
3422: (

Line 4007: from wf_activity_transitions

4003: v_notn_instance_id number;
4004:
4005: cursor c3 is
4006: select to_process_activity, result_code
4007: from wf_activity_transitions
4008: where from_process_activity = v_notn_instance_id;
4009:
4010: cursor c5 is
4011: select from_process_activity, result_code

Line 4012: from wf_activity_transitions

4008: where from_process_activity = v_notn_instance_id;
4009:
4010: cursor c5 is
4011: select from_process_activity, result_code
4012: from wf_activity_transitions
4013: where to_process_activity = v_notn_instance_id;
4014:
4015: v_activity_name varchar2(50);
4016: v_process_name varchar2(50);

Line 4260: update wf_activity_transitions

4256: x_user_comment => null,
4257: x_level_error => v_api_error_code
4258: );
4259: /* update notification to point to the OR just created */
4260: update wf_activity_transitions
4261: set to_process_activity = v_or_instance_id2
4262: where from_process_activity = v_notn_instance_id
4263: and to_process_activity = c4.to_process_activity;
4264: