APPS.RRS_SITE_INFO dependencies on RRS_SITE_EMAIL_REC

Line 1688: TYPE local_rrs_site_email_rec is RECORD (

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,
1690: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1691: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1692: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

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 1973: x_site_email_tab(i) := rrs_site_email_rec(

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(
1974: l_email_details(i).CONTACT_POINT_ID
1975: ,l_email_details(i).CONTACT_POINT_TYPE
1976: ,l_email_details(i).STATUS
1977: ,l_email_details(i).OWNER_TABLE_NAME