DBA Data[Home] [Help]

APPS.IGS_OR_PHONES_PKG dependencies on HZ_CONTACT_POINTS

Line 124: SELECT hz_contact_points_s.NEXTVAL

120: x_owner_table := g_parties;
121: x_owner_table_id := x_party_id;
122:
123: -- Get the value for the x_phone_id from the Sequence
124: SELECT hz_contact_points_s.NEXTVAL
125: INTO x_phone_id
126: FROM dual;
127:
128: IF (x_orig_system_reference IS NULL) THEN

Line 275: l_obj_ver hz_contact_points.object_version_number%TYPE;

271: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
272: telex_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type;
273: web_rec HZ_CONTACT_POINT_V2PUB.web_rec_type;
274: cpoint_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
275: l_obj_ver hz_contact_points.object_version_number%TYPE;
276:
277: tmp_var VARCHAR2(2000);
278: tmp_var1 VARCHAR2(2000);
279: