APPS.PO_VENDORMERGE_GRP dependencies on PO_REQUISITION_LINES

Line 371: -- modify PO_REQUISITION_LINES

367: IF (PO_LOG.d_stmt) THEN
368: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
369: END IF;
370:
371: -- modify PO_REQUISITION_LINES
372: UPDATE PO_REQUISITION_LINES prl
373: SET prl.suggested_vendor_name = (select pov1.vendor_name
374: from po_vendors pov1
375: where pov1.vendor_id =

Line 372: UPDATE PO_REQUISITION_LINES prl

368: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
369: END IF;
370:
371: -- modify PO_REQUISITION_LINES
372: UPDATE PO_REQUISITION_LINES prl
373: SET prl.suggested_vendor_name = (select pov1.vendor_name
374: from po_vendors pov1
375: where pov1.vendor_id =
376: p_vendor_id),

Line 395: UPDATE po_requisition_lines prl

391: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
392: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
393:
394:
395: UPDATE po_requisition_lines prl
396: SET prl.vendor_id = p_vendor_id,
397: prl.vendor_site_id = p_vendor_site_id,
398: prl.last_update_date = sysdate,
399: prl.last_updated_by = l_last_updated_by

Line 408: UPDATE po_requisition_lines prl

404: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
405: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
406:
407:
408: UPDATE po_requisition_lines prl
409: SET prl.vendor_id = p_vendor_id,
410: prl.last_update_date = sysdate,
411: prl.last_updated_by = l_last_updated_by
412: WHERE prl.vendor_id = p_dup_vendor_id

Line 425: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQUISITION_LINES');

421: WHERE prha.Requisition_Header_Id = prl.Requisition_Header_Id
422: AND NVL(PRHA.FEDERAL_FLAG,'N')='Y');
423:
424: IF (PO_LOG.d_stmt) THEN
425: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQUISITION_LINES');
426: END IF;
427:
428:
429: -- Update Req Template Records