APPS.PO_VENDORMERGE_GRP dependencies on PO_ASL_ATTRIBUTES

Line 530: -- modify po_asl_attributes

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
532: SET poasl1.vendor_id = p_vendor_id,
533: poasl1.vendor_site_id = p_vendor_site_id
534: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 531: UPDATE po_asl_attributes poasl1

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
532: SET poasl1.vendor_id = p_vendor_id,
533: poasl1.vendor_site_id = p_vendor_site_id
534: WHERE poasl1.vendor_id = p_dup_vendor_id
535: AND poasl1.vendor_site_id = p_dup_vendor_site_id

Line 538: from po_asl_attributes poasl2

534: WHERE poasl1.vendor_id = p_dup_vendor_id
535: AND poasl1.vendor_site_id = p_dup_vendor_site_id
536: AND not exists
537: (select vendor_id
538: from po_asl_attributes poasl2
539: where poasl2.vendor_id = p_vendor_id
540: and poasl2.vendor_site_id = p_vendor_site_id
541: and nvl(poasl2.item_id, -99) = nvl(poasl1.item_id, -99)
542: and nvl(poasl2.category_id, -99) = nvl(poasl1.category_id, -99)

Line 549: -- DELETE from po_asl_attributes poasl

545: --1755383 Added the nvl condition so that null values does not result
546: --in success
547: -- delete the approved_list_entry if the new vendor_id would make the
548: -- record a duplicate.
549: -- DELETE from po_asl_attributes poasl
550: -- WHERE vendor_id = p_dup_vendor_id
551: -- AND vendor_site_id = p_vendor_site_id ;
552: -- FIX FOR 1931927 commented the above do_sql and wrote the below one
553: DELETE from po_asl_attributes poasl

Line 553: DELETE from po_asl_attributes poasl

549: -- DELETE from po_asl_attributes poasl
550: -- WHERE vendor_id = p_dup_vendor_id
551: -- AND vendor_site_id = p_vendor_site_id ;
552: -- FIX FOR 1931927 commented the above do_sql and wrote the below one
553: DELETE from po_asl_attributes poasl
554: WHERE vendor_id = p_dup_vendor_id
555: AND vendor_site_id = p_dup_vendor_site_id ;
556:
557:

Line 560: UPDATE po_asl_attributes poasl1

556:
557:
558: --Bug 1755383 start
559:
560: UPDATE po_asl_attributes poasl1
561: SET poasl1.vendor_id = p_vendor_id
562: WHERE poasl1.vendor_id = p_dup_vendor_id
563: AND poasl1.vendor_site_id is null
564: AND exists

Line 571: from po_asl_attributes poasl2

567: where vendor_id = p_dup_vendor_id
568: and nvl(end_date_active, sysdate+1) <= sysdate)
569: AND not exists
570: (select vendor_id
571: from po_asl_attributes poasl2
572: where poasl2.vendor_id = p_vendor_id
573: and poasl2.vendor_site_id is null
574: and nvl(poasl2.item_id, -99) = nvl(poasl1.item_id, -99)
575: and nvl(poasl2.category_id, -99) = nvl(poasl1.category_id, -99)

Line 582: DELETE from po_asl_attributes poasl

578:
579: -- delete the approved_list_entry if the new vendor_id would make the
580: -- record a duplicate.
581:
582: DELETE from po_asl_attributes poasl
583: WHERE vendor_id = p_dup_vendor_id
584: AND vendor_site_id is null
585: AND exists
586: ( select vendor_id

Line 592: PO_LOG.stmt(d_module, d_progress, 'updated PO_ASL_ATTRIBUTES');

588: where vendor_id = p_dup_vendor_id
589: and nvl(end_date_active, sysdate+1) <= sysdate) ;
590:
591: IF (PO_LOG.d_stmt) THEN
592: PO_LOG.stmt(d_module, d_progress, 'updated PO_ASL_ATTRIBUTES');
593: END IF;
594:
595:
596: -- Prepare message name

Line 597: FND_MESSAGE.SET_NAME('PO','PO_ASL_ATTRIBUTES');

593: END IF;
594:
595:
596: -- Prepare message name
597: FND_MESSAGE.SET_NAME('PO','PO_ASL_ATTRIBUTES');
598: IF SQL%FOUND THEN
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: l_row_count := SQL%ROWCOUNT;
601: ELSE