CREATE proc JMO_SBR_Ins (
@sbr_name char(65),
@sbr_effdt int,
@sbr_expdt int,
@sbr_sprty char(2),
@sbr_stype char(1),
@sbr_any binary(1),
@sbr_ws varchar(21),
@sbr_cal varchar(9),
@sbr_erly int,
@sbr_must int,
@sbr_dedln int,
@sbr_mxtim int,
@sbr_avg int,
@sbr_flg1 binary(1),
@sbr_bklog binary(1),
@sbr_recs1 char(1),
@sbr_histc smallint,
@sbr_creus varchar(33),
@sbr_credt int,
@sbr_cretm int,
@sbr_lusdt int,
@sbr_lustm int,
@sbr_skip int,
@sbr_user varchar(33),
@sbr_desc varchar(255),
@sbr_faill int,
@sbr_failh int,
@sbr_subu varchar(33),
@sbr_subp varchar(15),
@sbr_domain varchar(16),
@sbr_ccal varchar(9),
@sbr_cri varchar(255),
@sbr_hact char(2),
@sbr_nwact char(2),
@sbr_cadj varchar(5),
@sbr_sutyp binary(1),
@sbr_qname char(1)
)
as
begin
Insert into jmo_sbr (
sbr_name,
sbr_effdt,
sbr_expdt,
sbr_sprty,
sbr_stype,
sbr_any,
sbr_ws,
sbr_cal,
sbr_erly,
sbr_must,
sbr_dedln,
sbr_mxtim,
sbr_avg,
sbr_flg1,
sbr_bklog,
sbr_recs1,
sbr_histc,
sbr_creus,
sbr_credt,
sbr_cretm,
sbr_lusdt,
sbr_lustm,
sbr_skip,
sbr_user,
sbr_desc,
sbr_faill,
sbr_failh,
sbr_subu,
sbr_subp,
sbr_domain,
sbr_ccal,
sbr_cri,
sbr_hact,
sbr_nwact,
sbr_cadj,
sbr_sutyp,
sbr_qname
)
Values (
@sbr_name,
@sbr_effdt,
@sbr_expdt,
@sbr_sprty,
@sbr_stype,
@sbr_any,
@sbr_ws,
@sbr_cal,
@sbr_erly,
@sbr_must,
@sbr_dedln,
@sbr_mxtim,
@sbr_avg,
@sbr_flg1,
@sbr_bklog,
@sbr_recs1,
@sbr_histc,
@sbr_creus,
@sbr_credt,
@sbr_cretm,
@sbr_lusdt,
@sbr_lustm,
@sbr_skip,
@sbr_user,
@sbr_desc,
@sbr_faill,
@sbr_failh,
@sbr_subu,
@sbr_subp,
@sbr_domain,
@sbr_ccal,
@sbr_cri,
@sbr_hact,
@sbr_nwact,
@sbr_cadj,
@sbr_sutyp,
@sbr_qname
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_SBR_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_SBR_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_SBR_Ins] TO [uniadmin]
GO
[dbo].[JMO_SBR_Ins]