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_PROCESS_ACTIVITIES

Line 65: FROM wf_process_activities

61:
62: BEGIN
63: SELECT nvl(instance_id, -1)
64: INTO r_instance_id
65: FROM wf_process_activities
66: WHERE process_name = p_process_name
67: AND activity_name = p_activity_name
68: AND instance_label = p_instance_label;
69:

Line 660: wf_process_activities_s.nextval instance_id,

656: 1 process_version,
657: nvl(oemap.activity_item_type,p_item_type) activity_item_type,
658: nvl(oemap.activity_name,
659: 'UPG_AN_'||to_char(soac.action_id)) activity_name,
660: wf_process_activities_s.nextval instance_id,
661: nvl(oemap.activity_name,
662: 'UPG_ILN_'||to_char(soac.action_id)) instance_label,
663:
664: decode(nvl(oemap.activity_name,

Line 709: FROM wf_process_activities

705: BEGIN
706: v_check_duplicate_flag := 'N';
707:
708: SELECT 'Y' INTO v_check_duplicate_flag
709: FROM wf_process_activities
710: WHERE process_item_type = c2.process_item_Type
711: AND process_name = c2.process_name
712: AND process_version = c2.process_version
713: AND instance_label = c2.instance_label;

Line 773: FROM wf_process_activities

769:
770: IF (p_item_type = 'OEOL') THEN
771: BEGIN
772: SELECT 'x' INTO v_dummy
773: FROM wf_process_activities
774: WHERE process_name = 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
775: AND activity_name = 'START';
776: EXCEPTION
777: WHEN TOO_MANY_ROWS THEN

Line 780: SELECT wf_process_activities_s.nextval

776: EXCEPTION
777: WHEN TOO_MANY_ROWS THEN
778: null;
779: WHEN NO_DATA_FOUND THEN
780: SELECT wf_process_activities_s.nextval
781: INTO v_instance_id
782: FROM dual;
783:
784: -- dbms_output.put_line('will be loading the Pr.Act. ');

Line 1020: SELECT wf_process_activities_s.nextval

1016: v_group_number := c2.group_number;
1017: v_instance_label := 'AND_'||to_Char(v_cycle_action_id)||'_'||
1018: to_Char(v_group_number);
1019:
1020: SELECT wf_process_activities_s.nextval
1021: INTO v_last_instance_id
1022: FROM dual;
1023:
1024: -- dbms_output.put_line('In the stage 7.1..');

Line 1028: /* Insert data into WF_PROCESS_ACTIVITIES */

1024: -- dbms_output.put_line('In the stage 7.1..');
1025: -- dbms_output.put_line(v_process_name||'- 1 '||v_instance_label
1026: -- ||'- '||to_char(v_last_instance_id));
1027:
1028: /* Insert data into WF_PROCESS_ACTIVITIES */
1029: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
1030: x_process_item_type => p_item_type,
1031: x_process_name => v_process_name,
1032: x_process_version => 1,

Line 1345: FROM wf_process_activities

1341: SELECT 'Y',instance_id
1342: INTO
1343: v_check_duplicate_flag,
1344: v_instance_id
1345: FROM wf_process_activities
1346: WHERE process_item_type = 'OEOH'
1347: AND process_name = v_hdr_process_name
1348: AND process_version = 1
1349: AND activity_item_type= 'OEOH'

Line 1368: wf_process_activities_s.nextval

1364:
1365: v_error_level := 2066;
1366: -- dbms_output.put_line('Stage D15 Flag = N');
1367: SELECT
1368: wf_process_activities_s.nextval
1369: INTO
1370: v_instance_id
1371: FROM dual;
1372:

Line 1587: FROM wf_process_activities

1583: -- dbms_output.put_line('Check duplicate - 002');
1584: v_check_duplicate_flag := 'N';
1585:
1586: SELECT 'Y',instance_id INTO v_check_duplicate_flag, v_instance_id
1587: FROM wf_process_activities
1588: WHERE process_item_type = 'OEOL'
1589: AND process_name = v_lin_process_name
1590: AND process_version = 1
1591: AND activity_item_type= 'OEOL'

Line 1604: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;

1600: IF v_check_duplicate_flag = 'N' THEN
1601: v_error_level := 2075;
1602: -- dbms_output.put_line('duplicate - 002');
1603:
1604: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1605:
1606: -- dbms_output.put_line('before insertion of activity:='
1607: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1608:

Line 1729: from wf_process_activities

1725: v_cycle_action_id := c2.cycle_action_id;
1726: IF v_result_id = 1 THEN
1727: begin
1728: select instance_id into v_instance_id
1729: from wf_process_activities
1730: where process_item_type = 'OEOL'
1731: and process_version =1
1732: and process_name = v_lin_process_name
1733: and instance_label = 'ENTER';

Line 1736: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;

1732: and process_name = v_lin_process_name
1733: and instance_label = 'ENTER';
1734: exception
1735: when no_data_found then
1736: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1737: wf_load.upload_process_activity
1738: (
1739: x_process_item_type => 'OEOL',
1740: x_process_name => v_lin_process_name,

Line 1926: SELECT wf_process_activities_s.nextval

1922: v_cycle_id
1923: FROM so_cycle_actions
1924: WHERE cycle_action_id = c2.cycle_action_id;
1925:
1926: SELECT wf_process_activities_s.nextval
1927: INTO v_last_instance_id
1928: FROM dual;
1929:
1930: v_api_error_level := 0;

Line 2470: from wf_process_activities

2466: for c2 in c1 loop
2467:
2468: -- find out the instance_id for activity "UPG_FULFILLMENT_SUB"
2469: select instance_id into v_instance_id
2470: from wf_process_activities
2471: where process_name =
2472: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2473: and activity_name = 'UPG_FULFILLMENT_SUB'
2474: and rownum = 1

Line 2499: -- delete from wf_process_activities

2495: v_level_error
2496: );
2497: End loop;
2498:
2499: -- delete from wf_process_activities
2500: -- the api will also delete from wf_activity_transition
2501: WF_LOAD.Delete_Process_Activity
2502: (
2503: p_step => v_instance_id

Line 2558: from wf_process_activities

2554: for c2 in c1 loop
2555:
2556: -- find out the instance_id for activity "UPG_MODEL_MFG_RELEASE"
2557: select instance_id into v_mfg_instance_id
2558: from wf_process_activities
2559: where process_name = 'UPG_PN_OEOL_REG_'||to_char(p_cycle_id)
2560: and activity_name = 'UPG_MODEL_MFG_RELEASE'
2561: and rownum = 1
2562: order by process_version desc;

Line 2566: from wf_process_activities

2562: order by process_version desc;
2563:
2564: -- find out the instance_id for activity "UPG_MODEL_MFG_RELEASE"
2565: select instance_id into v_instance_id
2566: from wf_process_activities
2567: where process_name = 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id)
2568: and activity_name = 'UPG_MODEL_MFG_RELEASE'
2569: and rownum = 1
2570: order by process_version desc;

Line 2577: from wf_process_activities

2573:
2574:
2575: -- find instance_id for shipping activity
2576: SELECT instance_id into v_cfg_shipping_instance_id
2577: from wf_process_activities
2578: where process_name = 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id)
2579: and activity_name = 'UPG_SHIPPING_SUB'
2580: and rownum = 1
2581: order by process_version desc;

Line 2585: from wf_process_activities

2581: order by process_version desc;
2582:
2583: -- find instance_id for shipping activity
2584: SELECT instance_id into v_mfg_shipping_instance_id
2585: from wf_process_activities
2586: where process_name = 'UPG_PN_OEOL_REG_'||to_char(p_cycle_id)
2587: and activity_name = 'UPG_SHIPPING_SUB'
2588: and rownum = 1
2589: order by process_version desc;

Line 2593: select wf_process_activities_s.nextval

2589: order by process_version desc;
2590:
2591: -- upload the configuration_line subprocess
2592:
2593: select wf_process_activities_s.nextval
2594: into v_new_instance_id
2595: from dual;
2596:
2597: WF_LOAD.UPLOAD_PROCESS_ACTIVITY ( x_process_item_type => 'OEOL',

Line 2657: -- delete from wf_process_activities

2653: v_level_error
2654: );
2655: end loop;
2656:
2657: -- delete from wf_process_activities
2658: -- the api will also delete from wf_activity_transition
2659: WF_LOAD.Delete_Process_Activity
2660: (
2661: p_step => v_instance_id

Line 2726: from wf_process_activities

2722: for c2 in c1 loop
2723:
2724: -- find out the instance_id for activity "UPG_SHIPPING_SUB"
2725: select instance_id into v_shipping_instance_id
2726: from wf_process_activities
2727: where process_name =
2728: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2729: and activity_name = 'UPG_SHIPPING_SUB'
2730: and rownum = 1

Line 2735: SELECT wf_process_activities_s.nextval

2731: order by process_version desc;
2732:
2733:
2734:
2735: SELECT wf_process_activities_s.nextval
2736: INTO v_and_instance_id1
2737: FROM dual;
2738:
2739: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 2785: from wf_process_activities

2781: -- now for the UPG_RMA_RECEIVING_SUB handling
2782:
2783: -- find out the instance_id for activity "UPG_RMA_RECEIVING_SUB"
2784: select instance_id into v_rma_instance_id
2785: from wf_process_activities
2786: where process_name =
2787: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2788: and activity_name = 'UPG_RMA_RECEIVING_SUB'
2789: and rownum = 1

Line 2794: SELECT wf_process_activities_s.nextval

2790: order by process_version desc;
2791:
2792:
2793:
2794: SELECT wf_process_activities_s.nextval
2795: INTO v_and_instance_id2
2796: FROM dual;
2797:
2798: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 2841: from wf_process_activities

2837:
2838: -- now for the util_get_line_cateogry check activity
2839: -- find out the instance_id for the START activity
2840: select instance_id into v_start_instance_id
2841: from wf_process_activities
2842: where process_name = 'UPG_PN_OEOL_'||p_line_type||'_'||
2843: to_char(p_cycle_id)
2844: and activity_name = 'START'
2845: and rownum = 1

Line 2848: SELECT wf_process_activities_s.nextval

2844: and activity_name = 'START'
2845: and rownum = 1
2846: order by process_version desc;
2847:
2848: SELECT wf_process_activities_s.nextval
2849: INTO v_get_category_instance_id
2850: FROM dual;
2851:
2852: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

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 2923: AND b.process_version = (select max(c.process_version) from wf_process_activities c

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'
2922: AND b.activity_name not like 'UPG_AN%CONT_L'
2923: AND b.process_version = (select max(c.process_version) from wf_process_activities c
2924: where c.process_name = b.process_name
2925: and c.activity_name = b.activity_name )
2926: AND t.from_process_activity not in
2927: (

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 2960: from wf_process_activities c

2956: ||to_char(p_cycle_id)
2957: AND b.activity_name = 'UPG_CLOSE_' || decode(p_item_type, 'OEOH',
2958: 'HEADER', 'OEOL', 'LINE', '') || '_PROCESS'
2959: AND b.process_version = (select max(c.process_version)
2960: from wf_process_activities c
2961: where c.process_name = b.process_name
2962: and c.activity_name = b.activity_name )
2963: AND t.to_process_activity = b.instance_id;
2964:

Line 2985: SELECT wf_process_activities_s.nextval

2981: AND rownum = 1);
2982:
2983:
2984: IF v_transitions < v_lookup_count THEN -- some transitions are missing
2985: SELECT wf_process_activities_s.nextval
2986: INTO v_instance_id
2987: FROM dual;
2988:
2989: wf_load.upload_process_activity

Line 3079: FROM wf_process_activities

3075: FROM wf_activity_transitions
3076: WHERE from_process_activity IN
3077: (
3078: SELECT instance_id
3079: FROM wf_process_activities
3080: WHERE process_name = 'UPG_PN_OEOL_'||p_line_type
3081: ||'_'||to_char(p_cycle_id)
3082: AND activity_name <> 'START'
3083: )

Line 3088: wf_process_activities b

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)
3092: AND a.from_process_activity <> a.to_process_activity

Line 3151: FROM wf_process_activities a, wf_process_activities b,

3147: v_tmp NUMBER;
3148:
3149: Cursor c1 is
3150: SELECT a.instance_id, a.instance_label, attr_value1.text_value
3151: FROM wf_process_activities a, wf_process_activities b,
3152: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2
3153: WHERE a.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3154: AND a.process_name = b.process_name
3155: AND a.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'

Line 3181: FROM wf_process_activities a, wf_activity_attr_values attr_value

3177: for c2 in c1 loop
3178: -- dbms_output.put_line('In wait_flow_adjusting: ' || c2.text_value);
3179: SELECT attr_value.text_value
3180: INTO v_continue_line_flow_label
3181: FROM wf_process_activities a, wf_activity_attr_values attr_value
3182: WHERE a.instance_label = c2.text_value
3183: AND a.process_name = 'UPG_PN_OEOH_REG_'||to_char(p_cycle_id)
3184: AND attr_value.process_activity_id = a.instance_id
3185: AND attr_value.name = 'WAITING_ACTIVITY';

Line 3191: FROM wf_process_activities

3187:
3188: IF c2.instance_label <> v_continue_line_flow_label THEN -- adjust
3189: SELECT instance_id
3190: INTO v_cont_act_instance_id
3191: FROM wf_process_activities
3192: WHERE instance_label=v_continue_line_flow_label
3193: AND process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id);
3194:
3195: v_delete_wait_instance := c2.instance_id;

Line 3253: wf_process_activities wpa,

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||'_'
3257: ||p_line_type||'_'||to_char(p_cycle_id)

Line 3254: wf_process_activities wpa2

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||'_'
3257: ||p_line_type||'_'||to_char(p_cycle_id)
3258: AND wpa.icon_geometry = '0,0'

Line 3265: FROM wf_process_activities

3261: GROUP BY wpa.instance_id;
3262:
3263: CURSOR c3 IS
3264: SELECT icon_geometry icon
3265: FROM wf_process_activities
3266: WHERE process_name = 'UPG_PN_'||p_item_type||'_'
3267: ||p_line_type||'_'||to_char(p_cycle_id)
3268: GROUP BY icon_geometry
3269: HAVING count(icon_geometry) > 1;

Line 3276: FROM wf_process_activities a,

3272: SELECT a.icon_geometry icon_from,
3273: a.instance_id from_id,
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

Line 3277: wf_process_activities b,

3273: a.instance_id from_id,
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||'_'

Line 3293: UPDATE wf_process_activities

3289:
3290: BEGIN
3291: -- dbms_output.enable('999999999');
3292:
3293: UPDATE wf_process_activities
3294: SET icon_geometry = '-312,0'
3295: WHERE activity_name = 'START'
3296: and process_name like 'UPG_PN%'
3297: and icon_geometry = '0,0';

Line 3320: UPDATE wf_process_activities

3316:
3317: -- dbms_output.put_line('v_icon_row = '||to_char(v_icon_row));
3318:
3319: v_error_level := 2153;
3320: UPDATE wf_process_activities
3321: SET icon_geometry = to_char(v_icon_row+110)||',0'
3322: WHERE instance_id = c2.id;
3323: END LOOP;
3324: END LOOP;

Line 3332: FROM wf_process_activities

3328: -- dbms_output.put_line('In c4 loop..');
3329: DECLARE
3330: CURSOR c5 IS
3331: SELECT instance_id id
3332: FROM wf_process_activities
3333: WHERE process_name = 'UPG_PN_'||p_item_type||'_'
3334: ||p_line_type||'_'||to_char(p_cycle_id)
3335: AND icon_geometry = c4.icon;
3336:

Line 3351: UPDATE wf_process_activities

3347: v_icon_x_value
3348: );
3349:
3350: v_error_level := 2157;
3351: UPDATE wf_process_activities
3352: SET icon_geometry = to_char(v_icon_x_value)||','
3353: ||to_char(v_icon_col)
3354: WHERE instance_id = c6.id;
3355:

Line 3411: wf_process_activities

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)
3415: AND wat.to_process_activity NOT IN

Line 3424: FROM wf_process_activities wpa2

3420: AND instance_id = to_process_activity
3421: AND to_process_activity IN
3422: (
3423: SELECT instance_id
3424: FROM wf_process_activities wpa2
3425: WHERE wpa2.activity_name <> 'END'
3426: AND wpa2.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type
3427: ||'_'||to_char(p_cycle_id));
3428: BEGIN

Line 3440: FROM wf_process_activities

3436: instance_id
3437: INTO
3438: v_end_found_flag,
3439: v_end_activity_id
3440: FROM wf_process_activities
3441: WHERE process_name = c2.process_name
3442: AND instance_label = 'AND'
3443: AND activity_name = 'AND';
3444: EXCEPTION

Line 3453: SELECT wf_process_activities_s.nextval

3449: END;
3450:
3451: IF v_end_found_flag = 'N' THEN
3452: v_error_level := 2162;
3453: SELECT wf_process_activities_s.nextval
3454: INTO v_and_activity_id
3455: FROM dual;
3456:
3457: v_error_level := 2163;

Line 3997: wf_process_activities wpa,

3993: instance_id,
3994: wa.name,
3995: wa.result_type
3996: from
3997: wf_process_activities wpa,
3998: wf_activities wa
3999: where wpa.activity_name = wa.name
4000: and wpa.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
4001: and wa.type = 'NOTICE';

Line 4135: wf_process_activities_s.nextval into v_instance_id

4131: );
4132:
4133: -- dbms_output.put_line('033');
4134: select
4135: wf_process_activities_s.nextval into v_instance_id
4136: from dual;
4137:
4138: -- dbms_output.put_line('043');
4139: v_api_error_code := 0;

Line 4180: wf_process_activities_s.nextval into v_or_instance_id

4176: -- dbms_output.put_line('063');
4177: /* Insert process activity OR - */
4178:
4179: select
4180: wf_process_activities_s.nextval into v_or_instance_id
4181: from dual;
4182:
4183: -- dbms_output.put_line('073');
4184: v_activity_name := 'OR';

Line 4236: select wf_process_activities_s.nextval into v_or_instance_id2

4232:
4233:
4234: for c4 in c3 loop
4235: /* for the same result_code from the PreNot and the Not, go to the OR-n */
4236: select wf_process_activities_s.nextval into v_or_instance_id2
4237: from dual;
4238:
4239: v_activity_name := 'OR';
4240: