USP_DATAFORMTEMPLATE_EDIT_PROGRAMFLATRATE

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RATESCALEID	uniqueidentifier	IN	Rate scale

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PROGRAMFLATRATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RATESCALEID uniqueidentifier
)

as
  set nocount on;

    declare @DEFAULTPRICINGSTRUCTURECODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROGRAMFLATRATE
        @ID = @ID,
        @DEFAULTPRICINGSTRUCTURECODE = @DEFAULTPRICINGSTRUCTURECODE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PROGRAMFLATRATE_2
        @ID,
        @CHANGEAGENTID,
        @RATESCALEID,
        @DEFAULTPRICINGSTRUCTURECODE

  return 0;