IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'fp_taSopDeleteDocumentWrapper'
AND type = 'P')
DROP PROCEDURE fp_taSopDeleteDocumentWrapper
GO
CREATE PROCEDURE fp_taSopDeleteDocumentWrapper
@I_vSOPTYPE SMALLINT,
@I_vSOPNUMBE CHAR(21)
AS
DECLARE @RC INT
DECLARE @I_vRemovePayments SMALLINT
DECLARE @I_vUSRDEFND1 CHAR(50)
DECLARE @I_vUSRDEFND2 CHAR(50)
DECLARE @I_vUSRDEFND3 CHAR(50)
DECLARE @I_vUSRDEFND4 VARCHAR(8000)
DECLARE @I_vUSRDEFND5 VARCHAR(8000)
DECLARE @O_iErrorState INT
DECLARE @oErrString VARCHAR(255)
EXECUTE @RC = taSopDeleteDocument
@I_vSOPTYPE
,@I_vSOPNUMBE
,@I_vRemovePayments
,@I_vUSRDEFND1
,@I_vUSRDEFND2
,@I_vUSRDEFND3
,@I_vUSRDEFND4
,@I_vUSRDEFND5
,@O_iErrorState OUTPUT
,@oErrString OUTPUT
if @O_iErrorState > 0 begin
select @oErrString = ec.ErrorDesc
from dynamics..taErrorCode ec
where ec.ErrorCode = @O_iErrorState
raiserror(@oErrString, 16,2)
end
GO
Grant EXEC on fp_taSopDeleteDocumentWrapper to public