14706: (l_email_return_status = FND_API.G_RET_STS_SUCCESS) AND
14707: (l_url_return_status = FND_API.G_RET_STS_SUCCESS) THEN
14708:
14709:
14710: SELECT po_vendor_contacts_s.nextval
14711: INTO l_vendor_contact_rec.vendor_contact_id
14712: FROM dual;
14713:
14714: INSERT INTO ap_supplier_contacts(
17998:
17999: IF i_vendor_contact_id IS NOT NULL THEN
18000: SELECT vendor_id
18001: INTO l_vendor_id
18002: FROM po_vendor_contacts
18003: WHERE vendor_contact_id = i_vendor_contact_id
18004: AND ROWNUM = 1;
18005: END IF;
18006: ELSE