[Home] [Help]
82:
83: IS
84:
85: BEGIN
86: wf_core.session_level := 20;
87:
88: /* Insert into table wf_activity_transitions */
89: BEGIN
90:
164: v_process_name VARCHAR2(80);
165:
166: BEGIN
167:
168: wf_core.session_level := 20;
169:
170: BEGIN
171:
172: SELECT 'x' INTO v_dummy
275: v_lookup_type VARCHAR2(80);
276:
277: BEGIN
278: -- dbms_output.enable(999999999999);
279: wf_core.session_level := 20;
280:
281: FOR c2 IN c1 LOOP
282: v_api_error_code := 0;
283:
362:
363: BEGIN
364: -- dbms_output.enable(999999999999);
365: v_api_error_code := 0;
366: wf_core.session_level := 20;
367:
368: -- dbms_output.put_line('Just entered...');
369: FOR c2 IN c1 LOOP
370: -- dbms_output.put_line('Entering loop..');
472:
473: BEGIN
474: -- dbms_output.enable('999999999');
475: v_api_error_code := 0;
476: wf_core.session_level := 20;
477:
478: FOR c2 IN c1 LOOP
479:
480: v_error_level := 2031;
620: END;
621:
622: -- dbms_output.put_line('Completed : '||v_name||' Error : '
623: -- ||to_char(v_api_error_code)||'---'
624: -- ||to_char(wf_core.session_level));
625: END LOOP;
626:
627: V_ERROR_FLAG := 'N';
628: EXCEPTION
692: v_instance_label VARCHAR2(80);
693: v_instance_id NUMBER;
694: BEGIN
695: -- dbms_output.enable('999999999');
696: wf_core.session_level := 20;
697: FOR c2 in c1 LOOP
698:
699: v_error_level := 2041;
700: v_api_error_code := 0;
905:
906: BEGIN
907: -- dbms_output.enable('999999999');
908: -- dbms_output.put_line('Entered program');
909: wf_core.session_level := 20;
910: v_cycle_action_id := 0;
911:
912: FOR c2 IN c1 LOOP
913:
1211:
1212: BEGIN
1213: -- dbms_output.enable('9999999999');
1214: -- dbms_output.put_line('Starting Program');
1215: wf_core.session_level := 20;
1216: v_book_flag := 'N';
1217: FOR c2 IN c1 LOOP
1218: v_error_level := 2061;
1219: -- dbms_output.put_line('Entering INTO C2 loop');
1890: v_count NUMBER;
1891: v_activity VARCHAR2(30);
1892:
1893: BEGIN
1894: wf_core.session_level := 20;
1895: v_cycle_action_id := 0;
1896:
1897: FOR c2 IN c1 LOOP
1898: v_error_level := 2081;
2461: from wf_activity_transitions
2462: where to_process_activity = v_instance_id;
2463:
2464: BEGIN
2465: wf_core.session_level := 20;
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
2549: where to_process_activity = v_instance_id;
2550:
2551:
2552: BEGIN
2553: wf_core.session_level := 20;
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
2717: from wf_activity_transitions
2718: where to_process_activity = v_rma_instance_id;
2719:
2720: BEGIN
2721: wf_core.session_level := 20;
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
2938: v_api_error_code NUMBER;
2939: v_instance_id NUMBER;
2940:
2941: BEGIN
2942: wf_core.session_level := 20;
2943: FOR c2 in c1 LOOP
2944: v_error_level := 2131;
2945: /* Insert into transtion table */
2946: SELECT count(distinct result_code)
3098:
3099: BEGIN
3100: -- dbms_output.enable('9999999999');
3101:
3102: wf_core.session_level := 20;
3103: -- dbms_output.put_line('Entered program');
3104:
3105: v_instance_id := oe_upgrade_wf.get_instance_id
3106: ('UPG_PN_OEOL'||'_'||p_line_type
3296: and process_name like 'UPG_PN%'
3297: and icon_geometry = '0,0';
3298:
3299: BEGIN
3300: wf_core.session_level := 20;
3301: -- dbms_output.put_line('Entered into c1');
3302:
3303: v_error_level := 2151;
3304: WHILE v_flag = 'Y' LOOP
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
3429: wf_core.session_level := 20;
3430: FOR c2 in c1 LOOP
3431: v_error_level := 2161;
3432: v_end_found_flag := 'N';
3433: BEGIN