eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RRS_SITE_INFO dependencies on HZ_CONTACT_POINTS

Line 1588: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

Line 1589: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

Line 1590: STATUS HZ_CONTACT_POINTS.STATUS%Type,

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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

Line 1591: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,

Line 1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,

Line 1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%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,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,

Line 1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

1590: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1591: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,

Line 1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,

1591: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,

Line 1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,

1592: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,

Line 1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,

1593: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,

Line 1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,

1594: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,

Line 1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,

1595: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,

Line 1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,

1596: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,

Line 1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,

1597: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,

Line 1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,

1598: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,

Line 1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,

1599: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

Line 1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,

1600: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,

Line 1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,

1601: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,

Line 1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,

1602: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,

Line 1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

1603: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,

1604: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1612: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,

1605: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1606: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1612: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1613: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

Line 1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1607: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
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: );

Line 1612: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1608: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
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;

Line 1613: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

1609: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
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;

Line 1614: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

1610: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1611: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
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:

Line 1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

1617: l_phone_details local_rrs_site_phone_tab;
1618:
1619:
1620: TYPE local_rrs_site_email_rec is RECORD (
1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

Line 1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

1618:
1619:
1620: TYPE local_rrs_site_email_rec is RECORD (
1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

Line 1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,

1619:
1620: TYPE local_rrs_site_email_rec is RECORD (
1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,

Line 1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

1620: TYPE local_rrs_site_email_rec is RECORD (
1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,

Line 1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

1621: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

1622: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,

1623: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1631: MEANING FND_LOOKUP_VALUES.MEANING%Type,

Line 1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,

1624: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1631: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1632: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

Line 1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1625: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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

Line 1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1626: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1627: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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: );

Line 1632: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

1628: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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;

Line 1633: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

1629: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1630: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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:

Line 1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

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,
1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

Line 1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

1637:
1638:
1639: TYPE local_rrs_site_url_rec is RECORD (
1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

Line 1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,

1638:
1639: TYPE local_rrs_site_url_rec is RECORD (
1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,

Line 1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

1639: TYPE local_rrs_site_url_rec is RECORD (
1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,

Line 1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

1640: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

Line 1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

1641: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,

Line 1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,

1642: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1647: URL HZ_CONTACT_POINTS.URL%Type,

1643: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

1644: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

Line 1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,

1645: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,

Line 1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1646: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,

Line 1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1647: URL HZ_CONTACT_POINTS.URL%Type,
1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type

Line 1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

1648: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );

Line 1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,

1649: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1650: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );
1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;

Line 1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type

1651: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1652: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1653: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1654: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1655: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1656: );
1657: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1658: l_url_details local_rrs_site_url_tab;
1659:

Line 1812: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO

1808: HzPuiContactPointPhoneEO.ACTUAL_CONTENT_SOURCE
1809: BULK COLLECT
1810: INTO l_phone_details
1811: FROM
1812: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1813: ,FND_TIMEZONES_VL Ftv
1814: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1815: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1816: AND Ftv.ENABLED_FLAG(+) = 'Y'

Line 1878: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,

1874: HzPuiContactPointEmailEO.ATTRIBUTE_CATEGORY,
1875: HzPuiContactPointEmailEO.ACTUAL_CONTENT_SOURCE
1876: BULK COLLECT
1877: INTO l_email_details
1878: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,
1879: fnd_lookup_values al
1880: WHERE HzPuiContactPointEmailEO.CONTACT_POINT_TYPE ='EMAIL'
1881: and HzPuiContactPointEmailEO.STATUS = 'A'
1882: and al.view_application_id(+) = 222

Line 1934: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,

1930: AL.MEANING USAGE,
1931: HzPuiContactPointUrlEO.ATTRIBUTE_CATEGORY
1932: BULK COLLECT
1933: INTO l_url_details
1934: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,
1935: fnd_lookup_values al
1936: WHERE HzPuiContactPointUrlEO.CONTACT_POINT_TYPE ='WEB'
1937: and HzPuiContactPointUrlEO.STATUS = 'A'
1938: and al.view_application_id(+) = 222