199:
200: FUNCTION C_VENDOR_NAMEFORMULA RETURN VARCHAR2 IS
201: BEGIN
202: DECLARE
203: APU2 PO_VENDORS.VENDOR_NAME%TYPE;
204: BEGIN
205: SELECT
206: SEGMENT1 || ' ' || VENDOR_NAME
207: INTO APU2
205: SELECT
206: SEGMENT1 || ' ' || VENDOR_NAME
207: INTO APU2
208: FROM
209: PO_VENDORS
210: WHERE VENDOR_ID = NVL(P_VENDOR_ID
211: ,-1);
212: RETURN (APU2);
213: EXCEPTION