DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_APPROVED_SUPPLIER_LIST

Line 463: -- modify po_approved_supplier_list

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
465: SET poasl1.vendor_id = p_vendor_id,
466: poasl1.vendor_site_id = p_vendor_site_id
467: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 464: UPDATE po_approved_supplier_list poasl1

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
465: SET poasl1.vendor_id = p_vendor_id,
466: poasl1.vendor_site_id = p_vendor_site_id
467: WHERE poasl1.vendor_id = p_dup_vendor_id
468: AND poasl1.vendor_site_id = p_dup_vendor_site_id

Line 471: from po_approved_supplier_list poasl2

467: WHERE poasl1.vendor_id = p_dup_vendor_id
468: AND poasl1.vendor_site_id = p_dup_vendor_site_id
469: AND not exists
470: ( select vendor_id
471: from po_approved_supplier_list poasl2
472: where poasl2.vendor_id = p_vendor_id
473: and poasl2.vendor_site_id = p_vendor_site_id
474: and nvl(poasl2.item_id, -99) =
475: nvl(poasl1.item_id, -99)

Line 486: DELETE from po_approved_supplier_list poasl

482:
483: -- delete the approved_list_entry if the new vendor_id would make the
484: -- record a duplicate.
485: -- Bug: 1494378
486: DELETE from po_approved_supplier_list poasl
487: WHERE vendor_id = p_dup_vendor_id
488: AND vendor_site_id = p_dup_vendor_site_id ;
489:
490: --Bug 1755383 start

Line 491: -- modify po_approved_supplier_list

487: WHERE vendor_id = p_dup_vendor_id
488: AND vendor_site_id = p_dup_vendor_site_id ;
489:
490: --Bug 1755383 start
491: -- modify po_approved_supplier_list
492:
493: UPDATE po_approved_supplier_list poasl1
494: SET poasl1.vendor_id = p_vendor_id
495: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 493: UPDATE po_approved_supplier_list poasl1

489:
490: --Bug 1755383 start
491: -- modify po_approved_supplier_list
492:
493: UPDATE po_approved_supplier_list poasl1
494: SET poasl1.vendor_id = p_vendor_id
495: WHERE poasl1.vendor_id = p_dup_vendor_id
496: AND poasl1.vendor_site_id is null
497: AND exists

Line 504: from po_approved_supplier_list poasl2

500: where vendor_id = p_dup_vendor_id
501: and nvl(end_date_active, sysdate+1) <= sysdate)
502: AND not exists
503: ( select vendor_id
504: from po_approved_supplier_list poasl2
505: where poasl2.vendor_id = p_vendor_id
506: and poasl2.vendor_site_id is null
507: and nvl(poasl2.item_id, -99) =
508: nvl(poasl1.item_id, -99)

Line 517: DELETE from po_approved_supplier_list poasl

513:
514: -- delete the approved_list_entry if the new vendor_id would make the
515: -- record a duplicate.
516:
517: DELETE from po_approved_supplier_list poasl
518: WHERE vendor_id = p_dup_vendor_id
519: AND vendor_site_id is null
520: AND exists
521: ( select vendor_id

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

523: where vendor_id = p_dup_vendor_id
524: and nvl(end_date_active, sysdate+1) <= sysdate);
525:
526: IF (PO_LOG.d_stmt) THEN
527: PO_LOG.stmt(d_module, d_progress, 'updated PO_APPROVED_SUPPLIER_LIST');
528: END IF;
529:
530: -- modify po_asl_attributes
531: UPDATE po_asl_attributes poasl1