[Home] [Help]
87:
88: IS
89:
90: BEGIN
91: wf_core.session_level := 20;
92:
93: /* Insert into table wf_activity_transitions */
94: BEGIN
95:
169: v_process_name VARCHAR2(80);
170:
171: BEGIN
172:
173: wf_core.session_level := 20;
174:
175: BEGIN
176:
177: SELECT 'x' INTO v_dummy
280: v_lookup_type VARCHAR2(80);
281:
282: BEGIN
283: -- dbms_output.enable(999999999999);
284: wf_core.session_level := 20;
285:
286: FOR c2 IN c1 LOOP
287: v_api_error_code := 0;
288:
367:
368: BEGIN
369: -- dbms_output.enable(999999999999);
370: v_api_error_code := 0;
371: wf_core.session_level := 20;
372:
373: -- dbms_output.put_line('Just entered...');
374: FOR c2 IN c1 LOOP
375: -- dbms_output.put_line('Entering loop..');
477:
478: BEGIN
479: -- dbms_output.enable('999999999');
480: v_api_error_code := 0;
481: wf_core.session_level := 20;
482:
483: FOR c2 IN c1 LOOP
484:
485: v_error_level := 2031;
625: END;
626:
627: -- dbms_output.put_line('Completed : '||v_name||' Error : '
628: -- ||to_char(v_api_error_code)||'---'
629: -- ||to_char(wf_core.session_level));
630: END LOOP;
631:
632: V_ERROR_FLAG := 'N';
633: EXCEPTION
698: v_instance_id NUMBER;
699: v_booked_count NUMBER;
700: BEGIN
701: -- dbms_output.enable('999999999');
702: wf_core.session_level := 20;
703: FOR c2 in c1 LOOP
704: /* We want to add UPG_BOOK_PROCESS_ASYNCH only if the original cycle has
705: an action with a pre-req of Enter -Booked (1-1) */
706: IF c2.activity_name = 'UPG_BOOK_PROCESS_ASYNCH' THEN
919:
920: BEGIN
921: -- dbms_output.enable('999999999');
922: -- dbms_output.put_line('Entered program');
923: wf_core.session_level := 20;
924: v_cycle_action_id := 0;
925:
926: FOR c2 IN c1 LOOP
927:
1223:
1224: BEGIN
1225: -- dbms_output.enable('9999999999');
1226: -- dbms_output.put_line('Starting Program');
1227: wf_core.session_level := 20;
1228: v_book_flag := 'N';
1229: FOR c2 IN c1 LOOP
1230: v_error_level := 2061;
1231: -- dbms_output.put_line('Entering INTO C2 loop');
1902: v_count NUMBER;
1903: v_activity VARCHAR2(30);
1904:
1905: BEGIN
1906: wf_core.session_level := 20;
1907: v_cycle_action_id := 0;
1908:
1909: FOR c2 IN c1 LOOP
1910: v_error_level := 2081;
2476: from wf_activity_transitions
2477: where to_process_activity = v_instance_id;
2478:
2479: BEGIN
2480: wf_core.session_level := 20;
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
2564: where to_process_activity = v_instance_id;
2565:
2566:
2567: BEGIN
2568: wf_core.session_level := 20;
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
2732: from wf_activity_transitions
2733: where to_process_activity = v_rma_instance_id;
2734:
2735: BEGIN
2736: wf_core.session_level := 20;
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
2953: v_api_error_code NUMBER;
2954: v_instance_id NUMBER;
2955:
2956: BEGIN
2957: wf_core.session_level := 20;
2958: FOR c2 in c1 LOOP
2959: v_error_level := 2131;
2960: /* Insert into transtion table */
2961: SELECT count(distinct result_code)
3113:
3114: BEGIN
3115: -- dbms_output.enable('9999999999');
3116:
3117: wf_core.session_level := 20;
3118: -- dbms_output.put_line('Entered program');
3119:
3120: v_instance_id := oe_upgrade_wf2.get_instance_id
3121: ('UPG_PN_OEOL'||'_'||p_line_type
3311: and process_name like 'UPG_PN%'
3312: and icon_geometry = '0,0';
3313:
3314: BEGIN
3315: wf_core.session_level := 20;
3316: -- dbms_output.put_line('Entered into c1');
3317:
3318: v_error_level := 2151;
3319: WHILE v_flag = 'Y' LOOP
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
3444: wf_core.session_level := 20;
3445: FOR c2 in c1 LOOP
3446: v_error_level := 2161;
3447: v_end_found_flag := 'N';
3448: BEGIN