CREATE PROCEDURE dbo.taCreateCustomerItems
@I_vITEMNMBR CHAR(30),
@I_vCUSTNMBR CHAR(15),
@I_vCUSTITEMNMBR CHAR(30) = '',
@I_vCUSTITEMDESC CHAR(50) = '',
@I_vCUSTITEMSHORNAME CHAR(15) = '',
@I_vCUSTITEMGENERICDESC CHAR(10) = '',
@I_vUSERDEF1 CHAR(20) = '',
@I_vUSERDEF2 CHAR(20) = '',
@I_vUSRDEF03 CHAR(20) = '',
@I_vUSRDEF04 CHAR(20) = '',
@I_vUSRDEF05 CHAR(20) = '',
@I_vSUBITEMNMBR CHAR(30) = '',
@I_vSTRTDATE DATETIME = '',
@I_vENDDATE DATETIME = '',
@I_vRequesterTrx SMALLINT = 0,
@I_vUSRDEFND1 CHAR(50) = '',
@I_vUSRDEFND2 CHAR(50) = '',
@I_vUSRDEFND3 CHAR(50) = '',
@I_vUSRDEFND4 VARCHAR(8000) = '',
@I_vUSRDEFND5 VARCHAR(8000) = '',
@O_iErrorState INT OUTPUT,
@oErrString VARCHAR(255) OUTPUT
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET NOCOUNT ON;
DECLARE @SUBITEMDESC CHAR(50),
@NOTEINDX DECIMAL(19, 5),
@CMPANYID SMALLINT,
@iGetNextNoteIdxErrState INT,
@iAddCodeErrState INT,
@iStatus INT,
@iCustomState INT,
@iCustomErrString VARCHAR(255),
@O_oErrorState INT,
@iError INT;
SELECT @SUBITEMDESC = '',
@NOTEINDX = 0,
@iStatus = 0,
@O_iErrorState = 0;
IF (@oErrString IS NULL)
BEGIN
SELECT @oErrString = '';
END;
EXEC @iStatus = taCreateCustomerItemsPre @I_vITEMNMBR OUTPUT,
@I_vCUSTNMBR OUTPUT,
@I_vCUSTITEMNMBR OUTPUT,
@I_vCUSTITEMDESC OUTPUT,
@I_vCUSTITEMSHORNAME OUTPUT,
@I_vCUSTITEMGENERICDESC OUTPUT,
@I_vUSERDEF1 OUTPUT,
@I_vUSERDEF2 OUTPUT,
@I_vUSRDEF03 OUTPUT,
@I_vUSRDEF04 OUTPUT,
@I_vUSRDEF05 OUTPUT,
@I_vSUBITEMNMBR OUTPUT,
@I_vSTRTDATE OUTPUT,
@I_vENDDATE OUTPUT,
@I_vRequesterTrx OUTPUT,
@I_vUSRDEFND1 OUTPUT,
@I_vUSRDEFND2 OUTPUT,
@I_vUSRDEFND3 OUTPUT,
@I_vUSRDEFND4 OUTPUT,
@I_vUSRDEFND5 OUTPUT,
@O_iErrorState = @iCustomState OUTPUT,
@oErrString = @iCustomErrString OUTPUT;
SELECT @iError = @@error;