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_LOAD

Line 100: wf_load.upload_activity_transition (

96: AND to_process_activity = p_to_instance_id;
97:
98: EXCEPTION
99: WHEN NO_DATA_FOUND THEN
100: wf_load.upload_activity_transition (
101: x_from_process_activity => p_from_instance_id,
102: x_result_code => p_result_code,
103: x_to_process_activity => p_to_instance_id,
104: x_protect_level => 20,

Line 205: wf_load.upload_activity (

201: and version = v_version;
202: exception
203: when no_data_found then
204: /* Insert data into WF_ACTIVITIES */
205: wf_load.upload_activity (
206: x_item_type => p_item_type,
207: x_name => v_process_name,
208: x_display_name => v_display_name,
209: x_description => NULL,

Line 296: wf_load.upload_lookup_type (

292:
293: v_error_level := 2011;
294:
295: /* Insert data into WF_LOOKUP_TYPES_TL */
296: wf_load.upload_lookup_type (
297: x_lookup_type => c2.lookup_type,
298: x_display_name => c2.display_name,
299: x_description => c2.description,
300: x_protect_level => c2.protect_level,

Line 388: wf_load.upload_lookup

384:
385: v_error_level := 2021;
386:
387: /* Insert data into WF_LOOKUPS_TL */
388: wf_load.upload_lookup
389: (
390: x_lookup_type => c2.lookup_type,
391: x_lookup_code => c2.lookup_code,
392: x_meaning => c2.meaning,

Line 520: WF_LOAD.UPLOAD_ACTIVITY (

516: end if;
517:
518: v_error_level := 2032;
519: /* Insert data into WF_ACITVITIES */
520: WF_LOAD.UPLOAD_ACTIVITY (
521: x_item_type => c2.item_type,
522: x_name => c2.activity_name,
523: x_display_name => c2.display_name,
524: x_description => c2.activity_name,

Line 548: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

544: x_level_error => v_api_error_code
545: );
546: --sam
547: if c2.type <> 'NOTICE' then
548: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
549: x_activity_item_type => c2.item_type,
550: x_activity_name => c2.activity_name,
551: x_activity_version => v_version,
552: x_name => 'S_COLUMN',

Line 566: Wf_Load.UPLOAD_MESSAGE (

562: x_value_type => 'CONSTANT',
563: x_level_error => v_api_error_code
564: ) ;
565: else
566: Wf_Load.UPLOAD_MESSAGE (
567: x_type=> c2.item_type,
568: x_name=> c2.activity_name,
569: x_display_name=> v_name,
570: x_description=> v_name,

Line 582: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

578: x_write_role=> null,
579: x_level_error=> v_api_error_code
580: );
581:
582: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(
583: x_message_type=> c2.item_Type,
584: x_message_name=> c2.activity_name,
585: x_name=> v_short_name,
586: x_display_name=> v_short_name,

Line 601: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(

597: x_level_error=> v_api_error_code
598: );
599:
600: if v_fyi_flag = 'N' then
601: Wf_Load.UPLOAD_MESSAGE_ATTRIBUTE(
602: x_message_type=> c2.item_Type,
603: x_message_name=> c2.activity_name,
604: x_name=> 'RESULT',
605: x_display_name=> 'RESULT',

Line 725: wf_load.upload_process_activity

721: IF v_check_duplicate_flag = 'N' THEN
722:
723: v_error_level := 2042;
724: -- dbms_output.put_line('attempting to insert:= '||c2.process_name||'**'||c2.activity_name);
725: wf_load.upload_process_activity
726: (
727: x_process_item_type => c2.process_item_type,
728: x_process_name => c2.process_name,
729: x_process_version => c2.process_version,

Line 748: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

744: -- dbms_output.put_line('inserted := '||c2.process_name||'**'||c2.activity_name);
745:
746:
747: if nvl(c2.approval,'-') <> 'Y' then
748: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
749: x_process_activity_id => c2.instance_id,
750: x_name => 'S_COLUMN',
751: x_protect_level => 20,
752: x_custom_level => 20,

Line 786: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

782: FROM dual;
783:
784: -- dbms_output.put_line('will be loading the Pr.Act. ');
785: v_error_level := 2142;
786: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
787: x_process_item_type => p_item_type,
788: x_process_name => 'UPG_PN_OEOL_'||p_line_type||'_'||to_char(p_cycle_id),
789: x_process_version => 1,
790: x_activity_item_type => 'WFSTD',

Line 1029: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

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

Line 1257: wf_load.upload_activity (

1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: v_error_level := 2062;
1256: -- dbms_output.put_line('Stage D5');
1257: wf_load.upload_activity (
1258: x_item_type => 'OEOH',
1259: x_name => v_hdr_activity_name,
1260: x_display_name => v_hdr_activity_name,
1261: x_description => NULL,

Line 1289: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1285:
1286: -- dbms_output.put_line('Activity inserted--'||v_hdr_activity_name);
1287:
1288: v_error_level := 2063;
1289: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1290: x_activity_item_type => 'OEOH',
1291: x_activity_name => v_hdr_activity_name,
1292: x_activity_version => 1,
1293: x_name => 'WAITING_ACTIVITY',

Line 1312: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1308: -- dbms_output.put_line('api error attr: ' || to_char(v_api_error_code));
1309: -- dbms_output.put_line('Attribute inserted-1-'||v_hdr_activity_name||'-WAITING_ACTIVITY');
1310: -- dbms_output.put_line('attempting insert-'||v_hdr_activity_name||'-WAITING_FLOW');
1311:
1312: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1313: x_activity_item_type => 'OEOH',
1314: x_activity_name => v_hdr_activity_name,
1315: x_activity_version => 1,
1316: x_name => 'WAITING_FLOW',

Line 1375: wf_load.upload_process_activity

1371: FROM dual;
1372:
1373: -- dbms_output.put_line('seq okay');
1374:
1375: wf_load.upload_process_activity
1376: (
1377: x_process_item_type => 'OEOH',
1378: x_process_name => v_hdr_process_name,
1379: x_process_version => 1,

Line 1405: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1401:
1402: -- dbms_output.put_line('Stage D17');
1403:
1404: v_error_level := 2067;
1405: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1406: x_process_activity_id => v_instance_id,
1407: x_name => 'WAITING_ACTIVITY',
1408: x_protect_level => 20,
1409: x_custom_level => 20,

Line 1420: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1416: -- ||to_char(v_instance_id));
1417: -- dbms_output.put_line('api error value1: ' || to_char(v_api_error_code));
1418:
1419: v_error_level := 2068;
1420: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1421: x_process_activity_id => v_instance_id,
1422: x_name => 'WAITING_FLOW',
1423: x_protect_level => 20,
1424: x_custom_level => 20,

Line 1509: wf_load.upload_activity (

1505: EXCEPTION
1506: WHEN NO_DATA_FOUND THEN
1507: v_error_level := 2071;
1508: -- dbms_output.put_line('Stage D23');
1509: wf_load.upload_activity (
1510: x_item_type => 'OEOL',
1511: x_name => v_lin_activity_name,
1512: x_display_name => v_lin_activity_name,
1513: x_description => NULL,

Line 1539: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1535:
1536: -- dbms_output.put_line('Activity Inserted --'||v_lin_activity_name);
1537:
1538: v_error_level := 2072;
1539: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1540: x_activity_item_type => 'OEOL',
1541: x_activity_name => v_lin_activity_name,
1542: x_activity_version => 1,
1543: x_name => 'CONTINUATION_ACTIVITY',

Line 1560: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

1556:
1557: -- dbms_output.put_line('Activity Attr Inserted -1-'||v_lin_activity_name);
1558:
1559: v_error_level := 2073;
1560: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
1561: x_activity_item_type => 'OEOL',
1562: x_activity_name => v_lin_activity_name,
1563: x_activity_version => 1,
1564: x_name => 'CONTINUATION_FLOW',

Line 1609: wf_load.upload_process_activity

1605:
1606: -- dbms_output.put_line('before insertion of activity:='
1607: -- ||v_lin_process_name||'=='||v_lin_activity_name);
1608:
1609: wf_load.upload_process_activity
1610: (
1611: x_process_item_type => 'OEOL',
1612: x_process_name => v_lin_process_name,
1613: x_process_version => 1,

Line 1637: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1633: NULL;
1634: END IF;
1635:
1636: v_error_level := 2076;
1637: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1638: x_process_activity_id => v_instance_id,
1639: x_name => 'CONTINUATION_ACTIVITY',
1640: x_protect_level => 20,
1641: x_custom_level => 20,

Line 1651: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

1647:
1648: -- dbms_output.put_line('Activity Attr value Inserted -1-'||v_lin_activity_name);
1649:
1650: v_error_level := 2077;
1651: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
1652: x_process_activity_id => v_instance_id,
1653: x_name => 'CONTINUATION_FLOW',
1654: x_protect_level => 20,
1655: x_custom_level => 20,

Line 1737: wf_load.upload_process_activity

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

Line 1940: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

1936: v_activity := 'AND';
1937: END IF;
1938:
1939: v_error_level := 2082;
1940: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
1941: x_process_item_type => p_item_type,
1942: x_process_name => v_process_name,
1943: x_process_version => 1,
1944: x_activity_item_type => 'WFSTD',

Line 2501: WF_LOAD.Delete_Process_Activity

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
2504: );
2505:

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

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',
2598: x_process_name => 'UPG_PN_OEOL_CFG_'||to_char(p_cycle_id),
2599: x_process_version => 1,
2600: x_activity_item_type => 'OEOL',
2601: x_activity_name => 'UPG_CONFIGURATION_LINE',

Line 2659: WF_LOAD.Delete_Process_Activity

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
2662: );
2663:

Line 2739: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2735: SELECT wf_process_activities_s.nextval
2736: INTO v_and_instance_id1
2737: FROM dual;
2738:
2739: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2740: x_process_item_type => 'OEOL',
2741: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2742: x_process_version => 1,
2743: x_activity_item_type => 'WFSTD',

Line 2798: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2794: SELECT wf_process_activities_s.nextval
2795: INTO v_and_instance_id2
2796: FROM dual;
2797:
2798: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2799: x_process_item_type => 'OEOL',
2800: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2801: x_process_version => 1,
2802: x_activity_item_type => 'WFSTD',

Line 2852: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

2848: SELECT wf_process_activities_s.nextval
2849: INTO v_get_category_instance_id
2850: FROM dual;
2851:
2852: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
2853: x_process_item_type => 'OEOL',
2854: x_process_name => 'UPG_PN_'||p_item_type||'_'||p_line_type ||'_'||to_char(p_cycle_id),
2855: x_process_version => 1,
2856: x_activity_item_type => 'OEOL',

Line 2989: wf_load.upload_process_activity

2985: SELECT wf_process_activities_s.nextval
2986: INTO v_instance_id
2987: FROM dual;
2988:
2989: wf_load.upload_process_activity
2990: (
2991: x_process_item_type => p_item_type,
2992: x_process_name => 'UPG_PN_' || p_item_type || '_' || p_line_type || '_' || to_char(p_cycle_id),
2993: x_process_version => 1,

Line 3008: wf_load.upload_activity_attr_value

3004: x_perform_role_type => 'CONSTANT',
3005: x_user_comment => NULL,
3006: x_level_error => v_api_error_code
3007: );
3008: wf_load.upload_activity_attr_value
3009: (
3010: x_process_activity_id => v_instance_id,
3011: x_name => 'WAIT_MODE',
3012: x_protect_level => 20,

Line 3019: wf_load.upload_activity_attr_value

3015: x_value_type => 'CONSTANT',
3016: x_effective_date => sysdate - 1,
3017: x_level_error => v_api_error_code
3018: );
3019: wf_load.upload_activity_attr_value
3020: (
3021: x_process_activity_id => v_instance_id,
3022: x_name => 'WAIT_RELATIVE_TIME',
3023: x_protect_level => 20,

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

3228: and to_process_activity = c6.to_process_activity;
3229: END;
3230: end loop;
3231: -- delete the extra WAIT
3232: WF_LOAD.Delete_Process_Activity(p_step=> v_delete_wait_instance);
3233: END IF;
3234: end loop;
3235: END Wait_Flow_Adjusting;
3236:

Line 3458: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

3454: INTO v_and_activity_id
3455: FROM dual;
3456:
3457: v_error_level := 2163;
3458: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3459: x_process_item_type => c2.process_item_type,
3460: x_process_name => c2.process_name,
3461: x_process_version => 1,
3462: x_activity_item_type => 'WFSTD',

Line 3478: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

3474: x_level_error => v_api_error_level
3475: );
3476:
3477: /* Create END activity */
3478: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
3479: x_process_item_type => c2.process_item_type,
3480: x_process_name => c2.process_name,
3481: x_process_version => 1,
3482: x_activity_item_type => 'WFSTD',

Line 3498: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (

3494: x_level_error => v_api_error_level
3495: );
3496:
3497: /* Establish the relation between 'AND' and 'END'*/
3498: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (
3499: x_from_process_activity => v_and_activity_id,
3500: x_result_code => '*',
3501: x_to_process_activity => v_end_activity_id,
3502: x_protect_level => 20,

Line 3511: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (

3507:
3508: END IF;
3509:
3510: v_error_level := 2164;
3511: WF_LOAD.UPLOAD_ACTIVITY_TRANSITION (
3512: x_from_process_activity => c2.to_process_activity,
3513: x_result_code => '*',
3514: x_to_process_activity => v_end_activity_id,
3515: x_protect_level => 20,

Line 4075: wf_load.upload_activity (

4071: end;
4072:
4073: -- dbms_output.put_line('..3');
4074:
4075: wf_load.upload_activity (
4076: x_item_type => P_item_type,
4077: x_name => v_activity_name,
4078: x_display_name => v_activity_name,
4079: x_description => NULL,

Line 4103: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (

4099: x_level_error => v_api_error_code
4100: );
4101:
4102: -- dbms_output.put_line('013');
4103: WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE (
4104: x_activity_item_type => P_item_type,
4105: x_activity_name => v_activity_name,
4106: x_activity_version => 1,
4107: x_name => 'S_COLUMN',

Line 4122: wf_load.upload_lookup

4118: x_level_error => v_api_error_code
4119: ) ;
4120:
4121: -- dbms_output.put_line('023');
4122: wf_load.upload_lookup
4123: (
4124: x_lookup_type => v_result_type,
4125: x_lookup_code => 'NOT_PROCESSED',
4126: x_meaning => 'NOT_PROCESSED_NOTN_'||c2.name,

Line 4143: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4139: v_api_error_code := 0;
4140:
4141: -- dbms_output.put_line('Stage 2');
4142:
4143: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4144: x_process_item_type => p_item_type,
4145: x_process_name => v_process_name,
4146: x_process_version => 1,
4147: x_activity_item_type => p_item_type,

Line 4164: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (

4160: );
4161:
4162:
4163: -- dbms_output.put_line('053');
4164: WF_LOAD.UPLOAD_ACTIVITY_ATTR_VALUE (
4165: x_process_activity_id => v_instance_id,
4166: x_name => 'S_COLUMN',
4167: x_protect_level => 20,
4168: x_custom_level => 20,

Line 4188: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4184: v_activity_name := 'OR';
4185:
4186: -- dbms_output.put_line('Stage 2');
4187:
4188: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4189: x_process_item_type => p_item_type,
4190: x_process_name => v_process_name,
4191: x_process_version => 1,
4192: x_activity_item_type => 'WFSTD',

Line 4226: wf_load.delete_transition (

4222: );
4223:
4224: /* Delete the transition between A and Notfn. */
4225:
4226: wf_load.delete_transition (
4227: p_previous_step => c6.from_process_activity,
4228: p_next_step => c2.instance_id,
4229: p_result_code => v_result_code
4230: );

Line 4241: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (

4237: from dual;
4238:
4239: v_activity_name := 'OR';
4240:
4241: WF_LOAD.UPLOAD_PROCESS_ACTIVITY (
4242: x_process_item_type => p_item_type,
4243: x_process_name => v_process_name,
4244: x_process_version => 1,
4245: x_activity_item_type => 'WFSTD',