USP_SAVE_BENEFITGLDISTRIBUTION_ADJUSTMENT_CUSTOMIZE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@GLDISTRIBUTION	xml	IN
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@BENEFITTYPECODE	tinyint	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_SAVE_BENEFITGLDISTRIBUTION_ADJUSTMENT_CUSTOMIZE
(
    @ID uniqueidentifier,
    @GLDISTRIBUTION xml,
    @ADJUSTMENTDATE datetime,
    @ADJUSTMENTPOSTDATE datetime,
    @ADJUSTMENTREASONCODEID uniqueidentifier,
    @ADJUSTMENTREASON nvarchar(300),
    @BENEFITTYPECODE tinyint,
    @CHANGEAGENTID uniqueidentifier = null
) as
    set nocount on;

    -- This sp is for Professional Services to create custom benefit adjustment distributions

    -- Add custom routines here to populate JOURNALENRY table and JOURNALENTRY_EXT table

    -- Also set return to something other than 0

    -- Product Development should NOT alter this spec


    return 0;