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


CREATE proc JMO_PRT1_Upd (
   @prt_scdn         char(65),
   @prt_name         char(65),
   @prt_jno          char(5),
   @prt_qual         char(5),
   @prt_seq          char(5),
   @prt_parm1        varchar(255),
   @prt_parm2        varchar(255),
   @prt_parm3        varchar(255),
   @prt_parm4        varchar(255),
   @k_prt_scdn       char(65),
   @k_prt_name       char(65),
   @k_prt_jno        char(5),
   @k_prt_qual       char(5),
   @k_prt_seq        char(5)
)
as
begin
   Update jmo_prt1
   Set
      prt_scdn         = @prt_scdn,
      prt_name         = @prt_name,
      prt_jno          = @prt_jno,
      prt_qual         = @prt_qual,
      prt_seq          = @prt_seq,
      prt_parm1        = @prt_parm1,
      prt_parm2        = @prt_parm2,
      prt_parm3        = @prt_parm3,
      prt_parm4        = @prt_parm4
   From  jmo_prt1 WITH (index=1)
   Where
      prt_scdn         = @k_prt_scdn      and
      prt_name         = @k_prt_name      and
      prt_jno          = @k_prt_jno       and
      prt_qual         = @k_prt_qual      and
      prt_seq          = @k_prt_seq
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Upd] TO [uniadmin]
GO