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 1539: delete from iem_kb_results where message_id=p_message_id;

1535: END IF;
1536: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
1537: delete from iem_rt_proc_emails where message_id=p_message_id;
1538: delete from iem_email_classifications where message_id=p_message_id;
1539: delete from iem_kb_results where message_id=p_message_id;
1540: delete from iem_ms_base_headers where message_id=p_message_id;
1541: delete from iem_ms_msgbodys where message_id=p_message_id;
1542: delete from iem_ms_msgparts where message_id=p_message_id;
1543: delete from iem_ms_exthdrs where message_id=p_message_id;