APPS.RRS_SITE_INFO dependencies on RRS_SITE_ADDRESS_REC

Line 172: TYPE local_rrs_site_address_rec is RECORD (

168:
169: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
170: l_site_header_details local_rrs_site_header_tab;
171:
172: TYPE local_rrs_site_address_rec is RECORD (
173: address1 hz_locations.address1%TYPE,
174: address2 hz_locations.address2%TYPE,
175: address3 hz_locations.address3%TYPE,
176: address4 hz_locations.address4%TYPE,

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 337: x_site_address_tab(i) := rrs_site_address_rec(l_site_address_details(i).address1

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
338: ,l_site_address_details(i).address2
339: ,l_site_address_details(i).address3
340: ,l_site_address_details(i).address4
341: ,l_site_address_details(i).city

Line 1568: TYPE local_rrs_site_address_rec is RECORD (

1564: l_site_id number;
1565: l_site_party_id number;
1566:
1567:
1568: TYPE local_rrs_site_address_rec is RECORD (
1569: address1 hz_locations.address1%TYPE,
1570: address2 hz_locations.address2%TYPE,
1571: address3 hz_locations.address3%TYPE,
1572: address4 hz_locations.address4%TYPE,

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 1760: x_site_address_tab(i) := rrs_site_address_rec(l_site_party_dets(i).address1

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
1762: ,l_site_party_dets(i).address3
1763: ,l_site_party_dets(i).address4
1764: ,l_site_party_dets(i).city