USP_RECORDOPERATION_VIEWBYDISBURSEMENT_MARKUNMATCHED

CREATE procedure dbo.USP_RECORDOPERATION_VIEWBYDISBURSEMENT_MARKUNMATCHED
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    declare @CURRENTDATE datetime = getdate();
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    update CCPMD set
        SETTLEMENTTYPECODE = 0,
        SETTLEMENTDATE = NULL,
        FEE = 0,
        NETAMOUNT = 0,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    from
        dbo.CREDITCARDPAYMENTMETHODDETAIL CCPMD
        inner join dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW R on R.DATABASETRANSACTIONID = CCPMD.ID
    where
        R.ID = @ID

    update dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW set
        STATUSCODE = case STATUSCODE
                        when 1 then 0
                        else STATUSCODE
                    end,
        DATABASETRANSACTIONID = null,
        DATECHANGED = @CURRENTDATE,
        CHANGEDBYID = @CHANGEAGENTID
    where
        ID = @ID

    delete from dbo.UNSETTLEDCREDITCARDTRANSACTION
    where PROCESSORTRANSACTIONSETTLEMENTIMPORTROWID = @ID

    update CP set
        SETTLEMENTTYPECODE = 0,
        SETTLEMENTDATE = NULL,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    from
        dbo.CREDITPAYMENT CP
        inner join dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW R on R.DATABASETRANSACTIONID = CP.ID
    where
        R.ID = @ID

    insert into dbo.UNSETTLEDCREDITCARDTRANSACTION
    (
        ID,
        TRANSACTIONDATE,
        CARDTYPE,
        CARDHOLDERNAME,
        CREDITCARDPARTIALNUMBER,
        AUTHORIZATIONCODE,
        AMOUNT,
        PROCESSORTRANSACTIONSETTLEMENTIMPORTID,
        VENDORID,
        CURRENCYID,
        PROCESSORTRANSACTIONSETTLEMENTIMPORTROWID,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
    )
    select
        newid(),
        TRANSACTIONDATE,
        CARDTYPE,
        CARDHOLDERNAME,
        CREDITCARDPARTIALNUMBER,
        AUTHORIZATIONCODE,
        AMOUNT,
        PROCESSORTRANSACTIONSETTLEMENTIMPORTID,
        VENDORID,
        CURRENCYID,
        ID,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
    from
        dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW IMPORTEDTRANSACTIONS
    where
        IMPORTEDTRANSACTIONS.ID = @ID

    return 0;
    return 0;

end