APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_VENDORS

Line 659: -- in PO_VENDORS table.

655:
656: -- ECO bug 5584556: Add new messages
657: l_progress := '020';
658: -- SQL What: Bulk validate vendor_id. Check that the ID is not NULL and it exists
659: -- in PO_VENDORS table.
660: -- Insert the error rows into GT table.
661: -- SQL Why : It will be used to mark the record in plsql table as error.
662: -- SQL Join: vendor_id
663: FORALL i IN 1 .. p_headers_rec.vendor_id.COUNT

Line 680: FROM PO_VENDORS PV

676: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
677: AND (p_headers_rec.vendor_id(i) IS NULL
678: OR p_headers_rec.vendor_id(i) = g_NULL_COLUMN_VALUE -- -2
679: OR NOT EXISTS(SELECT 1
680: FROM PO_VENDORS PV
681: WHERE p_headers_rec.vendor_id(i) = PV.vendor_id));
682:
683: 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;
684:

Line 743: FROM PO_VENDORS PV

739: -- So adding these additional where-clauses to skip those cases.
740: AND p_headers_rec.vendor_id(i) IS NOT NULL
741: AND p_headers_rec.vendor_id(i) <> g_NULL_COLUMN_VALUE -- -2
742: AND EXISTS(SELECT 1
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