APPS.UMX_REGISTER_USER_PVT dependencies on HZ_CONTACT_POINTS

Line 97: l_contact_point_id hz_contact_points.contact_point_id%type;

93: p_contact_party_id in varchar2)
94: IS
95:
96:
97: l_contact_point_id hz_contact_points.contact_point_id%type;
98: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
99: l_email_format HZ_CONTACT_POINTS.email_format%type;
100: l_email_address HZ_CONTACT_POINTS.email_address%type;
101: --initially this was raw phone num changed to phone_number

Line 99: l_email_format HZ_CONTACT_POINTS.email_format%type;

95:
96:
97: l_contact_point_id hz_contact_points.contact_point_id%type;
98: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
99: l_email_format HZ_CONTACT_POINTS.email_format%type;
100: l_email_address HZ_CONTACT_POINTS.email_address%type;
101: --initially this was raw phone num changed to phone_number
102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

Line 100: l_email_address HZ_CONTACT_POINTS.email_address%type;

96:
97: l_contact_point_id hz_contact_points.contact_point_id%type;
98: l_contact_preference_id hz_contact_preferences.contact_preference_id%type;
99: l_email_format HZ_CONTACT_POINTS.email_format%type;
100: l_email_address HZ_CONTACT_POINTS.email_address%type;
101: --initially this was raw phone num changed to phone_number
102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;

Line 103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;

99: l_email_format HZ_CONTACT_POINTS.email_format%type;
100: l_email_address HZ_CONTACT_POINTS.email_address%type;
101: --initially this was raw phone num changed to phone_number
102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

Line 104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;

100: l_email_address HZ_CONTACT_POINTS.email_address%type;
101: --initially this was raw phone num changed to phone_number
102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;

Line 105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;

101: --initially this was raw phone num changed to phone_number
102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;
109:

Line 106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;

102: -- bug #3483248
103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;
109:
110:

Line 107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;

103: l_primary_phone HZ_CONTACT_POINTS.phone_number%type;
104: l_area_code HZ_CONTACT_POINTS.phone_area_code%type;
105: l_country_code HZ_CONTACT_POINTS.phone_country_code%type;
106: l_phone_purpose HZ_CONTACT_POINTS.contact_point_purpose%type;
107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;