ALTER PROCEDURE [dbo].[LS_CUSTOMER_App]
@p_CUSTOMER_ID varchar(15),
@P_AUTH_STATUS VARCHAR(1),
@P_CHECKER_ID VARCHAR(12),
@P_APPROVE_DT VARCHAR(20)
AS
/*
DECLARE	@aStatus VARCHAR(1)
DECLARE @sErrorCode VARCHAR(20)
SET @sErrorCode = ''
	SELECT @aStatus = [AUTH_STATUS] FROM LS_CUSTOMER WHERE CUSTOMER_ID=@p_CUSTOMER_ID
	IF @aStatus = 'A'
		SET @sErrorCode = ''

	IF @ERRORSYS <> ''
	BEGIN
		SELECT ErrorCode Result, ''CUSTOMER_ID, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS
		RETURN '0'
	END*/
BEGIN TRANSACTION
		UPDATE LS_CUSTOMER SET AUTH_STATUS = 'A', CHECKER_ID = @P_CHECKER_ID, APPROVE_DT = CONVERT(DATETIME,@P_APPROVE_DT,103)
WHERE CUSTOMER_ID=@p_CUSTOMER_ID
		IF @@Error <> 0 GOTO ABORT
COMMIT TRANSACTION
SELECT '0' as Result, @p_CUSTOMER_ID  CUSTOMER_ID, '' ErrorDesc
RETURN '0'
ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, '' CUSTOMER_ID, '' ErrorDesc
		RETURN '-1'
End