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 1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

1652: l_site_party_dets local_rrs_site_address_tab;
1653:
1654:
1655: TYPE local_rrs_site_phone_rec is RECORD (
1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

Line 1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

1653:
1654:
1655: TYPE local_rrs_site_phone_rec is RECORD (
1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

Line 1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,

1654:
1655: TYPE local_rrs_site_phone_rec is RECORD (
1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

Line 1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

1655: TYPE local_rrs_site_phone_rec is RECORD (
1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,

Line 1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

1656: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,

Line 1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

1657: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,

Line 1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

1658: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,

Line 1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,

1659: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,

Line 1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,

1660: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,

Line 1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,

1661: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,

Line 1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,

1662: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,
1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,

Line 1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,

1663: PHONE_CALLING_CALENDAR HZ_CONTACT_POINTS.PHONE_CALLING_CALENDAR%Type,
1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,

Line 1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,

1664: LAST_CONTACT_DT_TIME HZ_CONTACT_POINTS.LAST_CONTACT_DT_TIME%Type,
1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,

Line 1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,

1665: PHONE_PREFERRED_ORDER HZ_CONTACT_POINTS.PHONE_PREFERRED_ORDER%Type,
1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,

Line 1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,

1666: PRIORITY_OF_USE_CODE HZ_CONTACT_POINTS.PRIORITY_OF_USE_CODE%Type,
1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,

Line 1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,

1667: TELEPHONE_TYPE HZ_CONTACT_POINTS.TELEPHONE_TYPE%Type,
1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

Line 1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,

1668: TIME_ZONE HZ_CONTACT_POINTS.TIME_ZONE%Type,
1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,

Line 1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,

1669: PHONE_TOUCH_TONE_TYPE_FLAG HZ_CONTACT_POINTS.PHONE_TOUCH_TONE_TYPE_FLAG%Type,
1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,

Line 1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,

1670: PHONE_AREA_CODE HZ_CONTACT_POINTS.PHONE_AREA_CODE%Type,
1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,

Line 1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

1671: PHONE_COUNTRY_CODE HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%Type,
1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,

1672: PHONE_NUMBER HZ_CONTACT_POINTS.PHONE_NUMBER%Type,
1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,

1673: PHONE_EXTENSION HZ_CONTACT_POINTS.PHONE_EXTENSION%Type,
1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

Line 1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );

Line 1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );
1684: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;

Line 1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );
1684: TYPE local_rrs_site_phone_tab IS TABLE OF local_rrs_site_phone_rec;
1685: l_phone_details local_rrs_site_phone_tab;

Line 1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type
1683: );
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:

Line 1689: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

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

Line 1690: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

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

Line 1691: STATUS HZ_CONTACT_POINTS.STATUS%Type,

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,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,

Line 1692: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

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,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,

Line 1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

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,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%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,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,

1691: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1692: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1699: MEANING FND_LOOKUP_VALUES.MEANING%Type,

Line 1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,

1692: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1699: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1700: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

Line 1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1693: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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

Line 1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1694: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1695: EMAIL_FORMAT HZ_CONTACT_POINTS.EMAIL_FORMAT%Type,
1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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: );

Line 1700: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type,

1696: EMAIL_ADDRESS HZ_CONTACT_POINTS.EMAIL_ADDRESS%Type,
1697: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1698: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
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;

Line 1701: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

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

Line 1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,

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,
1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

Line 1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,

1705:
1706:
1707: TYPE local_rrs_site_url_rec is RECORD (
1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

Line 1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,

1706:
1707: TYPE local_rrs_site_url_rec is RECORD (
1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,

Line 1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,

1707: TYPE local_rrs_site_url_rec is RECORD (
1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,

Line 1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,

1708: CONTACT_POINT_ID HZ_CONTACT_POINTS.CONTACT_POINT_ID%Type,
1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

Line 1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,

1709: CONTACT_POINT_TYPE HZ_CONTACT_POINTS.CONTACT_POINT_TYPE%Type,
1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,

Line 1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,

1710: STATUS HZ_CONTACT_POINTS.STATUS%Type,
1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

Line 1715: URL HZ_CONTACT_POINTS.URL%Type,

1711: OWNER_TABLE_NAME HZ_CONTACT_POINTS.OWNER_TABLE_NAME%Type,
1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

Line 1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,

1712: OWNER_TABLE_ID HZ_CONTACT_POINTS.OWNER_TABLE_ID%Type,
1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

Line 1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,

1713: PRIMARY_FLAG HZ_CONTACT_POINTS.PRIMARY_FLAG%Type,
1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,

Line 1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,

1714: WEB_TYPE HZ_CONTACT_POINTS.WEB_TYPE%Type,
1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,

Line 1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,

1715: URL HZ_CONTACT_POINTS.URL%Type,
1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type

Line 1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,

1716: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );

Line 1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,

1717: APPLICATION_ID HZ_CONTACT_POINTS.APPLICATION_ID%Type,
1718: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );
1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;

Line 1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type

1719: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1720: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1721: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type,
1722: MEANING FND_LOOKUP_VALUES.MEANING%Type,
1723: ATTRIBUTE_CATEGORY HZ_CONTACT_POINTS.ATTRIBUTE_CATEGORY%Type
1724: );
1725: TYPE local_rrs_site_url_tab IS TABLE OF local_rrs_site_url_rec;
1726: l_url_details local_rrs_site_url_tab;
1727:

Line 1895: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO

1891: HzPuiContactPointPhoneEO.ACTUAL_CONTENT_SOURCE
1892: BULK COLLECT
1893: INTO l_phone_details
1894: FROM
1895: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1896: ,FND_TIMEZONES_VL Ftv
1897: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1898: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1899: AND Ftv.ENABLED_FLAG(+) = 'Y'

Line 1957: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,

1953: HzPuiContactPointEmailEO.ATTRIBUTE_CATEGORY,
1954: HzPuiContactPointEmailEO.ACTUAL_CONTENT_SOURCE
1955: BULK COLLECT
1956: INTO l_email_details
1957: FROM HZ_CONTACT_POINTS HzPuiContactPointEmailEO,
1958: fnd_lookup_values al
1959: WHERE HzPuiContactPointEmailEO.CONTACT_POINT_TYPE ='EMAIL'
1960: and HzPuiContactPointEmailEO.STATUS = 'A'
1961: and al.view_application_id(+) = 222

Line 2011: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,

2007: AL.MEANING USAGE,
2008: HzPuiContactPointUrlEO.ATTRIBUTE_CATEGORY
2009: BULK COLLECT
2010: INTO l_url_details
2011: FROM HZ_CONTACT_POINTS HzPuiContactPointUrlEO,
2012: fnd_lookup_values al
2013: WHERE HzPuiContactPointUrlEO.CONTACT_POINT_TYPE ='WEB'
2014: and HzPuiContactPointUrlEO.STATUS = 'A'
2015: and al.view_application_id(+) = 222