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_LOAD

Line 105: wf_load.upload_activity_transition (

101: AND to_process_activity = p_to_instance_id;
102:
103: EXCEPTION
104: WHEN NO_DATA_FOUND THEN
105: wf_load.upload_activity_transition (
106: x_from_process_activity => p_from_instance_id,
107: x_result_code => p_result_code,
108: x_to_process_activity => p_to_instance_id,
109: x_protect_level => 20,

Line 210: wf_load.upload_activity (

206: and version = v_version;
207: exception
208: when no_data_found then
209: /* Insert data into WF_ACTIVITIES */
210: wf_load.upload_activity (
211: x_item_type => p_item_type,
212: x_name => v_process_name,
213: x_display_name => v_display_name,
214: x_description => NULL,

Line 301: wf_load.upload_lookup_type (

297:
298: v_error_level := 2011;
299:
300: /* Insert data into WF_LOOKUP_TYPES_TL */
301: wf_load.upload_lookup_type (
302: x_lookup_type => c2.lookup_type,
303: x_display_name => c2.display_name,
304: x_description => c2.description,
305: x_protect_level => c2.protect_level,

Line 393: wf_load.upload_lookup

389:
390: v_error_level := 2021;
391:
392: /* Insert data into WF_LOOKUPS_TL */
393: wf_load.upload_lookup
394: (
395: x_lookup_type => c2.lookup_type,
396: x_lookup_code => c2.lookup_code,
397: x_meaning => c2.meaning,

Line 525: WF_LOAD.UPLOAD_ACTIVITY (

521: end if;
522:
523: v_error_level := 2032;
524: /* Insert data into WF_ACITVITIES */
525: WF_LOAD.UPLOAD_ACTIVITY (
526: x_item_type => c2.item_type,
527: x_name => c2.activity_name,
528: x_display_name => c2.display_name,
529: x_description => c2.activity_name,

Line 553: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

549: x_level_error => v_api_error_code
550: );
551: --sam
552: if c2.type <> 'NOTICE' then
553: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
554: x_activity_item_type => c2.item_type,
555: x_activity_name => c2.activity_name,
556: x_activity_version => v_version,
557: x_name => 'S_COLUMN',

Line 571: Wf_Load.UPLOAD_MESSAGE (

567: x_value_type => 'CONSTANT',
568: x_level_error => v_api_error_code
569: ) ;
570: else
571: Wf_Load.UPLOAD_MESSAGE (
572: x_type=> c2.item_type,
573: x_name=> c2.activity_name,
574: x_display_name=> v_name,
575: x_description=> v_name,

Line 587: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

583: x_write_role=> null,
584: x_level_error=> v_api_error_code
585: );
586:
587: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(
588: x_message_type=> c2.item_Type,
589: x_message_name=> c2.activity_name,
590: x_name=> v_short_name,
591: x_display_name=> v_short_name,

Line 606: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

602: x_level_error=> v_api_error_code
603: );
604:
605: if v_fyi_flag = 'N' then
606: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(
607: x_message_type=> c2.item_Type,
608: x_message_name=> c2.activity_name,
609: x_name=> 'RESULT',
610: x_display_name=> 'RESULT',

Line 749: wf_load.upload_process_activity

745: IF v_check_duplicate_flag = 'N' THEN
746:
747: v_error_level := 2042;
748: -- dbms_output.put_line('attempting to insert:= '||c2.process_name||'**'||c2.activity_name);
749: wf_load.upload_process_activity
750: (
751: x_process_item_type => c2.process_item_type,
752: x_process_name => c2.process_name,
753: x_process_version => c2.process_version,

Line 772: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

768: -- dbms_output.put_line('inserted := '||c2.process_name||'**'||c2.activity_name);
769:
770:
771: if nvl(c2.approval,'-') <> 'Y' then
772: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
773: x_process_activity_id => c2.instance_id,
774: x_name => 'S_COLUMN',
775: x_protect_level => 20,
776: x_custom_level => 20,

Line 812: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

808: FROM dual;
809:
810: -- dbms_output.put_line('will be loading the Pr.Act. ');
811: v_error_level := 2142;
812: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
813: x_process_item_type => p_item_type,
814: x_process_name => 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id),
815: x_process_version => 1,
816: x_activity_item_type => 'WFSTD',

Line 1043: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

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,
1047: x_activity_item_type => 'WFSTD',

Line 1269: wf_load.upload_activity (

1265: EXCEPTION
1266: WHEN NO_DATA_FOUND THEN
1267: v_error_level := 2062;
1268: -- dbms_output.put_line('Stage D5');
1269: wf_load.upload_activity (
1270: x_item_type => 'OEOH',
1271: x_name => v_hdr_activity_name,
1272: x_display_name => v_hdr_activity_name,
1273: x_description => NULL,

Line 1301: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1297:
1298: -- dbms_output.put_line('Activity inserted--'||v_hdr_activity_name);
1299:
1300: v_error_level := 2063;
1301: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1302: x_activity_item_type => 'OEOH',
1303: x_activity_name => v_hdr_activity_name,
1304: x_activity_version => 1,
1305: x_name => 'WAITING_ACTIVITY',

Line 1324: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1320: -- dbms_output.put_line('api error attr: ' || to_char(v_api_error_code));
1321: -- dbms_output.put_line('Attribute inserted-1-'||v_hdr_activity_name||'-WAITING_ACTIVITY');
1322: -- dbms_output.put_line('attempting insert-'||v_hdr_activity_name||'-WAITING_FLOW');
1323:
1324: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1325: x_activity_item_type => 'OEOH',
1326: x_activity_name => v_hdr_activity_name,
1327: x_activity_version => 1,
1328: x_name => 'WAITING_FLOW',

Line 1387: wf_load.upload_process_activity

1383: FROM dual;
1384:
1385: -- dbms_output.put_line('seq okay');
1386:
1387: wf_load.upload_process_activity
1388: (
1389: x_process_item_type => 'OEOH',
1390: x_process_name => v_hdr_process_name,
1391: x_process_version => 1,

Line 1417: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1413:
1414: -- dbms_output.put_line('Stage D17');
1415:
1416: v_error_level := 2067;
1417: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1418: x_process_activity_id => v_instance_id,
1419: x_name => 'WAITING_ACTIVITY',
1420: x_protect_level => 20,
1421: x_custom_level => 20,

Line 1432: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1428: -- ||to_char(v_instance_id));
1429: -- dbms_output.put_line('api error value1: ' || to_char(v_api_error_code));
1430:
1431: v_error_level := 2068;
1432: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1433: x_process_activity_id => v_instance_id,
1434: x_name => 'WAITING_FLOW',
1435: x_protect_level => 20,
1436: x_custom_level => 20,

Line 1521: wf_load.upload_activity (

1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN
1519: v_error_level := 2071;
1520: -- dbms_output.put_line('Stage D23');
1521: wf_load.upload_activity (
1522: x_item_type => 'OEOL',
1523: x_name => v_lin_activity_name,
1524: x_display_name => v_lin_activity_name,
1525: x_description => NULL,

Line 1551: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1547:
1548: -- dbms_output.put_line('Activity Inserted --'||v_lin_activity_name);
1549:
1550: v_error_level := 2072;
1551: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1552: x_activity_item_type => 'OEOL',
1553: x_activity_name => v_lin_activity_name,
1554: x_activity_version => 1,
1555: x_name => 'CONTINUATION_ACTIVITY',

Line 1572: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1568:
1569: -- dbms_output.put_line('Activity Attr Inserted -1-'||v_lin_activity_name);
1570:
1571: v_error_level := 2073;
1572: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1573: x_activity_item_type => 'OEOL',
1574: x_activity_name => v_lin_activity_name,
1575: x_activity_version => 1,
1576: x_name => 'CONTINUATION_FLOW',

Line 1621: wf_load.upload_process_activity

1617:
1618: -- dbms_output.put_line('before insertion of activity:='
1619: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1620:
1621: wf_load.upload_process_activity
1622: (
1623: x_process_item_type => 'OEOL',
1624: x_process_name => v_lin_process_name,
1625: x_process_version => 1,

Line 1649: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1645: NULL;
1646: END IF;
1647:
1648: v_error_level := 2076;
1649: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1650: x_process_activity_id => v_instance_id,
1651: x_name => 'CONTINUATION_ACTIVITY',
1652: x_protect_level => 20,
1653: x_custom_level => 20,

Line 1663: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1659:
1660: -- dbms_output.put_line('Activity Attr value Inserted -1-'||v_lin_activity_name);
1661:
1662: v_error_level := 2077;
1663: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1664: x_process_activity_id => v_instance_id,
1665: x_name => 'CONTINUATION_FLOW',
1666: x_protect_level => 20,
1667: x_custom_level => 20,

Line 1749: wf_load.upload_process_activity

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,
1753: x_process_version => 1,

Line 1952: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

1948: v_activity := 'AND';
1949: END IF;
1950:
1951: v_error_level := 2082;
1952: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
1953: x_process_item_type => p_item_type,
1954: x_process_name => v_process_name,
1955: x_process_version => 1,
1956: x_activity_item_type => 'WFSTD',

Line 2516: WF_LOAD.Delete_Process_Activity

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
2519: );
2520:

Line 2612: WF_LOAD.UPLOAD_PROCESS_ACTIVITY ( x_process_item_type => 'OEOL',

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',
2613: x_process_name => 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id),
2614: x_process_version => 1,
2615: x_activity_item_type => 'OEOL',
2616: x_activity_name => 'UPG_CONFIGURATION_LINE',

Line 2674: WF_LOAD.Delete_Process_Activity

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
2677: );
2678:

Line 2754: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2750: SELECT wf_process_activities_s.nextval
2751: INTO v_and_instance_id1
2752: FROM dual;
2753:
2754: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2755: x_process_item_type => 'OEOL',
2756: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2757: x_process_version => 1,
2758: x_activity_item_type => 'WFSTD',

Line 2813: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2809: SELECT wf_process_activities_s.nextval
2810: INTO v_and_instance_id2
2811: FROM dual;
2812:
2813: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2814: x_process_item_type => 'OEOL',
2815: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2816: x_process_version => 1,
2817: x_activity_item_type => 'WFSTD',

Line 2867: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2863: SELECT wf_process_activities_s.nextval
2864: INTO v_get_category_instance_id
2865: FROM dual;
2866:
2867: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2868: x_process_item_type => 'OEOL',
2869: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2870: x_process_version => 1,
2871: x_activity_item_type => 'OEOL',

Line 3004: wf_load.upload_process_activity

3000: SELECT wf_process_activities_s.nextval
3001: INTO v_instance_id
3002: FROM dual;
3003:
3004: wf_load.upload_process_activity
3005: (
3006: x_process_item_type => p_item_type,
3007: x_process_name => 'UPG_PN_' || p_item_type || '_' || p_line_type || '_' || to_char(p_cycle_id),
3008: x_process_version => 1,

Line 3023: wf_load.upload_activity_attr_value

3019: x_perform_role_type => 'CONSTANT',
3020: x_user_comment => NULL,
3021: x_level_error => v_api_error_code
3022: );
3023: wf_load.upload_activity_attr_value
3024: (
3025: x_process_activity_id => v_instance_id,
3026: x_name => 'WAIT_MODE',
3027: x_protect_level => 20,

Line 3034: wf_load.upload_activity_attr_value

3030: x_value_type => 'CONSTANT',
3031: x_effective_date => sysdate - 1,
3032: x_level_error => v_api_error_code
3033: );
3034: wf_load.upload_activity_attr_value
3035: (
3036: x_process_activity_id => v_instance_id,
3037: x_name => 'WAIT_RELATIVE_TIME',
3038: x_protect_level => 20,

Line 3247: WF_LOAD.Delete_Process_Activity(p_step=> v_delete_wait_instance);

3243: and to_process_activity = c6.to_process_activity;
3244: END;
3245: end loop;
3246: -- delete the extra WAIT
3247: WF_LOAD.Delete_Process_Activity(p_step=> v_delete_wait_instance);
3248: END IF;
3249: end loop;
3250: END Wait_Flow_Adjusting;
3251:

Line 3473: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

3469: INTO v_and_activity_id
3470: FROM dual;
3471:
3472: v_error_level := 2163;
3473: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3474: x_process_item_type => c2.process_item_type,
3475: x_process_name => c2.process_name,
3476: x_process_version => 1,
3477: x_activity_item_type => 'WFSTD',

Line 3493: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

3489: x_level_error => v_api_error_level
3490: );
3491:
3492: /* Create END activity */
3493: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3494: x_process_item_type => c2.process_item_type,
3495: x_process_name => c2.process_name,
3496: x_process_version => 1,
3497: x_activity_item_type => 'WFSTD',

Line 3513: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (

3509: x_level_error => v_api_error_level
3510: );
3511:
3512: /* Establish the relation between 'AND' and 'END'*/
3513: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (
3514: x_from_process_activity => v_and_activity_id,
3515: x_result_code => '*',
3516: x_to_process_activity => v_end_activity_id,
3517: x_protect_level => 20,

Line 3526: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (

3522:
3523: END IF;
3524:
3525: v_error_level := 2164;
3526: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (
3527: x_from_process_activity => c2.to_process_activity,
3528: x_result_code => '*',
3529: x_to_process_activity => v_end_activity_id,
3530: x_protect_level => 20,

Line 3983: wf_load.upload_activity (

3979: end;
3980:
3981: -- dbms_output.put_line('..3');
3982:
3983: wf_load.upload_activity (
3984: x_item_type => P_item_type,
3985: x_name => v_activity_name,
3986: x_display_name => v_activity_name,
3987: x_description => NULL,

Line 4011: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

4007: x_level_error => v_api_error_code
4008: );
4009:
4010: -- dbms_output.put_line('013');
4011: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
4012: x_activity_item_type => P_item_type,
4013: x_activity_name => v_activity_name,
4014: x_activity_version => 1,
4015: x_name => 'S_COLUMN',

Line 4030: wf_load.upload_lookup

4026: x_level_error => v_api_error_code
4027: ) ;
4028:
4029: -- dbms_output.put_line('023');
4030: wf_load.upload_lookup
4031: (
4032: x_lookup_type => v_result_type,
4033: x_lookup_code => 'NOT_PROCESSED',
4034: x_meaning => 'NOT_PROCESSED_NOTN_'||c2.name,

Line 4051: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4047: v_api_error_code := 0;
4048:
4049: -- dbms_output.put_line('Stage 2');
4050:
4051: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4052: x_process_item_type => p_item_type,
4053: x_process_name => v_process_name,
4054: x_process_version => 1,
4055: x_activity_item_type => p_item_type,

Line 4072: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

4068: );
4069:
4070:
4071: -- dbms_output.put_line('053');
4072: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
4073: x_process_activity_id => v_instance_id,
4074: x_name => 'S_COLUMN',
4075: x_protect_level => 20,
4076: x_custom_level => 20,

Line 4096: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4092: v_activity_name := 'OR';
4093:
4094: -- dbms_output.put_line('Stage 2');
4095:
4096: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4097: x_process_item_type => p_item_type,
4098: x_process_name => v_process_name,
4099: x_process_version => 1,
4100: x_activity_item_type => 'WFSTD',

Line 4134: wf_load.delete_transition (

4130: );
4131:
4132: /* Delete the transition between A and Notfn. */
4133:
4134: wf_load.delete_transition (
4135: p_previous_step => c6.from_process_activity,
4136: p_next_step => c2.instance_id,
4137: p_result_code => v_result_code
4138: );

Line 4149: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4145: from dual;
4146:
4147: v_activity_name := 'OR';
4148:
4149: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4150: x_process_item_type => p_item_type,
4151: x_process_name => v_process_name,
4152: x_process_version => 1,
4153: x_activity_item_type => 'WFSTD',