APPS.IEM_MAILITEM_PUB dependencies on IEM_KB_RESULTS

Line 822: delete from iem_kb_results where message_id=p_message_id;

818: DELETE FROM iem_rt_proc_emails
819: WHERE MESSAGE_ID=p_message_id;
820: delete from iem_reroute_hists
821: where message_id=p_message_id;
822: delete from iem_kb_results where message_id=p_message_id;
823: delete from iem_email_classifications where message_id=p_message_id;
824: delete from iem_comp_rt_stats where type='WORKFLOW' and param=to_char(p_message_id);
825:
826: /*

Line 1725: delete from iem_kb_results where message_id=p_message_id;

1721: END IF;
1722: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
1723: delete from iem_rt_proc_emails where message_id=p_message_id;
1724: delete from iem_email_classifications where message_id=p_message_id;
1725: delete from iem_kb_results where message_id=p_message_id;
1726: delete from iem_ms_base_headers where message_id=p_message_id;
1727: delete from iem_ms_msgbodys where message_id=p_message_id;
1728: delete from iem_ms_msgparts where message_id=p_message_id;
1729: delete from iem_ms_exthdrs where message_id=p_message_id;