APPS.IEM_MSG_STAT_PUB dependencies on IEM_DOC_USAGE_STATS

Line 213: select count(DOC_USAGE_STATS_ID) into l_outbound_stats_count from IEM_DOC_USAGE_STATS where

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;
215: EXCEPTION
216: WHEN OTHERS THEN
217: NULL;

Line 258: UPDATE IEM_DOC_USAGE_STATS SET

254: END IF;
255:
256:
257: l_no := 'Y';
258: UPDATE IEM_DOC_USAGE_STATS SET
259: DATE_SENT = SYSDATE,
260: SAVED_Y_N = l_no,
261: LAST_UPDATED_BY = l_last_updated_by,
262: LAST_UPDATE_DATE = SYSDATE,

Line 364: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id;

360: WHEN OTHERS THEN
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.

Line 480: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id

476: WHEN OTHERS THEN
477: NULL;
478: END;
479:
480: DELETE FROM IEM_DOC_USAGE_STATS WHERE OUTBOUND_MSG_STATS_ID = l_outbound_msg_stats_id
481: AND SAVED_Y_N <> l_yes;
482:
483: -------------------End Code------------------------
484: -- Standard Check Of p_commit.

Line 582: UPDATE IEM_DOC_USAGE_STATS SET

578: WHEN OTHERS THEN
579: NULL;
580: END;
581:
582: UPDATE IEM_DOC_USAGE_STATS SET
583: SAVED_Y_N = 'Y',
584: DATE_SENT = SYSDATE,
585: LAST_UPDATED_BY = l_last_updated_by,
586: LAST_UPDATE_DATE = SYSDATE,

Line 736: select iem_doc_usage_stats_s1.nextval into l_sequence from dual;

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';
738: insert into IEM_DOC_USAGE_STATS
739: (
740: DOC_USAGE_STATS_ID,

Line 738: insert into IEM_DOC_USAGE_STATS

734: END IF;
735:
736: select iem_doc_usage_stats_s1.nextval into l_sequence from dual;
737: l_no := 'N';
738: insert into IEM_DOC_USAGE_STATS
739: (
740: DOC_USAGE_STATS_ID,
741: OUTBOUND_MSG_STATS_ID,
742: REPLY_Y_N,