APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_SUPPLIER_SITES_VAL_V

Line 597: -- validate vendor_site_id using po_supplier_sites_val_v

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:
601: --IN:

Line 896: FROM PO_SUPPLIER_SITES_VAL_V PSSV

892: FROM PO_VENDOR_SITES_ALL PVSA
893: WHERE p_headers_rec.vendor_site_id(i) = PVSA.vendor_site_id)
894: -- ECO bug 5584556: End
895: AND NOT EXISTS(SELECT 1
896: FROM PO_SUPPLIER_SITES_VAL_V PSSV
897: WHERE p_headers_rec.vendor_site_id(i) = PSSV.vendor_site_id);
898:
899: 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;
900:

Line 2549: -- validate vendor_site_id using PO_SUPPLIER_SITES_VAL_V

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
2553: (