APPS.RRS_SITE_INFO dependencies on RRS_SITE_CLUSTER_TAB

Line 14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_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_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

Line 1271: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

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

Line 1280: Type local_rrs_site_cluster_tab is table of local_rrs_site_cluster_rec;

1276:
1277: TYPE local_rrs_site_cluster_rec is RECORD (
1278: cluster_name rrs_site_groups_tl.name%TYPE
1279: );
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 (

Line 1281: l_cluster_name local_rrs_site_cluster_tab;

1277: TYPE local_rrs_site_cluster_rec is RECORD (
1278: cluster_name rrs_site_groups_tl.name%TYPE
1279: );
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,

Line 1421: x_site_cluster_tab := rrs_site_cluster_tab();

1417: WHERE curVer.SITE_GROUP_ID = SiteGroupMemberEO.SITE_GROUP_ID)
1418: AND SiteGroupMemberEO.CHILD_MEMBER_ID = l_site_id
1419: AND DELETED_FLAG = 'N';
1420:
1421: x_site_cluster_tab := rrs_site_cluster_tab();
1422: if l_cluster_name.count > 0 then
1423: FOR i in l_cluster_name.First..l_cluster_name.Last LOOP
1424: x_site_cluster_tab.Extend();
1425: x_site_cluster_tab(i) := rrs_site_cluster_rec(l_cluster_name(i).cluster_name