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

Line 80: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

76:
77: l_ws_id1 NUMBER;
78: l_ws_id2 NUMBER := null;
79: l_association_ws_id NUMBER;
80: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
81: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
82: l_curr_ws_id NUMBER;
83:
84: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

Line 81: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

77: l_ws_id1 NUMBER;
78: l_ws_id2 NUMBER := null;
79: l_association_ws_id NUMBER;
80: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
81: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
82: l_curr_ws_id NUMBER;
83:
84: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
85: l_distribution_status_id NUMBER;

Line 452: from ieu_uwqm_work_sources_b

448: BEGIN
449: l_not_valid_flag := 'N';
450: Select ws_id
451: into l_ws_id1
452: from ieu_uwqm_work_sources_b
453: where object_code = p_workitem_obj_code
454: -- and nvl(not_valid_flag,'N') = 'N';
455: and nvl(not_valid_flag,'N') = l_not_valid_flag;
456:

Line 483: from ieu_uwqm_work_sources_b

479: BEGIN
480: l_not_valid_flag := 'N';
481: Select ws_id
482: into l_ws_id2
483: from ieu_uwqm_work_sources_b
484: where object_code = p_source_object_type_code
485: -- and nvl(not_valid_flag,'N') = 'N';
486: and nvl(not_valid_flag,'N') = l_not_valid_flag;
487:

Line 504: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

500: BEGIN
501: l_not_valid_flag := 'N';
502: SELECT a.ws_id
503: INTO l_association_ws_id
504: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
505: WHERE child_ws_id = l_ws_id1
506: AND parent_ws_id = l_ws_id2
507: AND a.ws_id = b.ws_id
508: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 532: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props

528: BEGIN
529: l_not_valid_flag := 'N';
530: SELECT ws_a_props.dist_st_based_on_parent_flag
531: INTO l_dist_st_based_on_parent
532: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
533: WHERE ws_b.ws_id = l_association_ws_id
534: AND ws_b.ws_id = ws_a_props.ws_id
535: -- AND nvl(ws_b.not_valid_flag,'N') = 'N';
536: AND nvl(ws_b.not_valid_flag,'N') = l_not_valid_flag;

Line 567: FROM ieu_uwqm_work_sources_b

563: BEGIN
564:
565: SELECT distribute_from, distribute_to
566: INTO l_dist_from, l_dist_to
567: FROM ieu_uwqm_work_sources_b
568: WHERE ws_id = l_ws_id1;
569:
570: EXCEPTION
571: WHEN OTHERS THEN

Line 760: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

756: BEGIN
757: l_not_valid_flag := 'N';
758: select a.ws_id
759: into l_ws_id
760: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
761: where (parent_ws_id = l_curr_ws_id)
762: and a.ws_id = b.ws_id
763: -- and nvl(b.not_valid_flag, 'N') = 'N';
764: and nvl(b.not_valid_flag, 'N') = l_not_valid_flag;

Line 943: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

939:
940: l_ws_id1 NUMBER;
941: l_ws_id2 NUMBER;
942: l_association_ws_id NUMBER;
943: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
944: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
945: l_curr_ws_id NUMBER;
946:
947: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

Line 944: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

940: l_ws_id1 NUMBER;
941: l_ws_id2 NUMBER;
942: l_association_ws_id NUMBER;
943: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
944: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
945: l_curr_ws_id NUMBER;
946:
947: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
948: l_distribution_status_id NUMBER;

Line 1470: from ieu_uwqm_work_sources_b

1466: BEGIN
1467: l_not_valid_flag := 'N';
1468: Select ws_id
1469: into l_ws_id1
1470: from ieu_uwqm_work_sources_b
1471: where object_code = p_workitem_obj_code
1472: -- and nvl(not_valid_flag,'N') = 'N';
1473: and nvl(not_valid_flag,'N') = l_not_valid_flag;
1474:

Line 1501: from ieu_uwqm_work_sources_b

1497: BEGIN
1498: l_not_valid_flag := 'N';
1499: Select ws_id
1500: into l_ws_id2
1501: from ieu_uwqm_work_sources_b
1502: where object_code = m_source_object_type_code
1503: -- and nvl(not_valid_flag,'N') = 'N';
1504: and nvl(not_valid_flag,'N') = l_not_valid_flag;
1505:

Line 1522: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1518: BEGIN
1519: l_not_valid_flag := 'N';
1520: SELECT a.ws_id
1521: INTO l_association_ws_id
1522: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1523: WHERE child_ws_id = l_ws_id1
1524: AND parent_ws_id = l_ws_id2
1525: AND a.ws_id = b.ws_id
1526: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 1550: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props

1546: BEGIN
1547: l_not_valid_flag := 'N';
1548: SELECT ws_a_props.dist_st_based_on_parent_flag
1549: INTO l_dist_st_based_on_parent
1550: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
1551: WHERE ws_b.ws_id = l_association_ws_id
1552: AND ws_b.ws_id = ws_a_props.ws_id
1553: -- AND nvl(ws_b.not_valid_flag, 'N') = 'N';
1554: AND nvl(ws_b.not_valid_flag, 'N') = l_not_valid_flag;

Line 1584: FROM ieu_uwqm_work_sources_b

1580: BEGIN
1581:
1582: SELECT distribute_from, distribute_to
1583: INTO l_dist_from, l_dist_to
1584: FROM ieu_uwqm_work_sources_b
1585: WHERE ws_id = l_ws_id1;
1586:
1587: EXCEPTION
1588: WHEN OTHERS THEN

Line 1772: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1768: BEGIN
1769: l_not_valid_flag := 'N';
1770: select a.ws_id
1771: into l_ws_id
1772: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1773: where (parent_ws_id = l_curr_ws_id)
1774: and a.ws_id = b.ws_id
1775: -- and nvl(b.not_valid_flag, 'N') = 'N';
1776: and nvl(b.not_valid_flag, 'N') = l_not_valid_flag;

Line 1925: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

1921: l_parent_ws_id NUMBER;
1922: l_child_ws_id NUMBER;
1923: l_parent_obj_code VARCHAR2(500);
1924: l_child_obj_code VARCHAR2(500);
1925: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
1926: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
1927: l_ws_type VARCHAR2(500);
1928: l_obj_code VARCHAR2(500);
1929: l_distribution_status_id NUMBER;

Line 1926: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

1922: l_child_ws_id NUMBER;
1923: l_parent_obj_code VARCHAR2(500);
1924: l_child_obj_code VARCHAR2(500);
1925: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
1926: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
1927: l_ws_type VARCHAR2(500);
1928: l_obj_code VARCHAR2(500);
1929: l_distribution_status_id NUMBER;
1930: l_parent_dist_status NUMBER;

Line 2068: from ieu_uwqm_work_sources_b

2064: BEGIN
2065: l_not_valid_flag := 'N';
2066: Select ws_id, ws_type, object_code
2067: into l_ws_id, l_ws_type, l_obj_code
2068: from ieu_uwqm_work_sources_b
2069: where ws_code = p_ws_code
2070: -- and nvl(not_valid_flag, 'N') = 'N';
2071: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
2072:

Line 2143: FROM IEU_UWQM_WORK_SOURCES_B

2139: BEGIN
2140: l_not_valid_flag := 'N';
2141: SELECT object_code
2142: INTO l_parent_obj_code
2143: FROM IEU_UWQM_WORK_SOURCES_B
2144: WHERE ws_id = l_parent_ws_id
2145: -- and nvl(not_valid_flag, 'N') = 'N';
2146: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
2147:

Line 2171: FROM IEU_UWQM_WORK_SOURCES_B

2167: BEGIN
2168: l_not_valid_flag := 'N';
2169: SELECT object_code
2170: INTO l_child_obj_code
2171: FROM IEU_UWQM_WORK_SOURCES_B
2172: WHERE ws_id = l_child_ws_id
2173: -- and nvl(not_valid_flag, 'N') = 'N';
2174: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
2175:

Line 2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;

2645:
2646: l_token_str VARCHAR2(4000);
2647:
2648: l_ws_id NUMBER;
2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

Line 2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

2646: l_token_str VARCHAR2(4000);
2647:
2648: l_ws_id NUMBER;
2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;

Line 2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

2647:
2648: l_ws_id NUMBER;
2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2655:

Line 2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;

2648: l_ws_id NUMBER;
2649: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
2650: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2651: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2652: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
2653: l_bindvar_from_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2654: l_bindvar_to_list IEU_UWQ_GET_NEXT_WORK_PVT.IEU_UWQ_BINDVAR_LIST;
2655:
2656: BEGIN

Line 2694: from ieu_uwqm_work_sources_b

2690: BEGIN
2691: l_not_valid_flag := 'N';
2692: Select ws_id, ws_type, object_code
2693: into l_ws_id, l_ws_type, l_obj_code
2694: from ieu_uwqm_work_sources_b
2695: where ws_code = p_ws_det_list(i).ws_code
2696: -- and nvl(not_valid_flag, 'N') = 'N';
2697: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
2698:

Line 2814: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

2810:
2811: l_ws_id NUMBER;
2812: l_parent_ws_id NUMBER;
2813: l_child_ws_id NUMBER;
2814: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2815: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2816: l_ws_type VARCHAR2(500);
2817: l_ws_code VARCHAR2(500);
2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;

Line 2815: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

2811: l_ws_id NUMBER;
2812: l_parent_ws_id NUMBER;
2813: l_child_ws_id NUMBER;
2814: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2815: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2816: l_ws_type VARCHAR2(500);
2817: l_ws_code VARCHAR2(500);
2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
2819: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;

Line 2900: from ieu_uwqm_work_sources_b

2896: BEGIN
2897: l_not_valid_flag := 'N';
2898: Select ws_code, ws_type
2899: into l_ws_code, l_ws_type
2900: from ieu_uwqm_work_sources_b
2901: where ws_id = l_ws_id
2902: -- and nvl(not_valid_flag, 'N') = 'N';
2903: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
2904:

Line 3208: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

3204:
3205: l_ws_id1 NUMBER;
3206: l_ws_id2 NUMBER := null;
3207: l_association_ws_id NUMBER;
3208: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
3209: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
3210: l_curr_ws_id NUMBER;
3211:
3212: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

Line 3209: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

3205: l_ws_id1 NUMBER;
3206: l_ws_id2 NUMBER := null;
3207: l_association_ws_id NUMBER;
3208: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
3209: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
3210: l_curr_ws_id NUMBER;
3211:
3212: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
3213: l_distribution_status_id NUMBER;

Line 3610: from ieu_uwqm_work_sources_b

3606: BEGIN
3607: l_not_valid_flag := 'N';
3608: Select ws_id , ws_code
3609: into l_ws_id1, l_ws_code1
3610: from ieu_uwqm_work_sources_b
3611: where object_code = p_workitem_obj_code
3612: -- and nvl(not_valid_flag,'N') = 'N';
3613: and nvl(not_valid_flag,'N') = l_not_valid_flag;
3614:

Line 3641: from ieu_uwqm_work_sources_b

3637: BEGIN
3638: l_not_valid_flag := 'N';
3639: Select ws_id , ws_code
3640: into l_ws_id2, l_ws_code2
3641: from ieu_uwqm_work_sources_b
3642: where object_code = p_source_object_type_code
3643: -- and nvl(not_valid_flag,'N') = 'N';
3644: and nvl(not_valid_flag,'N') = l_not_valid_flag;
3645:

Line 3662: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

3658: BEGIN
3659: l_not_valid_flag := 'N';
3660: SELECT a.ws_id, b.ws_code
3661: INTO l_association_ws_id, l_assct_ws_code
3662: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
3663: WHERE child_ws_id = l_ws_id1
3664: AND parent_ws_id = l_ws_id2
3665: AND a.ws_id = b.ws_id
3666: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 3691: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props

3687: BEGIN
3688: l_not_valid_flag := 'N';
3689: SELECT ws_a_props.dist_st_based_on_parent_flag
3690: INTO l_dist_st_based_on_parent
3691: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
3692: WHERE ws_b.ws_id = l_association_ws_id
3693: AND ws_b.ws_id = ws_a_props.ws_id
3694: -- AND nvl(ws_b.not_valid_flag,'N') = 'N';
3695: AND nvl(ws_b.not_valid_flag,'N') = l_not_valid_flag;

Line 3727: FROM ieu_uwqm_work_sources_b

3723: BEGIN
3724:
3725: SELECT distribute_from, distribute_to
3726: INTO l_dist_from, l_dist_to
3727: FROM ieu_uwqm_work_sources_b
3728: WHERE ws_id = l_ws_id1;
3729:
3730: EXCEPTION
3731: WHEN OTHERS THEN

Line 3886: FROM ieu_uwqm_work_sources_b

3882: BEGIN
3883:
3884: SELECT distribute_from, distribute_to
3885: INTO l_log_dist_from, l_log_dist_to
3886: FROM ieu_uwqm_work_sources_b
3887: WHERE ws_id = l_curr_ws_id;
3888:
3889: EXCEPTION
3890: WHEN OTHERS THEN

Line 4099: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

4095: BEGIN
4096: l_not_valid_flag := 'N';
4097: select a.ws_id
4098: into l_ws_id
4099: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
4100: where (parent_ws_id = l_curr_ws_id)
4101: and a.ws_id = b.ws_id
4102: -- and nvl(b.not_valid_flag, 'N') = 'N';
4103: and nvl(b.not_valid_flag, 'N') = l_not_valid_flag;

Line 4504: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

4500:
4501: l_ws_id1 NUMBER;
4502: l_ws_id2 NUMBER;
4503: l_association_ws_id NUMBER;
4504: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4505: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4506: l_curr_ws_id NUMBER;
4507:
4508: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

Line 4505: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

4501: l_ws_id1 NUMBER;
4502: l_ws_id2 NUMBER;
4503: l_association_ws_id NUMBER;
4504: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4505: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4506: l_curr_ws_id NUMBER;
4507:
4508: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
4509: l_distribution_status_id NUMBER;

Line 5097: from ieu_uwqm_work_sources_b

5093: BEGIN
5094: l_not_valid_flag := 'N';
5095: Select ws_id, ws_code
5096: into l_ws_id1, l_ws_code1
5097: from ieu_uwqm_work_sources_b
5098: where object_code = p_workitem_obj_code
5099: -- and nvl(not_valid_flag,'N') = 'N';
5100: and nvl(not_valid_flag,'N') = l_not_valid_flag;
5101:

Line 5128: from ieu_uwqm_work_sources_b

5124: BEGIN
5125: l_not_valid_flag := 'N';
5126: Select ws_id, ws_code
5127: into l_ws_id2, l_ws_code2
5128: from ieu_uwqm_work_sources_b
5129: where object_code = m_source_object_type_code
5130: -- and nvl(not_valid_flag,'N') = 'N';
5131: and nvl(not_valid_flag,'N') = l_not_valid_flag;
5132:

Line 5149: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

5145: BEGIN
5146: l_not_valid_flag := 'N';
5147: SELECT a.ws_id, b.ws_code
5148: INTO l_association_ws_id, l_assct_ws_code
5149: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
5150: WHERE child_ws_id = l_ws_id1
5151: AND parent_ws_id = l_ws_id2
5152: AND a.ws_id = b.ws_id
5153: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 5178: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props

5174: BEGIN
5175: l_not_valid_flag := 'N';
5176: SELECT ws_a_props.dist_st_based_on_parent_flag
5177: INTO l_dist_st_based_on_parent
5178: FROM ieu_uwqm_work_sources_b ws_b, IEU_UWQM_WS_ASSCT_PROPS ws_a_props
5179: WHERE ws_b.ws_id = l_association_ws_id
5180: AND ws_b.ws_id = ws_a_props.ws_id
5181: -- AND nvl(ws_b.not_valid_flag, 'N') = 'N';
5182: AND nvl(ws_b.not_valid_flag, 'N') = l_not_valid_flag;

Line 5213: FROM ieu_uwqm_work_sources_b

5209: BEGIN
5210:
5211: SELECT distribute_from, distribute_to
5212: INTO l_dist_from, l_dist_to
5213: FROM ieu_uwqm_work_sources_b
5214: WHERE ws_id = l_ws_id1;
5215:
5216: EXCEPTION
5217: WHEN OTHERS THEN

Line 5394: FROM ieu_uwqm_work_sources_b

5390: BEGIN
5391:
5392: SELECT distribute_from, distribute_to
5393: INTO l_log_dist_from, l_log_dist_to
5394: FROM ieu_uwqm_work_sources_b
5395: WHERE ws_id = l_curr_ws_id;
5396:
5397: EXCEPTION
5398: WHEN OTHERS THEN

Line 5656: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

5652: BEGIN
5653: l_not_valid_flag := 'N';
5654: select a.ws_id
5655: into l_ws_id
5656: from ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
5657: where (parent_ws_id = l_curr_ws_id)
5658: and a.ws_id = b.ws_id
5659: -- and nvl(b.not_valid_flag, 'N') = 'N';
5660: and nvl(b.not_valid_flag, 'N') = l_not_valid_flag;

Line 6367: from ieu_uwqm_work_sources_b

6363: BEGIN
6364:
6365: select ws_code
6366: into l_ws_code
6367: from ieu_uwqm_work_sources_b
6368: where ws_id = l_ws_id;
6369:
6370: EXCEPTION
6371: when others then

Line 6726: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

6722: l_parent_ws_id NUMBER;
6723: l_child_ws_id NUMBER;
6724: l_parent_obj_code VARCHAR2(500);
6725: l_child_obj_code VARCHAR2(500);
6726: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
6727: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
6728: l_ws_type VARCHAR2(500);
6729: l_obj_code VARCHAR2(500);
6730: l_distribution_status_id NUMBER;

Line 6727: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

6723: l_child_ws_id NUMBER;
6724: l_parent_obj_code VARCHAR2(500);
6725: l_child_obj_code VARCHAR2(500);
6726: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
6727: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
6728: l_ws_type VARCHAR2(500);
6729: l_obj_code VARCHAR2(500);
6730: l_distribution_status_id NUMBER;
6731: l_parent_dist_status NUMBER;

Line 6905: from ieu_uwqm_work_sources_b

6901: BEGIN
6902: l_not_valid_flag := 'N';
6903: Select ws_id, ws_type, object_code
6904: into l_ws_id, l_ws_type, l_obj_code
6905: from ieu_uwqm_work_sources_b
6906: where ws_code = p_ws_code
6907: -- and nvl(not_valid_flag, 'N') = 'N';
6908: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
6909:

Line 6980: FROM IEU_UWQM_WORK_SOURCES_B

6976: BEGIN
6977: l_not_valid_flag := 'N';
6978: SELECT object_code
6979: INTO l_parent_obj_code
6980: FROM IEU_UWQM_WORK_SOURCES_B
6981: WHERE ws_id = l_parent_ws_id
6982: -- and nvl(not_valid_flag, 'N') = 'N';
6983: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
6984:

Line 7008: FROM IEU_UWQM_WORK_SOURCES_B

7004: BEGIN
7005: l_not_valid_flag := 'N';
7006: SELECT object_code
7007: INTO l_child_obj_code
7008: FROM IEU_UWQM_WORK_SOURCES_B
7009: WHERE ws_id = l_child_ws_id
7010: -- and nvl(not_valid_flag, 'N') = 'N';
7011: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
7012:

Line 7835: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;

7831:
7832: l_token_str VARCHAR2(4000);
7833:
7834: l_ws_id NUMBER;
7835: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
7836: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
7837: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
7838: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
7839:

Line 7836: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

7832: l_token_str VARCHAR2(4000);
7833:
7834: l_ws_id NUMBER;
7835: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
7836: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
7837: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
7838: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
7839:
7840: -- Audit Log

Line 7837: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

7833:
7834: l_ws_id NUMBER;
7835: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
7836: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
7837: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
7838: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
7839:
7840: -- Audit Log
7841: l_action_key VARCHAR2(2000);

Line 7838: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;

7834: l_ws_id NUMBER;
7835: l_ws_type IEU_UWQM_WORK_SOURCES_B.WS_TYPE%TYPE;
7836: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
7837: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
7838: l_obj_code IEU_UWQM_WORK_SOURCES_B.OBJECT_CODE%TYPE;
7839:
7840: -- Audit Log
7841: l_action_key VARCHAR2(2000);
7842: l_event_key VARCHAR2(2000);

Line 7932: from ieu_uwqm_work_sources_b

7928: BEGIN
7929: l_not_valid_flag := 'N';
7930: Select ws_id, ws_type, object_code
7931: into l_ws_id, l_ws_type, l_obj_code
7932: from ieu_uwqm_work_sources_b
7933: where ws_code = p_ws_det_list(i).ws_code
7934: -- and nvl(not_valid_flag, 'N') = 'N';
7935: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
7936:

Line 8411: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

8407:
8408: l_ws_id NUMBER;
8409: l_parent_ws_id NUMBER;
8410: l_child_ws_id NUMBER;
8411: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
8412: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
8413: l_ws_type VARCHAR2(500);
8414: l_ws_code VARCHAR2(500);
8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;

Line 8412: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

8408: l_ws_id NUMBER;
8409: l_parent_ws_id NUMBER;
8410: l_child_ws_id NUMBER;
8411: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
8412: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
8413: l_ws_type VARCHAR2(500);
8414: l_ws_code VARCHAR2(500);
8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
8416: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;

Line 8548: from ieu_uwqm_work_sources_b

8544: BEGIN
8545: l_not_valid_flag := 'N';
8546: Select ws_code, ws_type, distribute_from, distribute_to
8547: into l_ws_code, l_ws_type, l_log_dist_from, l_log_dist_to
8548: from ieu_uwqm_work_sources_b
8549: where ws_id = l_ws_id
8550: -- and nvl(not_valid_flag, 'N') = 'N';
8551: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
8552:

Line 9256: from ieu_uwqm_work_sources_b

9252: BEGIN
9253: l_not_valid_flag := 'N';
9254: select ws_code
9255: into l_ws_code
9256: from ieu_uwqm_work_sources_b
9257: where ws_code = p_ws_code
9258: -- and nvl(not_valid_flag, 'N') = 'N';
9259: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
9260: EXCEPTION WHEN NO_DATA_FOUND

Line 9284: update ieu_uwqm_work_sources_b

9280:
9281: ELSIF p_ws_code = l_ws_code
9282: THEN
9283: l_active_flag := 'Y';
9284: update ieu_uwqm_work_sources_b
9285: set active_flag = l_active_flag
9286: where ws_code = p_ws_code;
9287: END IF;
9288:

Line 9414: from ieu_uwqm_work_sources_b

9410: BEGIN
9411: l_not_valid_flag := 'N';
9412: select ws_code, nvl(active_flag,'N')
9413: into l_ws_code, l_ws_activation_status
9414: from ieu_uwqm_work_sources_b
9415: where ws_code = p_ws_code
9416: -- and nvl(not_valid_flag, 'N') = 'N';
9417: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
9418: EXCEPTION WHEN NO_DATA_FOUND

Line 10311: from ieu_uwqm_work_sources_b b, ieu_uwqm_ws_assct_props p

10307: l_ws_id NUMBER;
10308:
10309: CURSOR c_child_worksources IS
10310: select ws_code
10311: from ieu_uwqm_work_sources_b b, ieu_uwqm_ws_assct_props p
10312: where b.ws_id = p.ws_id
10313: and p.parent_ws_id = l_ws_id;
10314:
10315: BEGIN

Line 10372: from ieu_uwqm_work_sources_b

10368: BEGIN
10369: l_not_valid_flag := 'N';
10370: select ws_code, ws_id
10371: into l_ws_code, l_ws_id
10372: from ieu_uwqm_work_sources_b
10373: where ws_code = p_ws_code
10374: -- and nvl(not_valid_flag, 'N') = 'N';
10375: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
10376: EXCEPTION WHEN NO_DATA_FOUND

Line 10401: update ieu_uwqm_work_sources_b

10397:
10398: ELSIF p_ws_code = l_ws_code
10399: THEN
10400: l_active_flag := 'N';
10401: update ieu_uwqm_work_sources_b
10402: set active_flag = l_active_flag
10403: where ws_code = p_ws_code;
10404:
10405: for cur_rec in c_child_worksources

Line 10407: update ieu_uwqm_work_sources_b

10403: where ws_code = p_ws_code;
10404:
10405: for cur_rec in c_child_worksources
10406: loop
10407: update ieu_uwqm_work_sources_b
10408: set active_flag = l_active_flag
10409: where ws_code = cur_rec.ws_code;
10410: end loop;
10411:

Line 10780: FROM IEU_UWQM_WORK_SOURCES_B

10776: FROM IEU_UWQM_ITEMS_GTT A
10777: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10778: AND NOT EXISTS
10779: ( SELECT 1
10780: FROM IEU_UWQM_WORK_SOURCES_B
10781: WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE
10782: AND NVL(NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG );
10783:
10784: IF NVL(l_count, 0) > 0

Line 10797: FROM IEU_UWQM_WORK_SOURCES_B

10793: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10794: AND ROWNUM <= 5
10795: AND NOT EXISTS
10796: ( SELECT 1
10797: FROM IEU_UWQM_WORK_SOURCES_B
10798: WHERE OBJECT_CODE = A.WORKITEM_OBJ_CODE
10799: AND NVL(NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG );
10800:
10801: FOR i IN WORKITEM_PK_ID_LIST.FIRST..WORKITEM_PK_ID_LIST.LAST

Line 10833: FROM IEU_UWQM_WORK_SOURCES_B B

10829:
10830: UPDATE IEU_UWQM_ITEMS_GTT A
10831: SET A.WS_ID1 =
10832: (SELECT B.WS_ID
10833: FROM IEU_UWQM_WORK_SOURCES_B B
10834: WHERE A.WORKITEM_OBJ_CODE = B.OBJECT_CODE
10835: AND NVL(B.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
10836: , A.WS_ID2 =
10837: (SELECT C.WS_ID

Line 10838: FROM IEU_UWQM_WORK_SOURCES_B C

10834: WHERE A.WORKITEM_OBJ_CODE = B.OBJECT_CODE
10835: AND NVL(B.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
10836: , A.WS_ID2 =
10837: (SELECT C.WS_ID
10838: FROM IEU_UWQM_WORK_SOURCES_B C
10839: WHERE A.SOURCE_OBJECT_TYPE_CODE = C.OBJECT_CODE
10840: AND NVL(C.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)
10841: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;
10842:

Line 10850: , IEU_UWQM_WORK_SOURCES_B C

10846: UPDATE IEU_UWQM_ITEMS_GTT A
10847: SET A.ASSOCIATION_WS_ID =
10848: (SELECT B.WS_ID
10849: FROM IEU_UWQM_WS_ASSCT_PROPS B
10850: , IEU_UWQM_WORK_SOURCES_B C
10851: WHERE B.CHILD_WS_ID = A.WS_ID1
10852: AND B.PARENT_WS_ID = A.WS_ID2
10853: AND B.WS_ID = C.WS_ID
10854: AND NVL(C.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)

Line 10872: FROM IEU_UWQM_WORK_SOURCES_B B

10868: ) =
10869: (SELECT C.DIST_ST_BASED_ON_PARENT_FLAG
10870: , 'GROUP_OWNED'
10871: , 'INDIVIDUAL_ASSIGNED'
10872: FROM IEU_UWQM_WORK_SOURCES_B B
10873: , IEU_UWQM_WS_ASSCT_PROPS C
10874: WHERE A.ASSOCIATION_WS_ID = B.WS_ID
10875: AND B.WS_ID = C.WS_ID
10876: AND NVL(B.NOT_VALID_FLAG, 'N') = L_NOT_VALID_FLAG)

Line 11451: from ieu_uwqm_work_sources_b

11447: BEGIN
11448: l_not_valid_flag := 'N';
11449: Select ws_id, ws_type, object_code
11450: into l_ws_id, l_ws_type, l_obj_code
11451: from ieu_uwqm_work_sources_b
11452: where ws_code = p_ws_code
11453: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
11454:
11455: EXCEPTION

Line 11537: FROM IEU_UWQM_WORK_SOURCES_B

11533: BEGIN
11534: l_not_valid_flag := 'N';
11535: SELECT object_code, NVL(active_flag, 'N')
11536: INTO l_parent_obj_code, l_active_flag
11537: FROM IEU_UWQM_WORK_SOURCES_B
11538: WHERE ws_id = l_parent_ws_id
11539: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
11540:
11541: IF l_active_flag = 'N' THEN

Line 11642: FROM IEU_UWQM_WORK_SOURCES_B

11638: BEGIN
11639: l_not_valid_flag := 'N';
11640: SELECT object_code
11641: INTO l_child_obj_code
11642: FROM IEU_UWQM_WORK_SOURCES_B
11643: WHERE ws_id = l_child_ws_id
11644: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
11645:
11646: EXCEPTION

Line 12432: from ieu_uwqm_work_sources_b

12428: BEGIN
12429: l_not_valid_flag := 'N';
12430: Select ws_id, ws_type, object_code
12431: into l_ws_id, l_ws_type, l_obj_code
12432: from ieu_uwqm_work_sources_b
12433: where ws_code = p_ws_code
12434: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
12435:
12436: EXCEPTION

Line 12548: FROM IEU_UWQM_WORK_SOURCES_B

12544: BEGIN
12545: l_not_valid_flag := 'N';
12546: SELECT object_code
12547: INTO l_parent_obj_code
12548: FROM IEU_UWQM_WORK_SOURCES_B
12549: WHERE ws_id = l_parent_ws_id
12550: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
12551:
12552: EXCEPTION

Line 12577: FROM IEU_UWQM_WORK_SOURCES_B

12573: BEGIN
12574: l_not_valid_flag := 'N';
12575: SELECT object_code
12576: INTO l_child_obj_code
12577: FROM IEU_UWQM_WORK_SOURCES_B
12578: WHERE ws_id = l_child_ws_id
12579: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
12580:
12581: EXCEPTION

Line 12885: from ieu_uwqm_work_sources_b

12881: BEGIN
12882: l_not_valid_flag := 'N';
12883: Select ws_id
12884: into l_ws_id
12885: from ieu_uwqm_work_sources_b
12886: where ws_code = p_ws_code
12887: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
12888:
12889: EXCEPTION