[Home] [Help]
5: Procedure Get_complete_site_details(
6: p_site_id_num IN varchar2
7: ,p_site_name IN varchar2 Default null
8: ,p_page_name IN varchar2 Default null
9: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
10: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
11: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
12: ,x_property_tab OUT NOCOPY rrs_property_tab
13: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
27: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
28: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
29: ) is
30: /*
31: x_site_header_tab rrs_site_header_tab;
32: x_site_address_tab rrs_site_address_tab;
33: x_site_uses_tab rrs_site_uses_tab;
34: */
35:
110:
111: Procedure Get_site_details(
112: p_site_id_num IN varchar2
113: ,p_site_name IN varchar2 Default null
114: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
115: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
116: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
117: ) is
118:
165: end_date rrs_sites_b.end_date%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );
168:
169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
170: l_site_header_details local_rrs_site_header_tab;
171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
166: name rrs_sites_tl.name%TYPE
167: );
168:
169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
170: l_site_header_details local_rrs_site_header_tab;
171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
255: raise_application_error(-20101, ' Check the Site ID please');
256:
257: end;
258:
259: x_site_header_tab := rrs_site_header_tab();
260: x_site_header_tab.Extend();
261: x_site_header_tab(1) := rrs_site_header_rec(l_site_header_details(1).site_id
262: ,l_site_header_details(1).site_identification_number
263: ,l_site_header_details(1).site_type_code