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_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_ITEMS

Line 78: FROM ieu_uwqm_items

74: THEN
75:
76: SELECT status_id, source_object_id, source_object_type_code
77: INTO l_status_id, l_source_object_id, l_source_obj_type_code
78: FROM ieu_uwqm_items
79: WHERE work_item_id = p_work_item_id;
80:
81: ELSE
82:

Line 85: FROM ieu_uwqm_items

81: ELSE
82:
83: SELECT status_id, source_object_id, source_object_type_code
84: INTO l_status_id, l_source_object_id, l_source_obj_type_code
85: FROM ieu_uwqm_items
86: WHERE workitem_pk_id = p_workitem_pk_id
87: AND workitem_obj_code = p_workitem_obj_code;
88:
89: END IF;

Line 119: FROM IEU_UWQM_ITEMS

115: -- Release source_doc_id
116:
117: /* SELECT WORK_ITEM_ID
118: INTO L_SOURCEOBJ_WORKITEM_ID
119: FROM IEU_UWQM_ITEMS
120: WHERE (WORKITEM_PK_ID, WORKITEM_OBJ_CODE) IN
121: (SELECT SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE_CODE
122: FROM IEU_UWQM_ITEMS
123: WHERE ( (WORK_ITEM_ID = P_WORK_ITEM_ID) OR

Line 122: FROM IEU_UWQM_ITEMS

118: INTO L_SOURCEOBJ_WORKITEM_ID
119: FROM IEU_UWQM_ITEMS
120: WHERE (WORKITEM_PK_ID, WORKITEM_OBJ_CODE) IN
121: (SELECT SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE_CODE
122: FROM IEU_UWQM_ITEMS
123: WHERE ( (WORK_ITEM_ID = P_WORK_ITEM_ID) OR
124: ( (WORKITEM_PK_ID = P_WORKITEM_PK_ID) AND (WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE) )
125: )
126: );

Line 131: FROM IEU_UWQM_ITEMS

127: */
128: /*
129: SELECT WORK_ITEM_ID
130: INTO L_SOURCEOBJ_WORKITEM_ID
131: FROM IEU_UWQM_ITEMS
132: WHERE WORKITEM_PK_ID = l_source_object_id
133: AND WORKITEM_OBJ_CODE = l_source_obj_type_code;
134:
135: IF (L_SOURCEOBJ_WORKITEM_ID is not null)

Line 289: from ieu_uwqm_items

285: declare
286: cursor c1 is
287: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
288: workitem_obj_code
289: from ieu_uwqm_items
290: where owner_type = l_owner_type_ind
291: and owner_id = p_resource_id
292: and status_id in (0,1,2)
293: and reschedule_time <= sysdate

Line 320: from ieu_uwqm_items

316: declare
317: cursor c1 is
318: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
319: workitem_obj_code
320: from ieu_uwqm_items
321: where owner_type = l_owner_type_grp
322: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
323: and status_id in (0,1,2)
324: and reschedule_time <= sysdate

Line 353: from ieu_uwqm_items

349: declare
350: cursor c1 is
351: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
352: workitem_obj_code
353: from ieu_uwqm_items
354: where assignee_type = l_owner_type_ind
355: and assignee_id = p_resource_id
356: and status_id in (0,1,2)
357: and reschedule_time <= sysdate

Line 386: from ieu_uwqm_items

382: declare
383: cursor c1 is
384: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
385: workitem_obj_code
386: from ieu_uwqm_items
387: where assignee_type = l_owner_type_grp
388: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
389: and status_id in (0,1,2)
390: and reschedule_time <= sysdate

Line 757: FROM IEU_UWQM_ITEMS UWQM,

753: UWQM.RESCHEDULE_TIME,
754: LKUPS.MEANING WORK_TYPE,
755: DECODE(STATUS_ID, 0, '', 1, LKUPS1.MEANING, 2, LKUPS1.MEANING) STATUS_CODE
756: INTO X_UWQM_WORKITEM_DATA(i)
757: FROM IEU_UWQM_ITEMS UWQM,
758: IEU_UWQ_SEL_ENUMERATORS ENUM,
759: IEU_UWQM_PRIORITIES_TL PR,
760: FND_LOOKUP_VALUES_VL LKUPS,
761: FND_LOOKUP_VALUES_VL LKUPS1

Line 862: from ieu_uwqm_items

858: -------------- Individual Owned Work Items ----------1
859: declare
860: cursor c1 is
861: select work_item_id
862: from ieu_uwqm_items
863: where owner_type = l_owner_type_ind
864: and owner_id = p_resource_id
865: and status_id = p_status_id
866: and (p_node_type = 1 or p_node_type = 2)

Line 870: from ieu_uwqm_items

866: and (p_node_type = 1 or p_node_type = 2)
867: and reschedule_time <= sysdate
868: union
869: select work_item_id
870: from ieu_uwqm_items
871: where owner_type = l_owner_type_grp
872: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
873: and status_id = p_status_id
874: and (p_node_type = 1 or p_node_type = 3)

Line 878: from ieu_uwqm_items

874: and (p_node_type = 1 or p_node_type = 3)
875: and reschedule_time <= sysdate
876: union
877: select work_item_id
878: from ieu_uwqm_items
879: where assignee_type = l_owner_type_ind
880: and assignee_id = p_resource_id
881: and status_id = p_status_id
882: and (p_node_type = 1 or p_node_type = 4)

Line 886: from ieu_uwqm_items

882: and (p_node_type = 1 or p_node_type = 4)
883: and reschedule_time <= sysdate
884: union
885: select work_item_id
886: from ieu_uwqm_items
887: where assignee_type = l_owner_type_grp
888: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
889: and status_id = p_status_id
890: and (p_node_type = 1 or p_node_type = 5)

Line 1100: FROM IEU_UWQM_ITEMS '||

1096: IEU_ENUM_TYPE_UUID,
1097: WORK_ITEM_NUMBER,
1098: RESCHEDULE_TIME,
1099: WS_ID
1100: FROM IEU_UWQM_ITEMS '||
1101: ' WHERE ( '|| p_dist_to_extra_where_clause || ' ) '||
1102: ' AND DISTRIBUTION_STATUS_ID = :l_del_status' ||
1103: ' AND STATUS_ID = :l_open_status_id ' ||
1104: ' and reschedule_time <= sysdate ' ||

Line 1226: FROM IEU_UWQM_ITEMS '||

1222: IEU_ENUM_TYPE_UUID,
1223: WORK_ITEM_NUMBER,
1224: RESCHEDULE_TIME,
1225: WS_ID
1226: FROM IEU_UWQM_ITEMS '||
1227: ' WHERE ( '|| p_dist_from_extra_where_clause || ' ) '||
1228: ' AND DISTRIBUTION_STATUS_ID = :l_dist_status' ||
1229: ' AND STATUS_ID = :l_open_status_id ' ||
1230: ' and reschedule_time <= sysdate ' ||

Line 1323: update ieu_uwqm_items

1319:
1320: l_dist_wr_cur_cnt := l_dist_wr_cur_cnt + 1;
1321:
1322:
1323: update ieu_uwqm_items
1324: set distribution_status_id = 2
1325: where work_item_id = l_dist_nw_item.WORK_ITEM_ID;
1326:
1327:

Line 1513: from ieu_uwqm_items

1509: BEGIN
1510:
1511: select reschedule_time, distribution_status_id
1512: into l_reschedule_time, l_distribution_status_id
1513: from ieu_uwqm_items
1514: where workitem_pk_id = l_workitem_pk_id
1515: and workitem_obj_code = l_workitem_obj_code;
1516:
1517: EXCEPTION

Line 1736: from ieu_uwqm_items

1732: BEGIN
1733:
1734: select reschedule_time, distribution_status_id
1735: into l_reschedule_time, l_distribution_status_id
1736: from ieu_uwqm_items
1737: where workitem_pk_id = l_workitem_pk_id
1738: and workitem_obj_code = l_workitem_obj_code;
1739:
1740: EXCEPTION

Line 2009: update ieu_uwqm_items

2005: then
2006: l_status_id := 5;
2007: end if;
2008:
2009: update ieu_uwqm_items
2010: set distribution_status_id = 1
2011: where work_item_id = l_dist_items(k).work_item_id;
2012: commit;
2013:

Line 2043: from ieu_uwqm_items

2039: BEGIN
2040:
2041: select reschedule_time, distribution_status_id, priority_id
2042: into l_reschedule_time, l_distribution_status_id, l_priority_id
2043: from ieu_uwqm_items
2044: where workitem_pk_id = l_workitem_pk_id
2045: and workitem_obj_code = l_workitem_obj_code;
2046:
2047: EXCEPTION

Line 2162: from ieu_uwqm_items

2158: BEGIN
2159:
2160: select reschedule_time, distribution_status_id, priority_id
2161: into l_reschedule_time, l_distribution_status_id, l_priority_id
2162: from ieu_uwqm_items
2163: where workitem_pk_id = l_workitem_pk_id
2164: and workitem_obj_code = l_workitem_obj_code;
2165:
2166: EXCEPTION

Line 2306: from ieu_uwqm_items

2302: BEGIN
2303:
2304: select reschedule_time, distribution_status_id, priority_id
2305: into l_reschedule_time, l_distribution_status_id, l_priority_id
2306: from ieu_uwqm_items
2307: where workitem_pk_id = l_dist_items(j).workitem_pk_id
2308: and workitem_obj_code = l_dist_items(j).workitem_obj_code;
2309:
2310: EXCEPTION

Line 2435: update ieu_uwqm_items

2431: --dbms_output.put_line('Work item id: '||l_nw_items_list(y).workitem_pk_id);
2432: --dbms_output.put_line('Distributed Work Item Id: '||l_dist_work_item_id );
2433: if (l_nw_items_list(y).work_item_id <> nvl(l_dist_work_item_id,-1))
2434: then
2435: update ieu_uwqm_items
2436: set distribution_status_id = 1
2437: where work_item_id = l_nw_items_list(y).work_item_id;
2438: commit;
2439: end if;

Line 2821: FROM IEU_UWQM_ITEMS '||

2817: IEU_ENUM_TYPE_UUID,
2818: WORK_ITEM_NUMBER,
2819: RESCHEDULE_TIME,
2820: WS_ID
2821: FROM IEU_UWQM_ITEMS '||
2822: ' WHERE ' || ' ( ' ||p_extra_where_clause || ' ) '||
2823: ' AND DISTRIBUTION_STATUS_ID = :l_dist_status' ||
2824: ' AND STATUS_ID = :l_status_id ' ||
2825: ' and reschedule_time <= sysdate ' ||

Line 2929: update ieu_uwqm_items

2925:
2926: l_wr_cur_cnt := l_wr_cur_cnt + 1;
2927:
2928: -- update work item status to distributing
2929: update ieu_uwqm_items
2930: set distribution_status_id = 2
2931: where work_item_id = l_nw_item.WORK_ITEM_ID;
2932:
2933:

Line 3252: update ieu_uwqm_items

3248: l_status_id := 5;
3249: end if;
3250:
3251: -- insert into p_temp values('dist func failed '||l_return_status||' '||l_msg_data, l_dist_items(k).work_item_id);commit;
3252: update ieu_uwqm_items
3253: set distribution_status_id = 1
3254: where work_item_id = l_dist_items(k).work_item_id;
3255: commit;
3256:

Line 3301: from ieu_uwqm_items

3297: BEGIN
3298:
3299: select reschedule_time, distribution_status_id, priority_id
3300: into l_reschedule_time, l_distribution_status_id, l_priority_id
3301: from ieu_uwqm_items
3302: where workitem_pk_id = l_workitem_pk_id
3303: and workitem_obj_code = l_workitem_obj_code;
3304:
3305: EXCEPTION

Line 3430: from ieu_uwqm_items

3426: BEGIN
3427:
3428: select reschedule_time, priority_id
3429: into l_reschedule_time, l_priority_id
3430: from ieu_uwqm_items
3431: where workitem_pk_id = l_workitem_pk_id
3432: and workitem_obj_code = l_workitem_obj_code;
3433:
3434: EXCEPTION

Line 3542: update ieu_uwqm_items

3538: elsif (l_dist_items(j).DISTRIBUTED = 'FALSE')
3539: then
3540: -- set the distribution_status_id back to 'Distributable'
3541: --dbms_output.put_line('dist status set to FALSE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
3542: update ieu_uwqm_items
3543: set distribution_status_id = 1
3544: where work_item_id = l_dist_items(j).work_item_id;
3545: commit;
3546:

Line 3561: update ieu_uwqm_items

3557: end if; /* x_num_of_items_distributed <> -1 */
3558: if l_nw_items_list.count > 0 then
3559: for y in l_nw_items_list.first..l_nw_items_list.last
3560: loop
3561: update ieu_uwqm_items
3562: set distribution_status_id = 1
3563: where work_item_id = l_nw_items_list(y).work_item_id
3564: and distribution_status_id = 2;
3565: commit;

Line 4877: l_sql_stmt := 'UPDATE IEU_UWQM_ITEMS

4873: end if;
4874: l_df_grp_id_clause := '( owner_type = '||''''||'RS_GROUP'||''''||' and '||l_df_grp_id_clause||')';
4875:
4876:
4877: l_sql_stmt := 'UPDATE IEU_UWQM_ITEMS
4878: SET DISTRIBUTION_STATUS_ID = 1
4879: WHERE '|| l_df_grp_id_clause ||
4880: 'AND DISTRIBUTION_STATUS_ID = '||':l_distribution_status_id '||
4881: 'AND STATUS_ID = '||':l_status_id'