APPS.IEM_MAILITEM_PUB dependencies on IEM_ARCH_MSGS

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

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)
1547: (
1548: 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);
1549: delete from iem_ms_mimemsgs where message_id=p_message_id;
1550: EXCEPTION