DBA Data[Home] [Help]

APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_HIER_MEMBERS_COARSE_REC

Line 2747: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', NULL, 'NONE', 'NODE', NULL, 'ROOT_R0005', 0, 'R0005', NULL, 'ROOT');

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');

Line 2749: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'SITE', 10141, NULL, 10, NULL, NULL, NULL);

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');

Line 2751: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'ROOT_R0005', 'NODE', NULL, 'NEW_NODE_R5', 20, 'new node R5', NULL, '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);

Line 2753: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'NODE', 10005, NULL, 10, 'tempNODE', 'test description', 'BRKPNT');

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);

Line 2755: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'NEW_NODE_R5', 'SITE', NULL, 'MBOX0001', 20, 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(

Line 2757: --v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', NULL, 'temp_11040', 'SITE', NULL, 'MBOX980', 10, NULL, NULL, NULL);

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,

Line 2789: v_tab(1) := RRS_HIER_MEMBERS_COARSE_REC('NONE', -1, NULL, 'NODE', 10003, NULL, 0, NULL, NULL, 'ROOT');

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);

Line 2791: v_tab(2) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10006, 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);

Line 2793: v_tab(3) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10006, NULL, 'SITE', 10002, 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);

Line 2795: v_tab(4) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10004, 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);

Line 2797: v_tab(5) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10004, NULL, 'SITE', 10000, 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(

Line 2799: v_tab(6) := RRS_HIER_MEMBERS_COARSE_REC('NODE', 10003, NULL, 'NODE', 10005, NULL, 0, NULL, NULL, NULL);

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,