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

CREATE proc JMO_GBL_Ins (
   @gbl_name         char(8),
   @gbl_adate        int,
   @gbl_atime        int,
   @gbl_ldate        int,
   @gbl_ltime        int,
   @gbl_ndate        int,
   @gbl_ntime        int,
   @gbl_fdate        int,
   @gbl_ftime        int,
   @next_rpt         char(3),
   @gbl_ltype        binary(1),
   @gbl_flag1        binary(1),
   @act_trkset          char (1),
   @prescan_min      int,
   @prescan_max      int,
   @prescan_total    int,
   @prescan_cnt      int
)
as
begin
   Insert into jmo_gbl (
      gbl_name,
      gbl_adate,
      gbl_atime,
      gbl_ldate,
      gbl_ltime,
      gbl_ndate,
      gbl_ntime,
      gbl_fdate,
      gbl_ftime,
      next_rpt,
      gbl_ltype,
      gbl_flag1,
      act_trkset,
      prescan_min,
      prescan_max,
      prescan_total,
      prescan_cnt            
)
   Values (
      @gbl_name,
      @gbl_adate,
      @gbl_atime,
      @gbl_ldate,
      @gbl_ltime,
      @gbl_ndate,
      @gbl_ntime,
      @gbl_fdate,
      @gbl_ftime,
      @next_rpt,
      @gbl_ltype,
      @gbl_flag1,
      @act_trkset,
      @prescan_min,
      @prescan_max,
      @prescan_total,
      @prescan_cnt                      
)
end
GO
GRANT EXECUTE ON  [dbo].[JMO_GBL_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_GBL_Ins] TO [uniadmin]
GO