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

CREATE proc JMO_GEN_Upd (
   @scp_key          char(8),
   @scj_prty         char(2),
   @scg_en1          binary(1),
   @scg_en2          binary(1),
   @scg_en6          char(1),
   @sca_utotm        int,
   @sca_utoit        smallint,
   @scw_s            varchar(20),
   @scd_tab          varchar(8),
   @sch_istc         smallint,
   @scm_xaudt        smallint,
   @scq_name         varchar(32),
   @scm_axpsr        smallint,
   @scm_axinp        smallint,
   @scm_axres        smallint,
   @k_scp_key        char(8)
)
as
begin
   Update jmo_gen
   Set
      scp_key          = @scp_key,
      scj_prty         = @scj_prty,
      scg_en1          = @scg_en1,
      scg_en2          = @scg_en2,
      scg_en6          = @scg_en6,
      sca_utotm        = @sca_utotm,
      sca_utoit        = @sca_utoit,
      scw_s            = @scw_s,
      scd_tab          = @scd_tab,
      sch_istc         = @sch_istc,
      scm_xaudt        = @scm_xaudt,
      scq_name         = @scq_name,
      scm_axpsr        = @scm_axpsr,
      scm_axinp        = @scm_axinp,
      scm_axres        = @scm_axres
   From  jmo_gen WITH (index=1)
   Where
      scp_key          = @k_scp_key
end
GO
GRANT EXECUTE ON  [dbo].[JMO_GEN_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_GEN_Upd] TO [uniadmin]
GO