APPS.CS_UWQ_DISTRIBUTE_ITEMS dependencies on IEU_UWQM_ITEMS_GTT

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')