161: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
162: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
163: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
164: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
165: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
166: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
167: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
163: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab
164: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab
165: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
166: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
167: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
170: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
171: );
165: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
166: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
167: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
170: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
171: );
172:
173:
224:
225: Procedure Get_site_complete_attributes(
226: p_site_id_num IN varchar2
227: ,p_site_name IN varchar2 Default null
228: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
232: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
226: p_site_id_num IN varchar2
227: ,p_site_name IN varchar2 Default null
228: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
232: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
233: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
234: );
228: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
232: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
233: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
234: );
235:
236:
257: Procedure Get_site_attributes(
258: p_site_id_num IN varchar2
259: ,p_site_name IN varchar2 Default null
260: ,p_page_name IN varchar2 Default null
261: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
262: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
263: );
264:
265:
285: Procedure Get_location_attributes(
286: p_site_id_num IN varchar2
287: ,p_site_name IN varchar2 Default null
288: ,p_page_name IN varchar2 Default null
289: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
290: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
291: );
292:
293: --
312: Procedure Get_trade_area_attributes(
313: p_site_id_num IN varchar2
314: ,p_site_name IN varchar2 Default null
315: ,p_page_name IN varchar2 Default null
316: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
317: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
318: );
319:
320: