APPS.IEM_CLIENT_PUB dependencies on IEM_OUTBOX_ERRORS

Line 2132: UPDATE iem_outbox_errors SET expire = G_EXPIRE

2128: if ( l_status = FND_API.G_RET_STS_ERROR ) then
2129: raise IEM_REDIRECT_EX;
2130: end if;
2131:
2132: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2133: WHERE rt_media_item_id = p_rt_media_item_id;
2134:
2135: update iem_rt_interactions set expire = G_EXPIRE
2136: where rt_interaction_id = l_rt_interaction_id;

Line 2918: -- Expire iem_outbox_errors records if any

2914: WHEN OTHERS THEN
2915: NULL;
2916: END;
2917:
2918: -- Expire iem_outbox_errors records if any
2919: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2920: WHERE rt_media_item_id in (SELECT rt_media_item_id
2921: FROM iem_rt_media_items WHERE rt_interaction_id = l_rt_interaction_id);
2922:

Line 2919: UPDATE iem_outbox_errors SET expire = G_EXPIRE

2915: NULL;
2916: END;
2917:
2918: -- Expire iem_outbox_errors records if any
2919: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2920: WHERE rt_media_item_id in (SELECT rt_media_item_id
2921: FROM iem_rt_media_items WHERE rt_interaction_id = l_rt_interaction_id);
2922:
2923: -- write statistics data

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

3450:
3451: END LOOP;
3452:
3453: -- delete outbox errors
3454: delete from iem_outbox_errors where expire = 'Y';
3455:
3456: delete from iem_msg_parts where REF_KEY in
3457: (select rt_media_item_id from iem_rt_media_items WHERE expire='Y');
3458:

Line 4311: FROM iem_outbox_errors

4307: if ( l_rt_media_item_id is not null ) then
4308: begin
4309: l_try := 0;
4310: SELECT count(outbox_error_id) INTO l_try
4311: FROM iem_outbox_errors
4312: WHERE rt_media_item_id = l_rt_media_item_id;
4313: exception
4314: WHEN OTHERS then
4315: null;