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


CREATE proc JMO_TRT_Ins (
   @trt_trev char    (  9 ) ,
   @trt_trid char    ( 65 ) ,
   @trt_qual char    (  5 ) ,
   @trt_apc7 varchar (  9 ) ,
   @trt_desc varchar (255 ) ,
   @trt_jnam varchar ( 65 ) ,
   @trt_usid varchar ( 33 ) ,
   @trt_stan varchar ( 21 ) ,
   @trt_faill int ,
   @trt_failh int ,
   @trt_file varchar (255 ) ,
   @trt_ustat char ( 2 ) ,
   @trt_jobn varchar  ( 5 ) ,
   @trt_scdn varchar ( 65 ) ,
   @trt_bklog char ( 2 ) ,                     
   @trt_cal varchar   ( 9 ) ,                     
   @trt_fdate int  ,                            
   @trt_tstat char ( 2 )                  
)
as
begin
   Insert into jmo_trt (
       trt_trev,
       trt_trid,
       trt_qual,
       trt_apc7,
       trt_desc,
       trt_jnam,
       trt_usid,
       trt_stan,
       trt_faill,
       trt_failh,
       trt_file,
       trt_ustat,
       trt_jobn,
       trt_scdn,
       trt_bklog,                     
       trt_cal,                     
       trt_fdate,                            
       trt_tstat                  
)
   Values (
      @trt_trev,
      @trt_trid,
      @trt_qual,
      @trt_apc7,
      @trt_desc,
      @trt_jnam,
      @trt_usid,
      @trt_stan,
      @trt_faill,
      @trt_failh,
      @trt_file,
      @trt_ustat,
      @trt_jobn,
      @trt_scdn,
      @trt_bklog,                     
      @trt_cal,                     
      @trt_fdate,                            
      @trt_tstat
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRT_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Ins] TO [uniadmin]
GO