47: CREATE TYPE RRS_SITE_ADDRESS_TAB IS TABLE OF RRS_SITE_ADDRESS_REC;
48:
49:
50:
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;
148: ,p_site_name IN varchar2 Default null
149: ,p_page_name IN varchar2 Default null
150: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
151: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
152: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
153: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
154: ,x_property_tab OUT NOCOPY rrs_property_tab
155: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
156: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
194: p_site_id_num IN varchar2
195: ,p_site_name IN varchar2 Default null
196: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
197: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
198: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
199: );
200:
201:
202: --