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_party_site_address_tab OUT NOCOPY rrs_site_address_tab
13: ,x_property_tab OUT NOCOPY rrs_property_tab
14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
15: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

Line 34: x_site_uses_tab rrs_site_uses_tab;

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

Line 120: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

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

Line 208: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;

204: status_code_meaning rrs_lookups_v.meaning%TYPE,
205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
207: );
208: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
209: site_use_rec_details local_rrs_site_uses_tab;
210:
211: l_site_use_id number;
212: l_site_use_type_code varchar2(30);

Line 209: site_use_rec_details local_rrs_site_uses_tab;

205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE
206: -- is_primary_flag_meaning rrs_lookups_v.meaning%Type
207: );
208: TYPE local_rrs_site_uses_tab IS TABLE OF local_rrs_site_use_rec;
209: site_use_rec_details local_rrs_site_uses_tab;
210:
211: l_site_use_id number;
212: l_site_use_type_code varchar2(30);
213: l_status_code varchar2(30);

Line 400: x_site_uses_tab := rrs_site_uses_tab();

396: and LKUP3.LOOKUP_CODE = SiteUseEO.STATUS_CODE
397: AND RSB.SITE_ID = l_site_id ;
398:
399:
400: x_site_uses_tab := rrs_site_uses_tab();
401: if site_use_rec_details.count > 0 then
402: FOR i in site_use_rec_details.First..site_use_rec_details.Last LOOP
403: x_site_uses_tab.Extend();
404: x_site_uses_tab(i) := rrs_site_uses_rec(site_use_rec_details(i).site_id