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


CREATE proc JMO_TRT_Upd (
   @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 ),                  
   @k_trt_trev       char(9),
   @k_trt_trid       char(65),
   @k_trt_qual       char(5)
)
as
begin
   Update jmo_trt
   Set
      trt_trev  = @trt_trev,
      trt_trid  = @trt_trid,
      trt_qual  = @trt_qual,
      trt_apc7  = @trt_apc7,
      trt_desc  = @trt_desc,
      trt_jnam  = @trt_jnam,
      trt_usid  = @trt_usid,
      trt_stan  = @trt_stan,
      trt_faill = @trt_faill,
      trt_failh = @trt_failh,
      trt_file  = @trt_file,
      trt_ustat = @trt_ustat,
      trt_jobn  = @trt_jobn,
      trt_scdn  = @trt_scdn,
      trt_bklog = @trt_bklog,                     
      trt_cal   = @trt_cal,                     
      trt_fdate = @trt_fdate,                            
      trt_tstat = @trt_tstat                  
   From  jmo_trt WITH (index=1)
   Where
      trt_trev         = @k_trt_trev      and
      trt_trid         = @k_trt_trid      and
      trt_qual         = @k_trt_qual
end
GO
GRANT EXECUTE ON  [dbo].[JMO_TRT_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_TRT_Upd] TO [uniadmin]
GO