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 274: FROM ieu_uwqm_items

270: -- Query for work item if it already exists for this Task
271: BEGIN
272: SELECT 'Y'
273: INTO l_wi_flag
274: FROM ieu_uwqm_items
275: WHERE workitem_obj_code = 'TASK'
276: AND workitem_pk_id = p_tasks_data(j).task_id;
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN

Line 365: UPDATE IEU_UWQM_ITEMS_GTT A

361: --dbms_output.put_line('In SYNC SR Tasks, BEGIN, X_RETURN_STATUS='|| l_RETURN_STATUS );
362:
363:
364: BEGIN
365: UPDATE IEU_UWQM_ITEMS_GTT A
366: SET A.APPLICATION_ID = 170
367: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID;
368: -- EXCEPTION
369: -- WHEN others THEN null;

Line 388: UPDATE IEU_UWQM_ITEMS_GTT A

384: -- Else if individual IS member of group, just set assignee to the
385: -- individual task owner
386:
387: BEGIN
388: UPDATE IEU_UWQM_ITEMS_GTT A
389: SET A.ASSIGNEE_ID = A.OWNER_ID
390: , A.ASSIGNEE_TYPE_ACTUAL = A.OWNER_TYPE_ACTUAL
391: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
392: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM');

Line 394: UPDATE IEU_UWQM_ITEMS_GTT A

390: , A.ASSIGNEE_TYPE_ACTUAL = A.OWNER_TYPE_ACTUAL
391: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
392: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM');
393:
394: UPDATE IEU_UWQM_ITEMS_GTT A
395: SET A.OWNER_ID = ''
396: , A.OWNER_TYPE_ACTUAL = ''
397: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID
398: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM')

Line 402: , IEU_UWQM_ITEMS C

398: AND A.OWNER_TYPE_ACTUAL NOT IN ('RS_GROUP', 'RS_TEAM')
399: AND NOT EXISTS
400: ( SELECT 1
401: FROM JTF_RS_GROUP_MEMBERS B
402: , IEU_UWQM_ITEMS C
403: WHERE B.RESOURCE_ID = A.OWNER_ID
404: AND B.GROUP_ID = C.OWNER_ID
405: AND A.WORKITEM_OBJ_CODE = 'TASK'
406: AND C.WORKITEM_PK_ID = A.WORKITEM_PK_ID

Line 563: from ieu_uwqm_items

559: --commit;
560: begin
561: select distribution_status_id, status_id
562: into l_distribution_status, l_status_id
563: from ieu_uwqm_items
564: where workitem_pk_id = l_source_object_id
565: and workitem_obj_code = l_source_object_code;
566: exception when no_data_found then
567: l_distribution_status := 0;