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


CREATE proc JMO_PSRM_Ins (
   @psr_scdn         char(65),
   @psr_name         char(65),
   @psr_jno          char(5),
   @psr_pscd         char(65),
   @psr_pjob         char(65),
   @psr_pjno         char(5),
   @psr_flag         binary(1)
)
as
DECLARE @status int
begin
   IF ( EXISTS
            ( SELECT top 1 1 FROM jmo_psrm   
            WHERE     psr_scdn  = @psr_scdn      and
                      psr_name  = @psr_name      and
                      psr_jno   = @psr_jno       and
                      psr_pjob  = @psr_pjob      and
                      psr_pjno  = @psr_pjno      and
                      psr_pscd  = @psr_pscd
           ))
        RETURN 2601
   ELSE
        BEGIN
     
            Insert into jmo_psrm (
                psr_scdn,
                psr_name,
                psr_jno,
                psr_pscd,
                psr_pjob,
                psr_pjno,
                psr_flag
            )
            Values (
                @psr_scdn,
                @psr_name,
                @psr_jno,
                @psr_pscd,
                @psr_pjob,
                @psr_pjno,
                @psr_flag
            )
        END
   

end
GO
GRANT EXECUTE ON  [dbo].[JMO_PSRM_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSRM_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSRM_Ins] TO [uniadmin]
GO