if @BidRequestType$=$'Drop'

begin

declare @outputValue$1$ varchar$(50),$@BidRequestIdoutput$1$ int

EXEC $[$DOT$].[$sp$\_$DOTBidEngineFA$\_$ValidatePairing$\_$Drop$]$ @pEmployeeNumber,@pPairingNumber,@pPairingDate,@BidDetailId,@BidCycleMonth,@BidRequestId,@BidRequestType,@outputValue$=$@outputValue$1$ OUTPUT,@BidRequestIdoutput$=$@BidRequestIdoutput$1$ output $--=$'Fail UpdatepreviousDetailfailed'

if @outputValue$1=$'Fail UpdatepreviousDetailfailed'

begin

update $[$DOT$].[$BidAward$]$

set bidawardstatus$=$'Fail'

where requestid$=$@BidRequestIdoutput$1$

update #allbiddetail

set Flagdetail$=1$

where BidRequestId$=$BidRequestId

$--$return

end

end

$--$ if @BidRequestType$=$'ADD'

$--$begin

$--$ exec $[$DOT$].[$sp$\_$DOTBidEngineFA$\_$ValidatePairing$\_$Add$]$ @pEmployeeNumber,@pPairingNumber,@pPairingDate,@BidDetailId,@BidCycleMonth,@BidRequestId

$--$end

update #allbiddetail

set Flagdetail$=1$ where BidDetailId$=$ @BidDetailId and BidRequestId $=$ @BidRequestId

end

update #allrequest

set flag$=1$ where BidRequestId $=$ @BidRequestId

end