APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_VENDOR_CONTACTS

Line 598: -- validate vendor_contact_id using po_vendor_contacts

594: -- validate vendorId is Not Null
595: -- validate vendorSiteId is Not Null
596: -- validate vendor_id using po_suppliers_val_v
597: -- validate vendor_site_id using po_supplier_sites_val_v
598: -- validate vendor_contact_id using po_vendor_contacts
599: -- validate vendor site CCR if approval status is APPROVED.
600: --Parameters:
601: --IN:
602: --p_key

Line 962: FROM PO_VENDOR_CONTACTS PVC

958: AND p_headers_rec.vendor_id(i) IS NOT NULL
959: AND p_headers_rec.vendor_site_id(i) IS NOT NULL
960: AND p_headers_rec.vendor_contact_id(i) IS NOT NULL
961: AND NOT EXISTS(SELECT 1
962: FROM PO_VENDOR_CONTACTS PVC
963: WHERE p_headers_rec.vendor_site_id(i) = PVC.vendor_site_id
964: AND p_headers_rec.vendor_contact_id(i) = PVC.vendor_contact_id);
965:
966: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows insert into GT table='||SQL%rowcount); END IF;

Line 2550: -- validate vendor_contact_id using PO_VENDOR_CONTACTS

2546: -- validate vendorId is Not Null
2547: -- validate vendorSiteId is Not Null
2548: -- validate vendor_id using PO_SUPPLIERS_VAL_V
2549: -- validate vendor_site_id using PO_SUPPLIER_SITES_VAL_V
2550: -- validate vendor_contact_id using PO_VENDOR_CONTACTS
2551: -- validate vendor site CCR if approval status is APPROVED.
2552: validate_vendor_info
2553: (
2554: p_key => l_key,