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

195: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
196: l_site_address_details local_rrs_site_address_tab;
197:
198: TYPE local_rrs_site_use_rec is RECORD (
199: site_id rrs_site_uses.site_id%TYPE,
200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,

Line 200: site_use_id rrs_site_uses.site_use_id%TYPE,

196: l_site_address_details local_rrs_site_address_tab;
197:
198: TYPE local_rrs_site_use_rec is RECORD (
199: site_id rrs_site_uses.site_id%TYPE,
200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
204: status_code_meaning rrs_lookups_v.meaning%TYPE,

Line 201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,

197:
198: TYPE local_rrs_site_use_rec is RECORD (
199: site_id rrs_site_uses.site_id%TYPE,
200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
204: status_code_meaning rrs_lookups_v.meaning%TYPE,
205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE

Line 203: status_code rrs_site_uses.status_code%TYPE,

199: site_id rrs_site_uses.site_id%TYPE,
200: site_use_id rrs_site_uses.site_use_id%TYPE,
201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
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: );

Line 205: is_primary_flag rrs_site_uses.is_primary_flag%TYPE

201: site_use_type_code rrs_site_uses.site_use_type_code%TYPE,
202: site_use_type_code_meaning ar_lookups.meaning%Type,
203: status_code rrs_site_uses.status_code%TYPE,
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;

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

378: SiteUseEO.IS_PRIMARY_FLAG
379: --,LKUP2.MEANING AS IS_PRIMARY_FLAG_MEANING
380: BULK COLLECT
381: INTO site_use_rec_details
382: FROM RRS_SITE_USES SiteUseEO,
383: RRS_SITES_B RSB,
384: HZ_PARTY_SITE_USES HPSU,
385: AR_LOOKUPS LKUP1
386: -- ,RRS_LOOKUPS_V LKUP2

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

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

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
405: ,site_use_rec_details(i).site_use_id
406: ,site_use_rec_details(i).site_use_type_code
407: ,site_use_rec_details(i).site_use_type_code_meaning
408: ,site_use_rec_details(i).status_code

Line 615: FROM RRS_SITE_USES

611: AND eoab.attr_group_id = ext.attr_group_id
612: AND eoab.classification_code IN
613: (
614: SELECT SITE_USE_TYPE_CODE
615: FROM RRS_SITE_USES
616: WHERE SITE_ID = l_site_id
617: );
618:
619:

Line 632: FROM RRS_SITE_USES

628: AND fo.obj_name in ( 'RRS_SITE')
629: AND eoab.classification_code IN
630: (
631: SELECT SITE_USE_TYPE_CODE
632: FROM RRS_SITE_USES
633: WHERE SITE_ID = l_site_id
634: );
635: */
636:

Line 651: FROM RRS_SITE_USES

647: AND DISPLAY_NAME = p_page_name
648: AND CLASSIFICATION_CODE IN
649: (
650: SELECT SITE_USE_TYPE_CODE
651: FROM RRS_SITE_USES
652: WHERE SITE_ID = l_site_id
653: )
654: ORDER BY SEQUENCE;
655: Exception