DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_SITE_HEADER_TAB

Line 43: CREATE TYPE RRS_SITE_HEADER_TAB AS TABLE OF RRS_SITE_HEADER_REC;

39: Every procedure returns a collection with relevant information retrieved
40: from these procedures. These are the collections which are returned from
41: various procedures.
42:


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;

Line 150: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab

146: Procedure Get_complete_site_details(
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

Line 196: ,x_site_header_tab OUT NOCOPY rrs_site_header_tab

192:
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: