USP_DATAFORMTEMPLATE_ADD_PDACCOUNTSEGMENTMAPBATCHROW2

The save procedure used by the add dataform template "Account Segment Mapping Batch Row Add Form by system".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@PDACCOUNTSTRUCTUREID	uniqueidentifier	IN	Segment type
@LONGDESCRIPTIONID	uniqueidentifier	IN	Segment name
@PDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Segment value
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTSEGMENTMAPBATCHROW2(
    @ID uniqueidentifier output,
    @BATCHID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @PDACCOUNTSTRUCTUREID uniqueidentifier,
    @LONGDESCRIPTIONID uniqueidentifier,
    @PDACCOUNTSEGMENTVALUEID uniqueidentifier,
    @PDACCOUNTSYSTEMID uniqueidentifier
)
as
    set nocount on;

    if @ID is null
        set @ID = newid();

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @CURRENTDATE datetime
        set @CURRENTDATE = getdate();

    declare @ISDEFAULT bit
    select @ISDEFAULT = ISDEFAULT from dbo.PDACCOUNTSEGMENTMAPPING 
        where LONGDESCRIPTIONID = @LONGDESCRIPTIONID;
    set @ISDEFAULT = IsNull(@ISDEFAULT,0);


    begin try
        insert into dbo.BATCHPDACCOUNTSEGMENTMAPPING
        (
          ID,
            BATCHID,
            PDACCOUNTSTRUCTUREID,
            LONGDESCRIPTIONID,
            PDACCOUNTSEGMENTVALUEID,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED,
            SEQUENCE,
            ISDEFAULT
        )
        values
        (
          @ID,
            @BATCHID,
            @PDACCOUNTSTRUCTUREID,
            @LONGDESCRIPTIONID,
            @PDACCOUNTSEGMENTVALUEID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE,
            @SEQUENCE,
            @ISDEFAULT
        );
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

return 0;