eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on RRS_SITE_USES

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 191: site_id rrs_site_uses.site_id%TYPE,

187: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
188: l_site_address_details local_rrs_site_address_tab;
189:
190: TYPE local_rrs_site_use_rec is RECORD (
191: site_id rrs_site_uses.site_id%TYPE,
192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,

Line 192: site_use_id rrs_site_uses.site_use_id%TYPE,

188: l_site_address_details local_rrs_site_address_tab;
189:
190: TYPE local_rrs_site_use_rec is RECORD (
191: site_id rrs_site_uses.site_id%TYPE,
192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
196: status_code_meaning rrs_lookups_v.meaning%TYPE,

Line 193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,

189:
190: TYPE local_rrs_site_use_rec is RECORD (
191: site_id rrs_site_uses.site_id%TYPE,
192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
196: status_code_meaning rrs_lookups_v.meaning%TYPE,
197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE

Line 195: status_code rrs_site_uses.status_code%TYPE,

191: site_id rrs_site_uses.site_id%TYPE,
192: site_use_id rrs_site_uses.site_use_id%TYPE,
193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
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: );

Line 197: is_primary_flag rrs_site_uses.is_primary_flag%TYPE

193: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
194: site_use_type_code_meaning ar_lookups.meaning%Type,
195: status_code rrs_site_uses.status_code%TYPE,
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;

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 364: FROM RRS_SITE_USES SiteUseEO,

360: SiteUseEO.IS_PRIMARY_FLAG
361: --,LKUP2.MEANING AS IS_PRIMARY_FLAG_MEANING
362: BULK COLLECT
363: INTO site_use_rec_details
364: FROM RRS_SITE_USES SiteUseEO,
365: RRS_SITES_B RSB,
366: HZ_PARTY_SITE_USES HPSU,
367: AR_LOOKUPS LKUP1
368: -- ,RRS_LOOKUPS_V LKUP2

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

Line 386: x_site_uses_tab(i) := rrs_site_uses_rec(site_use_rec_details(i).site_id

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
387: ,site_use_rec_details(i).site_use_id
388: ,site_use_rec_details(i).site_use_type_code
389: ,site_use_rec_details(i).site_use_type_code_meaning
390: ,site_use_rec_details(i).status_code

Line 597: FROM RRS_SITE_USES

593: AND eoab.attr_group_id = ext.attr_group_id
594: AND eoab.classification_code IN
595: (
596: SELECT SITE_USE_TYPE_CODE
597: FROM RRS_SITE_USES
598: WHERE SITE_ID = l_site_id
599: );
600:
601:

Line 614: FROM RRS_SITE_USES

610: AND fo.obj_name in ( 'RRS_SITE')
611: AND eoab.classification_code IN
612: (
613: SELECT SITE_USE_TYPE_CODE
614: FROM RRS_SITE_USES
615: WHERE SITE_ID = l_site_id
616: );
617: */
618:

Line 633: FROM RRS_SITE_USES

629: AND DISPLAY_NAME = p_page_name
630: AND CLASSIFICATION_CODE IN
631: (
632: SELECT SITE_USE_TYPE_CODE
633: FROM RRS_SITE_USES
634: WHERE SITE_ID = l_site_id
635: )
636: ORDER BY SEQUENCE;
637: Exception