168: p_po_header_id IN NUMBER
169: )
170: RETURN NUMBER
171: IS
172: x_vendor_contact_id PO_HEADERS_ALL.vendor_contact_id%TYPE;
173: BEGIN
174:
175: SELECT vendor_contact_id
176: INTO x_vendor_contact_id
173: BEGIN
174:
175: SELECT vendor_contact_id
176: INTO x_vendor_contact_id
177: FROM po_headers_all
178: WHERE po_header_id = p_po_header_id;
179:
180: return (x_vendor_contact_id);
181: