698: -- validate vendorId is Not Null
699: -- validate vendorSiteId is Not Null
700: -- validate vendor_id using po_suppliers_val_v
701: -- validate vendor_site_id using po_supplier_sites_val_v
702: -- validate vendor_contact_id using po_vendor_contacts
703: -- validate vendor site CCR if approval status is APPROVED.
704: -------------------------------------------------------------------------
705: PROCEDURE vendor_info(
706: p_id_tbl IN po_tbl_number,
850: WHERE p_vendor_id_tbl(i) IS NOT NULL
851: AND p_vendor_site_id_tbl(i) IS NOT NULL
852: AND p_vendor_contact_id_tbl(i) IS NOT NULL
853: AND NOT EXISTS(SELECT 1
854: FROM po_vendor_contacts pvc
855: WHERE p_vendor_site_id_tbl(i) = pvc.vendor_site_id
856: AND p_vendor_contact_id_tbl(i) = pvc.vendor_contact_id);
857:
858: IF (SQL%ROWCOUNT > 0) THEN