DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on RRS_SITE_PHONE_REC

Line 1587: TYPE local_rrs_site_phone_rec is RECORD (

1583: TYPE local_rrs_site_address_tab IS TABLE OF local_rrs_site_address_rec;
1584: l_site_party_dets local_rrs_site_address_tab;
1585:
1586:
1587: TYPE local_rrs_site_phone_rec is RECORD (
1588: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1589: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1590: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1591: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

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 1825: x_site_phone_tab(i) := rrs_site_phone_rec(

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(
1826: l_phone_details(i).CONTACT_POINT_ID
1827: ,l_phone_details(i).CONTACT_POINT_TYPE
1828: ,l_phone_details(i).STATUS
1829: ,l_phone_details(i).OWNER_TABLE_NAME