87: CREATE TYPE RRS_SITE_ATTACHMENT_TAB IS TABLE OF RRS_SITE_ATTACHMENT_REC;
88:
89:
90:
91: CREATE TYPE RRS_SITE_ASSET_TAB IS TABLE OF RRS_SITE_ASSET_REC;
92:
93:
94:
95: CREATE TYPE RRS_PROPERTY_TAB IS TABLE OF RRS_PROPERTY_REC;
158: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
159: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
160: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
161: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
162: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
163: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
164: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
165: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
166: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
422:
423: Procedure Get_site_assets(
424: p_site_id_num IN varchar2
425: ,p_site_name IN varchar2 Default null
426: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
427: );
428:
429: end RRS_SITE_INFO;