[dbo].[UpdatePlasticDealHppSessionInfo]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@inPlasticDealId	int	4
@inHppSessionId	varchar(50)	50

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

/**
*    Updates a PlasticDeal with hosted payment page session information.  We know this info before
*    the hosted payment page is shown to the user so we need this info on the PlasticDeal should
*    something go wrong and we never get the response in a normal fashion.  With this info saved,
*    the Payment Research screen would be able to try and inquire and retrieve the results of this
*    transaction.
*/

CREATE PROCEDURE [dbo].[UpdatePlasticDealHppSessionInfo]
    @inPlasticDealId int,
    @inHppSessionId varchar(50)
as
set nocount on

update PlasticDeal set
    HppSessionID = @inHppSessionId
where DealID = @inPlasticDealId
GO
GRANT EXECUTE ON  [dbo].[UpdatePlasticDealHppSessionInfo] TO [MssExec]
GO