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.IEU_TASKS_USERHOOKS dependencies on IEU_UWQM_WORK_SOURCES_B

Line 29: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

25: l_task_status_id number := null;
26: l_ws_id1 NUMBER;
27: l_ws_id2 NUMBER := null;
28: l_association_ws_id NUMBER;
29: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
30: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
31: l_tasks_rules_func VARCHAR2(500);
32:
33: l_tasks_data_list SYSTEM.WR_TASKS_DATA_NST;

Line 30: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

26: l_ws_id1 NUMBER;
27: l_ws_id2 NUMBER := null;
28: l_association_ws_id NUMBER;
29: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
30: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
31: l_tasks_rules_func VARCHAR2(500);
32:
33: l_tasks_data_list SYSTEM.WR_TASKS_DATA_NST;
34: l_def_data_list SYSTEM.DEF_WR_DATA_NST;

Line 142: from ieu_uwqm_work_sources_b

138: BEGIN
139:
140: Select ws_id
141: into l_ws_id1
142: from ieu_uwqm_work_sources_b
143: --where object_code = 'TASK'
144: --and nvl(not_valid_flag,'N') = 'N';
145: where object_code = l_object_code
146: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 155: from ieu_uwqm_work_sources_b

151: BEGIN
152:
153: Select ws_id
154: into l_ws_id2
155: from ieu_uwqm_work_sources_b
156: where object_code = jtf_tasks_pub.p_task_user_hooks.source_object_type_code
157: -- and nvl(not_valid_flag,'N') = 'N';
158: and nvl(not_valid_flag,'N') = l_not_valid_flag;
159: EXCEPTION

Line 173: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

169: BEGIN
170:
171: SELECT a.ws_id, b.ws_code
172: INTO l_association_ws_id, l_association_ws_code
173: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
174: WHERE child_ws_id = l_ws_id1
175: AND parent_ws_id = l_ws_id2
176: AND a.ws_id = b.ws_id
177: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 403: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

399: l_task_type_id number;
400: l_ws_id1 NUMBER;
401: l_ws_id2 NUMBER := null;
402: l_association_ws_id NUMBER;
403: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
404: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
405: l_tasks_rules_func VARCHAR2(500);
406: l_orig_grp_owner NUMBER;
407:

Line 404: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

400: l_ws_id1 NUMBER;
401: l_ws_id2 NUMBER := null;
402: l_association_ws_id NUMBER;
403: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
404: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
405: l_tasks_rules_func VARCHAR2(500);
406: l_orig_grp_owner NUMBER;
407:
408: l_tasks_data_list SYSTEM.WR_TASKS_DATA_NST;

Line 545: from ieu_uwqm_work_sources_b

541: BEGIN
542:
543: Select ws_id
544: into l_ws_id1
545: from ieu_uwqm_work_sources_b
546: --where object_code = 'TASK'
547: --and nvl(not_valid_flag,'N') = 'N';
548: where object_code = l_object_code
549: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 558: from ieu_uwqm_work_sources_b

554: BEGIN
555:
556: Select ws_id
557: into l_ws_id2
558: from ieu_uwqm_work_sources_b
559: where object_code = jtf_tasks_pub.p_task_user_hooks.source_object_type_code
560: --and nvl(not_valid_flag,'N') = 'N';
561: and nvl(not_valid_flag,'N') = l_not_valid_flag;
562: EXCEPTION

Line 576: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

572: BEGIN
573:
574: SELECT a.ws_id, b.ws_code
575: INTO l_association_ws_id, l_association_ws_code
576: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
577: WHERE child_ws_id = l_ws_id1
578: AND parent_ws_id = l_ws_id2
579: AND a.ws_id = b.ws_id
580: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 984: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

980:
981: l_ws_id1 NUMBER;
982: l_ws_id2 NUMBER := null;
983: l_association_ws_id NUMBER;
984: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
985: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
986: l_tasks_rules_func VARCHAR2(500);
987: l_orig_grp_owner NUMBER;
988:

Line 985: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

981: l_ws_id1 NUMBER;
982: l_ws_id2 NUMBER := null;
983: l_association_ws_id NUMBER;
984: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
985: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
986: l_tasks_rules_func VARCHAR2(500);
987: l_orig_grp_owner NUMBER;
988:
989: l_tasks_data_list SYSTEM.WR_TASKS_DATA_NST;

Line 1028: from ieu_uwqm_work_sources_b

1024: BEGIN
1025:
1026: Select ws_id
1027: into l_ws_id1
1028: from ieu_uwqm_work_sources_b
1029: -- where object_code = 'TASK'
1030: --and nvl(not_valid_flag,'N') = 'N';
1031: where object_code = l_object_code
1032: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 1041: from ieu_uwqm_work_sources_b

1037: BEGIN
1038:
1039: Select ws_id
1040: into l_ws_id2
1041: from ieu_uwqm_work_sources_b
1042: where object_code = l_task_source_obj_type_code
1043: --and nvl(not_valid_flag,'N') = 'N';
1044: and nvl(not_valid_flag,'N') = l_not_valid_flag;
1045: EXCEPTION

Line 1059: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1055: BEGIN
1056:
1057: SELECT a.ws_id, b.ws_code
1058: INTO l_association_ws_id, l_association_ws_code
1059: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1060: WHERE child_ws_id = l_ws_id1
1061: AND parent_ws_id = l_ws_id2
1062: AND a.ws_id = b.ws_id
1063: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 1313: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

1309:
1310: l_ws_id1 NUMBER;
1311: l_ws_id2 NUMBER := null;
1312: l_association_ws_id NUMBER;
1313: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
1314: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
1315: l_task_asg_count number := 0;
1316: l_group_id varchar2(5);
1317:

Line 1314: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

1310: l_ws_id1 NUMBER;
1311: l_ws_id2 NUMBER := null;
1312: l_association_ws_id NUMBER;
1313: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
1314: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
1315: l_task_asg_count number := 0;
1316: l_group_id varchar2(5);
1317:
1318: l_tasks_rules_func VARCHAR2(500);

Line 1413: from ieu_uwqm_work_sources_b

1409: BEGIN
1410:
1411: Select ws_id
1412: into l_ws_id1
1413: from ieu_uwqm_work_sources_b
1414: -- where object_code = 'TASK'
1415: -- and nvl(not_valid_flag,'N') = 'N';
1416: where object_code = l_object_code
1417: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 1426: from ieu_uwqm_work_sources_b

1422: BEGIN
1423:
1424: Select ws_id
1425: into l_ws_id2
1426: from ieu_uwqm_work_sources_b
1427: where object_code = l_task_source_obj_type_code
1428: --and nvl(not_valid_flag,'N') = 'N';
1429: and nvl(not_valid_flag,'N') = l_not_valid_flag;
1430: EXCEPTION

Line 1444: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1440: BEGIN
1441:
1442: SELECT a.ws_id, b.ws_code
1443: INTO l_association_ws_id, l_association_ws_code
1444: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1445: WHERE child_ws_id = l_ws_id1
1446: AND parent_ws_id = l_ws_id2
1447: AND a.ws_id = b.ws_id
1448: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 2091: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

2087:
2088: l_ws_id1 NUMBER;
2089: l_ws_id2 NUMBER := null;
2090: l_association_ws_id NUMBER;
2091: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2092: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2093: l_uwq_assignee_id number;
2094: l_uwq_assignee_type varchar2(30);
2095: l_group_id varchar2(5);

Line 2092: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

2088: l_ws_id1 NUMBER;
2089: l_ws_id2 NUMBER := null;
2090: l_association_ws_id NUMBER;
2091: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2092: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2093: l_uwq_assignee_id number;
2094: l_uwq_assignee_type varchar2(30);
2095: l_group_id varchar2(5);
2096: l_other_asg_update_flag varchar2(5);

Line 2196: from ieu_uwqm_work_sources_b

2192: BEGIN
2193:
2194: Select ws_id
2195: into l_ws_id1
2196: from ieu_uwqm_work_sources_b
2197: --where object_code = 'TASK'
2198: --and nvl(not_valid_flag,'N') = 'N';
2199: where object_code = l_object_code
2200: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 2209: from ieu_uwqm_work_sources_b

2205: BEGIN
2206:
2207: Select ws_id
2208: into l_ws_id2
2209: from ieu_uwqm_work_sources_b
2210: where object_code = l_task_source_obj_type_code
2211: --and nvl(not_valid_flag,'N') = 'N';
2212: and nvl(not_valid_flag,'N') = l_not_valid_flag;
2213: EXCEPTION

Line 2227: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

2223: BEGIN
2224:
2225: SELECT a.ws_id, b.ws_code
2226: INTO l_association_ws_id, l_association_ws_code
2227: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
2228: WHERE child_ws_id = l_ws_id1
2229: AND parent_ws_id = l_ws_id2
2230: AND a.ws_id = b.ws_id
2231: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 2841: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

2837:
2838: l_ws_id1 NUMBER;
2839: l_ws_id2 NUMBER := null;
2840: l_association_ws_id NUMBER;
2841: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2842: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2843: l_uwq_assignee_id number;
2844: l_uwq_assignee_type varchar2(30);
2845: l_other_asg_deleted_flag varchar2(5);

Line 2842: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

2838: l_ws_id1 NUMBER;
2839: l_ws_id2 NUMBER := null;
2840: l_association_ws_id NUMBER;
2841: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2842: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2843: l_uwq_assignee_id number;
2844: l_uwq_assignee_type varchar2(30);
2845: l_other_asg_deleted_flag varchar2(5);
2846: l_entity varchar2(30);

Line 2932: from ieu_uwqm_work_sources_b

2928: BEGIN
2929:
2930: Select ws_id
2931: into l_ws_id1
2932: from ieu_uwqm_work_sources_b
2933: --where object_code = 'TASK'
2934: --and nvl(not_valid_flag,'N') = 'N';
2935: where object_code = l_object_code
2936: and nvl(not_valid_flag,'N') = l_not_valid_flag;

Line 2945: from ieu_uwqm_work_sources_b

2941: BEGIN
2942:
2943: Select ws_id
2944: into l_ws_id2
2945: from ieu_uwqm_work_sources_b
2946: where object_code = l_task_source_obj_type_code
2947: --and nvl(not_valid_flag,'N') = 'N';
2948: and nvl(not_valid_flag,'N') = l_not_valid_flag;
2949: EXCEPTION

Line 2963: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

2959: BEGIN
2960:
2961: SELECT a.ws_id, b.ws_code
2962: INTO l_association_ws_id, l_association_ws_code
2963: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
2964: WHERE child_ws_id = l_ws_id1
2965: AND parent_ws_id = l_ws_id2
2966: AND a.ws_id = b.ws_id
2967: --AND nvl(b.not_valid_flag,'N') = 'N';