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

CREATE proc JMO_JBR_Ins (
   @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(8),
   @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)

)
as
begin
   Insert into jmo_jbr (
      jbr_scdn,
      jbr_name,
      jbr_jno,
      jbr_ws,
      jbr_jobtyp,
      jbr_any,
      jbr_subu,
      jbr_abscd,
      jbr_jprty,
      jbr_abct,
      jbr_cal,
      jbr_erly,
      jbr_must,
      jbr_dedln,
      jbr_mxtim,
      jbr_avg,
      jbr_effdt,
      jbr_expdt,
      jbr_histc,
      jbr_flg1,
      jbr_bklog,
      jbr_recs1,
      jbr_desc,
      jbr_subfile,
      jbr_creus,
      jbr_credt,
      jbr_cretm,
      jbr_lusdt,
      jbr_lustm,
      jbr_user,
      jbr_skip,
      jbr_faill,
      jbr_failh,
      jbr_subp,
      jbr_domain,
      jbr_cycle,
      jbr_freq,
      jbr_count,
      jbr_ccal,
      jbr_cri,
      jbr_hact,
      jbr_nwact,
      jbr_cadj,
      jbr_sutyp,
      jbr_qname
)
   Values (
      @jbr_scdn,
      @jbr_name,
      @jbr_jno,
      @jbr_ws,
      @jbr_jobtyp,
      @jbr_any,
      @jbr_subu,
      @jbr_abscd,
      @jbr_jprty,
      @jbr_abct,
      @jbr_cal,
      @jbr_erly,
      @jbr_must,
      @jbr_dedln,
      @jbr_mxtim,
      @jbr_avg,
      @jbr_effdt,
      @jbr_expdt,
      @jbr_histc,
      @jbr_flg1,
      @jbr_bklog,
      @jbr_recs1,
      @jbr_desc,
      @jbr_subfile,
      @jbr_creus,
      @jbr_credt,
      @jbr_cretm,
      @jbr_lusdt,
      @jbr_lustm,
      @jbr_user,
      @jbr_skip,
      @jbr_faill,
      @jbr_failh,
      @jbr_subp,
      @jbr_domain,
      @jbr_cycle,
      @jbr_freq,
      @jbr_count,
      @jbr_ccal,
      @jbr_cri,   
      @jbr_hact,
      @jbr_nwact,
      @jbr_cadj,
      @jbr_sutyp,
      @jbr_qname
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JBR_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JBR_Ins] TO [uniadmin]
GO