APPS.CS_UWQ_DISTRIBUTE_ITEMS dependencies on IEU_UWQM_ITEMS

Line 62: FROM ieu_uwqm_items

58: WHERE RESOURCE_ID = P_RESOURCE_ID;
59:
60: CURSOR sel_wi_owner_csr(l_request_id IN NUMBER) IS
61: SELECT assignee_id
62: FROM ieu_uwqm_items
63: WHERE workitem_obj_code = 'SR'
64: AND workitem_pk_id = l_request_id;
65:
66: l_msg_index_OUT NUMBER;

Line 283: FROM ieu_uwqm_items

279: -- Query for work item if it already exists for this Task
280: BEGIN
281: SELECT 'Y'
282: INTO l_wi_flag
283: FROM ieu_uwqm_items
284: WHERE workitem_obj_code = 'TASK'
285: AND workitem_pk_id = p_tasks_data(j).task_id;
286: EXCEPTION
287: WHEN NO_DATA_FOUND THEN

Line 374: UPDATE IEU_UWQM_ITEMS_GTT A

370: --dbms_output.put_line('In SYNC SR Tasks, BEGIN, X_RETURN_STATUS='|| l_RETURN_STATUS );
371:
372:
373: BEGIN
374: UPDATE IEU_UWQM_ITEMS_GTT A
375: SET A.APPLICATION_ID = 170
376: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;
377: -- EXCEPTION
378: -- WHEN others THEN null;

Line 397: UPDATE IEU_UWQM_ITEMS_GTT A

393: -- Else if individual IS member of group, just set assignee to the
394: -- individual task owner
395:
396: BEGIN
397: UPDATE IEU_UWQM_ITEMS_GTT A
398: SET A.ASSIGNEE_ID = A.OWNER_ID
399: , A.ASSIGNEE_TYPE_ACTUAL = A.OWNER_TYPE_ACTUAL
400: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
401: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM');

Line 403: UPDATE IEU_UWQM_ITEMS_GTT A

399: , A.ASSIGNEE_TYPE_ACTUAL = A.OWNER_TYPE_ACTUAL
400: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
401: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM');
402:
403: UPDATE IEU_UWQM_ITEMS_GTT A
404: SET A.OWNER_ID = ''
405: , A.OWNER_TYPE_ACTUAL = ''
406: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
407: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM')

Line 411: , IEU_UWQM_ITEMS C

407: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM')
408: AND NOT EXISTS
409: ( SELECT 1
410: FROM JTF_RS_GROUP_MEMBERS B
411: , IEU_UWQM_ITEMS C
412: WHERE B.RESOURCE_ID = A.OWNER_ID
413: AND B.GROUP_ID = C.OWNER_ID
414: AND A.WORKITEM_OBJ_CODE = 'TASK'
415: AND C.WORKITEM_PK_ID = A.WORKITEM_PK_ID

Line 574: from ieu_uwqm_items

570: --commit;
571: begin
572: select distribution_status_id, status_id
573: into l_distribution_status, l_status_id
574: from ieu_uwqm_items
575: where workitem_pk_id = l_source_object_id
576: and workitem_obj_code = l_source_object_code;
577: exception when no_data_found then
578: l_distribution_status := 0;