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_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_WORK_SOURCES_B

Line 972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

968: l_ws_id NUMBER;
969: l_ctr NUMBER := 0;
970:
971: -- used for Distribution
972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;
975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;

Line 973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

969: l_ctr NUMBER := 0;
970:
971: -- used for Distribution
972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;
975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;
977: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;

Line 974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;

970:
971: -- used for Distribution
972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;
975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;
977: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;
978: l_work_item_status VARCHAR2(50);

Line 976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;

972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;
975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;
977: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;
978: l_work_item_status VARCHAR2(50);
979: l_work_item_status_id NUMBER;
980: l_dist_items SYSTEM.WR_ITEM_DATA_NST;

Line 1035: l_ws_code1 IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;

1031: cursor_id PLS_INTEGER;
1032: dummy PLS_INTEGER;
1033: temp number := 0;
1034: v varchar2(1000);
1035: l_ws_code1 IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;
1036: l_sec_incident NUMBER;
1037: l_del_temp_item_flag VARCHAR2(10);
1038:
1039: BEGIN

Line 1177: from ieu_uwqm_work_sources_b

1173: DBMS_SQL.COLUMN_VALUE(cursor_id,21,l_del_nw_item.WS_ID);
1174: BEGIN
1175: select ws_code
1176: into l_ws_code1
1177: from ieu_uwqm_work_sources_b
1178: where ws_id = l_del_nw_item.ws_id;
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: l_ws_code1 := '';

Line 1533: from ieu_uwqm_work_sources_b

1529:
1530: BEGIN
1531: select ws_code
1532: into l_ws_code
1533: from ieu_uwqm_work_sources_b
1534: where ws_id = l_del_nw_item.ws_id;
1535: EXCEPTION
1536: WHEN OTHERS THEN
1537: l_ws_code := '';

Line 1755: from ieu_uwqm_work_sources_b

1751:
1752: BEGIN
1753: select ws_code
1754: into l_ws_code
1755: from ieu_uwqm_work_sources_b
1756: where ws_id = l_del_nw_item.ws_id;
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: l_ws_code := '';

Line 1861: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

1857: SELECT WS_B.DISTRIBUTION_FUNCTION ,
1858: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
1859: INTO l_distribution_function,
1860: l_dist_st_based_on_parent_flag, l_ws_code
1861: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
1862: WHERE ws_b.ws_id = l_nw_items_list(z).WS_ID
1863: AND ws_b.not_valid_flag = l_not_valid_flag
1864: AND ws_b.ws_id = ws_a.ws_id(+);
1865:

Line 2765: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

2761: l_not_valid_flag VARCHAR2(1);
2762: cursor c_ws is
2763: select WS_B.WS_ID, 'INDIVIDUAL_ASSIGNED' DISTRIBUTE_TO, 'GROUP_OWNED' DISTRIBUTE_FROM , WS_B.DISTRIBUTION_FUNCTION ,
2764: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
2765: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
2766: where ws_b.not_valid_flag = l_not_valid_flag
2767: and ws_b.ws_id = ws_a.ws_id(+);
2768:
2769: -- Audit Trail

Line 3075: from ieu_uwqm_work_sources_b

3071: /*
3072: begin
3073: select ws_code
3074: into l_ws_name
3075: from ieu_uwqm_work_sources_b
3076: where ws_id = l_curr_ws_id;
3077: exception
3078: when others then
3079: l_ws_name := '';

Line 3720: FROM ieu_uwqm_work_sources_b

3716: BEGIN
3717: l_not_valid_flag := 'N';
3718: SELECT ws_id
3719: INTO l_ws_id
3720: FROM ieu_uwqm_work_sources_b
3721: WHERE ws_code = p_dist_workitem_data(n).WORK_SOURCE
3722: -- AND nvl(not_valid_flag,'N') = 'N';
3723: AND nvl(not_valid_flag,'N') = l_not_valid_flag;
3724:

Line 4320: from IEU_UWQM_WORK_SOURCES_B WS_B

4316:
4317: /*
4318: cursor C1 is
4319: select WS_B.WS_ID, WS_B.DISTRIBUTE_TO, WS_B.DISTRIBUTE_FROM , WS_B.DISTRIBUTION_FUNCTION
4320: from IEU_UWQM_WORK_SOURCES_B WS_B
4321: where ws_b.not_valid_flag = 'N';
4322: */
4323:
4324: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

Line 4324: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

4320: from IEU_UWQM_WORK_SOURCES_B WS_B
4321: where ws_b.not_valid_flag = 'N';
4322: */
4323:
4324: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4325: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4326: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4327:
4328: -- Variables for Distribute_from

Line 4325: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

4321: where ws_b.not_valid_flag = 'N';
4322: */
4323:
4324: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4325: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4326: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4327:
4328: -- Variables for Distribute_from
4329:

Line 4326: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;

4322: */
4323:
4324: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4325: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4326: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4327:
4328: -- Variables for Distribute_from
4329:
4330: l_df_own_where_clause varchar2(4000);

Line 4480: from IEU_UWQM_WORK_SOURCES_B WS_B

4476: BEGIN
4477: l_not_valid_flag := 'N';
4478: select WS_B.WS_ID
4479: into l_ws_id
4480: from IEU_UWQM_WORK_SOURCES_B WS_B
4481: where ws_code = p_ws_det_list(i).ws_code
4482: -- and ws_b.not_valid_flag = 'N';
4483: and ws_b.not_valid_flag = l_not_valid_flag;
4484: EXCEPTION