APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_MSGPARTS

Line 1728: delete from iem_ms_msgparts 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;
1730:
1731: -- Insert the MIME Message into Archived Message Stores
1732: insert into iem_arch_msgs(message_id,message_content,created_by,creation_date,last_updated_by,last_update_date,last_update_login)