APPS.CS_UWQ_DISTRIBUTE_ITEMS dependencies on IEU_UWQM_ITEMS_GTT

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