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

Line 18: from ieu_uwqm_items child

14: /*Cursor c1_purge_assct_wi(p_ws_id IN NUMBER,p_parent_ws_id IN NUMBER) is
15: Select workitem_pk_id, workitem_obj_code, source_object_id, source_object_type_code,
16: owner_id, owner_type, assignee_id, assignee_type, status_id, priority_id, due_date,
17: reschedule_time, distribution_status_id,work_item_number, work_item_id
18: from ieu_uwqm_items child
19: where ws_id = p_ws_id
20: and status_id in (3, 4)
21: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
22: and not exists

Line 24: from ieu_uwqm_items parent

20: and status_id in (3, 4)
21: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
22: and not exists
23: (select 1
24: from ieu_uwqm_items parent
25: where ws_id = p_parent_ws_id
26: and status_id in (0,5)
27: and parent.workitem_pk_id = child.source_object_id
28: and parent.workitem_obj_code = child.source_object_type_code);

Line 35: from ieu_uwqm_items

31: --** This cursor represents the Associate work items that are closed and have open parent work items **--
32: --** Here work items which have parents in open status are picked **--
33: Cursor C1_open_parent_assct_Wi(p_ws_id IN NUMBER,p_parent_ws_id IN NUMBER) is
34: Select workitem_pk_id, workitem_obj_code, source_object_id, source_object_type_code
35: from ieu_uwqm_items
36: where ws_id = p_ws_id
37: and status_id in (3, 4)
38: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
39: and (source_object_id, source_object_type_code) IN

Line 41: from ieu_uwqm_items

37: and status_id in (3, 4)
38: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
39: and (source_object_id, source_object_type_code) IN
40: (select workitem_pk_id, workitem_obj_code
41: from ieu_uwqm_items
42: where ws_id = p_parent_ws_id
43: and status_id in (0,5) );
44:
45:

Line 52: from ieu_uwqm_items parent

48: /*Cursor C2_purge_primary_wi(p_ws_id IN NUMBER,p_child_ws_id IN NUMBER) is
49: Select workitem_pk_id, workitem_obj_code, source_object_id, source_object_type_code,
50: owner_id, owner_type, assignee_id, assignee_type, status_id, priority_id, due_date,
51: reschedule_time, distribution_status_id,work_item_number,work_item_id
52: from ieu_uwqm_items parent
53: where ws_id = p_ws_id
54: and status_id in (3, 4)
55: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
56: and not exists

Line 58: from ieu_uwqm_items child

54: and status_id in (3, 4)
55: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
56: and not exists
57: (select source_object_id, source_object_type_code
58: from ieu_uwqm_items child
59: where ws_id = p_child_ws_id
60: and status_id in (0,5)
61: and child.workitem_pk_id = parent.source_object_id
62: and child.workitem_obj_code = parent.source_object_type_code);

Line 67: from ieu_uwqm_items

63: */
64: --** This cursor represents the Primary work items that are closed and have open child work items **--
65: Cursor C2_open_child_primary_wi(p_ws_id IN NUMBER,p_child_ws_id IN NUMBER) is
66: /*Select workitem_pk_id, workitem_obj_code, source_object_id, source_object_type_code
67: from ieu_uwqm_items
68: where ws_id = p_ws_id
69: and status_id in (3, 4)
70: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
71: and (workitem_pk_id, workitem_obj_code) in

Line 73: from ieu_uwqm_items

69: and status_id in (3, 4)
70: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
71: and (workitem_pk_id, workitem_obj_code) in
72: (select source_object_id, source_object_type_code
73: from ieu_uwqm_items
74: where ws_id = p_child_ws_id
75: and status_id in (0,5) );*/
76:
77: Select parent.workitem_pk_id, parent.workitem_obj_code, child.workitem_pk_id, child.workitem_obj_code

Line 78: from ieu_uwqm_items parent , ieu_uwqm_items child

74: where ws_id = p_child_ws_id
75: and status_id in (0,5) );*/
76:
77: Select parent.workitem_pk_id, parent.workitem_obj_code, child.workitem_pk_id, child.workitem_obj_code
78: from ieu_uwqm_items parent , ieu_uwqm_items child
79: where parent.ws_id = p_ws_id
80: and parent.status_id in (3, 4)
81: and ( to_date(trunc(parent.last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') )
82: and parent.workitem_pk_id = child.source_object_id

Line 92: from ieu_uwqm_items

88: /*Cursor C3_purge_wi(p_ws_id IN NUMBER) is
89: Select workitem_pk_id, workitem_obj_code, source_object_id, source_object_type_code,
90: owner_id, owner_type, assignee_id, assignee_type, status_id, priority_id, due_date,
91: reschedule_time, distribution_status_id,work_item_number,work_item_id
92: from ieu_uwqm_items
93: where status_id in(3,4)
94: and ws_id = p_ws_id
95: and to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') ;
96: */

Line 210: from ieu_uwqm_items

206: BEGIN
207: l_closed_item_exists := 0;
208: select count(*)
209: into l_closed_item_exists
210: from ieu_uwqm_items
211: where ws_id = l_parent_ws_id
212: and status_id in (3, 4)
213: and to_date(trunc(last_update_date), 'dd-mm-rrrr')
214: <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') ;

Line 228: from ieu_uwqm_items main

224:
225:
226: select count(*)
227: into l_wi_exists
228: from ieu_uwqm_items main
229: where status_id in (3,4)
230: and ws_id = l_parent_ws_id
231: and ( workitem_pk_id, workitem_obj_code) in
232: (Select source_object_id,source_object_type_code

Line 233: from ieu_uwqm_items

229: where status_id in (3,4)
230: and ws_id = l_parent_ws_id
231: and ( workitem_pk_id, workitem_obj_code) in
232: (Select source_object_id,source_object_type_code
233: from ieu_uwqm_items
234: where status_id in (3, 4)
235: and to_date(trunc(last_update_date), 'dd-mm-rrrr')
236: <= to_date(trunc(sysdate), 'dd-mm-rrrr') )
237: and not exists (select 1 from ieu_uwqm_items

Line 237: and not exists (select 1 from ieu_uwqm_items

233: from ieu_uwqm_items
234: where status_id in (3, 4)
235: and to_date(trunc(last_update_date), 'dd-mm-rrrr')
236: <= to_date(trunc(sysdate), 'dd-mm-rrrr') )
237: and not exists (select 1 from ieu_uwqm_items
238: where status_id in (0,5)
239: and source_object_id = main.workitem_pk_id
240: and source_object_type_code = main.workitem_obj_code
241: and to_date(trunc(last_update_date), 'dd-mm-rrrr')

Line 479: from ieu_uwqm_items child

475: END LOOP;
476:
477: --** delete all associate work items where parent work items are closed **--
478: delete
479: from ieu_uwqm_items child
480: where ws_id = l_ws_id
481: and status_id in (3, 4)
482: and to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr')
483: and not exists

Line 485: from ieu_uwqm_items parent

481: and status_id in (3, 4)
482: and to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr')
483: and not exists
484: (select 1
485: from ieu_uwqm_items parent
486: where ws_id = l_parent_ws_id
487: and status_id in (0,5)
488: and parent.workitem_pk_id = child.source_object_id
489: and parent.workitem_obj_code = child.source_object_type_code);

Line 719: from ieu_uwqm_items parent

715: IF (l_assct_ws_id is not null)
716: THEN
717: --** Open child Work Item does not exist. Hence the parent work item should be purged. **--
718: delete
719: from ieu_uwqm_items parent
720: where ws_id = l_ws_id
721: and status_id in (3, 4)
722: and to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr')
723: and not exists

Line 725: from ieu_uwqm_items child

721: and status_id in (3, 4)
722: and to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr')
723: and not exists
724: (select 1
725: from ieu_uwqm_items child
726: where ws_id = l_child_ws_id
727: and status_id in (0,5)
728: and child.source_object_id = parent.workitem_pk_id
729: and child.source_object_type_code = parent.workitem_obj_code );

Line 916: delete from ieu_uwqm_items

912: END IF; */
913:
914:
915:
916: delete from ieu_uwqm_items
917: where status_id in (3,4)
918: and ws_id = l_ws_id
919: and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') );
920: