DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_THREAD_DTLS

Line 459: fix for bug 13797286 . Don't insert into IEM_THREAD_DTLS if the message is redirected or rerouted.

455: END;
456: END IF;
457:
458: /*
459: fix for bug 13797286 . Don't insert into IEM_THREAD_DTLS if the message is redirected or rerouted.
460: */
461:
462:
463: IF l_thread_id IS NOT NULL AND nvl(l_post_rec.msg_status,'NEW') not in

Line 468: l_logmessage:='start insertion to IEM_THREAD_DTLS';

464: ('REDIRECT','REROUTE') THEN
465:
466:
467: if g_statement_log then
468: l_logmessage:='start insertion to IEM_THREAD_DTLS';
469: iem_logger(l_logmessage);
470: end if;
471:
472: insert into IEM_THREAD_DTLS(

Line 472: insert into IEM_THREAD_DTLS(

468: l_logmessage:='start insertion to IEM_THREAD_DTLS';
469: iem_logger(l_logmessage);
470: end if;
471:
472: insert into IEM_THREAD_DTLS(
473: THREAD_ID,
474: MESSAGE_ID,
475: MESSAGE_TYPE,
476: CREATED_BY,