APPS.IGS_OR_CONTACTS_PKG dependencies on HZ_CONTACT_POINTS_S

Line 229: SELECT hz_contact_points_s.NEXTVAL

225:
226: END IF;
227: CLOSE cur_or_cntcts;
228:
229: SELECT hz_contact_points_s.NEXTVAL
230: INTO l_contact_point_id
231: FROM DUAL;
232:
233: -- Assign the values in the Contacts Record

Line 597: SELECT hz_contact_points_s.NEXTVAL

593: IF x_email_address IS NOT NULL THEN
594: cpoint_rec.primary_flag := 'Y';
595: email_rec.email_address := x_email_address;
596:
597: SELECT hz_contact_points_s.NEXTVAL
598: INTO cpoint_rec.contact_point_id
599: FROM dual;
600:
601: cpoint_rec.created_by_module := 'IGS' ;