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_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: AND process_version = (SELECT max(process_version)

Line 70: 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: AND process_version = (SELECT max(process_version)
70: FROM wf_process_activities
71: WHERE process_name = p_process_name
72: AND activity_name = p_activity_name
73: AND instance_label = p_instance_label);
74:

Line 665: wf_process_activities_s.nextval instance_id,

661: 1 process_version,
662: nvl(oemap.activity_item_type,p_item_type) activity_item_type,
663: nvl(oemap.activity_name,
664: 'UPG_AN_'||to_char(soac.action_id)) activity_name,
665: wf_process_activities_s.nextval instance_id,
666: nvl(oemap.activity_name,
667: 'UPG_ILN_'||to_char(sca.cycle_action_id)) instance_label,
668:
669: decode(nvl(oemap.activity_name,

Line 733: FROM wf_process_activities

729: BEGIN
730: v_check_duplicate_flag := 'N';
731:
732: SELECT 'Y' INTO v_check_duplicate_flag
733: FROM wf_process_activities
734: WHERE process_item_type = c2.process_item_Type
735: AND process_name = c2.process_name
736: AND process_version = c2.process_version
737: AND instance_label = c2.instance_label;

Line 799: FROM wf_process_activities

795:
796: IF (p_item_type = 'OEOL') THEN
797: BEGIN
798: SELECT 'x' INTO v_dummy
799: FROM wf_process_activities
800: WHERE process_name = 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
801: AND activity_name = 'START';
802: EXCEPTION
803: WHEN TOO_MANY_ROWS THEN

Line 806: SELECT wf_process_activities_s.nextval

802: EXCEPTION
803: WHEN TOO_MANY_ROWS THEN
804: null;
805: WHEN NO_DATA_FOUND THEN
806: SELECT wf_process_activities_s.nextval
807: INTO v_instance_id
808: FROM dual;
809:
810: -- dbms_output.put_line('will be loading the Pr.Act. ');

Line 1034: SELECT wf_process_activities_s.nextval

1030: v_group_number := c2.group_number;
1031: v_instance_label := 'AND_'||to_Char(v_cycle_action_id)||'_'||
1032: to_Char(v_group_number);
1033:
1034: SELECT wf_process_activities_s.nextval
1035: INTO v_last_instance_id
1036: FROM dual;
1037:
1038: -- dbms_output.put_line('In the stage 7.1..');

Line 1042: /* Insert data into WF_PROCESS_ACTIVITIES */

1038: -- dbms_output.put_line('In the stage 7.1..');
1039: -- dbms_output.put_line(v_process_name||'- 1 '||v_instance_label
1040: -- ||'- '||to_char(v_last_instance_id));
1041:
1042: /* Insert data into WF_PROCESS_ACTIVITIES */
1043: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
1044: x_process_item_type => p_item_type,
1045: x_process_name => v_process_name,
1046: x_process_version => 1,

Line 1357: FROM wf_process_activities

1353: SELECT 'Y',instance_id
1354: INTO
1355: v_check_duplicate_flag,
1356: v_instance_id
1357: FROM wf_process_activities
1358: WHERE process_item_type = 'OEOH'
1359: AND process_name = v_hdr_process_name
1360: AND process_version = 1
1361: AND activity_item_type= 'OEOH'

Line 1380: wf_process_activities_s.nextval

1376:
1377: v_error_level := 2066;
1378: -- dbms_output.put_line('Stage D15 Flag = N');
1379: SELECT
1380: wf_process_activities_s.nextval
1381: INTO
1382: v_instance_id
1383: FROM dual;
1384:

Line 1599: FROM wf_process_activities

1595: -- dbms_output.put_line('Check duplicate - 002');
1596: v_check_duplicate_flag := 'N';
1597:
1598: SELECT 'Y',instance_id INTO v_check_duplicate_flag, v_instance_id
1599: FROM wf_process_activities
1600: WHERE process_item_type = 'OEOL'
1601: AND process_name = v_lin_process_name
1602: AND process_version = 1
1603: AND activity_item_type= 'OEOL'

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

1612: IF v_check_duplicate_flag = 'N' THEN
1613: v_error_level := 2075;
1614: -- dbms_output.put_line('duplicate - 002');
1615:
1616: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1617:
1618: -- dbms_output.put_line('before insertion of activity:='
1619: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1620:

Line 1741: from wf_process_activities

1737: v_cycle_action_id := c2.cycle_action_id;
1738: IF v_result_id = 1 THEN
1739: begin
1740: select instance_id into v_instance_id
1741: from wf_process_activities
1742: where process_item_type = 'OEOL'
1743: and process_version =1
1744: and process_name = v_lin_process_name
1745: and instance_label = 'ENTER';

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

1744: and process_name = v_lin_process_name
1745: and instance_label = 'ENTER';
1746: exception
1747: when no_data_found then
1748: SELECT wf_process_activities_s.nextval INTO v_instance_id FROM dual;
1749: wf_load.upload_process_activity
1750: (
1751: x_process_item_type => 'OEOL',
1752: x_process_name => v_lin_process_name,

Line 1938: SELECT wf_process_activities_s.nextval

1934: v_cycle_id
1935: FROM so_cycle_actions
1936: WHERE cycle_action_id = c2.cycle_action_id;
1937:
1938: SELECT wf_process_activities_s.nextval
1939: INTO v_last_instance_id
1940: FROM dual;
1941:
1942: v_api_error_level := 0;

Line 2485: from wf_process_activities

2481: for c2 in c1 loop
2482:
2483: -- find out the instance_id for activity "UPG_FULFILLMENT_SUB"
2484: select instance_id into v_instance_id
2485: from wf_process_activities
2486: where process_name =
2487: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2488: and activity_name = 'UPG_FULFILLMENT_SUB'
2489: and rownum = 1

Line 2514: -- delete from wf_process_activities

2510: v_level_error
2511: );
2512: End loop;
2513:
2514: -- delete from wf_process_activities
2515: -- the api will also delete from wf_activity_transition
2516: WF_LOAD.Delete_Process_Activity
2517: (
2518: p_step => v_instance_id

Line 2573: from wf_process_activities

2569: for c2 in c1 loop
2570:
2571: -- find out the instance_id for activity "UPG_MODEL_MFG_RELEASE"
2572: select instance_id into v_mfg_instance_id
2573: from wf_process_activities
2574: where process_name = 'UPG_PN_OEOL_REG_'||to_char(p_cycle_id)
2575: and activity_name = 'UPG_MODEL_MFG_RELEASE'
2576: and rownum = 1
2577: order by process_version desc;

Line 2581: from wf_process_activities

2577: order by process_version desc;
2578:
2579: -- find out the instance_id for activity "UPG_MODEL_MFG_RELEASE"
2580: select instance_id into v_instance_id
2581: from wf_process_activities
2582: where process_name = 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id)
2583: and activity_name = 'UPG_MODEL_MFG_RELEASE'
2584: and rownum = 1
2585: order by process_version desc;

Line 2592: from wf_process_activities

2588:
2589:
2590: -- find instance_id for shipping activity
2591: SELECT instance_id into v_cfg_shipping_instance_id
2592: from wf_process_activities
2593: where process_name = 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id)
2594: and activity_name = 'UPG_SHIPPING_SUB'
2595: and rownum = 1
2596: order by process_version desc;

Line 2600: from wf_process_activities

2596: order by process_version desc;
2597:
2598: -- find instance_id for shipping activity
2599: SELECT instance_id into v_mfg_shipping_instance_id
2600: from wf_process_activities
2601: where process_name = 'UPG_PN_OEOL_REG_'||to_char(p_cycle_id)
2602: and activity_name = 'UPG_SHIPPING_SUB'
2603: and rownum = 1
2604: order by process_version desc;

Line 2608: select wf_process_activities_s.nextval

2604: order by process_version desc;
2605:
2606: -- upload the configuration_line subprocess
2607:
2608: select wf_process_activities_s.nextval
2609: into v_new_instance_id
2610: from dual;
2611:
2612: WF_LOAD.UPLOAD_PROCESS_ACTIVITY ( x_process_item_type => 'OEOL',

Line 2672: -- delete from wf_process_activities

2668: v_level_error
2669: );
2670: end loop;
2671:
2672: -- delete from wf_process_activities
2673: -- the api will also delete from wf_activity_transition
2674: WF_LOAD.Delete_Process_Activity
2675: (
2676: p_step => v_instance_id

Line 2741: from wf_process_activities

2737: for c2 in c1 loop
2738:
2739: -- find out the instance_id for activity "UPG_SHIPPING_SUB"
2740: select instance_id into v_shipping_instance_id
2741: from wf_process_activities
2742: where process_name =
2743: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2744: and activity_name = 'UPG_SHIPPING_SUB'
2745: and rownum = 1

Line 2750: SELECT wf_process_activities_s.nextval

2746: order by process_version desc;
2747:
2748:
2749:
2750: SELECT wf_process_activities_s.nextval
2751: INTO v_and_instance_id1
2752: FROM dual;
2753:
2754: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 2800: from wf_process_activities

2796: -- now for the UPG_RMA_RECEIVING_SUB handling
2797:
2798: -- find out the instance_id for activity "UPG_RMA_RECEIVING_SUB"
2799: select instance_id into v_rma_instance_id
2800: from wf_process_activities
2801: where process_name =
2802: 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id)
2803: and activity_name = 'UPG_RMA_RECEIVING_SUB'
2804: and rownum = 1

Line 2809: SELECT wf_process_activities_s.nextval

2805: order by process_version desc;
2806:
2807:
2808:
2809: SELECT wf_process_activities_s.nextval
2810: INTO v_and_instance_id2
2811: FROM dual;
2812:
2813: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

Line 2856: from wf_process_activities

2852:
2853: -- now for the util_get_line_cateogry check activity
2854: -- find out the instance_id for the START activity
2855: select instance_id into v_start_instance_id
2856: from wf_process_activities
2857: where process_name = 'UPG_PN_OEOL_'||p_line_type||'_'||
2858: to_char(p_cycle_id)
2859: and activity_name = 'START'
2860: and rownum = 1

Line 2863: SELECT wf_process_activities_s.nextval

2859: and activity_name = 'START'
2860: and rownum = 1
2861: order by process_version desc;
2862:
2863: SELECT wf_process_activities_s.nextval
2864: INTO v_get_category_instance_id
2865: FROM dual;
2866:
2867: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

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

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'
2937: AND b.activity_name not like 'UPG_AN%CONT_L'
2938: AND b.process_version = (select max(c.process_version) from wf_process_activities c
2939: where c.process_name = b.process_name
2940: and c.activity_name = b.activity_name )
2941: AND t.from_process_activity not in
2942: (

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

2971: ||to_char(p_cycle_id)
2972: AND b.activity_name = 'UPG_CLOSE_' || decode(p_item_type, 'OEOH',
2973: 'HEADER', 'OEOL', 'LINE', '') || '_PROCESS'
2974: AND b.process_version = (select max(c.process_version)
2975: from wf_process_activities c
2976: where c.process_name = b.process_name
2977: and c.activity_name = b.activity_name )
2978: AND t.to_process_activity = b.instance_id;
2979:

Line 3000: SELECT wf_process_activities_s.nextval

2996: AND rownum = 1);
2997:
2998:
2999: IF v_transitions < v_lookup_count THEN -- some transitions are missing
3000: SELECT wf_process_activities_s.nextval
3001: INTO v_instance_id
3002: FROM dual;
3003:
3004: wf_load.upload_process_activity

Line 3094: FROM wf_process_activities

3090: FROM wf_activity_transitions
3091: WHERE from_process_activity IN
3092: (
3093: SELECT instance_id
3094: FROM wf_process_activities
3095: WHERE process_name = 'UPG_PN_OEOL_'||p_line_type
3096: ||'_'||to_char(p_cycle_id)
3097: AND activity_name <> 'START'
3098: )

Line 3103: wf_process_activities b

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

Line 3166: FROM wf_process_activities a, wf_process_activities b,

3162: v_tmp NUMBER;
3163:
3164: Cursor c1 is
3165: SELECT a.instance_id, a.instance_label, attr_value1.text_value
3166: FROM wf_process_activities a, wf_process_activities b,
3167: wf_activity_attr_values attr_value1, wf_activity_attr_values attr_value2
3168: WHERE a.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3169: AND a.process_name = b.process_name
3170: AND a.activity_name like 'UPG_AN_OEOL_%WAIT_FOR_H'

Line 3196: FROM wf_process_activities a, wf_activity_attr_values attr_value

3192: for c2 in c1 loop
3193: -- dbms_output.put_line('In wait_flow_adjusting: ' || c2.text_value);
3194: SELECT attr_value.text_value
3195: INTO v_continue_line_flow_label
3196: FROM wf_process_activities a, wf_activity_attr_values attr_value
3197: WHERE a.instance_label = c2.text_value
3198: AND a.process_name = 'UPG_PN_OEOH_REG_'||to_char(p_cycle_id)
3199: AND attr_value.process_activity_id = a.instance_id
3200: AND attr_value.name = 'WAITING_ACTIVITY';

Line 3206: FROM wf_process_activities

3202:
3203: IF c2.instance_label <> v_continue_line_flow_label THEN -- adjust
3204: SELECT instance_id
3205: INTO v_cont_act_instance_id
3206: FROM wf_process_activities
3207: WHERE instance_label=v_continue_line_flow_label
3208: AND process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id);
3209:
3210: v_delete_wait_instance := c2.instance_id;

Line 3268: wf_process_activities wpa,

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

Line 3269: wf_process_activities wpa2

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

Line 3280: FROM wf_process_activities

3276: GROUP BY wpa.instance_id;
3277:
3278: CURSOR c3 IS
3279: SELECT icon_geometry icon
3280: FROM wf_process_activities
3281: WHERE process_name = 'UPG_PN_'||p_item_type||'_'
3282: ||p_line_type||'_'||to_char(p_cycle_id)
3283: GROUP BY icon_geometry
3284: HAVING count(icon_geometry) > 1;

Line 3291: FROM wf_process_activities a,

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

Line 3292: wf_process_activities b,

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

Line 3308: UPDATE wf_process_activities

3304:
3305: BEGIN
3306: -- dbms_output.enable('999999999');
3307:
3308: UPDATE wf_process_activities
3309: SET icon_geometry = '-312,0'
3310: WHERE activity_name = 'START'
3311: and process_name like 'UPG_PN%'
3312: and icon_geometry = '0,0';

Line 3335: UPDATE wf_process_activities

3331:
3332: -- dbms_output.put_line('v_icon_row = '||to_char(v_icon_row));
3333:
3334: v_error_level := 2153;
3335: UPDATE wf_process_activities
3336: SET icon_geometry = to_char(v_icon_row+110)||',0'
3337: WHERE instance_id = c2.id;
3338: END LOOP;
3339: END LOOP;

Line 3347: FROM wf_process_activities

3343: -- dbms_output.put_line('In c4 loop..');
3344: DECLARE
3345: CURSOR c5 IS
3346: SELECT instance_id id
3347: FROM wf_process_activities
3348: WHERE process_name = 'UPG_PN_'||p_item_type||'_'
3349: ||p_line_type||'_'||to_char(p_cycle_id)
3350: AND icon_geometry = c4.icon;
3351:

Line 3366: UPDATE wf_process_activities

3362: v_icon_x_value
3363: );
3364:
3365: v_error_level := 2157;
3366: UPDATE wf_process_activities
3367: SET icon_geometry = to_char(v_icon_x_value)||','
3368: ||to_char(v_icon_col)
3369: WHERE instance_id = c6.id;
3370:

Line 3426: wf_process_activities

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

Line 3439: FROM wf_process_activities wpa2

3435: AND instance_id = to_process_activity
3436: AND to_process_activity IN
3437: (
3438: SELECT instance_id
3439: FROM wf_process_activities wpa2
3440: WHERE wpa2.activity_name <> 'END'
3441: AND wpa2.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type
3442: ||'_'||to_char(p_cycle_id));
3443: BEGIN

Line 3455: FROM wf_process_activities

3451: instance_id
3452: INTO
3453: v_end_found_flag,
3454: v_end_activity_id
3455: FROM wf_process_activities
3456: WHERE process_name = c2.process_name
3457: AND instance_label = 'AND'
3458: AND activity_name = 'AND';
3459: EXCEPTION

Line 3468: SELECT wf_process_activities_s.nextval

3464: END;
3465:
3466: IF v_end_found_flag = 'N' THEN
3467: v_error_level := 2162;
3468: SELECT wf_process_activities_s.nextval
3469: INTO v_and_activity_id
3470: FROM dual;
3471:
3472: v_error_level := 2163;

Line 3905: wf_process_activities wpa,

3901: instance_id,
3902: wa.name,
3903: wa.result_type
3904: from
3905: wf_process_activities wpa,
3906: wf_activities wa
3907: where wpa.activity_name = wa.name
3908: and wpa.process_name = 'UPG_PN_'||p_item_type||'_'||p_line_type||'_'||to_char(p_cycle_id)
3909: and wa.type = 'NOTICE';

Line 4043: wf_process_activities_s.nextval into v_instance_id

4039: );
4040:
4041: -- dbms_output.put_line('033');
4042: select
4043: wf_process_activities_s.nextval into v_instance_id
4044: from dual;
4045:
4046: -- dbms_output.put_line('043');
4047: v_api_error_code := 0;

Line 4088: wf_process_activities_s.nextval into v_or_instance_id

4084: -- dbms_output.put_line('063');
4085: /* Insert process activity OR - */
4086:
4087: select
4088: wf_process_activities_s.nextval into v_or_instance_id
4089: from dual;
4090:
4091: -- dbms_output.put_line('073');
4092: v_activity_name := 'OR';

Line 4144: select wf_process_activities_s.nextval into v_or_instance_id2

4140:
4141:
4142: for c4 in c3 loop
4143: /* for the same result_code from the PreNot and the Not, go to the OR-n */
4144: select wf_process_activities_s.nextval into v_or_instance_id2
4145: from dual;
4146:
4147: v_activity_name := 'OR';
4148: