APPS.RRS_SITE_INFO dependencies on RRS_SITE_HIERAR_TAB

Line 15: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

11: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
12: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
13: ,x_property_tab OUT NOCOPY rrs_property_tab
14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
15: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
16: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
17: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
18: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
19: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab

Line 1272: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

1268: p_site_id_num IN varchar2
1269: ,p_site_name IN varchar2 Default null
1270: ,x_property_tab OUT NOCOPY rrs_property_tab
1271: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
1272: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
1273: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
1274: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
1275: ) is
1276:

Line 1289: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;

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;

Line 1290: l_hierarchy_details local_rrs_site_hierar_tab;

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;
1294: l_site_party_id NUMBER;

Line 1495: x_site_hierar_tab := rrs_site_hierar_tab();

1491:
1492:
1493:
1494:
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