APPS.RRS_SITE_INFO dependencies on RRS_SITE_ADDRESS_REC

Line 176: TYPE local_rrs_site_address_rec is RECORD (

172:
173: TYPE local_rrs_site_header_tab IS TABLE OF local_rrs_site_header_rec;
174: l_site_header_details local_rrs_site_header_tab;
175:
176: TYPE local_rrs_site_address_rec is RECORD (
177: address1 hz_locations.address1%TYPE,
178: address2 hz_locations.address2%TYPE,
179: address3 hz_locations.address3%TYPE,
180: address4 hz_locations.address4%TYPE,

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

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
351: ,l_site_address_details(i).address2
352: ,l_site_address_details(i).address3
353: ,l_site_address_details(i).address4
354: ,l_site_address_details(i).city

Line 1635: TYPE local_rrs_site_address_rec is RECORD (

1631: l_site_id number;
1632: l_site_party_id number;
1633:
1634:
1635: TYPE local_rrs_site_address_rec is RECORD (
1636: address1 hz_locations.address1%TYPE,
1637: address2 hz_locations.address2%TYPE,
1638: address3 hz_locations.address3%TYPE,
1639: address4 hz_locations.address4%TYPE,

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

1833:
1834:
1835: FOR i in l_site_party_dets.First..l_site_party_dets.Last LOOP
1836: x_party_site_address_tab.Extend();
1837: x_party_site_address_tab(i) := rrs_site_address_rec(l_site_party_dets(i).address1
1838: ,l_site_party_dets(i).address2
1839: ,l_site_party_dets(i).address3
1840: ,l_site_party_dets(i).address4
1841: ,l_site_party_dets(i).city