DECLARE
  v_client NUMBER(10);
  v_acctSchemaId NUMBER(10);
  v_parentId1 NUMBER(10);
  v_parentId2 NUMBER(10);
  v_parentId3 NUMBER(10);
  v_parentId4 NUMBER(10);
  v_parentId5 NUMBER(10);
  v_parentId6 NUMBER(10);
  v_parentId7 NUMBER(10);
  v_parentId8 NUMBER(10);
  v_parentId9 NUMBER(10);
  AdAccountingrptElementId NUMBER(10);
BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client FROM AD_CLIENT;
SELECT MAX(C_ACCTSCHEMA_ID) INTO v_acctSchemaId FROM C_ACCTSCHEMA WHERE AD_CLIENT_ID = v_client;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, TEMPORARYFILTERTYPE, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Statement of cash flows (direct)', 'Y', 'Y', 'Y', 'A', v_acctSchemaId, 'Y', 'dd');
update ad_treenode set parent_id = 0, seqno=10 where node_id = AdAccountingrptElementId;
v_parentId1:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Net increase in cash', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId1, seqno=10 where node_id = AdAccountingrptElementId;
v_parentId2:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash flows from operating activities', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId2, seqno=10 where node_id = AdAccountingrptElementId;
v_parentId3:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash flows from investing activities', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId2, seqno=20 where node_id = AdAccountingrptElementId;
v_parentId4:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash flows from financing activities', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId2, seqno=30 where node_id = AdAccountingrptElementId;
v_parentId5:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash received from customers', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId3, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid for merchandise', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId3, seqno=20 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid for other expenses', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId3, seqno=30 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid for income taxes', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId3, seqno=40 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash received from sale of equipment', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId4, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid from equipment', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId4, seqno=20 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid to retired bonds payable', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId5, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid for dividends', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId5, seqno=20 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, TEMPORARYFILTERTYPE, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Statement of cash flows (indirect)', 'Y', 'Y', 'Y', 'A', v_acctSchemaId, 'Y', 'dd');
update ad_treenode set parent_id = 0, seqno=20 where node_id = AdAccountingrptElementId;
v_parentId6:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Adjustments to reconcile net income to net cash provided by operating', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId6, seqno=10 where node_id = AdAccountingrptElementId;
v_parentId7:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Decrease in accounts receivable', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Increase in merchandise inventory', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=20 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Increase in prepaid expenses', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=30 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Decrease in accounts payable', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=40 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Increase in income taxes payable', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=50 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Depreciation expense', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=60 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Loss on sale of plants assets', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=70 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Loss on retirement of bonds', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId7, seqno=80 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash flows from investing activities', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId6, seqno=20 where node_id = AdAccountingrptElementId;
v_parentId8:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash received from sale of equipment', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId8, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'cash paid from equipment', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId8, seqno=20 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash flows from financing activities', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId6, seqno=30 where node_id = AdAccountingrptElementId;
v_parentId9:= AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid to retired bonds payable', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId9, seqno=10 where node_id = AdAccountingrptElementId;
AD_SEQUENCE_NEXT('AD_AccountingRpt_Element', '1000000',AdAccountingrptElementId);
Insert into TAD.AD_ACCOUNTINGRPT_ELEMENT
   (AD_ACCOUNTINGRPT_ELEMENT_ID, UPDATED, UPDATEDBY, CREATED, CREATEDBY, ISACTIVE, AD_CLIENT_ID, AD_ORG_ID, NAME,
 ISSUMMARY, ISSHOWN, FILTEREDBYORGANIZATION, C_ACCTSCHEMA_ID, ISREPORT, REPORT_TYPE)
 Values
   (AdAccountingrptElementId, sysdate, 100, sysdate, 100, 'Y', v_client, 0, 'Cash paid for dividends', 'Y', 'Y', 'N', v_acctSchemaId, 'N', 'dd');
update ad_treenode set parent_id = v_parentId9, seqno=20 where node_id = AdAccountingrptElementId;
COMMIT;
END;