APPS.IEM_MIGRATION_PVT dependencies on IEM_ARCH_MSGDTLS

Line 259: insert into iem_arch_msgdtls

255: where media_id=l_media_id;
256: l_received_date:=sysdate;
257: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
258:
259: insert into iem_arch_msgdtls
260: (MESSAGE_ID ,
261: EMAIL_ACCOUNT_ID ,
262: MAILPROC_STATUS ,
263: MAIL_TYPE,

Line 335: delete from iem_arch_msgdtls where message_id=l_message_id;

331: l_mig_status:='E';
332: l_error_text:=sqlerrm;
333:
334: delete from iem_arch_msgs where message_id=l_message_id;
335: delete from iem_arch_msgdtls where message_id=l_message_id;
336:
337: update iem_migration_store_temp
338: set mig_Status='E',
339: error_text=l_error_text