USP_DATAFORMTEMPLATE_ADD_PDCOMPOSITESEGMENTMAPPING_PRELOAD

The load procedure used by the edit dataform template "Composite Segment Mapping Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PDACCOUNTSTRUCTUREID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@TABLE1	uniqueidentifier	INOUT	Segment value
@TABLE2	uniqueidentifier	INOUT	Segment value
@TABLE3	uniqueidentifier	INOUT	Segment value
@TABLE4	uniqueidentifier	INOUT	Segment value
@TABLE1NAME	nvarchar(25)	INOUT	Table 1 Name
@TABLE2NAME	nvarchar(25)	INOUT	Table 2 Name
@TABLE3NAME	nvarchar(25)	INOUT	Table 3 Name
@TABLE4NAME	nvarchar(25)	INOUT	Table 4 Name
@STRUCTUREID	uniqueidentifier	INOUT	Segment value
@PDCOMPOSITESEGMENTID	uniqueidentifier	INOUT	Segment value
@SHOWSIMPLE1	bit	INOUT	Show Simple 1
@SHOWSIMPLE2	bit	INOUT	Show Simple 2
@SHOWSIMPLE3	bit	INOUT	Show Simple 3
@SHOWSIMPLE4	bit	INOUT	Show Simple 4

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDCOMPOSITESEGMENTMAPPING_PRELOAD
(
    @PDACCOUNTSTRUCTUREID uniqueidentifier,
    @TABLE1 uniqueidentifier = null output,
    @TABLE2 uniqueidentifier = null output,
    @TABLE3 uniqueidentifier = null output,
    @TABLE4 uniqueidentifier = null output,
    @TABLE1NAME nvarchar(25) = null output,
    @TABLE2NAME nvarchar(25) = null output,
    @TABLE3NAME nvarchar(25) = null output,
    @TABLE4NAME nvarchar(25) = null output,    
    @STRUCTUREID uniqueidentifier = null output,
    @PDCOMPOSITESEGMENTID uniqueidentifier = null  output,
    @SHOWSIMPLE1 bit = null output,
    @SHOWSIMPLE2 bit = null output,
    @SHOWSIMPLE3 bit = null output,
    @SHOWSIMPLE4 bit = null output

)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database
    select 
        @TABLE1 = (select PDACCOUNTTABLESAVAILABLEFORSEGMENTID from PDCOMPOSITESEGMENTTABLELIST where SEQUENCE = 1 and PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE2 = (select PDACCOUNTTABLESAVAILABLEFORSEGMENTID from PDCOMPOSITESEGMENTTABLELIST where SEQUENCE = 2 and PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE3 = (select PDACCOUNTTABLESAVAILABLEFORSEGMENTID from PDCOMPOSITESEGMENTTABLELIST where SEQUENCE = 3 and PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE4 = (select PDACCOUNTTABLESAVAILABLEFORSEGMENTID from PDCOMPOSITESEGMENTTABLELIST where SEQUENCE = 4 and PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE1NAME = (select friendlytablename from PDACCOUNTTABLESAVAILABLEFORSEGMENT as a join PDCOMPOSITESEGMENTTABLELIST as b on a.ID = b.PDACCOUNTTABLESAVAILABLEFORSEGMENTID where SEQUENCE = 1 and b.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE2NAME = (select friendlytablename from PDACCOUNTTABLESAVAILABLEFORSEGMENT as a join PDCOMPOSITESEGMENTTABLELIST as b on a.ID = b.PDACCOUNTTABLESAVAILABLEFORSEGMENTID where SEQUENCE = 2 and b.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),
        @TABLE3NAME = isnull((select friendlytablename from PDACCOUNTTABLESAVAILABLEFORSEGMENT as a join PDCOMPOSITESEGMENTTABLELIST as b on a.ID = b.PDACCOUNTTABLESAVAILABLEFORSEGMENTID where SEQUENCE = 3 and b.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),'EMPTY'),
        @TABLE4NAME = isnull((select friendlytablename from PDACCOUNTTABLESAVAILABLEFORSEGMENT as a join PDCOMPOSITESEGMENTTABLELIST as b on a.ID = b.PDACCOUNTTABLESAVAILABLEFORSEGMENTID where SEQUENCE = 4 and b.PDCOMPOSITESEGMENTID = PDCOMPOSITESEGMENT.ID),'EMPTY'),        
        @STRUCTUREID = (select ID  from PDACCOUNTSTRUCTURE where PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = PDCOMPOSITESEGMENT.ID and PDACCOUNTSTRUCTURE.ID = @PDACCOUNTSTRUCTUREID),
        @PDCOMPOSITESEGMENTID = (select PDACCOUNTTABLESAVAILABLEFORSEGMENTID  from PDACCOUNTSTRUCTURE where PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = PDCOMPOSITESEGMENT.ID and PDACCOUNTSTRUCTURE.ID = @PDACCOUNTSTRUCTUREID)
from PDCOMPOSITESEGMENT JOIN PDACCOUNTSTRUCTURE on PDCOMPOSITESEGMENT.ID = PDACCOUNTSTRUCTURE.PDACCOUNTTABLESAVAILABLEFORSEGMENTID
 where PDACCOUNTSTRUCTURE.ID = @PDACCOUNTSTRUCTUREID    


    set @SHOWSIMPLE1 = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(@TABLE1)
    set @SHOWSIMPLE2 = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(@TABLE2)
    set @SHOWSIMPLE3 = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(@TABLE3)
    set @SHOWSIMPLE4 = dbo.UFN_PDCOMPOSITESEGMENTMAPPING_USESIMPLE(@TABLE4)


    return 0;