APPS.IEM_CLIENT_PUB dependencies on IEM_OUTBOX_ERRORS

Line 2114: UPDATE iem_outbox_errors SET expire = G_EXPIRE

2110: if ( l_status = FND_API.G_RET_STS_ERROR ) then
2111: raise IEM_REDIRECT_EX;
2112: end if;
2113:
2114: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2115: WHERE rt_media_item_id = p_rt_media_item_id;
2116:
2117: update iem_rt_interactions set expire = G_EXPIRE
2118: where rt_interaction_id = l_rt_interaction_id;

Line 2856: -- Expire iem_outbox_errors records if any

2852: WHEN OTHERS THEN
2853: NULL;
2854: END;
2855:
2856: -- Expire iem_outbox_errors records if any
2857: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2858: WHERE rt_media_item_id in (SELECT rt_media_item_id
2859: FROM iem_rt_media_items WHERE rt_interaction_id = l_rt_interaction_id);
2860:

Line 2857: UPDATE iem_outbox_errors SET expire = G_EXPIRE

2853: NULL;
2854: END;
2855:
2856: -- Expire iem_outbox_errors records if any
2857: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2858: WHERE rt_media_item_id in (SELECT rt_media_item_id
2859: FROM iem_rt_media_items WHERE rt_interaction_id = l_rt_interaction_id);
2860:
2861: -- write statistics data

Line 3392: delete from iem_outbox_errors where expire = 'Y';

3388:
3389: END LOOP;
3390:
3391: -- delete outbox errors
3392: delete from iem_outbox_errors where expire = 'Y';
3393:
3394: delete from iem_msg_parts where REF_KEY in
3395: (select rt_media_item_id from iem_rt_media_items WHERE expire='Y');
3396:

Line 4236: FROM iem_outbox_errors

4232: if ( l_rt_media_item_id is not null ) then
4233: begin
4234: l_try := 0;
4235: SELECT count(outbox_error_id) INTO l_try
4236: FROM iem_outbox_errors
4237: WHERE rt_media_item_id = l_rt_media_item_id;
4238: exception
4239: WHEN OTHERS then
4240: null;