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


CREATE proc JMO_PSR1_Ins (
   @psr_scdn         char(65),
   @psr_name         char(65),
   @psr_jno          char(5),
   @psr_qual         char(5),
   @psr_pscd         char(65),
   @psr_pjob         char(65),
   @psr_pjno         char(5),
   @psr_pqua         char(5),
   @psr_flag         binary(1)
)
as
begin
    IF ( EXISTS
            ( SELECT top 1 1 FROM jmo_psr1   
            WHERE psr_scdn  = @psr_scdn      and
                      psr_name  = @psr_name      and
                      psr_jno   = @psr_jno       and
                      psr_qual  = @psr_qual      and
                      psr_pscd  = @psr_pscd      and
                      psr_pjob  = @psr_pjob      and
                      psr_pjno  = @psr_pjno      and
                      psr_pqua  = @psr_pqua
           ))
        RETURN 2601
    ELSE
        BEGIN
            Insert into jmo_psr1 (
                psr_scdn,
                psr_name,
                psr_jno,
                psr_qual,
                psr_pscd,
                psr_pjob,
                psr_pjno,
                psr_pqua,
                psr_flag
            )
            Values (
                @psr_scdn,
                @psr_name,
                @psr_jno,
                @psr_qual,
                @psr_pscd,
                @psr_pjob,
                @psr_pjno,
                @psr_pqua,
                @psr_flag
            )
        END
end
GO
GRANT EXECUTE ON  [dbo].[JMO_PSR1_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSR1_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PSR1_Ins] TO [uniadmin]
GO