APPS.RRS_SITE_INFO dependencies on RRS_SITE_EMAIL_TAB

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

Line 1626: ,x_site_email_tab OUT NOCOPY rrs_site_email_tab

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

Line 1703: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;

1699: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1700: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1701: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1702: );
1703: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;
1704: l_email_details local_rrs_site_email_tab;
1705:
1706:
1707: TYPE local_rrs_site_url_rec is RECORD (

Line 1704: l_email_details local_rrs_site_email_tab;

1700: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1701: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1702: );
1703: TYPE local_rrs_site_email_tab IS TABLE OF local_rrs_site_email_rec;
1704: l_email_details local_rrs_site_email_tab;
1705:
1706:
1707: TYPE local_rrs_site_url_rec is RECORD (
1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

Line 1969: x_site_email_tab := rrs_site_email_tab();

1965: and (HzPuiContactPointEmailEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
1966: AND HzPuiContactPointEmailEO.OWNER_TABLE_ID = l_site_party_id)
1967: ORDER BY HzPuiContactPointEmailEO.PRIMARY_FLAG DESC, USAGE NULLS LAST, HzPuiContactPointEmailEO.PRIMARY_BY_PURPOSE DESC;
1968:
1969: x_site_email_tab := rrs_site_email_tab();
1970: if l_email_details.count > 0 then
1971: FOR i in l_email_details.First..l_email_details.Last LOOP
1972: x_site_email_tab.Extend();
1973: x_site_email_tab(i) := rrs_site_email_rec(