USP_DATAFORMTEMPLATE_EDITLOAD_MOBILEPAYENCRYPTIONKEY

                create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MOBILEPAYENCRYPTIONKEY (
                    @DATALOADED bit = 0 output,
                    @PUBLICKEY nvarchar(2048) = null output,
                    @PRIVATEKEY nvarchar(2048) = null output,
                    @PASSPHRASE nvarchar(128) = null output,
                    @TSLONG bigint = 0 output
                )
                as
                    set nocount on;

                    declare @ID uniqueidentifier;
                    set @ID = '1EF64F51-C034-4BC0-B82A-40FDAD4E7F29';

                    set @DATALOADED = 1;
                    set @TSLONG = 0;

                    exec dbo.USP_GET_KEY_ACCESS;

                    select 
                        @PUBLICKEY = coalesce(convert(nvarchar(2048), DecryptByKey(MK.PUBLICKEY)), ''),
                        @PRIVATEKEY = coalesce(convert(nvarchar(2048), DecryptByKey(MK.PRIVATEKEY)), ''),
                        @PASSPHRASE = coalesce(convert(nvarchar(128), DecryptByKey(MK.PASSPHRASE)), ''),
                        @TSLONG = MK.TSLONG
                    from
                        dbo.MOBILEPAYENCRYPTIONKEY MK
                    where
                        ID = @ID;

                    close symmetric key sym_BBInfinity;

                    return 0;