begin
if updating(SRM_THEFT_CASE_STATUS)then
update m_servicemaster@collection
set srm_theft_tag@collection =:new.SRM_THEFT_CASE_STATUS,
srm_theft_amt@collection =:new.srm_theft_amt,srm_modify_date=sysdate
where :new.srm_service_no=srm_service_no@collection;
end if;
end;