APPS.RRS_SITE_INFO dependencies on RRS_SITE_CLUSTER_TAB

Line 13: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

9: ,x_site_header_tab OUT NOCOPY rrs_site_header_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

Line 1253: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

1249: Procedure Get_site_associations(
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

Line 1262: Type local_rrs_site_cluster_tab is table of local_rrs_site_cluster_rec;

1258:
1259: TYPE local_rrs_site_cluster_rec is RECORD (
1260: cluster_name rrs_site_groups_tl.name%TYPE
1261: );
1262: Type local_rrs_site_cluster_tab is table of local_rrs_site_cluster_rec;
1263: l_cluster_name local_rrs_site_cluster_tab;
1264:
1265:
1266: TYPE local_rrs_site_hierar_rec is RECORD (

Line 1263: l_cluster_name local_rrs_site_cluster_tab;

1259: TYPE local_rrs_site_cluster_rec is RECORD (
1260: cluster_name rrs_site_groups_tl.name%TYPE
1261: );
1262: Type local_rrs_site_cluster_tab is table of local_rrs_site_cluster_rec;
1263: l_cluster_name local_rrs_site_cluster_tab;
1264:
1265:
1266: TYPE local_rrs_site_hierar_rec is RECORD (
1267: hierarchy_name rrs_site_groups_tl.name%TYPE,

Line 1402: x_site_cluster_tab := rrs_site_cluster_tab();

1398: WHERE curVer.SITE_GROUP_ID = SiteGroupMemberEO.SITE_GROUP_ID)
1399: AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1400: AND DELETED_FLAG = 'N';
1401:
1402: x_site_cluster_tab := rrs_site_cluster_tab();
1403: if l_cluster_name.count > 0 then
1404: FOR i in l_cluster_name.First..l_cluster_name.Last LOOP
1405: x_site_cluster_tab.Extend();
1406: x_site_cluster_tab(i) := rrs_site_cluster_rec(l_cluster_name(i).cluster_name