APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_BASE_HEADERS

Line 1421: l_header_rec iem_ms_base_headers%rowtype;

1417: x_return_status OUT NOCOPY VARCHAR2,
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;

Line 1478: select * into l_header_rec from iem_ms_base_headers

1474: l_media_rec);
1475: EXCEPTION WHEN OTHERS THEN
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

Line 1540: delete from iem_ms_base_headers where message_id=p_message_id;

1536: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
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: