DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID = (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0002/2021/TTr-0690903')
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
@p_AUTH_STATUS = 'A', -- varchar(1)
@p_CHECKER_ID = 'taila', -- varchar(15)
@p_APPROVE_DT = '2021-03-21 8:15:56 AM', -- datetime
@p_ROLE_LOGIN = 'HQDT', -- varchar(50)
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)

¿

ALTER PROCEDURE [dbo].[CM_HANGHOA_Upd]
@p_HH_ID	varchar(15) = null ,
@p_HH_CODE	varchar(15) = NULL ,
@p_HH_NAME	nvarchar(200) = NULL ,
@p_HH_TYPE_ID	varchar(15) = NULL ,
@p_DESCRIPTION	nvarchar(2000) = NULL ,
@p_SUP_ID	varchar(15) = NULL ,
@p_PRICE	decimal(17) = NULL ,
@p_UNIT_ID	varchar(15) = NULL ,
@p_NOTES	nvarchar(1000) = NULL ,
@p_RECORD_STATUS	varchar(1) = NULL ,
@p_MAKER_ID	varchar(12) = NULL ,
@p_CREATE_DT	VARCHAR(20) = NULL,
@p_AUTH_STATUS	varchar(50) = NULL ,
@p_CHECKER_ID	varchar(12) = NULL ,
@p_APPROVE_DT	VARCHAR(20) = NULL,
@p_GD_ID	varchar(15) = null,
@p_GROUP_ID_TTCT varchar(15)  = NULL,
@p_GROUP_ID_CDT varchar(15)  = NULL,
@p_DVCM_ID varchar(15)  = NULL

AS
BEGIN TRANSACTION
		
		declare @OLD_DVCM_ID NVARCHAR(15) = NULL
		SELECT @OLD_DVCM_ID = DVCM_ID FROM CM_HANGHOA_DVCM WHERE HH_ID = @p_HH_ID

		--kIEM TRA MA LA DUY NHAT
		IF EXISTS (SELECT * FROM CM_HANGHOA WHERE HH_CODE = @p_HH_CODE AND HH_ID <> @p_HH_ID)
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Mã hàng hóa đã tồn tại trong hệ thống' ErrorDesc
			RETURN -1
		END
		--kIEM TRA MA LA DUY NHAT
		IF(@p_HH_CODE IS NULL OR @p_HH_CODE ='')
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Mã hàng hóa chưa tự động phát sinh. Vui lòng nhập mã hàng hóa' ErrorDesc
			RETURN -1
		END
		IF(@p_MAKER_ID NOT IN ('vanpt2', 'quanvta','phuongvn','cuongvd','tuyenlt','tanvt','tungnt4'))
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Bạn không nằm trong danh sách những user được phép thêm mới hàng hóa. Vui lòng liên hệ bộ phận Mua Hàng - Phòng Hành Chính Hội Sở' ErrorDesc
			RETURN -1
		END
		UPDATE CM_HANGHOA SET [HH_CODE] = @p_HH_CODE,[HH_NAME] = @p_HH_NAME,[HH_TYPE_ID] = @p_HH_TYPE_ID,[DESCRIPTION] = @p_DESCRIPTION,[SUP_ID] = @p_SUP_ID,[PRICE] = @p_PRICE,[UNIT_ID] = @p_UNIT_ID,[NOTES] = @p_NOTES,[RECORD_STATUS] = @p_RECORD_STATUS,[MAKER_ID] = @p_MAKER_ID,[CREATE_DT] = CONVERT(DATETIME, @p_CREATE_DT, 103),[AUTH_STATUS] = @p_AUTH_STATUS,[CHECKER_ID] = @p_CHECKER_ID,[APPROVE_DT] = CONVERT(DATETIME, @p_APPROVE_DT, 103), [GD_ID] = @p_GD_ID
		WHERE  HH_ID = @p_HH_ID

		DELETE SYS_HH_GROUP_LIMIT WHERE HH_ID = @p_HH_ID
		INSERT INTO SYS_HH_GROUP_LIMIT(HH_ID, GROUP_LIMIT_ID, TYPE_LIMIT)
		VALUES (@p_HH_ID, @p_GROUP_ID_TTCT, 'TTCT')
		INSERT INTO SYS_HH_GROUP_LIMIT(HH_ID, GROUP_LIMIT_ID, TYPE_LIMIT)
		VALUES (@p_HH_ID, @p_GROUP_ID_CDT, 'CDT')
		DELETE CM_HANGHOA_DVCM WHERE HH_ID = @p_HH_ID AND DVCM_ID = @OLD_DVCM_ID
		INSERT INTO CM_HANGHOA_DVCM(HH_ID, DVCM_ID)
		VALUES (@p_HH_ID, @p_DVCM_ID)

		IF @@Error <> 0 GOTO ABORT
COMMIT TRANSACTION
		SELECT 0 as Result, @p_HH_ID  HH_ID, '' ErrorDesc
		RETURN 0
ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT -1 as Result, '' HH_ID,	N'Cập nhật thất bại' ErrorDesc
		RETURN -1
End

¿

ALTER PROCEDURE [dbo].[CM_HANGHOA_Ins]
	@p_HH_CODE	varchar(50)  = NULL,
	@p_HH_NAME	nvarchar(200)  = NULL,
	@p_HH_TYPE_ID	varchar(15)  = NULL,
	@p_DESCRIPTION	nvarchar(2000)  = NULL,
	@p_SUP_ID	varchar(15)  = NULL,
	@p_PRICE	decimal(18)  = NULL,
	@p_UNIT_ID	varchar(15)  = NULL,
	@p_NOTES	nvarchar(1000)  = NULL,
	@p_RECORD_STATUS	varchar(1)  = NULL,
	@p_MAKER_ID	varchar(15)  = NULL,
	@p_CREATE_DT	VARCHAR(20) = NULL,
	@p_AUTH_STATUS	varchar(50)  = NULL,
	@p_CHECKER_ID	varchar(12)  = NULL,
	@p_APPROVE_DT	VARCHAR(20) = NULL,
	@p_GD_ID	varchar(15)  = NULL,
	@p_GROUP_ID_TTCT varchar(15)  = NULL,
	@p_GROUP_ID_CDT varchar(15)  = NULL,
	@p_DVCM_ID varchar(15)  = NULL
AS
	DECLARE @l_HH_ID VARCHAR(15)
	
BEGIN TRANSACTION
		
		--kIEM TRA MA LA DUY NHAT
		IF EXISTS (SELECT * FROM CM_HANGHOA WHERE HH_CODE = @p_HH_CODE)
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Mã hàng hóa đã tồn tại trong hệ thống' ErrorDesc
			RETURN -1
		END
		IF(@p_MAKER_ID NOT IN ('vanpt2', 'quanvta','phuongvn','cuongvd','tuyenlt','tanvt','tungnt4'))
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Bạn không nằm trong danh sách những user được phép thêm mới hàng hóa. Vui lòng liên hệ bộ phận Mua Hàng - Phòng Hành Chính Hội Sở' ErrorDesc
			RETURN -1
		END
		IF(@p_HH_CODE IS NULL OR @p_HH_CODE ='')
		BEGIN
			ROLLBACK TRANSACTION
			SELECT -1 as Result, '' HH_ID, N'Mã hàng hóa chưa tự động phát sinh. Vui lòng nhập mã hàng hóa' ErrorDesc
			RETURN -1
		END
		EXEC SYS_CodeMasters_Gen 'CM_HANGHOA', @l_HH_ID out
		IF @l_HH_ID='' OR @l_HH_ID IS NULL GOTO ABORT
	
		SET @p_AUTH_STATUS = 'A'
		IF EXISTS (SELECT * FROM TL_MENU WHERE MENU_NAME_EL = N'hanghoa' and ISAPPROVE_FUNC = 1)
		BEGIN
			SET @p_AUTH_STATUS = 'U'	
		END
		
		INSERT INTO CM_HANGHOA([HH_ID],[HH_CODE],[HH_NAME],[HH_TYPE_ID],[DESCRIPTION],[SUP_ID],[PRICE],[UNIT_ID],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[GD_ID])
		VALUES(@l_HH_ID ,@p_HH_CODE ,@p_HH_NAME ,@p_HH_TYPE_ID ,@p_DESCRIPTION ,@p_SUP_ID ,@p_PRICE ,@p_UNIT_ID ,@p_NOTES ,@p_RECORD_STATUS ,@p_MAKER_ID ,CONVERT(DATETIME, @p_CREATE_DT, 103) ,@p_AUTH_STATUS ,@p_CHECKER_ID ,CONVERT(DATETIME, @p_APPROVE_DT, 103), @p_GD_ID)
		
		DELETE SYS_HH_GROUP_LIMIT WHERE HH_ID = @l_HH_ID
		INSERT INTO SYS_HH_GROUP_LIMIT(HH_ID, GROUP_LIMIT_ID, TYPE_LIMIT)
		VALUES (@l_HH_ID, @p_GROUP_ID_TTCT, 'TTCT')
		INSERT INTO SYS_HH_GROUP_LIMIT(HH_ID, GROUP_LIMIT_ID, TYPE_LIMIT)
		VALUES (@l_HH_ID, @p_GROUP_ID_CDT, 'CDT')
		DELETE CM_HANGHOA_DVCM WHERE HH_ID = @l_HH_ID AND DVCM_ID = @p_DVCM_ID
		INSERT INTO CM_HANGHOA_DVCM(HH_ID, DVCM_ID)
		VALUES (@l_HH_ID, @p_DVCM_ID)

		IF @@Error <> 0 GOTO ABORT
		
COMMIT TRANSACTION
SELECT 0 as Result, @l_HH_ID  HH_ID, '' ErrorDesc
RETURN 0
ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT -1 as Result, '' HH_ID, N'Thêm thất bại' ErrorDesc
		RETURN -1
End