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_VALIDATE_WF dependencies on WF_ACTIVITIES

Line 8: G_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VALIDATE_WF';
6:
7: -- Global variables used in the package
8: G_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
9: G_loop_tbl NumberTable;
10: G_exit_from_loop VARCHAR2(3) := 'NO';
11: /*----------------------------------------------------------------
12: Function Display_Name

Line 46: FROM wf_activities_tl wa

42: oe_debug_pub.add('Entering Display_Name for process : '||l_process,5);
43:
44: SELECT DISTINCT wa.name, wa.display_name
45: INTO l_process_name, l_display_name
46: FROM wf_activities_tl wa
47: WHERE wa.item_type = l_item_type
48: AND wa.name = l_process
49: AND wa.language = userenv('LANG')
50: AND wa.version =

Line 52: FROM wf_activities_tl p1

48: AND wa.name = l_process
49: AND wa.language = userenv('LANG')
50: AND wa.version =
51: ( SELECT MAX(p1.version)
52: FROM wf_activities_tl p1
53: WHERE p1.item_type = wa.item_type
54: AND p1.name = wa.name
55: AND p1.language = wa.language
56: );

Line 215: , wf_activities wa

211: , l_process VARCHAR2) IS
212: SELECT p.activity_name
213: , p.activity_item_type
214: FROM wf_process_activities p
215: , wf_activities wa
216: WHERE p.process_item_type = l_process_item_type
217: AND p.process_name = l_process
218: AND p.activity_item_type = wa.item_type
219: AND p.activity_name = wa.name

Line 228: FROM wf_activities wa1

224: WHERE p1.process_item_type = p.process_item_type
225: AND p1.process_name = p.process_name
226: )
227: AND wa.version = ( SELECT MAX(wa1.version)
228: FROM wf_activities wa1
229: WHERE wa1.item_type = wa.item_type
230: AND wa1.name = wa.name
231: );
232:

Line 339: FROM wf_process_activities p , wf_activities w

335: , w.type
336: , w.function
337: , p.instance_label
338: , p.start_end
339: FROM wf_process_activities p , wf_activities w
340: WHERE p.process_item_type = l_process_item_type
341: AND p.process_name = l_process
342: AND p.activity_item_type = w.item_type
343: AND p.activity_name = w.name

Line 361: FROM wf_process_activities p , wf_activities w

357: , w.type
358: , w.function
359: , p.instance_label
360: , p.start_end
361: FROM wf_process_activities p , wf_activities w
362: WHERE p.process_item_type = l_process_item_type
363: AND p.process_name = l_process
364: AND p.activity_item_type = w.item_type
365: AND p.activity_name = w.name

Line 376: , wf_activities wa

372: , l_process_act_version NUMBER) IS
373: SELECT p.activity_name
374: , p.activity_item_type
375: FROM wf_process_activities p
376: , wf_activities wa
377: WHERE p.process_item_type = l_process_item_type
378: AND p.process_name = l_process
379: AND p.activity_item_type = wa.item_type
380: AND p.activity_name = wa.name

Line 911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

907: l_order_flow VARCHAR2(30);
908: l_activity_name VARCHAR2(30);
909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;

Line 912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

908: l_activity_name VARCHAR2(30);
909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;
916: l_end_time NUMBER;

Line 913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;
916: l_end_time NUMBER;
917:

Line 972: FROM wf_activities wa

968:
969: BEGIN
970: SELECT 'YES'
971: INTO l_coresp_cont_act
972: FROM wf_activities wa
973: WHERE wa.function = 'WF_STANDARD.WAITFORFLOW'
974: AND wa.name = l_wait_text_default
975: AND wa.item_type IN ('OEOH','OEOL')
976: AND wa.version = ( SELECT MAX(version)

Line 977: FROM wf_activities wa1

973: WHERE wa.function = 'WF_STANDARD.WAITFORFLOW'
974: AND wa.name = l_wait_text_default
975: AND wa.item_type IN ('OEOH','OEOL')
976: AND wa.version = ( SELECT MAX(version)
977: FROM wf_activities wa1
978: WHERE wa1.item_type = wa.item_type
979: AND wa1.name = wa.name );
980: -- The above sql ensures that the WAITING_ACTIVITY given by
981: -- the previous sql has a function of type WAITFORFLOW

Line 1075: FROM wf_activities wa

1071:
1072: BEGIN
1073: SELECT 'YES'
1074: INTO l_coresp_wait_act
1075: FROM wf_activities wa
1076: WHERE wa.function = 'WF_STANDARD.CONTINUEFLOW'
1077: AND wa.name = l_cont_text_default
1078: AND wa.item_type IN ('OEOH','OEOL')
1079: AND wa.version = ( SELECT MAX(version)

Line 1080: FROM wf_activities wa1

1076: WHERE wa.function = 'WF_STANDARD.CONTINUEFLOW'
1077: AND wa.name = l_cont_text_default
1078: AND wa.item_type IN ('OEOH','OEOL')
1079: AND wa.version = ( SELECT MAX(version)
1080: FROM wf_activities wa1
1081: WHERE wa1.item_type = wa.item_type
1082: AND wa1.name = wa.name );
1083: -- The above sql ensures that the CONTINUATION_ACTIVITY
1084: -- given by the previous sql has a function of type CONTINUEFLOW

Line 1421: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1417: l_instance NUMBER;
1418: l_name VARCHAR2(30);
1419: l_type VARCHAR2(8);
1420: l_from_process_activity_exists VARCHAR2(1);
1421: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1422: l_start_time NUMBER;
1423: l_end_time NUMBER;
1424: -- l_start_end VARCHAR2(8);
1425:

Line 1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1540: l_fulfill_act_exists VARCHAR2(1);
1541: l_type VARCHAR2(8);
1542: l_attr_first_time VARCHAR2(2000);
1543: l_line_process_name VARCHAR2(30);
1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1546: l_start_time NUMBER;
1547: l_end_time NUMBER;
1548: testing_instance NUMBER;

Line 1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1541: l_type VARCHAR2(8);
1542: l_attr_first_time VARCHAR2(2000);
1543: l_line_process_name VARCHAR2(30);
1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1546: l_start_time NUMBER;
1547: l_end_time NUMBER;
1548: testing_instance NUMBER;
1549: hdr_instance NUMBER;

Line 1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1985: l_msg_data VARCHAR2(2000);
1986: l_quick_val BOOLEAN := TRUE;
1987: l_msg_count NUMBER;
1988: l_order_type_id NUMBER := NULL;
1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1991: l_start_time NUMBER;
1992: l_end_time NUMBER;
1993: testing_instance NUMBER;

Line 1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1986: l_quick_val BOOLEAN := TRUE;
1987: l_msg_count NUMBER;
1988: l_order_type_id NUMBER := NULL;
1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1991: l_start_time NUMBER;
1992: l_end_time NUMBER;
1993: testing_instance NUMBER;
1994: testing_inst NUMBER;