DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on PO_VENDORS

Line 619: FROM po_vendors pov

615: FUNCTION Validate_PrefSupplier(p_pref_supp_name IN VARCHAR2,
616: p_pref_supp_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
617: CURSOR c1 IS
618: SELECT pov.vendor_id
619: FROM po_vendors pov
620: where pov.vendor_name = p_pref_supp_name;
621: BEGIN
622: IF (p_pref_supp_name IS NULL OR p_pref_supp_name = '') THEN
623: p_pref_supp_id := NULL;

Line 650: FROM po_vendors pov

646: FUNCTION Validate_ConsSupplier(p_cons_supp_name IN VARCHAR2,
647: p_cons_supp_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
648: CURSOR c1 IS
649: SELECT pov.vendor_id
650: FROM po_vendors pov
651: where pov.vendor_name = p_cons_supp_name;
652: BEGIN
653: IF (p_cons_supp_name IS NULL OR p_cons_supp_name = '') THEN
654: p_cons_supp_id := -9999;

Line 714: FROM po_vendors

710: FUNCTION Validate_SavingsSupplier(p_supplier_name IN VARCHAR2,
711: p_supplier_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
712: CURSOR c1 IS
713: SELECT vendor_id
714: FROM po_vendors
715: WHERE vendor_name = p_supplier_name;
716: BEGIN
717: IF (p_supplier_name IS NULL OR p_supplier_name = '') THEN
718: p_supplier_id := -9999;