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


CREATE proc JMO_STR1_Del (
   @k_str_name      char(65),
   @k_str_qual      char(5)
)
as
begin
   Delete From jmo_str1
   Where
       str_name         = @k_str_name      and
       str_qual         = @k_str_qual

   Delete From jmo_jtr1
   Where
       jtr_scdn         = @k_str_name      and
       jtr_qual         = @k_str_qual

   Delete From jmo_prt1
   Where
       prt_scdn         = @k_str_name      and
       prt_qual         = @k_str_qual

   Delete From jmo_psr1
   Where
       psr_scdn         = @k_str_name      and
       psr_qual         = @k_str_qual

   Delete From jmo_psr1
   Where
       psr_pscd         = @k_str_name      and
       psr_pqua         = @k_str_qual

end
GO
GRANT EXECUTE ON  [dbo].[JMO_STR1_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR1_Del] TO [uniadmin]
GO