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 47: CREATE TYPE RRS_SITE_ADDRESS_TAB IS TABLE OF RRS_SITE_ADDRESS_REC;

43: CREATE TYPE RRS_SITE_HEADER_TAB AS TABLE OF RRS_SITE_HEADER_REC;
44:
45:
46:



47: 	CREATE TYPE  RRS_SITE_ADDRESS_TAB IS TABLE OF RRS_SITE_ADDRESS_REC;

48:

49:
50:



51: 	CREATE TYPE  RRS_SITE_USES_TAB IS TABLE OF RRS_SITE_USES_REC;


Line 151: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab


147: p_site_id_num IN varchar2

148: ,p_site_name IN varchar2 Default null

149: ,p_page_name IN varchar2 Default null

150: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab

151: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

152: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

153: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab

154: ,x_property_tab OUT NOCOPY rrs_property_tab

155: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab


Line 153: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab


149: ,p_page_name IN varchar2 Default null

150: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab

151: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

152: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

153: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab

154: ,x_property_tab OUT NOCOPY rrs_property_tab

155: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab

156: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

157: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab


Line 197: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab


193: Procedure Get_site_details(

194: p_site_id_num IN varchar2

195: ,p_site_name IN varchar2 Default null

196: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab

197: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

198: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab

199: );

200: 

201: 


Line 400: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab


396: 

397: Procedure Get_site_contacts(

398: p_site_id_num IN varchar2

399: ,p_site_name IN varchar2 Default null

400: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab

401: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

402: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab

403: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab

404: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab