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


CREATE proc JMO_PSRM_Del (
   @k_psr_scdn      char(65),
   @k_psr_name      char(65),
   @k_psr_jno       char(5),
   @k_psr_pscd      char(65),  
   @k_psr_pjob      char(65),
   @k_psr_pjno      char(5)
)
as
begin
   Delete From jmo_psrm
   Where
       psr_scdn         = @k_psr_scdn      and
       psr_name         = @k_psr_name      and
       psr_jno          = @k_psr_jno       and
       psr_pscd         = @k_psr_pscd      and
       psr_pjob         = @k_psr_pjob      and
       psr_pjno         = @k_psr_pjno      

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