APPS.IEM_MIGRATION_PVT dependencies on IEM_ARCH_MSGDTLS

Line 329: insert into iem_arch_msgdtls

325: END;
326: END IF;
327: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
328:
329: insert into iem_arch_msgdtls
330: (MESSAGE_ID ,
331: EMAIL_ACCOUNT_ID ,
332: MAILPROC_STATUS ,
333: MAIL_TYPE,

Line 426: delete from iem_arch_msgdtls where message_id=l_message_id;

422: --so every block will fall under this rather than duplicating the code
423: IF l_mig_status = 'E' THEN
424: BEGIN
425: delete from iem_arch_msgs where message_id=l_message_id;
426: delete from iem_arch_msgdtls where message_id=l_message_id;
427: EXCEPTION WHEN OTHERS THEN
428: l_error_text:=l_error_text ||'-Other exception during delete sqlerrm:'||sqlerrm;
429: END;
430: