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
167: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
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
167: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: );
170:
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
167: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
168: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
169: );
170:
171:
172: --
223: Procedure Get_site_complete_attributes(
224: p_site_id_num IN varchar2
225: ,p_site_name IN varchar2 Default null
226: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
227: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
228: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
225: ,p_site_name IN varchar2 Default null
226: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
227: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
228: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
232: );
233:
227: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
228: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
229: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
230: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
231: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
232: );
233:
234:
235: --
256: p_site_id_num IN varchar2
257: ,p_site_name IN varchar2 Default null
258: ,p_page_name IN varchar2 Default null
259: ,x_site_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
260: ,x_site_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
261: );
262:
263:
264: --
284: p_site_id_num IN varchar2
285: ,p_site_name IN varchar2 Default null
286: ,p_page_name IN varchar2 Default null
287: ,x_loc_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
288: ,x_loc_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
289: );
290:
291: --
292: -- Get_trade_area_attributes (PUBLIC)
311: p_site_id_num IN varchar2
312: ,p_site_name IN varchar2 Default null
313: ,p_page_name IN varchar2 Default null
314: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
315: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
316: );
317:
318:
319: --