2743: BEGIN
2744:
2745: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();
2746: v_tab.EXTEND();
2747: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', NULL, 'NONE', 'NODE', NULL, 'ROOT_R0005', 0, 'R0005', NULL, 'ROOT');
2748: v_tab.EXTEND();
2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);
2750: v_tab.EXTEND();
2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, 'BRKPNT');
2745: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();
2746: v_tab.EXTEND();
2747: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', NULL, 'NONE', 'NODE', NULL, 'ROOT_R0005', 0, 'R0005', NULL, 'ROOT');
2748: v_tab.EXTEND();
2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);
2750: v_tab.EXTEND();
2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, 'BRKPNT');
2752: v_tab.EXTEND();
2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');
2747: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', NULL, 'NONE', 'NODE', NULL, 'ROOT_R0005', 0, 'R0005', NULL, 'ROOT');
2748: v_tab.EXTEND();
2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);
2750: v_tab.EXTEND();
2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, 'BRKPNT');
2752: v_tab.EXTEND();
2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');
2754: v_tab.EXTEND();
2755: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'SITE', NULL, 'MBOX0001', 20, NULL, NULL, NULL);
2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);
2750: v_tab.EXTEND();
2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, 'BRKPNT');
2752: v_tab.EXTEND();
2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');
2754: v_tab.EXTEND();
2755: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'SITE', NULL, 'MBOX0001', 20, NULL, NULL, NULL);
2756: --v_tab.EXTEND();
2757: --v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'temp_11040', 'SITE', NULL, 'MBOX980', 10, NULL, NULL, NULL);
2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, 'BRKPNT');
2752: v_tab.EXTEND();
2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');
2754: v_tab.EXTEND();
2755: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'SITE', NULL, 'MBOX0001', 20, NULL, NULL, NULL);
2756: --v_tab.EXTEND();
2757: --v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'temp_11040', 'SITE', NULL, 'MBOX980', 10, NULL, NULL, NULL);
2758:
2759: RRS_HIERARCHY_CRUD_PKG.Create_Hierarchy_Coarse(
2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');
2754: v_tab.EXTEND();
2755: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'SITE', NULL, 'MBOX0001', 20, NULL, NULL, NULL);
2756: --v_tab.EXTEND();
2757: --v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'temp_11040', 'SITE', NULL, 'MBOX980', 10, NULL, NULL, NULL);
2758:
2759: RRS_HIERARCHY_CRUD_PKG.Create_Hierarchy_Coarse(
2760: p_hier_name => v_name,
2761: p_hier_description => v_desc,
2785:
2786: v_tab := RRS_HIER_MEMBERS_COARSE_TAB();
2787:
2788: v_tab.EXTEND();
2789: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', -1, NULL, 'NODE', 10003, NULL, 0, NULL, NULL, 'ROOT');
2790: v_tab.EXTEND();
2791: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10006, NULL, 0, NULL, NULL, NULL);
2792: v_tab.EXTEND();
2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, NULL, 0, NULL, NULL, NULL);
2787:
2788: v_tab.EXTEND();
2789: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', -1, NULL, 'NODE', 10003, NULL, 0, NULL, NULL, 'ROOT');
2790: v_tab.EXTEND();
2791: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10006, NULL, 0, NULL, NULL, NULL);
2792: v_tab.EXTEND();
2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, NULL, 0, NULL, NULL, NULL);
2794: v_tab.EXTEND();
2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, NULL, 0, NULL, NULL, NULL);
2789: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', -1, NULL, 'NODE', 10003, NULL, 0, NULL, NULL, 'ROOT');
2790: v_tab.EXTEND();
2791: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10006, NULL, 0, NULL, NULL, NULL);
2792: v_tab.EXTEND();
2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, NULL, 0, NULL, NULL, NULL);
2794: v_tab.EXTEND();
2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, NULL, 0, NULL, NULL, NULL);
2796: v_tab.EXTEND();
2797: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10004, NULL, 'SITE', 10000, NULL, 0, NULL, NULL, NULL);
2791: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10006, NULL, 0, NULL, NULL, NULL);
2792: v_tab.EXTEND();
2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, NULL, 0, NULL, NULL, NULL);
2794: v_tab.EXTEND();
2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, NULL, 0, NULL, NULL, NULL);
2796: v_tab.EXTEND();
2797: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10004, NULL, 'SITE', 10000, NULL, 0, NULL, NULL, NULL);
2798: v_tab.EXTEND();
2799: v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10005, NULL, 0, NULL, NULL, NULL);
2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, NULL, 0, NULL, NULL, NULL);
2794: v_tab.EXTEND();
2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, NULL, 0, NULL, NULL, NULL);
2796: v_tab.EXTEND();
2797: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10004, NULL, 'SITE', 10000, NULL, 0, NULL, NULL, NULL);
2798: v_tab.EXTEND();
2799: v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10005, NULL, 0, NULL, NULL, NULL);
2800:
2801: RRS_HIERARCHY_CRUD_PKG.Update_Hierarchy_Coarse(
2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, NULL, 0, NULL, NULL, NULL);
2796: v_tab.EXTEND();
2797: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10004, NULL, 'SITE', 10000, NULL, 0, NULL, NULL, NULL);
2798: v_tab.EXTEND();
2799: v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10005, NULL, 0, NULL, NULL, NULL);
2800:
2801: RRS_HIERARCHY_CRUD_PKG.Update_Hierarchy_Coarse(
2802: p_hier_name => v_name,
2803: --p_hier_new_name => v_new_name,