APPS.PO_VENDORMERGE_GRP dependencies on PO_REQEXPRESS_LINES_ALL

Line 340: UPDATE po_reqexpress_lines_all PRL

336: END IF;
337:
338:
339: -- Update Req Template Records
340: UPDATE po_reqexpress_lines_all PRL
341: SET PRL.suggested_vendor_id = p_vendor_id,
342: PRL.suggested_vendor_site_id = p_vendor_site_id,
343: PRL.last_update_date = SYSDATE,
344: PRL.last_updated_by = l_last_updated_by

Line 356: UPDATE po_reqexpress_lines_all PRL

352: --SQL Why: If the supplier is not active after vendor merge,the records
353: -- associated to that supplier should be moved to point to the
354: -- new supplier
355:
356: UPDATE po_reqexpress_lines_all PRL
357: SET PRL.suggested_vendor_id = p_vendor_id,
358: last_update_date = SYSDATE,
359: last_updated_by = l_last_updated_by
360: WHERE PRL.suggested_vendor_id = p_dup_vendor_id

Line 370: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQEXPRESS_LINES_ALL');

366: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
367:
368:
369: IF (PO_LOG.d_stmt) THEN
370: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQEXPRESS_LINES_ALL');
371: END IF;
372:
373: -- modify po_approved_supplier_list
374: UPDATE po_approved_supplier_list poasl1