USP_DATAFORMTEMPLATE_VIEW_R68COMMITEXCEPTIONDETAIL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@MESSAGE	nvarchar(1024)	INOUT
@R68PROCESSCOMMITPARAMETERSID	uniqueidentifier	INOUT
@REVENUESPLITID	uniqueidentifier	INOUT
@TYPECODE	tinyint	INOUT
@DATEADDED	datetime	INOUT
@NAME	nvarchar(500)	INOUT
@CALCULATEDUSERDEFINEDID	nvarchar(200)	INOUT
@REVENUEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_R68COMMITEXCEPTIONDETAIL
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 out,
  @MESSAGE nvarchar(1024) = null out,
  @R68PROCESSCOMMITPARAMETERSID uniqueidentifier = null out,
  @REVENUESPLITID uniqueidentifier = null out,
  @TYPECODE tinyint = null out,
  @DATEADDED DateTime = null out,
  @NAME nvarchar(500) = null out,
  @CALCULATEDUSERDEFINEDID nvarchar(200) = null out,
  @REVENUEID uniqueidentifier = null out
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

select 
  @ID = rce.ID,
  @DATALOADED = 1,
  @MESSAGE = FULLMESSAGE,
  @R68PROCESSCOMMITPARAMETERSID = R68PROCESSCOMMITPARAMETERSID,
  @REVENUESPLITID = REVENUESPLITID,
  @TYPECODE = rce.TYPECODE,
  @DATEADDED = rce.DATEADDED,
  @NAME = Name,
  @CALCULATEDUSERDEFINEDID = CALCULATEDUSERDEFINEDID,
  @REVENUEID = ftli.FINANCIALTRANSACTIONID
from 
    [dbo].[R68PROCESSCOMMITEXCEPTION] rce
left join 
    [dbo].[R68PROCESSCOMMITPARAMETERS] rpc ON rpc.id = rce.R68PROCESSCOMMITPARAMETERSID
left join
    [dbo].[FINANCIALTRANSACTIONLINEITEM] ftli ON ftli.id = rce.REVENUESPLITID
left join
    [dbo].[FINANCIALTRANSACTION] ft ON ft.ID = ftli.FINANCIALTRANSACTIONID
where
    rce.ID = @ID
    return 0;