IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'dd_taSopLineDeleteWrapper'
AND type = 'P')
DROP PROCEDURE dd_taSopLineDeleteWrapper
GO
CREATE PROCEDURE dd_taSopLineDeleteWrapper
-- dd_taSopLineDeleteWrapper 2, 'ORDST2229', 606208, 'ACCS-CRD-12WH'
@I_vSOPTYPE SMALLINT,
@I_vSOPNUMBE CHAR(21),
@I_vLNITMSEQ int,
@I_vITEMNMBR char(30)
AS
DECLARE @RC int
DECLARE @I_vCMPNTSEQ int = 0
DECLARE @I_vRequesterTrx smallint = 0
DECLARE @I_vRecreateDist smallint = 1 --1=Recreate Distributions - should be used unless manually changing distributions
DECLARE @I_vDeleteType smallint = 1 --1=Line Item Delete; 2=Kit Item Line Component Delete
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 = 0
DECLARE @oErrString varchar(255) = ''
EXECUTE @RC = taSopLineDelete
@I_vSOPTYPE
,@I_vSOPNUMBE
,@I_vLNITMSEQ
,@I_vITEMNMBR
,@I_vRequesterTrx
,@I_vRecreateDist
,@I_vCMPNTSEQ
,@I_vDeleteType
,@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 dd_taSopLineDeleteWrapper to public