APPS.RRS_SITE_INFO dependencies on RRS_SITE_PHONE_TAB

Line 18: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

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

Line 1625: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab

1621: Procedure Get_site_contacts(
1622: p_site_id_num IN varchar2
1623: ,p_site_name IN varchar2 Default null
1624: ,x_party_site_address_tab OUT NOCOPY rrs_site_address_tab
1625: ,x_site_phone_tab OUT NOCOPY rrs_site_phone_tab
1626: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab
1627: ,x_site_url_tab OUT NOCOPY rrs_site_url_tab
1628: ,x_site_person_tab OUT NOCOPY rrs_site_person_tab
1629: ) is

Line 1684: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;

1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );
1684: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;
1685: l_phone_details local_rrs_site_phone_tab;
1686:
1687:
1688: TYPE local_rrs_site_email_rec is RECORD (

Line 1685: l_phone_details local_rrs_site_phone_tab;

1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );
1684: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;
1685: l_phone_details local_rrs_site_phone_tab;
1686:
1687:
1688: TYPE local_rrs_site_email_rec is RECORD (
1689: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1903: x_site_phone_tab := rrs_site_phone_tab();

1899: AND Ftv.ENABLED_FLAG(+) = 'Y'
1900: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)
1901: );
1902:
1903: x_site_phone_tab := rrs_site_phone_tab();
1904: if l_phone_details.count > 0 then
1905: FOR i in l_phone_details.First..l_phone_details.Last LOOP
1906: x_site_phone_tab.Extend();
1907: x_site_phone_tab(i) := rrs_site_phone_rec(