APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_MSGPARTS

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