APPS.PO_VENDORMERGE_GRP dependencies on PO_AUTOSOURCE_VENDORS

Line 240: -- modify PO_AUTOSOURCE_VENDORS

236: IF (PO_LOG.d_stmt) THEN
237: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
238: END IF;
239:
240: -- modify PO_AUTOSOURCE_VENDORS
241: UPDATE po_autosource_vendors pav1
242: SET pav1.vendor_id = p_vendor_id
243: WHERE pav1.vendor_id = p_dup_vendor_id
244: AND not exists

Line 241: UPDATE po_autosource_vendors pav1

237: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
238: END IF;
239:
240: -- modify PO_AUTOSOURCE_VENDORS
241: UPDATE po_autosource_vendors pav1
242: SET pav1.vendor_id = p_vendor_id
243: WHERE pav1.vendor_id = p_dup_vendor_id
244: AND not exists
245: (select vendor_id

Line 246: from po_autosource_vendors pav2

242: SET pav1.vendor_id = p_vendor_id
243: WHERE pav1.vendor_id = p_dup_vendor_id
244: AND not exists
245: (select vendor_id
246: from po_autosource_vendors pav2
247: where pav2.vendor_id = p_vendor_id
248: and pav2.autosource_rule_id =
249: pav1.autosource_rule_id) ;
250:

Line 253: UPDATE po_autosource_vendors pav1

249: pav1.autosource_rule_id) ;
250:
251:
252: -- modify split
253: UPDATE po_autosource_vendors pav1
254: SET pav1.split = (SELECT sum (pav3.split)
255: FROM po_autosource_vendors pav3
256: WHERE pav3.autosource_rule_id =
257: pav1.autosource_rule_id

Line 255: FROM po_autosource_vendors pav3

251:
252: -- modify split
253: UPDATE po_autosource_vendors pav1
254: SET pav1.split = (SELECT sum (pav3.split)
255: FROM po_autosource_vendors pav3
256: WHERE pav3.autosource_rule_id =
257: pav1.autosource_rule_id
258: AND pav3.vendor_id IN
259: (p_vendor_id, p_dup_vendor_id))

Line 263: from po_autosource_vendors pav2

259: (p_vendor_id, p_dup_vendor_id))
260: WHERE pav1.vendor_id = p_vendor_id
261: AND exists
262: (select pav2.vendor_id
263: from po_autosource_vendors pav2
264: where pav2.vendor_id = p_dup_vendor_id
265: and pav2.autosource_rule_id =
266: pav1.autosource_rule_id) ;
267:

Line 278: DELETE from po_autosource_vendors pavl

274:
275:
276: IF (p_dup_vendor_id <> p_vendor_id) THEN
277:
278: DELETE from po_autosource_vendors pavl
279: WHERE vendor_id = p_dup_vendor_id ;
280:
281: END IF;
282:

Line 284: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_VENDORS');

280:
281: END IF;
282:
283: IF (PO_LOG.d_stmt) THEN
284: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_VENDORS');
285: END IF;
286:
287: -- modify po_autosource_documents
288: --