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_WS_ASSCT_PROPS

Line 84: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

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;
86: l_parent_dist_status NUMBER;
87: l_set_dist_id_flag VARCHAR2(5);
88: l_parent_status_id NUMBER;

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 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 947: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

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;
949: l_parent_dist_status NUMBER;
950: l_set_dist_id_flag VARCHAR2(5);
951: l_parent_status_id NUMBER;

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 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 2117: FROM IEU_UWQM_WS_ASSCT_PROPS

2113: BEGIN
2114:
2115: SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
2116: INTO l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
2117: FROM IEU_UWQM_WS_ASSCT_PROPS
2118: WHERE ws_id = l_ws_id;
2119:
2120: EXCEPTION
2121: WHEN NO_DATA_FOUND THEN

Line 2931: FROM IEU_UWQM_WS_ASSCT_PROPS

2927: BEGIN
2928:
2929: SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag
2930: INTO l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent
2931: FROM IEU_UWQM_WS_ASSCT_PROPS
2932: WHERE ws_id = l_ws_id;
2933:
2934: EXCEPTION
2935: WHEN NO_DATA_FOUND THEN

Line 3212: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

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;
3214: l_parent_dist_status NUMBER;
3215: l_set_dist_id_flag VARCHAR2(5);
3216: l_parent_status_id NUMBER;

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 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 4508: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

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;
4510: l_parent_dist_status NUMBER;
4511: l_set_dist_id_flag VARCHAR2(5);
4512: l_parent_status_id NUMBER;

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 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 6954: FROM IEU_UWQM_WS_ASSCT_PROPS

6950: BEGIN
6951:
6952: SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
6953: INTO l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
6954: FROM IEU_UWQM_WS_ASSCT_PROPS
6955: WHERE ws_id = l_ws_id;
6956:
6957: EXCEPTION
6958: WHEN NO_DATA_FOUND THEN

Line 8578: FROM IEU_UWQM_WS_ASSCT_PROPS

8574: BEGIN
8575:
8576: SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag
8577: INTO l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent
8578: FROM IEU_UWQM_WS_ASSCT_PROPS
8579: WHERE ws_id = l_ws_id;
8580:
8581: EXCEPTION
8582: WHEN NO_DATA_FOUND THEN

Line 9761: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

9757: l_prev_source_object_type_code VARCHAR2(30);
9758: l_audit_log_id NUMBER;
9759:
9760: l_curr_ws_id NUMBER;
9761: l_dist_st_based_on_parent IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
9762: l_distribution_status_id NUMBER;
9763: l_parent_dist_status NUMBER;
9764: l_set_dist_id_flag VARCHAR2(5);
9765: l_parent_status_id NUMBER;

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 10849: FROM IEU_UWQM_WS_ASSCT_PROPS B

10845:
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

Line 10873: , IEU_UWQM_WS_ASSCT_PROPS C

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)
10877: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID

Line 11507: FROM IEU_UWQM_WS_ASSCT_PROPS

11503: BEGIN
11504:
11505: SELECT parent_ws_id, child_ws_id, dist_st_based_on_parent_flag , tasks_rules_function
11506: INTO l_parent_ws_id, l_child_ws_id, l_dist_st_based_on_parent , l_tasks_rules_func
11507: FROM IEU_UWQM_WS_ASSCT_PROPS
11508: WHERE ws_id = l_ws_id;
11509:
11510: EXCEPTION
11511: WHEN NO_DATA_FOUND THEN

Line 12519: FROM IEU_UWQM_WS_ASSCT_PROPS

12515: BEGIN
12516:
12517: SELECT parent_ws_id, child_ws_id
12518: INTO l_parent_ws_id, l_child_ws_id
12519: FROM IEU_UWQM_WS_ASSCT_PROPS
12520: WHERE ws_id = l_ws_id;
12521:
12522: EXCEPTION
12523: WHEN NO_DATA_FOUND THEN