USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGORDER2

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.
@REVENUETYPES	xml	IN	Revenue types
@APPLICATIONTYPES	xml	IN	Application types
@SUBTYPEONE	xml	IN	Resource categories
@OFFICEID	int	IN	Office ID
@DEBITGLACCOUNTID	uniqueidentifier	IN	Account
@DEBITPDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@CREDITGLACCOUNTID	uniqueidentifier	IN	Account
@CREDITPDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@PDACCOUNTSYSTEMID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGORDER2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REVENUETYPES xml,
    @APPLICATIONTYPES xml,
    @SUBTYPEONE xml,
    @OFFICEID int,
    @DEBITGLACCOUNTID uniqueidentifier,
    @DEBITPDACCOUNTSEGMENTVALUEID uniqueidentifier,
    @CREDITGLACCOUNTID uniqueidentifier,
    @CREDITPDACCOUNTSEGMENTVALUEID uniqueidentifier,
    @PDACCOUNTSYSTEMID uniqueidentifier
)

as
  set nocount on;

    declare @SUBTYPETWO xml;
    declare @SUBTYPETHREE xml;
    declare @SUBTYPEFOUR xml;
    declare @SUBTYPEFIVE xml;
    declare @SUBTYPESIX xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PDACCOUNTCODEMAPTICKETINGORDER2
        @ID = @ID,
        @SUBTYPETWO = @SUBTYPETWO output,
        @SUBTYPETHREE = @SUBTYPETHREE output,
        @SUBTYPEFOUR = @SUBTYPEFOUR output,
        @SUBTYPEFIVE = @SUBTYPEFIVE output,
        @SUBTYPESIX = @SUBTYPESIX output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGORDER3
        @ID,
        @CHANGEAGENTID,
        @REVENUETYPES,
        @APPLICATIONTYPES,
        @SUBTYPEONE,
        @OFFICEID,
        @DEBITGLACCOUNTID,
        @DEBITPDACCOUNTSEGMENTVALUEID,
        @CREDITGLACCOUNTID,
        @CREDITPDACCOUNTSEGMENTVALUEID,
        @PDACCOUNTSYSTEMID,
        @SUBTYPETWO,
        @SUBTYPETHREE,
        @SUBTYPEFOUR,
        @SUBTYPEFIVE,
        @SUBTYPESIX

  return 0;