USP_DATAFORMTEMPLATE_ADD_CLOSING_REQUIREMENT_PRELOAD

The load procedure used by the edit dataform template "Closing Requirement Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CLOSINGELEMENTID	uniqueidentifier	INOUT
@CLOSINGELEMENTTYPE	tinyint	INOUT
@RECORDTYPEID	uniqueidentifier	INOUT
@CLOSINGREQUIREMENTDETAIL	xml	INOUT	Closing Requirement Details
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CLOSING_REQUIREMENT_PRELOAD
(
  @CLOSINGELEMENTID uniqueidentifier = null output,
  @CLOSINGELEMENTTYPE tinyint = null output,
  @RECORDTYPEID uniqueidentifier = null output,
  @CLOSINGREQUIREMENTDETAIL xml = null output
  ,@PDACCOUNTSYSTEMID uniqueidentifier
)
as
set nocount on;

if @PDACCOUNTSYSTEMID is null
  set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

select top 1 @CLOSINGELEMENTID = ID, @CLOSINGELEMENTTYPE = ELEMENTDEFINITIONCODE
from dbo.PDACCOUNTSTRUCTURE where CLOSINGELEMENT=1
  and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
  and ISBASICGL = 0;

set @CLOSINGREQUIREMENTDETAIL = 
(select
  ST.ID as ACCOUNTSTRUCTUREID,
  dbo.UFN_TRANSLATIONFUNCTION_ACCOUNTSTRUCTURE_NAME(ST.ID) as SEGMENTNAME,
  0 as PRESERVEDETAILSDURINGCLOSING,
  0 as REQUIRETOBALANCE,
  case when ST.ELEMENTTYPECODE = 1 then 3
    when ST.ELEMENTTYPECODE = 2 then 0 
  end as ACCOUNTREQUIREMENTSCODE,
  ST.ELEMENTTYPECODE as ELEMENTTYPECODE,
  '11111111-1111-1111-1111-111111111111' as CLOSINGREQUIREMENTID
from
  dbo.PDACCOUNTSTRUCTURE ST
  where ELEMENTDEFINITIONCODE<>1 and CLOSINGELEMENT = 0
  order by ST.DESCRIPTION
for xml raw('ITEM'),type,elements,root('CLOSINGREQUIREMENTDETAIL'),BINARY BASE64)

select @RECORDTYPEID = ID from dbo.RECORDTYPE
where upper(NAME) = 
  case @CLOSINGELEMENTTYPE
  when 1 then 'ACCOUNT CODE'
  when 7 then 'PROJECT'
  else 'ACCOUNTING ELEMENT' end

return 0;