75: CREATE TYPE RRS_SITE_EMAIL_TAB IS TABLE OF RRS_SITE_EMAIL_REC;
76:
77:
78:
79: CREATE TYPE RRS_SITE_URL_TAB IS TABLE OF RRS_SITE_URL_REC;
80:
81:
82:
83: CREATE TYPE RRS_SITE_PERSON_TAB IS TABLE OF RRS_SITE_PERSON_REC;
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
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
397: ,p_site_name IN varchar2 Default null
398: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
399: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
400: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
401: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
402: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
403: );
404:
405: