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


CREATE proc JMO_STR_Ins (
   @str_name         char(65),
   @str_qual         char(5),
   @str_avgtb        int,
   @str_ows          varchar(21),
   @str_ws           varchar(21),
   @str_wstyp        char(1),
   @str_any          binary(1),
   @str_erly         int,
   @str_must         int,
   @str_dedln        int,
   @str_mxtim        int,
   @str_avgt         int,
   @str_jcont        int,
   @str_flg1         binary(1),
   @str_flg3         binary(1),
   @str_bklog        binary(1),
   @str_histc        smallint,
   @str_desc         varchar(255),
   @str_newpr        char(2),
   @str_fordate      int,
   @str_erdt         int,
   @str_mudt         int,
   @str_dedt         int,
   @str_mxdt         int,
   @str_adate        int,
   @str_vdate        int,
   @str_sdate        int,
   @str_edate        int,
   @str_pdate        int,
   @str_atime        int,
   @str_vtime        int,
   @str_stime        int,
   @str_etime        int,
   @str_dprty        int,
   @str_cc           varchar(9),
   @str_hstat        binary(1),
   @str_rstat        binary(1),
   @str_flg5         binary(1),
   @str_cmrun        varchar(33),
   @str_cmhld        varchar(33),
   @str_cmrls        varchar(33),
   @str_cmcnc        varchar(33),
   @str_cmfrc        varchar(33),
   @str_cal          varchar(9),
   @str_faill        int,
   @str_failh        int,
   @str_subu         varchar(33),
   @str_subp         varchar(15),
   @str_domain       varchar(16),
   @str_flg4         binary(1),
   @str_sutyp        binary(1),
   @str_qname        char(1)
)
as
begin
   Insert into jmo_str (
      str_name,
      str_qual,
      str_avgtb,
      str_ows,
      str_ws,
      str_wstyp,
      str_any,
      str_erly,
      str_must,
      str_dedln,
      str_mxtim,
      str_avgt,
      str_jcont,
      str_flg1,
      str_flg3,
      str_bklog,
      str_histc,
      str_desc,
      str_newpr,
      str_fordate,
      str_erdt,
      str_mudt,
      str_dedt,
      str_mxdt,
      str_adate,
      str_vdate,
      str_sdate,
      str_edate,
      str_pdate,
      str_atime,
      str_vtime,
      str_stime,
      str_etime,
      str_dprty,
      str_cc,
      str_hstat,
      str_rstat,
      str_flg5,
      str_cmrun,
      str_cmhld,
      str_cmrls,
      str_cmcnc,
      str_cmfrc,
      str_cal,
      str_faill,
      str_failh,
      str_subu,
      str_subp,
      str_domain,
      str_flg4,
      str_sutyp,
      str_qname
)
   Values (
      @str_name,
      @str_qual,
      @str_avgtb,
      @str_ows,
      @str_ws,
      @str_wstyp,
      @str_any,
      @str_erly,
      @str_must,
      @str_dedln,
      @str_mxtim,
      @str_avgt,
      @str_jcont,
      @str_flg1,
      @str_flg3,
      @str_bklog,
      @str_histc,
      @str_desc,
      @str_newpr,
      @str_fordate,
      @str_erdt,
      @str_mudt,
      @str_dedt,
      @str_mxdt,
      @str_adate,
      @str_vdate,
      @str_sdate,
      @str_edate,
      @str_pdate,
      @str_atime,
      @str_vtime,
      @str_stime,
      @str_etime,
      @str_dprty,
      @str_cc,
      @str_hstat,
      @str_rstat,
      @str_flg5,
      @str_cmrun,
      @str_cmhld,
      @str_cmrls,
      @str_cmcnc,
      @str_cmfrc,
      @str_cal,
      @str_faill,
      @str_failh,
      @str_subu,
      @str_subp,
      @str_domain,
      @str_flg4,
      @str_sutyp,
      @str_qname
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_STR_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_STR_Ins] TO [uniadmin]
GO