628: END IF;
629:
630: SELECT vendor_id
631: INTO x_vendor_id
632: FROM po_vendors
633: WHERE vendor_name = p_vendor_name;
634:
635: RETURN x_vendor_id;
636: EXCEPTION
656: END IF;
657:
658: SELECT vendor_id
659: INTO x_vendor_id
660: FROM po_vendors
661: WHERE segment1 = p_vendor_num;
662:
663: RETURN x_vendor_id;
664: EXCEPTION