USP_RECORDOPERATION_VIEWBYDISBURSEMENT_MARKRECONCILED

CREATE procedure dbo.USP_RECORDOPERATION_VIEWBYDISBURSEMENT_MARKRECONCILED
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    --check deletion rules, if any


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


    update dbo.PROCESSORTRANSACTIONSETTLEMENTIMPORTROW set
        STATUSCODE = 1,
        DATECHANGED = @CURRENTDATE,
        CHANGEDBYID = @CHANGEAGENTID
    where
        ID = @ID

    delete from
        dbo.UNSETTLEDCREDITCARDTRANSACTION
    where
        PROCESSORTRANSACTIONSETTLEMENTIMPORTROWID = @ID

    return 0;

end