APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_SUPPLIERS_VAL_V

Line 596: -- validate vendor_id using po_suppliers_val_v

592: -- None.
593: --Function:
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:

Line 747: FROM PO_SUPPLIERS_VAL_V PSV

743: FROM PO_VENDORS PV
744: WHERE p_headers_rec.vendor_id(i) = PV.vendor_id)
745: -- ECO bug 5584556: End
746: AND NOT EXISTS(SELECT 1
747: FROM PO_SUPPLIERS_VAL_V PSV
748: WHERE p_headers_rec.vendor_id(i) = PSV.vendor_id);
749:
750: 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;
751:

Line 2548: -- validate vendor_id using PO_SUPPLIERS_VAL_V

2544:
2545: l_progress := '040';
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