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