91: -- Allocate the sequence to the primary key address_id
92: -----------------------------------------------------------------
93: SELECT pn_addresses_s.nextval
94: INTO x_address_id
95: FROM dual;
96:
97: INSERT INTO pn_addresses_all ( address_id,
98: address_line1,
99: address_line2,