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

Line 96: from ieu_uwqm_items

92: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
93:
94: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
95: select work_item_id, workitem_pk_id, workitem_obj_code
96: from ieu_uwqm_items
97: where source_object_id = p_source_object_id
98: and source_object_type_code = p_source_object_type_code
99: and ( distribution_status_id = 0 or distribution_status_id = 1);
100:

Line 598: FROM ieu_uwqm_items

594: then
595: BEGIN
596: SELECT distribution_status_id, status_id
597: INTO l_parent_dist_status, l_parent_status_id
598: FROM ieu_uwqm_items
599: WHERE workitem_pk_id = p_source_object_id
600: AND workitem_obj_code = p_source_object_type_code;
601: EXCEPTION
602: WHEN OTHERS THEN

Line 959: from ieu_uwqm_items

955: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
956:
957: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
958: select work_item_id, workitem_pk_id, workitem_obj_code
959: from ieu_uwqm_items
960: where source_object_id = p_source_object_id
961: and source_object_type_code = p_source_object_type_code
962: and ( distribution_status_id = 0 or distribution_status_id = 1);
963:

Line 1083: from ieu_uwqm_items

1079: m_assignee_type,
1080: m_source_object_id,
1081: m_source_object_type_code,
1082: m_application_id
1083: from ieu_uwqm_items
1084: where workitem_obj_code = p_workitem_obj_code
1085: and workitem_pk_id = p_workitem_pk_id;
1086:
1087: *****************/

Line 1110: from ieu_uwqm_items

1106: m_assignee_type,
1107: m_source_object_id,
1108: m_source_object_type_code,
1109: m_application_id
1110: from ieu_uwqm_items
1111: where workitem_obj_code = p_workitem_obj_code
1112: and workitem_pk_id = p_workitem_pk_id;
1113:
1114: EXCEPTION WHEN OTHERS THEN

Line 1175: from ieu_uwqm_items a, ieu_uwqm_priorities_b b

1171:
1172: BEGIN
1173: select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
1174: into m_priority_code
1175: from ieu_uwqm_items a, ieu_uwqm_priorities_b b
1176: where a.priority_id = b.priority_id
1177: and a.priority_level = b.priority_level
1178: and a.workitem_obj_code = p_workitem_obj_code
1179: and a.workitem_pk_id = p_workitem_pk_id;

Line 1202: from ieu_uwqm_items

1198:
1199: BEGIN
1200: select decode(p_work_item_status, FND_API.G_MISS_CHAR, decode(status_id, 0, 'OPEN', 3, 'CLOSE', 4, 'DELETE', 5, 'SLEEP'), p_work_item_status) status_id
1201: into m_work_item_status
1202: from ieu_uwqm_items
1203: where workitem_obj_code = p_workitem_obj_code
1204: and workitem_pk_id = p_workitem_pk_id;
1205: EXCEPTION
1206: WHEN OTHERS THEN

Line 1615: FROM ieu_uwqm_items

1611: then
1612: BEGIN
1613: SELECT distribution_status_id, status_id
1614: INTO l_parent_dist_status, l_parent_status_id
1615: FROM ieu_uwqm_items
1616: WHERE workitem_pk_id = m_source_object_id
1617: AND workitem_obj_code = m_source_object_type_code;
1618: EXCEPTION
1619: WHEN OTHERS THEN

Line 1977: from ieu_uwqm_items

1973:
1974: -- Cursor for primary ws
1975: cursor c_pry_ws(p_obj_code in VARCHAR2) is
1976: select work_item_id, owner_type, assignee_type
1977: from ieu_uwqm_items
1978: where workitem_obj_code = p_obj_code;
1979:
1980: -- Cursor for association ws
1981: cursor c_assct_ws(p_parent_obj_code in VARCHAR2, p_child_obj_code in VARCHAR2) is

Line 1983: from ieu_uwqm_items

1979:
1980: -- Cursor for association ws
1981: cursor c_assct_ws(p_parent_obj_code in VARCHAR2, p_child_obj_code in VARCHAR2) is
1982: select work_item_id, owner_type, assignee_type, source_object_id, source_object_type_code
1983: from ieu_uwqm_items
1984: where workitem_obj_code = p_child_obj_code
1985: and source_object_type_code = p_parent_obj_code;
1986:
1987: cursor c_task(p_source_object_type_code in varchar2) is

Line 2266: update ieu_uwqm_items

2262: end if;
2263:
2264: end if;
2265:
2266: update ieu_uwqm_items
2267: set ws_id = l_ws_id,
2268: distribution_status_id = l_distribution_status_id
2269: where work_item_id = cur_rec.work_item_id;
2270: commit;

Line 2330: from ieu_uwqm_items

2326:
2327: begin
2328: l_workitem_obj_code_1 := 'TASK';
2329: select count(*) into l_uwqm_count
2330: from ieu_uwqm_items
2331: -- where workitem_obj_code = 'TASK'
2332: where workitem_obj_code = l_workitem_obj_code_1
2333: and workitem_pk_id = l_task_id;
2334: exception when others then

Line 2458: FROM ieu_uwqm_items

2454: then
2455: BEGIN
2456: SELECT distribution_status_id, status_id
2457: INTO l_parent_dist_status, l_parent_status_id
2458: FROM ieu_uwqm_items
2459: WHERE workitem_pk_id = cur_rec.source_object_id
2460: AND workitem_obj_code = cur_rec.source_object_type_code;
2461: EXCEPTION
2462: WHEN OTHERS THEN

Line 2511: update ieu_uwqm_items

2507:
2508: end if; /* l_set_dist_id_flag */
2509:
2510:
2511: update ieu_uwqm_items
2512: set ws_id = l_ws_id,
2513: distribution_status_id = l_distribution_status_id
2514: where work_item_id = cur_rec.work_item_id;
2515: commit;

Line 2536: update IEU_UWQM_ITEMS

2532:
2533: BEGIN
2534: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
2535: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
2536: update IEU_UWQM_ITEMS
2537: set status_id = l_task_status_rec.l_status_id_list(i),
2538: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2539: LAST_UPDATE_DATE = SYSDATE,
2540: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;

2814: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
2815: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2816: l_ws_type VARCHAR2(500);
2817: l_ws_code VARCHAR2(500);
2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
2819: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
2820: l_source_object_id NUMBER;
2821: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
2822: l_distribution_status_id NUMBER;

Line 2819: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;

2815: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
2816: l_ws_type VARCHAR2(500);
2817: l_ws_code VARCHAR2(500);
2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
2819: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
2820: l_source_object_id NUMBER;
2821: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
2822: l_distribution_status_id NUMBER;
2823: l_parent_dist_status NUMBER;

Line 2821: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;

2817: l_ws_code VARCHAR2(500);
2818: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
2819: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
2820: l_source_object_id NUMBER;
2821: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
2822: l_distribution_status_id NUMBER;
2823: l_parent_dist_status NUMBER;
2824: l_dist_st_based_on_parent VARCHAR2(5);
2825: l_set_dist_id_flag VARCHAR2(5);

Line 2869: from ieu_uwqm_items

2865: BEGIN
2866:
2867: select owner_type, assignee_type, ws_id, source_object_id, source_object_type_code
2868: into l_owner_type , l_assignee_type, l_ws_id, l_source_object_id, l_source_object_type_code
2869: from ieu_uwqm_items
2870: where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
2871: and workitem_obj_code = p_wr_item_list(i).workitem_obj_code;
2872:
2873: EXCEPTION

Line 2964: FROM ieu_uwqm_items

2960: then
2961: BEGIN
2962: SELECT distribution_status_id, status_id
2963: INTO l_parent_dist_status, l_parent_status_id
2964: FROM ieu_uwqm_items
2965: WHERE workitem_pk_id = l_source_object_id
2966: AND workitem_obj_code = l_source_object_type_code;
2967: EXCEPTION
2968: WHEN OTHERS THEN

Line 3080: update ieu_uwqm_items

3076: */
3077: end if; /* l_set_dist_id_flag */
3078:
3079: -- dbms_output.put_line('l_set_dist_id_flag: '||l_set_dist_id_flag|| ' dist status: '|| l_distribution_status_id);
3080: update ieu_uwqm_items
3081: set distribution_status_id = l_distribution_status_id
3082: where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
3083: and workitem_obj_code = p_wr_item_list(i).workitem_obj_code;
3084:

Line 3224: from ieu_uwqm_items

3220: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
3221:
3222: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
3223: select work_item_id, workitem_pk_id, workitem_obj_code
3224: from ieu_uwqm_items
3225: where source_object_id = p_source_object_id
3226: and source_object_type_code = p_source_object_type_code
3227: and ( distribution_status_id = 0 or distribution_status_id = 1);
3228:

Line 3758: FROM ieu_uwqm_items

3754: then
3755: BEGIN
3756: SELECT distribution_status_id, status_id
3757: INTO l_parent_dist_status, l_parent_status_id
3758: FROM ieu_uwqm_items
3759: WHERE workitem_pk_id = p_source_object_id
3760: AND workitem_obj_code = p_source_object_type_code;
3761: EXCEPTION
3762: WHEN OTHERS THEN

Line 4520: from ieu_uwqm_items

4516: l_wr_item_list IEU_WR_PUB.IEU_WR_ITEM_LIST;
4517:
4518: cursor c1(p_source_object_id IN NUMBER, p_source_object_type_code IN VARCHAR2) is
4519: select work_item_id, workitem_pk_id, workitem_obj_code
4520: from ieu_uwqm_items
4521: where source_object_id = p_source_object_id
4522: and source_object_type_code = p_source_object_type_code
4523: and ( distribution_status_id = 0 or distribution_status_id = 1);
4524:

Line 4682: from ieu_uwqm_items

4678: m_assignee_type,
4679: m_source_object_id,
4680: m_source_object_type_code,
4681: m_application_id
4682: from ieu_uwqm_items
4683: where workitem_obj_code = p_workitem_obj_code
4684: and workitem_pk_id = p_workitem_pk_id;
4685: EXCEPTION
4686: WHEN OTHERS THEN

Line 4729: from ieu_uwqm_items

4725: m_assignee_type,
4726: m_source_object_id,
4727: m_source_object_type_code,
4728: m_application_id
4729: from ieu_uwqm_items
4730: where workitem_obj_code = p_workitem_obj_code
4731: and workitem_pk_id = p_workitem_pk_id;
4732:
4733: EXCEPTION WHEN OTHERS THEN

Line 4799: from ieu_uwqm_items a, ieu_uwqm_priorities_b b

4795:
4796: BEGIN
4797: select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
4798: into m_priority_code
4799: from ieu_uwqm_items a, ieu_uwqm_priorities_b b
4800: where a.priority_id = b.priority_id
4801: and a.priority_level = b.priority_level
4802: and a.workitem_obj_code = p_workitem_obj_code
4803: and a.workitem_pk_id = p_workitem_pk_id;

Line 4827: from ieu_uwqm_items

4823: BEGIN
4824:
4825: select decode(p_work_item_status, FND_API.G_MISS_CHAR, decode(status_id, 0, 'OPEN', 3, 'CLOSE', 4, 'DELETE', 5, 'SLEEP'), p_work_item_status) status_id
4826: into m_work_item_status
4827: from ieu_uwqm_items
4828: where workitem_obj_code = p_workitem_obj_code
4829: and workitem_pk_id = p_workitem_pk_id;
4830: EXCEPTION
4831: WHEN OTHERS THEN

Line 5244: FROM ieu_uwqm_items

5240: then
5241: BEGIN
5242: SELECT distribution_status_id, status_id
5243: INTO l_parent_dist_status, l_parent_status_id
5244: FROM ieu_uwqm_items
5245: WHERE workitem_pk_id = m_source_object_id
5246: AND workitem_obj_code = m_source_object_type_code;
5247: EXCEPTION
5248: WHEN OTHERS THEN

Line 5373: FROM IEU_UWQM_ITEMS

5369: priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
5370: INTO l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
5371: l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
5372: l_prev_source_object_id, l_prev_source_object_type_code
5373: FROM IEU_UWQM_ITEMS
5374: WHERE workitem_obj_code = p_workitem_obj_code
5375: AND workitem_pk_id = p_workitem_pk_id;
5376:
5377: EXCEPTION

Line 6210: FROM ieu_uwqm_items

6206:
6207: BEGIN
6208: SELECT work_item_id
6209: INTO l_work_item_id
6210: FROM ieu_uwqm_items
6211: WHERE workitem_obj_code = p_workitem_obj_code
6212: AND workitem_pk_id = p_workitem_pk_id;
6213: EXCEPTION WHEN NO_DATA_FOUND
6214: THEN

Line 6302: FROM IEU_UWQM_ITEMS

6298: priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code, workitem_pk_id, workitem_obj_code
6299: INTO l_ws_id, l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
6300: l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
6301: l_prev_source_object_id, l_prev_source_object_type_code, l_workitem_pk_id, l_obj_code
6302: FROM IEU_UWQM_ITEMS
6303: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;
6304:
6305: EXCEPTION
6306: WHEN OTHERS THEN

Line 6317: FROM IEU_UWQM_ITEMS

6313: priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
6314: INTO l_ws_id, l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
6315: l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
6316: l_prev_source_object_id, l_prev_source_object_type_code
6317: FROM IEU_UWQM_ITEMS
6318: WHERE workitem_obj_code = p_workitem_obj_code
6319: AND workitem_pk_id = p_workitem_pk_id;
6320:
6321: EXCEPTION

Line 6331: UPDATE IEU_UWQM_ITEMS

6327:
6328: IF (p_work_item_id is not null)
6329: THEN
6330:
6331: UPDATE IEU_UWQM_ITEMS
6332: SET reschedule_time = P_reschedule_time
6333: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;
6334:
6335: ELSE

Line 6337: UPDATE IEU_UWQM_ITEMS

6333: WHERE WORK_ITEM_ID = P_WORK_ITEM_ID;
6334:
6335: ELSE
6336:
6337: UPDATE IEU_UWQM_ITEMS
6338: SET reschedule_time = P_reschedule_time
6339: WHERE WORKITEM_PK_ID = P_WORKITEM_PK_ID
6340: AND WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE;
6341:

Line 6773: from ieu_uwqm_items

6769:
6770: -- Cursor for primary ws
6771: cursor c_pry_ws(p_obj_code in VARCHAR2) is
6772: select work_item_id, owner_type, assignee_type
6773: from ieu_uwqm_items
6774: where workitem_obj_code = p_obj_code;
6775:
6776: -- Cursor for association ws
6777: cursor c_assct_ws(p_parent_obj_code in VARCHAR2, p_child_obj_code in VARCHAR2) is

Line 6780: from ieu_uwqm_items

6776: -- Cursor for association ws
6777: cursor c_assct_ws(p_parent_obj_code in VARCHAR2, p_child_obj_code in VARCHAR2) is
6778: select work_item_id, workitem_pk_id, workitem_obj_code, owner_id, owner_type, assignee_id, assignee_type, source_object_id, source_object_type_code,
6779: status_id, priority_id, due_date
6780: from ieu_uwqm_items
6781: where workitem_obj_code = p_child_obj_code
6782: and source_object_type_code = p_parent_obj_code;
6783:
6784: cursor c_task(p_source_object_type_code in varchar2) is

Line 7103: update ieu_uwqm_items

7099: end if;
7100:
7101: end if;
7102:
7103: update ieu_uwqm_items
7104: set ws_id = l_ws_id,
7105: distribution_status_id = l_distribution_status_id
7106: where work_item_id = cur_rec.work_item_id;
7107: commit;

Line 7205: from ieu_uwqm_items

7201:
7202: begin
7203: l_workitem_obj_code_1 := 'TASK';
7204: select count(*) into l_uwqm_count
7205: from ieu_uwqm_items
7206: -- where workitem_obj_code = 'TASK'
7207: where workitem_obj_code = l_workitem_obj_code_1
7208: and workitem_pk_id = l_task_id;
7209: exception when others then

Line 7345: FROM ieu_uwqm_items

7341: then
7342: BEGIN
7343: SELECT distribution_status_id, status_id
7344: INTO l_parent_dist_status, l_parent_status_id
7345: FROM ieu_uwqm_items
7346: WHERE workitem_pk_id = cur_rec.source_object_id
7347: AND workitem_obj_code = cur_rec.source_object_type_code;
7348: EXCEPTION
7349: WHEN OTHERS THEN

Line 7459: update ieu_uwqm_items

7455:
7456: end if; /* l_set_dist_id_flag */
7457:
7458:
7459: update ieu_uwqm_items
7460: set ws_id = l_ws_id,
7461: distribution_status_id = l_distribution_status_id
7462: where work_item_id = cur_rec.work_item_id;
7463: commit;

Line 7541: update IEU_UWQM_ITEMS

7537:
7538: BEGIN
7539: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
7540: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
7541: update IEU_UWQM_ITEMS
7542: set status_id = l_task_status_rec.l_status_id_list(i),
7543: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
7544: LAST_UPDATE_DATE = SYSDATE,
7545: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 8050: FROM ieu_uwqm_items

8046: BEGIN
8047:
8048: SELECT distribution_status_id, reschedule_time, due_date
8049: INTO l_dist_status_id, l_reschedule_time, l_due_date
8050: FROM ieu_uwqm_items
8051: WHERE workitem_pk_id = l_workitem_pk_id
8052: AND workitem_obj_code = l_workitem_obj_code;
8053: EXCEPTION
8054: when others then

Line 8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;

8411: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
8412: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
8413: l_ws_type VARCHAR2(500);
8414: l_ws_code VARCHAR2(500);
8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
8416: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
8417: l_source_object_id NUMBER;
8418: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
8419: l_distribution_status_id NUMBER;

Line 8416: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;

8412: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
8413: l_ws_type VARCHAR2(500);
8414: l_ws_code VARCHAR2(500);
8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
8416: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
8417: l_source_object_id NUMBER;
8418: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
8419: l_distribution_status_id NUMBER;
8420: l_parent_dist_status NUMBER;

Line 8418: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;

8414: l_ws_code VARCHAR2(500);
8415: l_owner_type IEU_UWQM_ITEMS.OWNER_TYPE%TYPE;
8416: l_assignee_type IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE;
8417: l_source_object_id NUMBER;
8418: l_source_object_type_code IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE;
8419: l_distribution_status_id NUMBER;
8420: l_parent_dist_status NUMBER;
8421: l_dist_st_based_on_parent VARCHAR2(5);
8422: l_set_dist_id_flag VARCHAR2(5);

Line 8516: from ieu_uwqm_items

8512: select ws_id, owner_id, owner_type, assignee_id, assignee_type, status_id,
8513: priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
8514: into l_ws_id, l_owner_id, l_owner_type, l_assignee_id, l_assignee_type, l_prev_status_id,
8515: l_priority_id, l_due_date, l_reschedule_time, l_prev_distribution_status_id, l_source_object_id, l_source_object_type_code
8516: from ieu_uwqm_items
8517: where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
8518: and workitem_obj_code = p_wr_item_list(i).workitem_obj_code;
8519:
8520: EXCEPTION

Line 8611: FROM ieu_uwqm_items

8607: then
8608: BEGIN
8609: SELECT distribution_status_id, status_id
8610: INTO l_parent_dist_status, l_parent_status_id
8611: FROM ieu_uwqm_items
8612: WHERE workitem_pk_id = l_source_object_id
8613: AND workitem_obj_code = l_source_object_type_code;
8614: EXCEPTION
8615: WHEN OTHERS THEN

Line 8727: update ieu_uwqm_items

8723: */
8724: end if; /* l_set_dist_id_flag */
8725:
8726: --dbms_output.put_line('l_set_dist_id_flag: '||l_set_dist_id_flag|| ' dist status: '|| l_distribution_status_id);
8727: update ieu_uwqm_items
8728: set distribution_status_id = l_distribution_status_id
8729: where workitem_pk_id = p_wr_item_list(i).workitem_pk_id
8730: and workitem_obj_code = p_wr_item_list(i).workitem_obj_code;
8731:

Line 9592: fnd_file.put_line(FND_FILE.LOG, 'Deleting rows from table IEU_UWQM_ITEMS');

9588: END IF;
9589:
9590: END IF;
9591:
9592: fnd_file.put_line(FND_FILE.LOG, 'Deleting rows from table IEU_UWQM_ITEMS');
9593: -- This statement deletes the records from the UWQ work repository table
9594: -- that are linked to an SR that is available in the global temp table
9595: -- with purge status NULL.
9596:

Line 9597: DELETE /+ INDEX(IEU_UWQM_ITEMS IEU_UWQM_ITEMS_U2) /

9593: -- This statement deletes the records from the UWQ work repository table
9594: -- that are linked to an SR that is available in the global temp table
9595: -- with purge status NULL.
9596:
9597: DELETE /*+ INDEX(IEU_UWQM_ITEMS IEU_UWQM_ITEMS_U2) */
9598: from IEU_UWQM_ITEMS
9599: WHERE WORKITEM_OBJ_CODE = p_object_type
9600: and WORKITEM_PK_ID in
9601: (

Line 9598: from IEU_UWQM_ITEMS

9594: -- that are linked to an SR that is available in the global temp table
9595: -- with purge status NULL.
9596:
9597: DELETE /*+ INDEX(IEU_UWQM_ITEMS IEU_UWQM_ITEMS_U2) */
9598: from IEU_UWQM_ITEMS
9599: WHERE WORKITEM_OBJ_CODE = p_object_type
9600: and WORKITEM_PK_ID in
9601: (
9602: SELECT t.object_id

Line 9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');

9606: AND nvl(t.purge_status,'S') <> 'E'
9607: );
9608:
9609: l_row_count := SQL%ROWCOUNT;
9610: fnd_file.put_line(FND_FILE.LOG, 'After deleting data from table IEU_UWQM_ITEMS ' || l_row_count || ' rows');
9611:
9612: x_return_status := fnd_api.g_ret_sts_success;
9613:
9614: fnd_file.put_line(FND_FILE.LOG, 'Completed work in ' || 'IEU_WR_PUB.PURGE_WR_ITEM' || ' with return status ' || x_return_status);

Line 9883: FROM IEU_UWQM_ITEMS

9879: priority_id, due_date, reschedule_time, distribution_status_id, source_object_id, source_object_type_code
9880: INTO l_prev_owner_id, l_prev_owner_type, l_prev_assignee_id, l_prev_assignee_type, l_prev_status_id,
9881: l_prev_priority_id, l_prev_due_date, l_prev_reschedule_time, l_prev_distribution_status_id,
9882: l_prev_source_object_id, l_prev_source_object_type_code
9883: FROM IEU_UWQM_ITEMS
9884: WHERE workitem_obj_code = p_workitem_obj_code
9885: AND workitem_pk_id = p_workitem_pk_id;
9886:
9887: EXCEPTION

Line 10485: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;

10481: L_MISS_NUM NUMBER;
10482:
10483: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10484: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
10485: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
10486: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;

10483: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10484: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
10485: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
10486: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;

Line 10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;

10484: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
10485: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
10486: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;

Line 10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

10485: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
10486: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;
10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

Line 10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;

10486: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;
10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10494: TYPE CHAR_TAB IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;

10487: TYPE OWNER_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE%TYPE INDEX BY BINARY_INTEGER;
10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;
10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10494: TYPE CHAR_TAB IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
10495:

Line 10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;

10488: TYPE ASSIGNEE_TYPE_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE%TYPE INDEX BY BINARY_INTEGER;
10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;
10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10494: TYPE CHAR_TAB IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
10495:
10496: WORKITEM_OBJ_CODE_LIST WORKITEM_OBJ_CODE_TAB;

Line 10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

10489: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
10490: TYPE OWNER_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.OWNER_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10491: TYPE ASSIGNEE_TYPE_ACTUAL_TAB IS TABLE OF IEU_UWQM_ITEMS.ASSIGNEE_TYPE_ACTUAL%TYPE INDEX BY BINARY_INTEGER;
10492: TYPE IEU_ENUM_TYPE_UUID_TAB IS TABLE OF IEU_UWQM_ITEMS.IEU_ENUM_TYPE_UUID%TYPE INDEX BY BINARY_INTEGER;
10493: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10494: TYPE CHAR_TAB IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
10495:
10496: WORKITEM_OBJ_CODE_LIST WORKITEM_OBJ_CODE_TAB;
10497: WORKITEM_PK_ID_LIST NUMBER_TAB;

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 10947: FROM IEU_UWQM_ITEMS B

10943: , A.PARENT_DIST_STATUS_ID
10944: ) =
10945: (SELECT B.STATUS_ID
10946: , B.DISTRIBUTION_STATUS_ID
10947: FROM IEU_UWQM_ITEMS B
10948: WHERE A.SOURCE_OBJECT_ID = B.WORKITEM_PK_ID
10949: AND A.SOURCE_OBJECT_TYPE_CODE = B.WORKITEM_OBJ_CODE)
10950: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10951: AND A.DIST_ST_BASED_ON_PARENT_FLAG = 'Y';

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 11059: INSERT INTO IEU_UWQM_ITEMS

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
11059: INSERT INTO IEU_UWQM_ITEMS
11060: ( WORK_ITEM_ID
11061: , OBJECT_VERSION_NUMBER
11062: , CREATED_BY
11063: , CREATION_DATE

Line 11091: ( IEU_UWQM_ITEMS_S1.NEXTVAL

11087: , STATUS_UPDATE_USER_ID
11088: , WS_ID
11089: , DISTRIBUTION_STATUS_ID
11090: ) VALUES
11091: ( IEU_UWQM_ITEMS_S1.NEXTVAL
11092: , 1
11093: , P_USER_ID
11094: , SYSDATE
11095: , P_USER_ID

Line 11157: UPDATE IEU_UWQM_ITEMS

11153:
11154: if (errors > 0) then
11155: BEGIN
11156: FORALL i in l_wr_items_rec.WORKITEM_OBJ_CODE_LST.FIRST..l_wr_items_rec.WORKITEM_OBJ_CODE_LST.LAST SAVE EXCEPTIONS
11157: UPDATE IEU_UWQM_ITEMS
11158: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
11159: , CREATED_BY = P_USER_ID
11160: , CREATION_DATE = SYSDATE
11161: , LAST_UPDATED_BY = P_USER_ID

Line 11356: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11352:
11353: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11354: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
11355: TYPE TITLE_TAB IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
11356: TYPE WORK_ITEM_NUMBER_TAB IS TABLE OF IEU_UWQM_ITEMS.WORK_ITEM_NUMBER%TYPE INDEX BY BINARY_INTEGER;
11357: TYPE CHAR_TAB IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
11358:
11359:
11360: TYPE ws_details_rec IS RECORD

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 11907: update IEU_UWQM_ITEMS

11903:
11904: BEGIN
11905: -- fnd_file.put_line(FND_FILE.LOG,'Begin update');
11906: FORALL i in 1..l_task_status_rec.l_task_id_list.COUNT SAVE EXCEPTIONS
11907: update IEU_UWQM_ITEMS
11908: set status_id = l_task_status_rec.l_status_id_list(i),
11909: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
11910: LAST_UPDATE_DATE = SYSDATE,
11911: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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 12344: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;

12340: l_count NUMBER;
12341: L_MISS_NUM NUMBER;
12342:
12343: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12344: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
12345: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
12346:
12347: WORKITEM_OBJ_CODE_LIST WORKITEM_OBJ_CODE_TAB;
12348: WORKITEM_PK_ID_LIST NUMBER_TAB;

Line 12345: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

12341: L_MISS_NUM NUMBER;
12342:
12343: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12344: TYPE WORKITEM_OBJ_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.WORKITEM_OBJ_CODE%TYPE INDEX BY BINARY_INTEGER;
12345: TYPE SOURCE_OBJECT_TYPE_CODE_TAB IS TABLE OF IEU_UWQM_ITEMS.SOURCE_OBJECT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
12346:
12347: WORKITEM_OBJ_CODE_LIST WORKITEM_OBJ_CODE_TAB;
12348: WORKITEM_PK_ID_LIST NUMBER_TAB;
12349:

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

Line 12722: UPDATE IEU_UWQM_ITEMS

12718: IF l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.FIRST IS NOT NULL THEN
12719: BEGIN
12720: FORALL i in l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.FIRST..l_wr_item_status_rec.WORKITEM_OBJ_CODE_LST.LAST SAVE EXCEPTIONS
12721:
12722: UPDATE IEU_UWQM_ITEMS
12723: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12724: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12725: , LAST_UPDATE_DATE = SYSDATE
12726: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 12843: from ieu_uwqm_items

12839: l_done BOOLEAN;
12840:
12841: cursor c_status(p_ws_id IN NUMBER) is
12842: select work_item_id
12843: from ieu_uwqm_items
12844: where ws_id = p_ws_id
12845: and status_id = 0;
12846:
12847: BEGIN

Line 12929: UPDATE IEU_UWQM_ITEMS

12925: l_done := c_status%NOTFOUND;
12926:
12927: BEGIN
12928: FORALL i in 1..l_wr_item_status_rec.WORK_ITEM_ID_LIST.COUNT SAVE EXCEPTIONS
12929: UPDATE IEU_UWQM_ITEMS
12930: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
12931: , LAST_UPDATED_BY = FND_GLOBAL.USER_ID
12932: , LAST_UPDATE_DATE = SYSDATE
12933: , LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID