APPS.PO_VENDORMERGE_GRP dependencies on PO_REQEXPRESS_LINES_ALL

Line 430: UPDATE po_reqexpress_lines_all PRL

426: END IF;
427:
428:
429: -- Update Req Template Records
430: UPDATE po_reqexpress_lines_all PRL
431: SET PRL.suggested_vendor_id = p_vendor_id,
432: PRL.suggested_vendor_site_id = p_vendor_site_id,
433: PRL.last_update_date = SYSDATE,
434: PRL.last_updated_by = l_last_updated_by

Line 446: UPDATE po_reqexpress_lines_all PRL

442: --SQL Why: If the supplier is not active after vendor merge,the records
443: -- associated to that supplier should be moved to point to the
444: -- new supplier
445:
446: UPDATE po_reqexpress_lines_all PRL
447: SET PRL.suggested_vendor_id = p_vendor_id,
448: last_update_date = SYSDATE,
449: last_updated_by = l_last_updated_by
450: WHERE PRL.suggested_vendor_id = p_dup_vendor_id

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

456: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
457:
458:
459: IF (PO_LOG.d_stmt) THEN
460: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQEXPRESS_LINES_ALL');
461: END IF;
462:
463: -- modify po_approved_supplier_list
464: UPDATE po_approved_supplier_list poasl1