APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_MIMEMSGS

Line 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);

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
1737: WHEN NO_DATA_FOUND THEN
1738: ROLLBACK TO resolve_data_pvt;

Line 1735: delete from iem_ms_mimemsgs where message_id=p_message_id;

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
1737: WHEN NO_DATA_FOUND THEN
1738: ROLLBACK TO resolve_data_pvt;
1739: x_return_status := 'N';