DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_SITE_PHONE_TAB

Line 71: CREATE TYPE RRS_SITE_PHONE_TAB IS TABLE OF RRS_SITE_PHONE_REC;

67: CREATE TYPE RRS_RELATIONSHIP_TAB IS TABLE OF RRS_RELATIONSHIP_REC;
68:
69:
70:


71: CREATE TYPE RRS_SITE_PHONE_TAB IS TABLE OF RRS_SITE_PHONE_REC;
72:

73:
74:

75: CREATE TYPE RRS_SITE_EMAIL_TAB IS TABLE OF RRS_SITE_EMAIL_REC;

Line 157: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

153: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
154: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
155: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
156: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
157: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
158: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
159: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
160: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
161: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab

Line 399: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

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
403: );