APPS.IGS_OR_CONTACTS_PKG dependencies on HZ_CONTACT_POINTS

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 458: -- Cursor for the email address from the HZ_CONTACT_POINTS

454: l_contact_point_id NUMBER(20);
455: tmp_var1 VARCHAR2(2000);
456: tmp_var VARCHAR2(2000);
457:
458: -- Cursor for the email address from the HZ_CONTACT_POINTS
459: CURSOR cur_hz_contact_pts(cp_contact_point_id NUMBER) IS
460: SELECT email_address
461: FROM hz_contact_points
462: WHERE contact_point_id = cp_contact_point_id;

Line 461: FROM hz_contact_points

457:
458: -- Cursor for the email address from the HZ_CONTACT_POINTS
459: CURSOR cur_hz_contact_pts(cp_contact_point_id NUMBER) IS
460: SELECT email_address
461: FROM hz_contact_points
462: WHERE contact_point_id = cp_contact_point_id;
463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;

Line 464: l_obj_ver hz_contact_points.object_version_number%TYPE;

460: SELECT email_address
461: FROM hz_contact_points
462: WHERE contact_point_id = cp_contact_point_id;
463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;
466: l_rel_obj_ver_num hz_org_contacts.object_version_number%TYPE;
467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;
468:

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' ;