USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGPAYMENT

USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGPAYMENT

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
@PAYMENTMETHODS xml IN Payment 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

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGPAYMENT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REVENUETYPES xml,
    @APPLICATIONTYPES xml,
    @PAYMENTMETHODS xml,
    @SUBTYPEONE xml,
    @OFFICEID int,
    @DEBITGLACCOUNTID uniqueidentifier,
    @DEBITPDACCOUNTSEGMENTVALUEID uniqueidentifier,
    @CREDITGLACCOUNTID uniqueidentifier,
    @CREDITPDACCOUNTSEGMENTVALUEID uniqueidentifier
)

as
    set nocount on;

    declare @SUBTYPETWO xml;
    declare @SUBTYPETHREE xml;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PDACCOUNTCODEMAPTICKETINGPAYMENT
        @ID = @ID,
        @SUBTYPETWO = @SUBTYPETWO output,
        @SUBTYPETHREE = @SUBTYPETHREE output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PDACCOUNTCODEMAPTICKETINGPAYMENT_2
        @ID,
        @CHANGEAGENTID,
        @REVENUETYPES,
        @APPLICATIONTYPES,
        @PAYMENTMETHODS,
        @SUBTYPEONE,
        @OFFICEID,
        @DEBITGLACCOUNTID,
        @DEBITPDACCOUNTSEGMENTVALUEID,
        @CREDITGLACCOUNTID,
        @CREDITPDACCOUNTSEGMENTVALUEID,
        @SUBTYPETWO,
        @SUBTYPETHREE

    return 0;