DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_SITE_CLUSTER_TAB

Line 55: CREATE TYPE RRS_SITE_CLUSTER_TAB IS TABLE OF RRS_SITE_CLUSTER_REC;

51: CREATE TYPE RRS_SITE_USES_TAB IS TABLE OF RRS_SITE_USES_REC;
52:
53:
54:


55: CREATE TYPE RRS_SITE_CLUSTER_TAB IS TABLE OF RRS_SITE_CLUSTER_REC;
56:

57:
58:

59: CREATE TYPE RRS_SITE_HIERAR_TAB IS TABLE OF RRS_SITE_HIERAR_REC;

Line 153: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

149: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
150: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
151: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
152: ,x_property_tab OUT NOCOPY rrs_property_tab
153: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
154: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
155: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
156: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
157: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

Line 344: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

340: Procedure Get_site_associations(
341: p_site_id_num IN varchar2
342: ,p_site_name IN varchar2 Default null
343: ,x_property_tab OUT NOCOPY rrs_property_tab
344: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
345: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
346: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
347: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
348: );