APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_MSGBODYS

Line 1422: l_msg_text iem_ms_msgbodys.value%type;

1418: x_msg_count OUT NOCOPY NUMBER,
1419: x_msg_data OUT NOCOPY VARCHAR2) IS
1420: l_msg_rec iem_rt_proc_emails%rowtype;
1421: l_header_rec iem_ms_base_headers%rowtype;
1422: l_msg_text iem_ms_msgbodys.value%type;
1423: l_ret_status varchar2(10);
1424: l_msg_data varchar2(1000);
1425: l_msg_count number;
1426: l_out_message_id number;

Line 1480: select value into l_msg_text from iem_ms_msgbodys

1476: raise ERROR_CLOSING_MEDIA;
1477: END ;
1478: select * into l_header_rec from iem_ms_base_headers
1479: where message_id=p_message_id;
1480: select value into l_msg_text from iem_ms_msgbodys
1481: where message_id=p_message_id and rownum=1;
1482: for v1 in c1 loop
1483: l_top_intent:=v1.classification;
1484: exit;

Line 1541: delete from iem_ms_msgbodys where message_id=p_message_id;

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