DBA Data[Home] [Help]

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 150: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

146: p_site_id_num IN varchar2
147: ,p_site_name IN varchar2 Default null
148: ,p_page_name IN varchar2 Default null
149: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
150: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
151: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
152: ,x_property_tab OUT NOCOPY rrs_property_tab
153: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
154: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab

Line 195: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

191: Procedure Get_site_details(
192: p_site_id_num IN varchar2
193: ,p_site_name IN varchar2 Default null
194: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab
195: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
196: ,x_site_uses_tab OUT NOCOPY rrs_site_uses_tab
197: );
198:
199:

Line 398: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab

394:
395: Procedure Get_site_contacts(
396: p_site_id_num IN varchar2
397: ,p_site_name IN varchar2 Default null
398: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
399: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
400: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
401: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
402: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab