APPS.IEM_ARCH_PVT dependencies on IEM_ARCH_MSGS

Line 505: delete from iem_arch_msgs where message_id=v1.source_message_id;

501: x_out_text:='Error While Creating MLCS';
502: else
503: delete from iem_archived_dtls where request_id=p_request_id
504: and source_message_id=v1.source_message_id;
505: delete from iem_arch_msgs where message_id=v1.source_message_id;
506: delete from iem_arch_msgdtls where message_id=v1.source_message_id;
507: end if;
508: -- Update the MLCS with ENDDATE TIME
509: l_media_lc_rec.milcs_id:=l_milcs_id;