USP_DATAFORMTEMPLATE_PLANNEDGIFT_EDITSAVE_8

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@VEHICLECODE	tinyint	IN
@SUBTYPECODE	tinyint	IN
@EXPECTEDGIFTAMOUNT	money	IN
@ISREVOCABLE	bit	IN
@ISANONYMOUS	bit	IN
@EXPECTEDMATURITY	UDT_YEAR	IN
@DISCOUNTRATE	decimal(6, 1)	IN
@NETPRESENTVALUE	money	IN
@NETPRESENTVALUEDATE	datetime	IN
@REMAINDERVALUE	money	IN
@REMAINDERVALUEDATE	datetime	IN
@RECOGNITIONAMOUNT	money	IN
@GIFTDATE	datetime	IN
@PAYOUTRATE	decimal(6, 3)	IN
@PAYOUTAMOUNT	money	IN
@PAYMENTPERIODSTART	datetime	IN
@PAYMENTPERIODEND	datetime	IN
@PAYMENTFREQUENCYCODE	tinyint	IN
@TERMTYPECODE	tinyint	IN
@TERMENDDATE	datetime	IN
@YEARSINTERM	tinyint	IN
@TRUSTTAXIDNUMBER	nvarchar(100)	IN
@POOLEDINCOMEFUNDCODEID	uniqueidentifier	IN
@POOLEDINCOMEFUNDUNITS	int	IN
@POOLEDINCOMEFUNDTOTALUNITS	int	IN
@LIFEINSURANCEPREMIUM	money	IN
@LIFEINSURANCEPREMIUMFREQUENCYCODE	tinyint	IN
@LIFEINSURANCEPREMIUMDUEDATE	datetime	IN
@STATUSCODE	tinyint	IN
@DESIGNATION	xml	IN
@ASSETS	xml	IN
@BENEFICIARIES	xml	IN
@RELATIONSHIPS	xml	IN
@PROBATEDATE	datetime	IN
@DISCOUNTDATE	datetime	IN
@REMAINDERMANPERCENT	decimal(6, 1)	IN
@PROBATESTATUSCODE	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITES	xml	IN
@ISTESTAMENTARY	bit	IN
@OTHERSUBTYPECODEID	uniqueidentifier	IN
@ISLIVINGTRUST	bit	IN
@GIFTVALUEISNOMINAL	bit	IN
@ISCONTINGENT	bit	IN
@ORGISPOLICY	bit	IN
@ORGISBENEFICIARY	bit	IN
@TRUSTHELDOUTSIDE	bit	IN
@TOTALPAYOUT	money	IN
@REALIZEDVALUE	money	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@HADSPOTRATE	bit	IN
@RATECHANGED	bit	IN
@TRIGGERDATE	datetime	IN
@ISFLIP	bit	IN
@TRIGGEREVENTCODEID	uniqueidentifier	IN
@EXCL_RATIO	decimal(6, 3)	IN
@EXCL_EXPDATE	datetime	IN
@DONOTRECEIPT	bit	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_PLANNEDGIFT_EDITSAVE_8
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @VEHICLECODE tinyint,
    @SUBTYPECODE tinyint,
    @EXPECTEDGIFTAMOUNT money,
    @ISREVOCABLE bit,
    @ISANONYMOUS bit,
    @EXPECTEDMATURITY dbo.UDT_YEAR,
    @DISCOUNTRATE decimal(6,1),
    @NETPRESENTVALUE money,
    @NETPRESENTVALUEDATE datetime,
    @REMAINDERVALUE money,
    @REMAINDERVALUEDATE datetime,
    @RECOGNITIONAMOUNT money,
    @GIFTDATE datetime,
    @PAYOUTRATE decimal(6,3),
    @PAYOUTAMOUNT money,
    @PAYMENTPERIODSTART datetime,
    @PAYMENTPERIODEND datetime,
    @PAYMENTFREQUENCYCODE tinyint,
    @TERMTYPECODE tinyint,
    @TERMENDDATE datetime,
    @YEARSINTERM tinyint,
    @TRUSTTAXIDNUMBER nvarchar(100),
    @POOLEDINCOMEFUNDCODEID uniqueidentifier,
    @POOLEDINCOMEFUNDUNITS int,
    @POOLEDINCOMEFUNDTOTALUNITS int,
    @LIFEINSURANCEPREMIUM money,
    @LIFEINSURANCEPREMIUMFREQUENCYCODE tinyint,
    @LIFEINSURANCEPREMIUMDUEDATE datetime,
    @STATUSCODE tinyint,
    @DESIGNATION xml,
    @ASSETS xml,
    @BENEFICIARIES xml,
    @RELATIONSHIPS xml,
    @PROBATEDATE datetime,
    @DISCOUNTDATE datetime,
    @REMAINDERMANPERCENT decimal(6,1),
    @PROBATESTATUSCODE tinyint,
    @CURRENTAPPUSERID uniqueidentifier,
    @SITES xml,
    @ISTESTAMENTARY bit,
    @OTHERSUBTYPECODEID uniqueidentifier,
    @ISLIVINGTRUST bit,
    @GIFTVALUEISNOMINAL bit,
    @ISCONTINGENT bit,
    @ORGISPOLICY bit,
    @ORGISBENEFICIARY bit,
    @TRUSTHELDOUTSIDE bit,
    @TOTALPAYOUT money,
    @REALIZEDVALUE money,
    @BASECURRENCYID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @HADSPOTRATE bit,
    @RATECHANGED bit,
    @TRIGGERDATE datetime,
    @ISFLIP bit,
    @TRIGGEREVENTCODEID uniqueidentifier,
    @EXCL_RATIO decimal(6,3),
    @EXCL_EXPDATE datetime,
    @DONOTRECEIPT bit
)

as
  set nocount on;

    declare @LIFEINSURANCEPOLICYNUMBER nvarchar(50);
    declare @LIFEINSURANCEDATEISSUED datetime;
    declare @LIFEINSURANCEFACEVALUE money;
    declare @LIFEINSURANCEDOESINCLUDEDIVIDENDPARTICIPATION bit;
    declare @LIFEINSURANCEISLOANALLOWED bit;
    declare @LIFEINSURANCEOUTSTANDINGLOANAMOUNT money;

  exec dbo.USP_DATAFORMTEMPLATE_PLANNEDGIFT_EDITLOAD_4
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @LIFEINSURANCEPOLICYNUMBER = @LIFEINSURANCEPOLICYNUMBER output,
        @LIFEINSURANCEDATEISSUED = @LIFEINSURANCEDATEISSUED output,
        @LIFEINSURANCEFACEVALUE = @LIFEINSURANCEFACEVALUE output,
        @LIFEINSURANCEDOESINCLUDEDIVIDENDPARTICIPATION = @LIFEINSURANCEDOESINCLUDEDIVIDENDPARTICIPATION output,
        @LIFEINSURANCEISLOANALLOWED = @LIFEINSURANCEISLOANALLOWED output,
        @LIFEINSURANCEOUTSTANDINGLOANAMOUNT = @LIFEINSURANCEOUTSTANDINGLOANAMOUNT output

  exec dbo.USP_DATAFORMTEMPLATE_PLANNEDGIFT_EDITSAVE_9
        @ID,
        @CHANGEAGENTID,
        @VEHICLECODE,
        @SUBTYPECODE,
        @EXPECTEDGIFTAMOUNT,
        @ISREVOCABLE,
        @ISANONYMOUS,
        @EXPECTEDMATURITY,
        @DISCOUNTRATE,
        @NETPRESENTVALUE,
        @NETPRESENTVALUEDATE,
        @REMAINDERVALUE,
        @REMAINDERVALUEDATE,
        @RECOGNITIONAMOUNT,
        @GIFTDATE,
        @PAYOUTRATE,
        @PAYOUTAMOUNT,
        @PAYMENTPERIODSTART,
        @PAYMENTPERIODEND,
        @PAYMENTFREQUENCYCODE,
        @TERMTYPECODE,
        @TERMENDDATE,
        @YEARSINTERM,
        @TRUSTTAXIDNUMBER,
        @POOLEDINCOMEFUNDCODEID,
        @POOLEDINCOMEFUNDUNITS,
        @POOLEDINCOMEFUNDTOTALUNITS,
        @LIFEINSURANCEPREMIUM,
        @LIFEINSURANCEPREMIUMFREQUENCYCODE,
        @LIFEINSURANCEPREMIUMDUEDATE,
        @STATUSCODE,
        @DESIGNATION,
        @ASSETS,
        @BENEFICIARIES,
        @RELATIONSHIPS,
        @PROBATEDATE,
        @DISCOUNTDATE,
        @REMAINDERMANPERCENT,
        @PROBATESTATUSCODE,
        @CURRENTAPPUSERID,
        @SITES,
        @ISTESTAMENTARY,
        @OTHERSUBTYPECODEID,
        @ISLIVINGTRUST,
        @GIFTVALUEISNOMINAL,
        @ISCONTINGENT,
        @ORGISPOLICY,
        @ORGISBENEFICIARY,
        @TRUSTHELDOUTSIDE,
        @TOTALPAYOUT,
        @REALIZEDVALUE,
        @BASECURRENCYID,
        @TRANSACTIONCURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @HADSPOTRATE,
        @RATECHANGED,
        @TRIGGERDATE,
        @ISFLIP,
        @TRIGGEREVENTCODEID,
        @EXCL_RATIO,
        @EXCL_EXPDATE,
        @DONOTRECEIPT,
        @LIFEINSURANCEPOLICYNUMBER,
        @LIFEINSURANCEDATEISSUED,
        @LIFEINSURANCEFACEVALUE,
        @LIFEINSURANCEDOESINCLUDEDIVIDENDPARTICIPATION,
        @LIFEINSURANCEISLOANALLOWED,
        @LIFEINSURANCEOUTSTANDINGLOANAMOUNT

  return 0;