DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PO_VENDORS

Line 556: (p_supplier_id IN po_vendors.vendor_id%TYPE) return VARCHAR2 is

552: return null;
553: END get_project_role_name;
554:
555: FUNCTION get_supplier_name
556: (p_supplier_id IN po_vendors.vendor_id%TYPE) return VARCHAR2 is
557: l_return_value VARCHAR2(80) := 'invalid value';
558: BEGIN
559: select vendor_name
560: into l_return_value

Line 561: from po_vendors

557: l_return_value VARCHAR2(80) := 'invalid value';
558: BEGIN
559: select vendor_name
560: into l_return_value
561: from po_vendors
562: where vendor_id = p_supplier_id;
563: return l_return_value;
564: EXCEPTION
565: when NO_DATA_FOUND then