APPS.RRS_SITE_INFO dependencies on RRS_SITE_EMAIL_TAB

Line 18: ,x_site_email_tab OUT NOCOPY rrs_site_email_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
22: ,x_site_asset_tab OUT NOCOPY rrs_site_asset_tab

Line 1559: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab

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

Line 1635: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;

1631: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1632: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1633: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1634: );
1635: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;
1636: l_email_details local_rrs_site_email_tab;
1637:
1638:
1639: TYPE local_rrs_site_url_rec is RECORD (

Line 1636: l_email_details local_rrs_site_email_tab;

1632: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1633: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1634: );
1635: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;
1636: l_email_details local_rrs_site_email_tab;
1637:
1638:
1639: TYPE local_rrs_site_url_rec is RECORD (
1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1891: x_site_email_tab := rrs_site_email_tab();

1887: AND HzPuiContactPointEmailEO.OWNER_TABLE_ID = l_site_party_id)
1888: ORDER BY HzPuiContactPointEmailEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointEmailEO.PRIMARY_BY_PURPOSE DESC;
1889:
1890:
1891: x_site_email_tab := rrs_site_email_tab();
1892: if l_email_details.count > 0 then
1893: FOR i in l_email_details.First..l_email_details.Last LOOP
1894: x_site_email_tab.Extend();
1895: x_site_email_tab(i) := rrs_site_email_rec(