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_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

Line 32: x_site_address_tab rrs_site_address_tab;

28: ,x_tr_area_attrib_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
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

Line 115: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

111: Procedure Get_site_details(
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;

Line 187: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

183: country_name fnd_territories_vl.territory_short_name%Type,
184: address varchar2(1000),
185: identifying_address_flag hz_party_sites.identifying_address_flag%Type
186: );
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,

Line 188: l_site_address_details local_rrs_site_address_tab;

184: address varchar2(1000),
185: identifying_address_flag hz_party_sites.identifying_address_flag%Type
186: );
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,

Line 333: x_site_address_tab := rrs_site_address_tab();

329: WHERE COUNTRY = FTV.TERRITORY_CODE
330: AND LOCATION_ID = l_location_id;
331:
332:
333: x_site_address_tab := rrs_site_address_tab();
334: if l_site_address_details.count > 0 then
335: FOR i in l_site_address_details.First..l_site_address_details.Last LOOP
336: x_site_address_tab.Extend();
337: x_site_address_tab(i) := rrs_site_address_rec(l_site_address_details(i).address1

Line 1557: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

1553:
1554: Procedure Get_site_contacts(
1555: p_site_id_num IN varchar2
1556: ,p_site_name IN varchar2 Default null
1557: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
1558: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1559: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1560: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1561: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab

Line 1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;

1579: country_name fnd_territories_vl.territory_short_name%Type,
1580: address varchar2(1000),
1581: identifying_address_flag hz_party_sites.identifying_address_flag%Type
1582: );
1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1584: l_site_party_dets local_rrs_site_address_tab;
1585:
1586:
1587: TYPE local_rrs_site_phone_rec is RECORD (

Line 1584: l_site_party_dets local_rrs_site_address_tab;

1580: address varchar2(1000),
1581: identifying_address_flag hz_party_sites.identifying_address_flag%Type
1582: );
1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1584: l_site_party_dets local_rrs_site_address_tab;
1585:
1586:
1587: TYPE local_rrs_site_phone_rec is RECORD (
1588: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1757: x_site_address_tab := rrs_site_address_tab();

1753: WHERE COUNTRY = FTV.TERRITORY_CODE
1754: AND HL.LOCATION_ID = HPS.LOCATION_ID
1755: AND HPS.PARTY_ID = l_site_party_id;
1756:
1757: x_site_address_tab := rrs_site_address_tab();
1758: FOR i in l_site_party_dets.First..l_site_party_dets.Last LOOP
1759: x_site_address_tab.Extend();
1760: x_site_address_tab(i) := rrs_site_address_rec(l_site_party_dets(i).address1
1761: ,l_site_party_dets(i).address2