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


CREATE proc JMO_PRB_Upd (
   @prb_scdn         char(65),
   @prb_name         char(65),
   @prb_jno          char(5),
   @prb_seq          char(5),
   @prb_parm1        varchar(255),
   @prb_parm2        varchar(255),
   @prb_parm3        varchar(255),
   @prb_parm4        varchar(255),
   @k_prb_scdn       char(65),
   @k_prb_name       char(65),
   @k_prb_jno        char(5),
   @k_prb_seq        char(5)
)
as
begin
   Update jmo_prb
   Set
      prb_scdn         = @prb_scdn,
      prb_name         = @prb_name,
      prb_jno          = @prb_jno,
      prb_seq          = @prb_seq,
      prb_parm1        = @prb_parm1,
      prb_parm2        = @prb_parm2,
      prb_parm3        = @prb_parm3,
      prb_parm4        = @prb_parm4
   From  jmo_prb WITH (index=1)
   Where
      prb_scdn         = @k_prb_scdn      and
      prb_name         = @k_prb_name      and
      prb_jno          = @k_prb_jno       and
      prb_seq          = @k_prb_seq
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PRB_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRB_Upd] TO [uniadmin]
GO