APPS.IEM_MAILITEM_PUB dependencies on IEM_MS_BASE_HEADERS

Line 1607: l_header_rec iem_ms_base_headers%rowtype;

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

Line 1664: select * into l_header_rec from iem_ms_base_headers

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

Line 1726: delete from iem_ms_base_headers where message_id=p_message_id;

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