APPS.RRS_SITE_INFO dependencies on RRS_SITE_HIERAR_TAB

Line 14: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

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

Line 1254: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

1250: p_site_id_num IN varchar2
1251: ,p_site_name IN varchar2 Default null
1252: ,x_property_tab OUT NOCOPY rrs_property_tab
1253: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
1254: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
1255: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
1256: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
1257: ) is
1258:

Line 1270: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;

1266: TYPE local_rrs_site_hierar_rec is RECORD (
1267: hierarchy_name rrs_site_groups_tl.name%TYPE,
1268: hierarchy_node_name rrs_site_group_nodes_tl.name%TYPE
1269: );
1270: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;
1271: l_hierarchy_details local_rrs_site_hierar_tab;
1272:
1273: l_site_id NUMBER;
1274: l_location_id NUMBER;

Line 1271: l_hierarchy_details local_rrs_site_hierar_tab;

1267: hierarchy_name rrs_site_groups_tl.name%TYPE,
1268: hierarchy_node_name rrs_site_group_nodes_tl.name%TYPE
1269: );
1270: Type local_rrs_site_hierar_tab is table of local_rrs_site_hierar_rec;
1271: l_hierarchy_details local_rrs_site_hierar_tab;
1272:
1273: l_site_id NUMBER;
1274: l_location_id NUMBER;
1275: l_site_party_id NUMBER;

Line 1429: x_site_hierar_tab := rrs_site_hierar_tab();

1425: SiteGroupMemberEO.SITE_GROUP_ID) AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1426: AND DELETED_FLAG = 'N';
1427:
1428:
1429: x_site_hierar_tab := rrs_site_hierar_tab();
1430: if l_hierarchy_details.count > 0 then
1431: FOR i in l_hierarchy_details.First..l_hierarchy_details.Last LOOP
1432: x_site_hierar_tab.Extend();
1433: x_site_hierar_tab(i) := rrs_site_hierar_rec(l_hierarchy_details(i).hierarchy_name