APPS.RRS_SITE_INFO dependencies on RRS_SITE_PHONE_TAB

Line 17: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

13: ,x_site_cluster_tab OUT NOCOPY rrs_site_cluster_tab
14: ,x_site_hierar_tab OUT NOCOPY rrs_site_hierar_tab
15: ,x_trade_area_grp_tab OUT NOCOPY rrs_trade_area_grp_tab
16: ,x_relationship_tab OUT NOCOPY rrs_relationship_tab
17: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
18: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
19: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
20: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
21: ,x_site_attachment_tab OUT NOCOPY rrs_site_attachment_tab

Line 1558: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

1554: Procedure Get_site_contacts(
1555: p_site_id_num IN varchar2
1556: ,p_site_name IN varchar2 Default null
1557: ,x_site_address_tab OUT NOCOPY rrs_site_address_tab
1558: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1559: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1560: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1561: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
1562: ) is

Line 1616: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;

1612: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1613: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1614: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1615: );
1616: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;
1617: l_phone_details local_rrs_site_phone_tab;
1618:
1619:
1620: TYPE local_rrs_site_email_rec is RECORD (

Line 1617: l_phone_details local_rrs_site_phone_tab;

1613: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1614: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1615: );
1616: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;
1617: l_phone_details local_rrs_site_phone_tab;
1618:
1619:
1620: TYPE local_rrs_site_email_rec is RECORD (
1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1821: x_site_phone_tab := rrs_site_phone_tab();

1817: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)
1818: );
1819:
1820:
1821: x_site_phone_tab := rrs_site_phone_tab();
1822: if l_phone_details.count > 0 then
1823: FOR i in l_phone_details.First..l_phone_details.Last LOOP
1824: x_site_phone_tab.Extend();
1825: x_site_phone_tab(i) := rrs_site_phone_rec(