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_MSG_STAT_PUB dependencies on IEM_OUTBOUND_MSG_STATS

Line 65: select iem_outbound_msg_stats_s1.nextval into l_i_sequence from dual;

61: -- Initialize API return status to SUCCESS
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63:
64: -----------------------Code------------------------
65: select iem_outbound_msg_stats_s1.nextval into l_i_sequence from dual;
66:
67: l_no := 'N';
68: insert into IEM_OUTBOUND_MSG_STATS
69: (

Line 68: insert into IEM_OUTBOUND_MSG_STATS

64: -----------------------Code------------------------
65: select iem_outbound_msg_stats_s1.nextval into l_i_sequence from dual;
66:
67: l_no := 'N';
68: insert into IEM_OUTBOUND_MSG_STATS
69: (
70: OUTBOUND_MSG_STATS_ID,
71: MEDIA_ID,
72: INBOUND_MEDIA_ID,

Line 210: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id from IEM_OUTBOUND_MSG_STATS where

206:
207: -----------------------Code------------------------
208: l_outBoundMethod := p_outBoundMethod;
209: BEGIN
210: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id from IEM_OUTBOUND_MSG_STATS where
211: MEDIA_ID = p_outBoundMediaID and INBOUND_MEDIA_ID = p_inBoundMediaID;
212:
213: select count(DOC_USAGE_STATS_ID) into l_outbound_stats_count from IEM_DOC_USAGE_STATS where
214: OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;

Line 228: UPDATE IEM_OUTBOUND_MSG_STATS SET

224:
225: l_no := 'N';
226: IF (p_outBoundMediaID > 0)
227: THEN
228: UPDATE IEM_OUTBOUND_MSG_STATS SET
229: AUTO_REPLIED_Y_N = l_no,
230: AGENT_ID = p_agentID,
231: OUTBOUND_METHOD = p_outBoundMethod,
232: EMAIL_ACCOUNT_ID = p_accountID,

Line 241: UPDATE IEM_OUTBOUND_MSG_STATS SET

237: LAST_UPDATE_DATE = SYSDATE,
238: LAST_UPDATE_LOGIN = l_last_update_login
239: WHERE MEDIA_ID = p_outBoundMediaID;
240: ELSE
241: UPDATE IEM_OUTBOUND_MSG_STATS SET
242: AUTO_REPLIED_Y_N = l_no,
243: AGENT_ID = p_agentID,
244: OUTBOUND_METHOD = p_outBoundMethod,
245: EMAIL_ACCOUNT_ID = p_accountID,

Line 354: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;

350: -----------------------Code------------------------
351: BEGIN
352: IF (p_outBoundMediaID > 0) THEN
353: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
354: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
355: ELSE
356: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
357: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
358: END IF;

Line 357: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;

353: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
354: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
355: ELSE
356: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
357: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN
361: NULL;

Line 365: DELETE FROM IEM_OUTBOUND_MSG_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;

361: NULL;
362: END;
363:
364: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
365: DELETE FROM IEM_OUTBOUND_MSG_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;
366:
367: -------------------End Code------------------------
368: -- Standard Check Of p_commit.
369: IF FND_API.To_Boolean(p_commit) THEN

Line 470: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;

466:
467: BEGIN
468: IF (p_outBoundMediaID > 0) THEN
469: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
470: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
471: ELSE
472: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
473: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
474: END IF;

Line 473: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;

469: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
470: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
471: ELSE
472: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
473: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
474: END IF;
475: EXCEPTION
476: WHEN OTHERS THEN
477: NULL;

Line 572: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;

568: -----------------------Code------------------------
569: BEGIN
570: IF (p_outBoundMediaID > 0) THEN
571: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
572: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
573: ELSE
574: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
575: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
576: END IF;

Line 575: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;

571: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
572: FROM IEM_OUTBOUND_MSG_STATS WHERE MEDIA_ID = p_outBoundMediaID;
573: ELSE
574: SELECT OUTBOUND_MSG_STATS_ID INTO l_outbound_msg_stats_id
575: FROM IEM_OUTBOUND_MSG_STATS WHERE INBOUND_MEDIA_ID = p_inBoundMediaID;
576: END IF;
577: EXCEPTION
578: WHEN OTHERS THEN
579: NULL;

Line 730: from IEM_OUTBOUND_MSG_STATS where MEDIA_ID = l_outbound_media_ID;

726: END;
727:
728: IF (l_outbound_media_ID > 0) THEN
729: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id
730: from IEM_OUTBOUND_MSG_STATS where MEDIA_ID = l_outbound_media_ID;
731: ELSE
732: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id
733: from IEM_OUTBOUND_MSG_STATS where INBOUND_MEDIA_ID = l_inbound_media_ID;
734: END IF;

Line 733: from IEM_OUTBOUND_MSG_STATS where INBOUND_MEDIA_ID = l_inbound_media_ID;

729: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id
730: from IEM_OUTBOUND_MSG_STATS where MEDIA_ID = l_outbound_media_ID;
731: ELSE
732: select OUTBOUND_MSG_STATS_ID into l_outbound_msg_stats_id
733: from IEM_OUTBOUND_MSG_STATS where INBOUND_MEDIA_ID = l_inbound_media_ID;
734: END IF;
735:
736: select iem_doc_usage_stats_s1.nextval into l_sequence from dual;
737: l_no := 'N';

Line 803: UPDATE IEM_OUTBOUND_MSG_STATS SET

799: IF (p_kb_doc_ID > 0) THEN
800: l_uses_kb_docs_y_n := 'Y';
801: END IF;
802:
803: UPDATE IEM_OUTBOUND_MSG_STATS SET
804: USES_SUGGESTIONS_Y_N = p_suggested_y_n,
805: USES_KB_DOCS_Y_N = l_uses_kb_docs_y_n,
806: LAST_UPDATED_BY = l_last_updated_by,
807: LAST_UPDATE_DATE = SYSDATE,