APPS.RRS_SITE_INFO dependencies on RRS_SITE_USES_TAB

Line 11: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

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
14: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
15: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab

Line 33: x_site_uses_tab rrs_site_uses_tab;

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:
36: begin
37:

Line 116: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

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:
119: l_site_id number;
120: l_site_id_num varchar2(30);

Line 200: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;

196: status_code_meaning rrs_lookups_v.meaning%TYPE,
197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
199: );
200: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
201: site_use_rec_details local_rrs_site_uses_tab;
202:
203: l_site_use_id number;
204: l_site_use_type_code varchar2(30);

Line 201: site_use_rec_details local_rrs_site_uses_tab;

197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
198: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
199: );
200: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
201: site_use_rec_details local_rrs_site_uses_tab;
202:
203: l_site_use_id number;
204: l_site_use_type_code varchar2(30);
205: l_status_code varchar2(30);

Line 382: x_site_uses_tab := rrs_site_uses_tab();

378: and LKUP3.LOOKUP_CODE = SiteUseEO.STATUS_CODE
379: AND RSB.SITE_ID = l_site_id ;
380:
381:
382: x_site_uses_tab := rrs_site_uses_tab();
383: if site_use_rec_details.count > 0 then
384: FOR i in site_use_rec_details.First..site_use_rec_details.Last LOOP
385: x_site_uses_tab.Extend();
386: x_site_uses_tab(i) := rrs_site_uses_rec(site_use_rec_details(i).site_id