APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_MSGBODYS

Line 1608: l_msg_text iem_ms_msgbodys.value%type;

1604: x_msg_count OUT NOCOPY NUMBER,
1605: x_msg_data OUT NOCOPY VARCHAR2) IS
1606: l_msg_rec iem_rt_proc_emails%rowtype;
1607: l_header_rec iem_ms_base_headers%rowtype;
1608: l_msg_text iem_ms_msgbodys.value%type;
1609: l_ret_status varchar2(10);
1610: l_msg_data varchar2(1000);
1611: l_msg_count number;
1612: l_out_message_id number;

Line 1666: select value into l_msg_text from iem_ms_msgbodys

1662: raise ERROR_CLOSING_MEDIA;
1663: END ;
1664: select * into l_header_rec from iem_ms_base_headers
1665: where message_id=p_message_id;
1666: select value into l_msg_text from iem_ms_msgbodys
1667: where message_id=p_message_id and rownum=1;
1668: for v1 in c1 loop
1669: l_top_intent:=v1.classification;
1670: exit;

Line 1727: delete from iem_ms_msgbodys where message_id=p_message_id;

1723: delete from iem_rt_proc_emails 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