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_ADDRESS_TAB

Line 10: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

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
14: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

Line 12: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab

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
16: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab

Line 33: x_site_address_tab rrs_site_address_tab;

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

Line 119: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

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:
123: l_site_id number;

Line 195: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

191: geometry_source_meaning rrs_lookups_v.meaning%Type,
192: longitude number,
193: latitude number
194: );
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,

Line 196: l_site_address_details local_rrs_site_address_tab;

192: longitude number,
193: latitude number
194: );
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,

Line 346: x_site_address_tab := rrs_site_address_tab();

342: WHERE HL.COUNTRY = FTV.TERRITORY_CODE
343: AND HL.LOCATION_ID = l_location_id;
344:
345:
346: x_site_address_tab := rrs_site_address_tab();
347: if l_site_address_details.count > 0 then
348: FOR i in l_site_address_details.First..l_site_address_details.Last LOOP
349: x_site_address_tab.Extend();
350: x_site_address_tab(i) := rrs_site_address_rec(l_site_address_details(i).address1

Line 1624: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab

1620:
1621: Procedure Get_site_contacts(
1622: p_site_id_num IN varchar2
1623: ,p_site_name IN varchar2 Default null
1624: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
1625: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1626: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1627: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1628: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab

Line 1651: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

1647: address varchar2(1000),
1648: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
1649: site_purpose ar_lookups.meaning%type --Bug 7871825
1650: );
1651: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1652: l_site_party_dets local_rrs_site_address_tab;
1653:
1654:
1655: TYPE local_rrs_site_phone_rec is RECORD (

Line 1652: l_site_party_dets local_rrs_site_address_tab;

1648: identifying_address_flag hz_party_sites.identifying_address_flag%Type,
1649: site_purpose ar_lookups.meaning%type --Bug 7871825
1650: );
1651: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1652: l_site_party_dets local_rrs_site_address_tab;
1653:
1654:
1655: TYPE local_rrs_site_phone_rec is RECORD (
1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1761: x_party_site_address_tab := rrs_site_address_tab();

1757:
1758:
1759: begin
1760:
1761: x_party_site_address_tab := rrs_site_address_tab();
1762:
1763: begin
1764: Select RSB.SITE_ID,
1765: RSB.SITE_PARTY_ID