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.IEM_OP_ADMIN_PUB dependencies on IEM_OUTBOX_ERRORS

Line 95: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

91: ----------------------code ------------------
92: if (p_sort_by = 'M') then
93:
94: if (p_sort_dir = 0) then
95: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
96: where a.outbox_error_id = (select max(b.outbox_error_id)
97: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id asc';
98: else
99: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

Line 97: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id asc';

93:
94: if (p_sort_dir = 0) then
95: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
96: where a.outbox_error_id = (select max(b.outbox_error_id)
97: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id asc';
98: else
99: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
100: where a.outbox_error_id = (select max(b.outbox_error_id)
101: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id desc';

Line 99: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

95: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
96: where a.outbox_error_id = (select max(b.outbox_error_id)
97: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id asc';
98: else
99: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
100: where a.outbox_error_id = (select max(b.outbox_error_id)
101: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id desc';
102: end if;
103:

Line 101: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id desc';

97: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id asc';
98: else
99: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
100: where a.outbox_error_id = (select max(b.outbox_error_id)
101: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by rt_media_item_id desc';
102: end if;
103:
104: elsif (p_sort_by = 'S') then
105:

Line 107: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

103:
104: elsif (p_sort_by = 'S') then
105:
106: if (p_sort_dir = 0) then
107: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
108: where a.outbox_error_id = (select max(b.outbox_error_id)
109: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary asc';
110: else
111: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

Line 109: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary asc';

105:
106: if (p_sort_dir = 0) then
107: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
108: where a.outbox_error_id = (select max(b.outbox_error_id)
109: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary asc';
110: else
111: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
112: where a.outbox_error_id = (select max(b.outbox_error_id)
113: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary desc';

Line 111: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

107: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
108: where a.outbox_error_id = (select max(b.outbox_error_id)
109: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary asc';
110: else
111: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
112: where a.outbox_error_id = (select max(b.outbox_error_id)
113: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary desc';
114: end if;
115:

Line 113: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary desc';

109: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary asc';
110: else
111: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
112: where a.outbox_error_id = (select max(b.outbox_error_id)
113: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_summary desc';
114: end if;
115:
116: elsif (p_sort_by = 'D') then
117: if (p_sort_dir = 0) then

Line 118: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

114: end if;
115:
116: elsif (p_sort_by = 'D') then
117: if (p_sort_dir = 0) then
118: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
119: where a.outbox_error_id = (select max(b.outbox_error_id)
120: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message asc';
121: else
122: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

Line 120: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message asc';

116: elsif (p_sort_by = 'D') then
117: if (p_sort_dir = 0) then
118: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
119: where a.outbox_error_id = (select max(b.outbox_error_id)
120: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message asc';
121: else
122: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
123: where a.outbox_error_id = (select max(b.outbox_error_id)
124: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message desc';

Line 122: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

118: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
119: where a.outbox_error_id = (select max(b.outbox_error_id)
120: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message asc';
121: else
122: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
123: where a.outbox_error_id = (select max(b.outbox_error_id)
124: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message desc';
125: end if;
126: elsif (p_sort_by = 'C') then

Line 124: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message desc';

120: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message asc';
121: else
122: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
123: where a.outbox_error_id = (select max(b.outbox_error_id)
124: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message desc';
125: end if;
126: elsif (p_sort_by = 'C') then
127: if (p_sort_dir = 0) then
128: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

Line 128: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

124: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by error_message desc';
125: end if;
126: elsif (p_sort_by = 'C') then
127: if (p_sort_dir = 0) then
128: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
129: where a.outbox_error_id = (select max(b.outbox_error_id)
130: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date asc';
131: else
132: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

Line 130: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date asc';

126: elsif (p_sort_by = 'C') then
127: if (p_sort_dir = 0) then
128: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
129: where a.outbox_error_id = (select max(b.outbox_error_id)
130: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date asc';
131: else
132: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
133: where a.outbox_error_id = (select max(b.outbox_error_id)
134: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date desc';

Line 132: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a

128: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
129: where a.outbox_error_id = (select max(b.outbox_error_id)
130: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date asc';
131: else
132: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
133: where a.outbox_error_id = (select max(b.outbox_error_id)
134: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date desc';
135: end if;
136:

Line 134: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date desc';

130: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date asc';
131: else
132: str := 'select a.RT_MEDIA_ITEM_ID, a.ERROR_SUMMARY, a.ERROR_MESSAGE, a.CREATE_DATE, to_char(a.create_date, :1) FROM IEM_OUTBOX_ERRORS a
133: where a.outbox_error_id = (select max(b.outbox_error_id)
134: from IEM_OUTBOX_ERRORS b where a.rt_media_item_id = b.rt_media_item_id and b.expire <> :2 and b.create_date = (select max(b.create_date) from IEM_OUTBOX_ERRORS c where a.rt_media_item_id = c.rt_media_item_id)) order by create_date desc';
135: end if;
136:
137: end if;
138:

Line 153: -- Since there are multiple records for one msg at iem_outbox_errors,

149: x := false;
150: if (l_start = 0) then
151: x := true;
152: else
153: -- Since there are multiple records for one msg at iem_outbox_errors,
154: -- l_op_rec can have multi-records for same rt_media_item_id.
155: if (l_op_rec.rt_media_item_id <> l_outbox_array(l_outbox_array.LAST).rt_media_item_id) then
156: x := true;
157: end if;

Line 312: delete from iem_outbox_errors;

308: ----------------------code ------------------
309:
310: if ( p_rt_media_item_id_array.COUNT > 0 ) then
311: if ( p_rt_media_item_id_array(p_rt_media_item_id_array.FIRST).num = G_ALL ) then
312: delete from iem_outbox_errors;
313: else
314: for i in p_rt_media_item_id_array.FIRST..p_rt_media_item_id_array.LAST loop
315: delete from iem_outbox_errors where rt_media_item_id = p_rt_media_item_id_array(i).num;
316: end loop;

Line 315: delete from iem_outbox_errors where rt_media_item_id = p_rt_media_item_id_array(i).num;

311: if ( p_rt_media_item_id_array(p_rt_media_item_id_array.FIRST).num = G_ALL ) then
312: delete from iem_outbox_errors;
313: else
314: for i in p_rt_media_item_id_array.FIRST..p_rt_media_item_id_array.LAST loop
315: delete from iem_outbox_errors where rt_media_item_id = p_rt_media_item_id_array(i).num;
316: end loop;
317: end if;
318: end if;
319: --------------------------

Line 412: update iem_outbox_errors set expire = G_EXPIRE;

408:
409: update iem_rt_interactions set expire = G_EXPIRE
410: where expire = G_PROCESSING;
411:
412: update iem_outbox_errors set expire = G_EXPIRE;
413: end;
414: else
415: for i in p_rt_media_item_id_array.FIRST..p_rt_media_item_id_array.LAST loop
416: begin

Line 427: update iem_outbox_errors set expire = G_EXPIRE where

423:
424: update iem_rt_media_items set expire = G_EXPIRE where
425: rt_interaction_id = l_rt_interaction_id;
426:
427: update iem_outbox_errors set expire = G_EXPIRE where
428: rt_media_item_id = p_rt_media_item_id_array(i).num;
429: end;
430: end loop;
431: end if;

Line 934: update iem_outbox_errors set expire = G_EXPIRE

930:
931: update iem_rt_interactions set expire = G_EXPIRE
932: where rt_interaction_id = l_rt_interaction_id;
933:
934: update iem_outbox_errors set expire = G_EXPIRE
935: where rt_media_item_id in
936: (select rt_media_item_id from iem_rt_media_items
937: where rt_interaction_id = l_rt_interaction_id);
938:

Line 961: update iem_outbox_errors set expire = G_EXPIRE

957: update iem_rt_proc_emails set queue_status = null
958: where message_id = l_message_id;
959: end if;
960:
961: update iem_outbox_errors set expire = G_EXPIRE
962: where rt_media_item_id in
963: (select rt_media_item_id from iem_rt_media_items
964: where rt_interaction_id = l_rt_interaction_id);
965: