24: BEGIN
25:
26: SELECT 1
27: INTO dummy
28: FROM dual
29: WHERE NOT EXISTS ( SELECT 1
30: FROM pn_contacts_all c
31: WHERE c.last_name = x_last_name
32: AND c.first_name = x_first_name
148: END IF;
149:
150: SELECT pn_contacts_s.nextval
151: INTO x_contact_id
152: FROM dual;
153:
154: INSERT INTO pn_contacts_all
155: (
156: contact_id,