[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_party_site_address_tab OUT NOCOPY rrs_site_address_tab
13: ,x_property_tab OUT NOCOPY rrs_property_tab
28: ,x_tr_area_attrib_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
29: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
30: ) is
31: /*
32: x_site_header_tab rrs_site_header_tab;
33: x_site_address_tab rrs_site_address_tab;
34: x_site_uses_tab rrs_site_uses_tab;
35: */
36:
114:
115: Procedure Get_site_details(
116: p_site_id_num IN varchar2
117: ,p_site_name IN varchar2 Default null
118: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
119: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
120: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
121: ) is
122:
169: end_date rrs_sites_b.end_date%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );
172:
173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
174: l_site_header_details local_rrs_site_header_tab;
175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
170: name rrs_sites_tl.name%TYPE
171: );
172:
173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
174: l_site_header_details local_rrs_site_header_tab;
175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
263: raise_application_error(-20101, ' Check the Site ID please');
264:
265: end;
266:
267: x_site_header_tab := rrs_site_header_tab();
268: x_site_header_tab.Extend();
269: x_site_header_tab(1) := rrs_site_header_rec(l_site_header_details(1).site_id
270: ,l_site_header_details(1).site_identification_number
271: ,l_site_header_details(1).site_type_code