1280: Type local_rrs_site_cluster_tab is table of local_rrs_site_cluster_rec;
1281: l_cluster_name local_rrs_site_cluster_tab;
1282:
1283:
1284: TYPE local_rrs_site_hierar_rec is RECORD (
1285: hierarchy_name rrs_site_groups_tl.name%TYPE,
1286: hierarchy_node_name rrs_site_group_nodes_tl.name%TYPE,
1287: parent_site_name rrs_sites_tl.name%Type
1288: );
1285: hierarchy_name rrs_site_groups_tl.name%TYPE,
1286: hierarchy_node_name rrs_site_group_nodes_tl.name%TYPE,
1287: parent_site_name rrs_sites_tl.name%Type
1288: );
1289: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;
1290: l_hierarchy_details local_rrs_site_hierar_tab;
1291:
1292: l_site_id NUMBER;
1293: l_location_id NUMBER;
1495: x_site_hierar_tab := rrs_site_hierar_tab();
1496: if l_hierarchy_details.count > 0 then
1497: FOR i in l_hierarchy_details.First..l_hierarchy_details.Last LOOP
1498: x_site_hierar_tab.Extend();
1499: x_site_hierar_tab(i) := rrs_site_hierar_rec(l_hierarchy_details(i).hierarchy_name
1500: ,l_hierarchy_details(i).hierarchy_node_name
1501: ,l_hierarchy_details(i).parent_site_name
1502: );
1503: END LOOP;