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.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CONTACT_POINTS

Line 1543: l_contact_point_id hz_contact_points.contact_point_id%type;

1539: p_contact_party_id in varchar2)
1540: ---------------------------------------------------------------------------
1541: IS
1542:
1543: l_contact_point_id hz_contact_points.contact_point_id%type;
1544: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

Line 1545: l_email_format HZ_CONTACT_POINTS.email_format%type;

1541: IS
1542:
1543: l_contact_point_id hz_contact_points.contact_point_id%type;
1544: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;

Line 1546: l_email_address HZ_CONTACT_POINTS.email_address%type;

1542:
1543: l_contact_point_id hz_contact_points.contact_point_id%type;
1544: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;

Line 1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

1543: l_contact_point_id hz_contact_points.contact_point_id%type;
1544: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

Line 1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;

1544: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;

Line 1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;

1545: l_email_format HZ_CONTACT_POINTS.email_format%type;
1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1553:

Line 1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;

1546: l_email_address HZ_CONTACT_POINTS.email_address%type;
1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1553:
1554: l_profile_id number;

Line 1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

1547: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1553:
1554: l_profile_id number;
1555: l_cust_site_use_id NUMBER;

Line 1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;

1548: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1549: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1550: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1551: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1552: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1553:
1554: l_profile_id number;
1555: l_cust_site_use_id NUMBER;
1556:

Line 1631: FROM hz_contact_points

1627: l_contact_point_id := null;
1628:
1629: SELECT contact_point_id
1630: INTO l_contact_point_id
1631: FROM hz_contact_points
1632: WHERE owner_table_id = p_contact_party_id
1633: AND owner_table_name = 'HZ_PARTIES'
1634: AND status = 'A'
1635: AND primary_flag = 'Y'

Line 1678: FROM HZ_CONTACT_POINTS

1674: END IF;
1675:
1676: SELECT object_version_number
1677: INTO l_object_version_number
1678: FROM HZ_CONTACT_POINTS
1679: WHERE contact_point_id = l_contact_point_id;
1680: ----------------------------------------------------------------------------
1681: l_debug_info := 'In CreateContactPointInternal l_object_version_number:'||l_object_version_number;
1682: ----------------------------------------------------------------------------

Line 1739: FROM hz_contact_points

1735: l_contact_point_id := null;
1736:
1737: SELECT contact_point_id
1738: INTO l_contact_point_id
1739: FROM hz_contact_points
1740: WHERE owner_table_id = p_contact_party_id
1741: AND owner_table_name = 'HZ_PARTIES'
1742: AND status = 'A'
1743: AND primary_flag = 'Y'

Line 1780: FROM HZ_CONTACT_POINTS

1776: END IF;
1777:
1778: SELECT object_version_number
1779: INTO l_object_version_number
1780: FROM HZ_CONTACT_POINTS
1781: WHERE contact_point_id = l_contact_point_id;
1782: ----------------------------------------------------------------------------
1783: l_debug_info := 'In CreateContactPointInternal l_object_version_number:' || l_object_version_number;
1784: ----------------------------------------------------------------------------