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


CREATE proc JMO_JWB_Upd (
   @jwb_scdn         char(65),
   @jwb_name         char(65),
   @jwb_jno          char(5),
   @jwb_resn         char(17),
   @jwb_srt          int,
   @jwb_srv          smallint,
   @jwb_flag         binary(1),
   @jwb_desc         varchar(255),
   @k_jwb_scdn       char(65),
   @k_jwb_name       char(65),
   @k_jwb_jno        char(5),
   @k_jwb_resn       char(17)
)
as
begin
   Update jmo_jwb
   Set
      jwb_scdn         = @jwb_scdn,
      jwb_name         = @jwb_name,
      jwb_jno          = @jwb_jno,
      jwb_resn         = @jwb_resn,
      jwb_srt          = @jwb_srt,
      jwb_srv          = @jwb_srv,
      jwb_flag         = @jwb_flag,
      jwb_desc         = @jwb_desc
   From  jmo_jwb WITH (index=1)
   Where
      jwb_scdn         = @k_jwb_scdn      and
      jwb_name         = @k_jwb_name      and
      jwb_jno          = @k_jwb_jno       and
      jwb_resn         = @k_jwb_resn
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JWB_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JWB_Upd] TO [uniadmin]
GO