/****** Object:  Stored Procedure dbo.JMO_TRT_Del    Script Date: 12/1/2005 11:49:35 PM ******/


CREATE proc JMO_TRT_Del (
   @k_trt_trev      char(8),
   @k_trt_trid      char(64),
   @k_trt_qual      char(5)
)
as
begin
   Delete From jmo_trt
   Where
       trt_trev         = @k_trt_trev      and
       trt_trid         = @k_trt_trid      and
       trt_qual         = @k_trt_qual

   Delete From jmo_psrt
   Where
       psr_scdn         = @k_trt_trev      and
       psr_name         = @k_trt_trid      and
       psr_qual         = @k_trt_qual
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRT_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Del] TO [uniadmin]
GO