DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS2 dependencies on PO_VENDOR_CONTACTS

Line 702: -- validate vendor_contact_id using po_vendor_contacts

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,

Line 854: FROM po_vendor_contacts pvc

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