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 1443: l_contact_point_id hz_contact_points.contact_point_id%type;

1439: p_contact_party_id in varchar2)
1440: ---------------------------------------------------------------------------
1441: IS
1442:
1443: l_contact_point_id hz_contact_points.contact_point_id%type;
1444: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

Line 1445: l_email_format HZ_CONTACT_POINTS.email_format%type;

1441: IS
1442:
1443: l_contact_point_id hz_contact_points.contact_point_id%type;
1444: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;

Line 1446: l_email_address HZ_CONTACT_POINTS.email_address%type;

1442:
1443: l_contact_point_id hz_contact_points.contact_point_id%type;
1444: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;

Line 1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

1443: l_contact_point_id hz_contact_points.contact_point_id%type;
1444: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

Line 1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;

1444: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;

Line 1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;

1445: l_email_format HZ_CONTACT_POINTS.email_format%type;
1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1453:

Line 1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;

1446: l_email_address HZ_CONTACT_POINTS.email_address%type;
1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1453:
1454: l_profile_id number;

Line 1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

1447: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1453:
1454: l_profile_id number;
1455: l_cust_site_use_id NUMBER;

Line 1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;

1448: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
1449: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
1450: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
1451: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
1452: l_object_version_number HZ_CONTACT_POINTS.object_version_number%type;
1453:
1454: l_profile_id number;
1455: l_cust_site_use_id NUMBER;
1456:

Line 1517: FROM hz_contact_points

1513: l_contact_point_id := null;
1514:
1515: SELECT contact_point_id
1516: INTO l_contact_point_id
1517: FROM hz_contact_points
1518: WHERE owner_table_id = p_contact_party_id
1519: AND owner_table_name = 'HZ_PARTIES'
1520: AND status = 'A'
1521: AND primary_flag = 'Y'

Line 1558: FROM HZ_CONTACT_POINTS

1554: END IF;
1555:
1556: SELECT object_version_number
1557: INTO l_object_version_number
1558: FROM HZ_CONTACT_POINTS
1559: WHERE contact_point_id = l_contact_point_id;
1560:
1561:
1562: HZ_CONTACT_POINT_V2PUB.update_contact_point (

Line 1614: FROM hz_contact_points

1610: l_contact_point_id := null;
1611:
1612: SELECT contact_point_id
1613: INTO l_contact_point_id
1614: FROM hz_contact_points
1615: WHERE owner_table_id = p_contact_party_id
1616: AND owner_table_name = 'HZ_PARTIES'
1617: AND status = 'A'
1618: AND primary_flag = 'Y'

Line 1655: FROM HZ_CONTACT_POINTS

1651: END IF;
1652:
1653: SELECT object_version_number
1654: INTO l_object_version_number
1655: FROM HZ_CONTACT_POINTS
1656: WHERE contact_point_id = l_contact_point_id;
1657:
1658: HZ_CONTACT_POINT_V2PUB.update_contact_point (
1659: p_contact_point_rec => l_contact_point_rec,