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


CREATE proc JMO_JBR_DelY (
   @k_jbr_scdn      char(65),
   @k_jbr_name      char(65),
   @k_jbr_jno       char(5)
   
)
as
begin
   Delete From jmo_jbr
   Where
       jbr_name         = @k_jbr_name      and
       jbr_jno          = @k_jbr_jno       and
       jbr_scdn         = @k_jbr_scdn

   Delete From jmo_jwb
   Where
       jwb_name         = @k_jbr_name      and
       jwb_jno          = @k_jbr_jno       and
       jwb_scdn         = @k_jbr_scdn

   Delete From jmo_prb
   Where
       prb_name         = @k_jbr_name      and
       prb_jno          = @k_jbr_jno       and
       prb_scdn         = @k_jbr_scdn

/* drop PSRM where base key is equal to jbr   */

   Delete From jmo_psrm
   Where
       psr_name         = @k_jbr_name      and
       psr_jno          = @k_jbr_jno       and
       psr_scdn         = @k_jbr_scdn


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