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


CREATE proc JMO_JHR_Upd (
   @jhr_jschd        char(65),
   @jhr_name         char(65),
   @jhr_jno          char(5),
   @jhr_key          char(12),
   @jhr_ws           varchar(21),
   @jhr_avcpu        int,
   @jhr_hcnt         smallint,
   @jhr_erdt         int,
   @jhr_msdt         int,
   @jhr_deddt        int,
   @jhr_adate        int,
   @jhr_vdate        int,
   @jhr_sdate        int,
   @jhr_edate        int,
   @jhr_ertm         int,
   @jhr_mstm         int,
   @jhr_dedtm        int,
   @jhr_atime        int,
   @jhr_vtime        int,
   @jhr_stime        int,
   @jhr_etime        int,
   @jhr_relpt        int,
   @jhr_rcput        int,
   @jhr_code         int,
   @jhr_qual         char(4),
   @jhr_stat         binary(1),
   @jhr_late         char(1),
   @jhr_cmrun        varchar(33),
   @jhr_cmhld        varchar(33),
   @jhr_cmrls        varchar(33),
   @jhr_cmcnc        varchar(33),
   @jhr_cmfrc        varchar(33),
   @jhr_cmstr        varchar(33),
   @jhr_cmcmp        varchar(33),
   @jhr_pid          int,
   @jhr_uxjno        int,
   @jhr_sysid        varchar(16),
   @jhr_avelp        int,
   @jhr_qname        char(1),
   @k_jhr_jschd      varchar(65),
   @k_jhr_name       char(65),
   @k_jhr_jno        char(5),
   @k_jhr_key        char(12)
)
as
begin
   Update jmo_jhr
   Set
      jhr_jschd        = @jhr_jschd,
      jhr_name         = @jhr_name,
      jhr_jno          = @jhr_jno,
      jhr_key          = @jhr_key,
      jhr_ws           = @jhr_ws,
      jhr_avcpu        = @jhr_avcpu,
      jhr_hcnt         = @jhr_hcnt,
      jhr_erdt         = @jhr_erdt,
      jhr_msdt         = @jhr_msdt,
      jhr_deddt        = @jhr_deddt,
      jhr_adate        = @jhr_adate,
      jhr_vdate        = @jhr_vdate,
      jhr_sdate        = @jhr_sdate,
      jhr_edate        = @jhr_edate,
      jhr_ertm         = @jhr_ertm,
      jhr_mstm         = @jhr_mstm,
      jhr_dedtm        = @jhr_dedtm,
      jhr_atime        = @jhr_atime,
      jhr_vtime        = @jhr_vtime,
      jhr_stime        = @jhr_stime,
      jhr_etime        = @jhr_etime,
      jhr_relpt        = @jhr_relpt,
      jhr_rcput        = @jhr_rcput,
      jhr_code         = @jhr_code,
      jhr_qual         = @jhr_qual,
      jhr_stat         = @jhr_stat,
      jhr_late         = @jhr_late,
      jhr_cmrun        = @jhr_cmrun,
      jhr_cmhld        = @jhr_cmhld,
      jhr_cmrls        = @jhr_cmrls,
      jhr_cmcnc        = @jhr_cmcnc,
      jhr_cmfrc        = @jhr_cmfrc,
      jhr_cmstr        = @jhr_cmstr,
      jhr_cmcmp        = @jhr_cmcmp,
      jhr_pid          = @jhr_pid,
      jhr_uxjno        = @jhr_uxjno,
      jhr_sysid        = @jhr_sysid,
      jhr_avelp        = @jhr_avelp,
      jhr_qname        = @jhr_qname
   From  jmo_jhr WITH (index=1)
   Where
      jhr_jschd        = @k_jhr_jschd     and
      jhr_name         = @k_jhr_name      and
      jhr_jno          = @k_jhr_jno       and
      jhr_key          = @k_jhr_key
end
GO
GRANT EXECUTE ON  [dbo].[JMO_JHR_Upd] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Upd] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_JHR_Upd] TO [uniadmin]
GO