USP_REPORT_GLACCOUNTMAPPINGUPDATE_SUCCESS

CREATE procedure dbo.USP_REPORT_GLACCOUNTMAPPINGUPDATE_SUCCESS
(
    @ID nvarchar(36)
)
with execute as owner
as

    set nocount on;

    declare @TABLENAME nvarchar(255);
    declare @SQL nvarchar(max);

    if nullif(@ID, '') is not null
    begin
        select @TABLENAME = BUSINESSPROCESSOUTPUT.TABLENAME
        from dbo.BUSINESSPROCESSSTATUS
        inner join dbo.BUSINESSPROCESSOUTPUT on BUSINESSPROCESSSTATUS.ID = BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID
        where BUSINESSPROCESSSTATUS.ID = @ID;

        if @TABLENAME is null or OBJECT_ID(@TABLENAME) is null
            raiserror('Business process exception table could not be found.  The process might not have completed successfully. ',13,1);

        begin try
            set @SQL = 'select 
                CASE WHEN TRANSACTIONTYPECODE in (0, 1, 2, 3, 4, 6, 7, 8, 9, 15) THEN ''http://www.blackbaud.com/REVENUEID?REVENUEID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [REVENUEID]
                ,CASE WHEN TRANSACTIONTYPECODE = 5 THEN ''http://www.blackbaud.com/ORDERID?ORDERID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [ORDERID]
                ,CASE WHEN TRANSACTIONTYPECODE = 100 THEN ''http://www.blackbaud.com/ADJUSTMENTID?ADJUSTMENTID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [ADJUSTMENTID]
                ,CASE WHEN TRANSACTIONTYPECODE = 101 THEN ''http://www.blackbaud.com/CORRECTIONID?CORRECTIONID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [CORRECTIONID]
                ,CASE WHEN TRANSACTIONTYPECODE = 102 THEN ''http://www.blackbaud.com/DEPOSITID?DEPOSITID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [DEPOSITID]
                ,CASE WHEN TRANSACTIONTYPECODE = 103 THEN ''http://www.blackbaud.com/REFUNDID?REFUNDID='' + CONVERT(nvarchar(36), TRANSACTIONID) ELSE null END as [REFUNDID]
                ,TRANSACTIONDESCID
                ,TRANSACTIONTYPE
                ,ERRORMESSAGE
                FROM dbo. ' + @TABLENAME;

            exec sp_executesql @SQL;
        end try

        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch
    end
    else
        select null as [REVENUEID], null as [ORDERID], null as [ADJUSTMENTID], null as [CORRECTIONID], null as [DEPOSITID], null as [REFUNDID], null as [TRANSACTIONDESCID], null as [TRANSACTIONTYPE], null as [ERRORMESSAGE]