DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on HZ_CONTACT_POINTS

Line 96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;

92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
98:
99: CURSOR c_chk_email_addr (cp_person_id hz_parties.party_id%TYPE)
100: IS

Line 185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;

181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
186: BEGIN
187:
188: IF g_cur_data.r_s_email_address IS NOT NULL THEN
189: p_contact_points_rec.contact_point_type := 'EMAIL';