IF EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE SPECIFIC_SCHEMA = N'dbo'
AND SPECIFIC_NAME = N'dd_taRMTransactionTaxInsertWrapper'
)
DROP PROCEDURE dbo.dd_taRMTransactionTaxInsertWrapper
GO
CREATE OR ALTER PROCEDURE dd_taRMTransactionTaxInsertWrapper
@I_vCUSTNMBR CHAR(15),
@I_vDOCNUMBR CHAR(20),
@I_vRMDTYPAL SMALLINT,
@I_vBACHNUMB CHAR(15),
@I_vTAXDTLID CHAR(15),
@I_vTAXAMNT NUMERIC(19,5),
@I_vSTAXAMNT NUMERIC(19,5),
@I_vFRTTXAMT NUMERIC(19,5),
@I_vMSCTXAMT NUMERIC(19,5),
@I_vTAXDTSLS NUMERIC(19,5),
@I_vSEQNUMBR INT,
@I_vACTINDX INT,
@I_vACTNUMST VARCHAR(75),
@I_vTDTTXSLS NUMERIC(19,5),
@I_vRequesterTrx SMALLINT,
@I_vUSRDEFND1 CHAR(50),
@I_vUSRDEFND2 CHAR(50),
@I_vUSRDEFND3 CHAR(50),
@I_vUSRDEFND4 VARCHAR(8000),
@I_vUSRDEFND5 VARCHAR(8000),
@O_iErrorState INT,
@oErrString VARCHAR(255)
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE @ErrorDesc VARCHAR(256)
DECLARE @RC int
SELECT @O_iErrorState = 0,
@O_iErrorState = ''
EXECUTE @RC = dbo.taRMTransactionTaxInsert
@I_vCUSTNMBR
,@I_vDOCNUMBR
,@I_vRMDTYPAL
,@I_vBACHNUMB
,@I_vTAXDTLID
,@I_vTAXAMNT
,@I_vSTAXAMNT
,@I_vFRTTXAMT
,@I_vMSCTXAMT
,@I_vTAXDTSLS
,@I_vSEQNUMBR
,@I_vACTINDX
,@I_vACTNUMST
,@I_vTDTTXSLS
,@I_vRequesterTrx
,@I_vUSRDEFND1
,@I_vUSRDEFND2
,@I_vUSRDEFND3
,@I_vUSRDEFND4
,@I_vUSRDEFND5
,@O_iErrorState OUTPUT
,@oErrString OUTPUT
IF @O_iErrorState > 0 BEGIN
SELECT @ErrorDesc = tec.ErrorDesc
FROM dynamics..taErrorCode tec
WHERE tec.ErrorCode = @O_iErrorState
END ELSE BEGIN
SELECT @ErrorDesc = ''
END
GO
Grant EXEC on dd_taRMTransactionTaxInsertWrapper to public
-- sp_sps ''
GO