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


CREATE proc JMO_JBR_Upd (
   @jbr_scdn         char(65),
   @jbr_name         char(65),
   @jbr_jno          char(5),
   @jbr_ws           varchar(21),
   @jbr_jobtyp       char(1),
   @jbr_any          binary(1),
   @jbr_subu         varchar(33),
   @jbr_abscd        varchar(65),
   @jbr_jprty        char(2),
   @jbr_abct         int,
   @jbr_cal          varchar(9),
   @jbr_erly         int,
   @jbr_must         int,
   @jbr_dedln        int,
   @jbr_mxtim        int,
   @jbr_avg          int,
   @jbr_effdt        int,
   @jbr_expdt        int,
   @jbr_histc        smallint,
   @jbr_flg1         binary(1),
   @jbr_bklog        binary(1),
   @jbr_recs1        char(1),
   @jbr_desc         varchar(255),
   @jbr_subfile        varchar(255),
   @jbr_creus        varchar(33),
   @jbr_credt        int,
   @jbr_cretm        int,
   @jbr_lusdt        int,
   @jbr_lustm        int,
   @jbr_user         varchar(33),
   @jbr_skip         int,
   @jbr_faill        int,
   @jbr_failh        int,
   @jbr_subp         varchar(15),
   @jbr_domain       varchar(16),
   @jbr_cycle        char(1),
   @jbr_freq         int,
   @jbr_count        int,
   @jbr_ccal         varchar(9),
   @jbr_cri          varchar(255),   
   @jbr_hact         char(2),
   @jbr_nwact        char(2),
   @jbr_cadj         varchar(5),
   @jbr_sutyp        binary(1),
   @jbr_qname        char(1),
   @k_jbr_scdn       char(65),
   @k_jbr_name       char(65),
   @k_jbr_jno        char(5)
)
as
begin
   Update jmo_jbr
   Set
      jbr_scdn         = @jbr_scdn,
      jbr_name         = @jbr_name,
      jbr_jno          = @jbr_jno,
      jbr_ws           = @jbr_ws,
      jbr_jobtyp       = @jbr_jobtyp,
      jbr_any          = @jbr_any,
      jbr_subu         = @jbr_subu,
      jbr_abscd        = @jbr_abscd,
      jbr_jprty        = @jbr_jprty,
      jbr_abct         = @jbr_abct,
      jbr_cal          = @jbr_cal,
      jbr_erly         = @jbr_erly,
      jbr_must         = @jbr_must,
      jbr_dedln        = @jbr_dedln,
      jbr_mxtim        = @jbr_mxtim,
      jbr_avg          = @jbr_avg,
      jbr_effdt        = @jbr_effdt,
      jbr_expdt        = @jbr_expdt,
      jbr_histc        = @jbr_histc,
      jbr_flg1         = @jbr_flg1,
      jbr_bklog        = @jbr_bklog,
      jbr_recs1        = @jbr_recs1,
      jbr_desc         = @jbr_desc,
      jbr_subfile        = @jbr_subfile,
      jbr_creus        = @jbr_creus,
      jbr_credt        = @jbr_credt,
      jbr_cretm        = @jbr_cretm,
      jbr_lusdt        = @jbr_lusdt,
      jbr_lustm        = @jbr_lustm,
      jbr_user         = @jbr_user,
      jbr_skip         = @jbr_skip,
      jbr_faill        = @jbr_faill,
      jbr_failh        = @jbr_failh,
      jbr_subp         = @jbr_subp,
      jbr_domain       = @jbr_domain,
      jbr_cycle        = @jbr_cycle,
      jbr_freq         = @jbr_freq,
      jbr_count        = @jbr_count,
      jbr_ccal         = @jbr_ccal,
      jbr_cri          = @jbr_cri,
      jbr_hact         = @jbr_hact,
      jbr_nwact        = @jbr_nwact,
      jbr_cadj         = @jbr_cadj,
      jbr_sutyp        = @jbr_sutyp,
      jbr_qname        = @jbr_qname
   From  jmo_jbr WITH (index=1)
   Where
      jbr_scdn         = @k_jbr_scdn      and
      jbr_name         = @k_jbr_name      and
      jbr_jno          = @k_jbr_jno       
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JBR_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Upd] TO [uniadmin]
GO