APPS.IEM_MAILITEM_PUB dependencies on IEM_ARCH_MSGS

Line 1732: insert into iem_arch_msgs(message_id,message_content,created_by,creation_date,last_updated_by,last_update_date,last_update_login)

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)
1733: (
1734: select message_id,mime_msg,created_by,creation_date,last_updated_by,last_update_date,last_update_login from iem_ms_mimemsgs where message_id=p_message_id and draft_flag=0);
1735: delete from iem_ms_mimemsgs where message_id=p_message_id;
1736: EXCEPTION