APPS.PO_VENDORMERGE_GRP dependencies on PO_REQUISITION_LINES

Line 294: -- modify PO_REQUISITION_LINES

290: IF (PO_LOG.d_stmt) THEN
291: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
292: END IF;
293:
294: -- modify PO_REQUISITION_LINES
295: UPDATE PO_REQUISITION_LINES
296: SET suggested_vendor_name = (select pov1.vendor_name
297: from po_vendors pov1
298: where pov1.vendor_id =

Line 295: UPDATE PO_REQUISITION_LINES

291: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
292: END IF;
293:
294: -- modify PO_REQUISITION_LINES
295: UPDATE PO_REQUISITION_LINES
296: SET suggested_vendor_name = (select pov1.vendor_name
297: from po_vendors pov1
298: where pov1.vendor_id =
299: p_vendor_id),

Line 314: UPDATE po_requisition_lines

310: where vendor_site_id =
311: p_dup_vendor_site_id);
312:
313:
314: UPDATE po_requisition_lines
315: SET vendor_id = p_vendor_id,
316: vendor_site_id = p_vendor_site_id,
317: last_update_date = sysdate,
318: last_updated_by = l_last_updated_by

Line 322: UPDATE po_requisition_lines

318: last_updated_by = l_last_updated_by
319: WHERE vendor_id = p_dup_vendor_id
320: AND vendor_site_id = p_dup_vendor_site_id ;
321:
322: UPDATE po_requisition_lines
323: SET vendor_id = p_vendor_id,
324: last_update_date = sysdate,
325: last_updated_by = l_last_updated_by
326: WHERE vendor_id = p_dup_vendor_id

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

331: where vendor_id = p_dup_vendor_id
332: and nvl(end_date_active, sysdate+1) <= sysdate);
333:
334: IF (PO_LOG.d_stmt) THEN
335: PO_LOG.stmt(d_module, d_progress, 'updated PO_REQUISITION_LINES');
336: END IF;
337:
338:
339: -- Update Req Template Records