USP_STANDINGORDERSIMPORTPROCESS_EXCEPTIONLIST

Gets a list of exception rows from a standing orders import process run.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_EXCEPTIONLIST
            (
                @BUSINESSPROCESSSTATUSID uniqueidentifier
            )
            as
                set nocount on;

                exec dbo.USP_GET_KEY_ACCESS;

                select
                  dbo.UFN_DECRYPT_XMLTOTEXT(STANDINGORDERSIMPORTPROCESSEXCEPTION.ROWDATAXML) as ROWDATA
                from
                    dbo.STANDINGORDERSIMPORTPROCESSEXCEPTION
                where
                    BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID
                order by
                    ROWNUMBER

                close symmetric key sym_BBInfinity;