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_ITEMS_GTT

Line 10612: FROM IEU_UWQM_ITEMS_GTT

10608: WORKITEM_OBJ_CODE_LIST.delete;
10609:
10610: SELECT Count(*)
10611: INTO l_count
10612: FROM IEU_UWQM_ITEMS_GTT
10613: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
10614: AND WORKITEM_STATUS NOT IN ('OPEN', 'CLOSE', 'DELETE', 'SLEEP');
10615:
10616: IF NVL(l_count, 0) > 0

Line 10624: FROM IEU_UWQM_ITEMS_GTT

10620: , WORKITEM_OBJ_CODE
10621: BULK COLLECT INTO
10622: WORKITEM_PK_ID_LIST
10623: , WORKITEM_OBJ_CODE_LIST
10624: FROM IEU_UWQM_ITEMS_GTT
10625: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
10626: AND WORKITEM_STATUS NOT IN ('OPEN', 'CLOSE', 'DELETE', 'SLEEP')
10627: AND ROWNUM <= 5;
10628:

Line 10662: FROM IEU_UWQM_ITEMS_GTT A

10658: WORKITEM_OBJ_CODE_LIST.delete;
10659:
10660: SELECT count(*)
10661: INTO l_count
10662: FROM IEU_UWQM_ITEMS_GTT A
10663: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10664: AND NOT EXISTS
10665: ( SELECT 1
10666: FROM JTF_OBJECTS_B

Line 10676: FROM IEU_UWQM_ITEMS_GTT A

10672: , WORKITEM_OBJ_CODE
10673: BULK COLLECT INTO
10674: WORKITEM_PK_ID_LIST
10675: , WORKITEM_OBJ_CODE_LIST
10676: FROM IEU_UWQM_ITEMS_GTT A
10677: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10678: AND ROWNUM <= 5
10679: AND NOT EXISTS
10680: ( SELECT 1

Line 10716: FROM IEU_UWQM_ITEMS_GTT A

10712: WORKITEM_OBJ_CODE_LIST.delete;
10713:
10714: SELECT count(*)
10715: INTO l_count
10716: FROM IEU_UWQM_ITEMS_GTT A
10717: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10718: AND NOT EXISTS
10719: ( SELECT 1
10720: FROM IEU_UWQM_PRIORITIES_B B

Line 10731: FROM IEU_UWQM_ITEMS_GTT A

10727: , WORKITEM_OBJ_CODE
10728: BULK COLLECT INTO
10729: WORKITEM_PK_ID_LIST
10730: , WORKITEM_OBJ_CODE_LIST
10731: FROM IEU_UWQM_ITEMS_GTT A
10732: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10733: AND ROWNUM <= 5
10734: AND NOT EXISTS
10735: ( SELECT 1

Line 10776: FROM IEU_UWQM_ITEMS_GTT A

10772: WORKITEM_OBJ_CODE_LIST.delete;
10773:
10774: SELECT count(*)
10775: INTO l_count
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

Line 10792: FROM IEU_UWQM_ITEMS_GTT A

10788: , WORKITEM_OBJ_CODE
10789: BULK COLLECT INTO
10790: WORKITEM_PK_ID_LIST
10791: , WORKITEM_OBJ_CODE_LIST
10792: FROM IEU_UWQM_ITEMS_GTT A
10793: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10794: AND ROWNUM <= 5
10795: AND NOT EXISTS
10796: ( SELECT 1

Line 10830: UPDATE IEU_UWQM_ITEMS_GTT A

10826:
10827: -- Set Distribution Status based on these rules
10828: -- Get the Work_source_id
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

Line 10846: UPDATE IEU_UWQM_ITEMS_GTT A

10842:
10843:
10844: -- Check if Any Work Source Association exists for this combination of Object Code/Source Obj Code
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

Line 10864: UPDATE IEU_UWQM_ITEMS_GTT A

10860:
10861: BEGIN
10862: l_not_valid_flag := 'N';
10863:
10864: UPDATE IEU_UWQM_ITEMS_GTT A
10865: SET ( A.DIST_ST_BASED_ON_PARENT_FLAG
10866: , A.DIST_FROM
10867: , A.DIST_TO
10868: ) =

Line 10910: UPDATE IEU_UWQM_ITEMS_GTT A

10906: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
10907: -- Set Work Item Status Id
10908: -- set PRIORITY_ID and PRIORITY_LEVEL
10909:
10910: UPDATE IEU_UWQM_ITEMS_GTT A
10911: SET A.OWNER_TYPE = CASE WHEN (A.OWNER_TYPE_ACTUAL <> 'RS_GROUP' AND A.OWNER_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
10912: ELSE A.OWNER_TYPE_ACTUAL
10913: END
10914: , A.ASSIGNEE_TYPE = CASE WHEN (A.ASSIGNEE_TYPE_ACTUAL <> 'RS_GROUP' AND A.ASSIGNEE_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'

Line 10928: UPDATE IEU_UWQM_ITEMS_GTT A

10924: WHERE A.PRIORITY_CODE = B.PRIORITY_CODE)
10925: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;
10926:
10927:
10928: UPDATE IEU_UWQM_ITEMS_GTT A
10929: SET A.DIST_FROM = 'GROUP_OWNED'
10930: , A.DIST_TO = 'INDIVIDUAL_ASSIGNED'
10931: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10932: AND A.ASSOCIATION_WS_ID IS NULL;

Line 10934: UPDATE IEU_UWQM_ITEMS_GTT A

10930: , A.DIST_TO = 'INDIVIDUAL_ASSIGNED'
10931: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10932: AND A.ASSOCIATION_WS_ID IS NULL;
10933:
10934: UPDATE IEU_UWQM_ITEMS_GTT A
10935: SET A.WS_ID = NVL(A.ASSOCIATION_WS_ID, A.WS_ID1)
10936: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;
10937:
10938:

Line 10941: UPDATE IEU_UWQM_ITEMS_GTT A

10937:
10938:
10939: -- If the Distribution State is based on the Parent, then check if the parent is distributed.
10940:
10941: UPDATE IEU_UWQM_ITEMS_GTT A
10942: SET ( A.PARENT_STATUS_ID
10943: , A.PARENT_DIST_STATUS_ID
10944: ) =
10945: (SELECT B.STATUS_ID

Line 10957: UPDATE IEU_UWQM_ITEMS_GTT

10953:
10954: -- If the parent is not distributed, then this item will be in "On-Hold/Unavailable" status
10955: -- else set the status based on distribute_from and distribute_to
10956:
10957: UPDATE IEU_UWQM_ITEMS_GTT
10958: SET DIST_ID_FLAG = CASE WHEN DIST_ST_BASED_ON_PARENT_FLAG = 'Y' THEN
10959: CASE WHEN PARENT_STATUS_ID = 3 THEN 'T'
10960: ELSE CASE WHEN PARENT_DIST_STATUS_ID <> 3 THEN 'F'
10961: ELSE 'T'

Line 10968: UPDATE IEU_UWQM_ITEMS_GTT

10964: ELSE 'T'
10965: END
10966: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;
10967:
10968: UPDATE IEU_UWQM_ITEMS_GTT
10969: SET DISTRIBUTION_STATUS_ID = CASE WHEN (DIST_ID_FLAG = 'T') THEN
10970: CASE WHEN (PARENT_DIST_STATUS_ID <> 3) THEN 0
10971: ELSE CASE WHEN (DIST_FROM = 'GROUP_OWNED') AND (DIST_TO = 'INDIVIDUAL_ASSIGNED') THEN
10972: CASE WHEN (OWNER_TYPE = 'RS_GROUP') AND ((ASSIGNEE_TYPE IS NULL)

Line 11054: FROM IEU_UWQM_ITEMS_GTT

11050: , l_wr_items_rec.WORK_ITEM_NUMBER_LIST
11051: , l_wr_items_rec.WS_ID_LIST
11052: , l_wr_items_rec.DISTRIBUTION_STATUS_ID_LIST
11053: , l_wr_items_rec.l_ins_flag
11054: FROM IEU_UWQM_ITEMS_GTT
11055: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;
11056:
11057: IF l_wr_items_rec.WORKITEM_OBJ_CODE_LST.FIRST IS NOT NULL THEN
11058: FORALL i IN l_wr_items_rec.WORKITEM_OBJ_CODE_LST.FIRST..l_wr_items_rec.WORKITEM_OBJ_CODE_LST.LAST SAVE EXCEPTIONS

Line 11674: select IEU_UWQM_ITEMS_GTT_S1.NEXTVAL into l_processing_set_id from dual;

11670:
11671: if (l_ws_type = 'ASSOCIATION')
11672: then
11673:
11674: select IEU_UWQM_ITEMS_GTT_S1.NEXTVAL into l_processing_set_id from dual;
11675:
11676: open c_task(l_parent_obj_code);
11677: loop
11678:

Line 11679: delete from IEU_UWQM_ITEMS_GTT;

11675:
11676: open c_task(l_parent_obj_code);
11677: loop
11678:
11679: delete from IEU_UWQM_ITEMS_GTT;
11680: l_ws_details_rec.WORKITEM_PK_ID_LIST.delete;
11681: l_ws_details_rec.TASK_PRIORITY_ID_LIST.delete;
11682: l_ws_details_rec.IMPORTANCE_LEVEL_LIST.delete;
11683: l_ws_details_rec.DUE_DATE_LIST.delete;

Line 11733: Insert into ieu_uwqm_items_gtt

11729: IF l_ws_details_rec.WORKITEM_PK_ID_LIST.FIRST IS NOT NULL THEN
11730:
11731: BEGIN
11732: FORALL i IN l_ws_details_rec.WORKITEM_PK_ID_LIST.FIRST..l_ws_details_rec.WORKITEM_PK_ID_LIST.LAST SAVE EXCEPTIONS
11733: Insert into ieu_uwqm_items_gtt
11734: ( PROCESSING_SET_ID
11735: , WORKITEM_OBJ_CODE
11736: , WORKITEM_PK_ID
11737: , STATUS_ID

Line 11844: update ieu_uwqm_items_gtt gtt

11840: l_msg_data := '';
11841: l_return_status := '';
11842:
11843: BEGIN
11844: update ieu_uwqm_items_gtt gtt
11845: set due_date = (select booking_end_date
11846: from jtf_task_all_assignments asg
11847: where asg.task_id = gtt.workitem_pk_id
11848: and asg.assignee_role= 'OWNER');

Line 12032: FROM IEU_UWQM_ITEMS_GTT GTT, JTF_TASK_ASSIGNMENTS ASG

12028: cursor c_task_asg(p_processing_set_id in number) is
12029: SELECT resource_id, WORKITEM_PK_ID, resource_type_code
12030: from (SELECT GTT.WORKITEM_PK_ID, asg.resource_id, asg.resource_type_code,
12031: max(asg.last_update_date) over (partition by asg.task_id) max_update_date, asg.last_update_date
12032: FROM IEU_UWQM_ITEMS_GTT GTT, JTF_TASK_ASSIGNMENTS ASG
12033: WHERE GTT.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12034: AND GTT.WORKITEM_PK_ID = ASG.TASK_ID
12035: and GTT.OWNER_TYPE_ACTUAL = 'RS_GROUP'
12036: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')

Line 12092: update IEU_UWQM_ITEMS_GTT

12088: l_task_asg_rec.l_asg_type_act_list;
12089:
12090: BEGIN
12091: FORALL i in 1..l_task_asg_rec.l_asg_task_id_list.COUNT SAVE EXCEPTIONS
12092: update IEU_UWQM_ITEMS_GTT
12093: set assignee_id = l_task_asg_rec.l_asg_id_list(i),
12094: assignee_type_actual = l_task_asg_rec.l_asg_type_act_list(i)
12095: where processing_set_id = p_processing_set_id
12096: and workitem_pk_id = l_task_asg_rec.l_asg_task_id_list(i);

Line 12472: FROM IEU_UWQM_ITEMS_GTT A

12468: WORKITEM_OBJ_CODE_LIST.delete;
12469:
12470: SELECT count(*)
12471: INTO l_count
12472: FROM IEU_UWQM_ITEMS_GTT A
12473: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12474: AND A.WORKITEM_OBJ_CODE <> L_OBJ_CODE;
12475:
12476: IF NVL(l_count, 0) > 0

Line 12484: FROM IEU_UWQM_ITEMS_GTT A

12480: , WORKITEM_OBJ_CODE
12481: BULK COLLECT INTO
12482: WORKITEM_PK_ID_LIST
12483: , WORKITEM_OBJ_CODE_LIST
12484: FROM IEU_UWQM_ITEMS_GTT A
12485: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12486: AND A.WORKITEM_OBJ_CODE <> L_OBJ_CODE
12487: AND ROWNUM <= 5;
12488:

Line 12612: FROM IEU_UWQM_ITEMS_GTT A

12608: WORKITEM_OBJ_CODE_LIST.delete;
12609:
12610: SELECT count(*)
12611: INTO l_count
12612: FROM IEU_UWQM_ITEMS_GTT A
12613: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12614: AND ( A.WORKITEM_OBJ_CODE <> L_CHILD_OBJ_CODE OR A.SOURCE_OBJECT_TYPE_CODE <> L_PARENT_OBJ_CODE);
12615:
12616: IF NVL(l_count, 0) > 0

Line 12624: FROM IEU_UWQM_ITEMS_GTT A

12620: , WORKITEM_OBJ_CODE
12621: BULK COLLECT INTO
12622: WORKITEM_PK_ID_LIST
12623: , WORKITEM_OBJ_CODE_LIST
12624: FROM IEU_UWQM_ITEMS_GTT A
12625: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12626: AND (A.WORKITEM_OBJ_CODE <> L_CHILD_OBJ_CODE OR A.SOURCE_OBJECT_TYPE_CODE <> L_PARENT_OBJ_CODE)
12627: AND ROWNUM <= 5;
12628:

Line 12664: FROM IEU_UWQM_ITEMS_GTT

12660: WORKITEM_OBJ_CODE_LIST.delete;
12661:
12662: SELECT Count(*)
12663: INTO l_count
12664: FROM IEU_UWQM_ITEMS_GTT
12665: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
12666: AND WORKITEM_STATUS NOT IN ('CLOSE', 'DELETE');
12667:
12668: IF NVL(l_count, 0) > 0

Line 12676: FROM IEU_UWQM_ITEMS_GTT

12672: , WORKITEM_OBJ_CODE
12673: BULK COLLECT INTO
12674: WORKITEM_PK_ID_LIST
12675: , WORKITEM_OBJ_CODE_LIST
12676: FROM IEU_UWQM_ITEMS_GTT
12677: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
12678: AND WORKITEM_STATUS NOT IN ('CLOSE', 'DELETE')
12679: AND ROWNUM <= 5;
12680:

Line 12715: FROM IEU_UWQM_ITEMS_GTT

12711: , DECODE(WORKITEM_STATUS, 'CLOSE', 3, 'DELETE', 4, STATUS_ID) "STATUS_ID"
12712: BULK COLLECT INTO l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST
12713: , l_wr_item_status_rec.WORKITEM_PK_ID_LST
12714: , l_wr_item_status_rec.STATUS_ID_LIST
12715: FROM IEU_UWQM_ITEMS_GTT
12716: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;
12717:
12718: IF l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.FIRST IS NOT NULL THEN
12719: BEGIN