AKI-REFILL-9

USE SPEX_DB;

IF EXISTS (
SELECT *
    FROM INFORMATION_SCHEMA.ROUTINES
WHERE SPECIFIC_SCHEMA = N'spex'
    AND SPECIFIC_NAME = N'SP_AMANAH_RE_FILL_5_CLOSE_BT'
    AND ROUTINE_TYPE = N'PROCEDURE'
)
DROP PROCEDURE spex.SP_AMANAH_RE_FILL_5_CLOSE_BT
GO

CREATE PROCEDURE spex.SP_AMANAH_RE_FILL_5_CLOSE_BT
(
    @RESERVE_LOC VARCHAR(MAX),
    @BT_NO VARCHAR(30),
    @USERNAME VARCHAR(20)
)
AS
BEGIN

    DECLARE @MSG_TEXT VARCHAR(MAX) = ''
    DECLARE @RES_TEXT VARCHAR(MAX) = ''

    SET NOCOUNT ON;
    CREATE TABLE #TB_T_DATA (
        RESULT VARCHAR(MAX),
        Message VARCHAR(MAX)
    )

    DELETE FROM TB_T_BUCKET_TRANSFER
    WHERE BT_NO = @BT_NO

    -- UPDATE dbo.TB_R_REFILL SET STATUS = 0 WHERE TRANSFER_NO = @TRANSFER_NO AND BT_NO = @BT_NO

    SET @MSG_TEXT = '';
    SET @RES_TEXT = 'Success'

    INSERT INTO #TB_T_DATA
    VALUES (@RES_TEXT, @MSG_TEXT)

    SELECT RESULT, Message
    FROM #TB_T_DATA

END
GO