APPS.PO_VENDORMERGE_GRP dependencies on PO_APPROVED_SUPPLIER_LIST

Line 373: -- modify po_approved_supplier_list

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
375: SET poasl1.vendor_id = p_vendor_id,
376: poasl1.vendor_site_id = p_vendor_site_id
377: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 374: UPDATE po_approved_supplier_list poasl1

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
375: SET poasl1.vendor_id = p_vendor_id,
376: poasl1.vendor_site_id = p_vendor_site_id
377: WHERE poasl1.vendor_id = p_dup_vendor_id
378: AND poasl1.vendor_site_id = p_dup_vendor_site_id

Line 381: from po_approved_supplier_list poasl2

377: WHERE poasl1.vendor_id = p_dup_vendor_id
378: AND poasl1.vendor_site_id = p_dup_vendor_site_id
379: AND not exists
380: ( select vendor_id
381: from po_approved_supplier_list poasl2
382: where poasl2.vendor_id = p_vendor_id
383: and poasl2.vendor_site_id = p_vendor_site_id
384: and nvl(poasl2.item_id, -99) =
385: nvl(poasl1.item_id, -99)

Line 396: DELETE from po_approved_supplier_list poasl

392:
393: -- delete the approved_list_entry if the new vendor_id would make the
394: -- record a duplicate.
395: -- Bug: 1494378
396: DELETE from po_approved_supplier_list poasl
397: WHERE vendor_id = p_dup_vendor_id
398: AND vendor_site_id = p_dup_vendor_site_id ;
399:
400: --Bug 1755383 start

Line 401: -- modify po_approved_supplier_list

397: WHERE vendor_id = p_dup_vendor_id
398: AND vendor_site_id = p_dup_vendor_site_id ;
399:
400: --Bug 1755383 start
401: -- modify po_approved_supplier_list
402:
403: UPDATE po_approved_supplier_list poasl1
404: SET poasl1.vendor_id = p_vendor_id
405: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 403: UPDATE po_approved_supplier_list poasl1

399:
400: --Bug 1755383 start
401: -- modify po_approved_supplier_list
402:
403: UPDATE po_approved_supplier_list poasl1
404: SET poasl1.vendor_id = p_vendor_id
405: WHERE poasl1.vendor_id = p_dup_vendor_id
406: AND poasl1.vendor_site_id is null
407: AND exists

Line 414: from po_approved_supplier_list poasl2

410: where vendor_id = p_dup_vendor_id
411: and nvl(end_date_active, sysdate+1) <= sysdate)
412: AND not exists
413: ( select vendor_id
414: from po_approved_supplier_list poasl2
415: where poasl2.vendor_id = p_vendor_id
416: and poasl2.vendor_site_id is null
417: and nvl(poasl2.item_id, -99) =
418: nvl(poasl1.item_id, -99)

Line 427: DELETE from po_approved_supplier_list poasl

423:
424: -- delete the approved_list_entry if the new vendor_id would make the
425: -- record a duplicate.
426:
427: DELETE from po_approved_supplier_list poasl
428: WHERE vendor_id = p_dup_vendor_id
429: AND vendor_site_id is null
430: AND exists
431: ( select vendor_id

Line 437: PO_LOG.stmt(d_module, d_progress, 'updated PO_APPROVED_SUPPLIER_LIST');

433: where vendor_id = p_dup_vendor_id
434: and nvl(end_date_active, sysdate+1) <= sysdate);
435:
436: IF (PO_LOG.d_stmt) THEN
437: PO_LOG.stmt(d_module, d_progress, 'updated PO_APPROVED_SUPPLIER_LIST');
438: END IF;
439:
440: -- modify po_asl_attributes
441: UPDATE po_asl_attributes poasl1