APPS.AMS_REGISTRANTS_PVT dependencies on HZ_CONTACT_POINTS_S

Line 1166: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1162:
1163: -- Create contact points Phone
1164:
1165: if x_phone_number is not NULL and x_party_rel_party_id is not null then
1166: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1167: x_return_status := null;
1168: x_msg_count := null;
1169: x_msg_data := null;
1170: cpoint_rec.contact_point_id := x_contact_point_id;

Line 1233: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1229:
1230: -- Create contact points Email
1231:
1232: if x_email_address is not NULL and x_party_rel_party_id is not null then
1233: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1234:
1235: x_return_status := null;
1236: x_msg_count := null;
1237: x_msg_data := null;

Line 1660: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1656: -- ***************************************************8
1657: -- Create contact points Phone
1658:
1659: if x_phone_number is not NULL and x_per_party_id is not null then
1660: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1661:
1662: x_return_status := null;
1663: x_msg_count := null;
1664: x_msg_data := null;

Line 1731: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;

1727:
1728: -- Create contact points Email
1729:
1730: if x_email_address is not NULL and x_per_party_id is not null then
1731: SELECT hz_contact_points_s.nextval into x_contact_point_id from dual;
1732:
1733: x_return_status := null;
1734: x_msg_count := null;
1735: x_msg_data := null;