APPS.PO_VENDORMERGE_GRP dependencies on PO_ASL_ATTRIBUTES

Line 440: -- modify po_asl_attributes

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
442: SET poasl1.vendor_id = p_vendor_id,
443: poasl1.vendor_site_id = p_vendor_site_id
444: WHERE poasl1.vendor_id = p_dup_vendor_id

Line 441: UPDATE po_asl_attributes poasl1

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
442: SET poasl1.vendor_id = p_vendor_id,
443: poasl1.vendor_site_id = p_vendor_site_id
444: WHERE poasl1.vendor_id = p_dup_vendor_id
445: AND poasl1.vendor_site_id = p_dup_vendor_site_id

Line 448: from po_asl_attributes poasl2

444: WHERE poasl1.vendor_id = p_dup_vendor_id
445: AND poasl1.vendor_site_id = p_dup_vendor_site_id
446: AND not exists
447: (select vendor_id
448: from po_asl_attributes poasl2
449: where poasl2.vendor_id = p_vendor_id
450: and poasl2.vendor_site_id = p_vendor_site_id
451: and nvl(poasl2.item_id, -99) = nvl(poasl1.item_id, -99)
452: and nvl(poasl2.category_id, -99) = nvl(poasl1.category_id, -99)

Line 459: -- DELETE from po_asl_attributes poasl

455: --1755383 Added the nvl condition so that null values does not result
456: --in success
457: -- delete the approved_list_entry if the new vendor_id would make the
458: -- record a duplicate.
459: -- DELETE from po_asl_attributes poasl
460: -- WHERE vendor_id = p_dup_vendor_id
461: -- AND vendor_site_id = p_vendor_site_id ;
462: -- FIX FOR 1931927 commented the above do_sql and wrote the below one
463: DELETE from po_asl_attributes poasl

Line 463: DELETE from po_asl_attributes poasl

459: -- DELETE from po_asl_attributes poasl
460: -- WHERE vendor_id = p_dup_vendor_id
461: -- AND vendor_site_id = p_vendor_site_id ;
462: -- FIX FOR 1931927 commented the above do_sql and wrote the below one
463: DELETE from po_asl_attributes poasl
464: WHERE vendor_id = p_dup_vendor_id
465: AND vendor_site_id = p_dup_vendor_site_id ;
466:
467:

Line 470: UPDATE po_asl_attributes poasl1

466:
467:
468: --Bug 1755383 start
469:
470: UPDATE po_asl_attributes poasl1
471: SET poasl1.vendor_id = p_vendor_id
472: WHERE poasl1.vendor_id = p_dup_vendor_id
473: AND poasl1.vendor_site_id is null
474: AND exists

Line 481: from po_asl_attributes poasl2

477: where vendor_id = p_dup_vendor_id
478: and nvl(end_date_active, sysdate+1) <= sysdate)
479: AND not exists
480: (select vendor_id
481: from po_asl_attributes poasl2
482: where poasl2.vendor_id = p_vendor_id
483: and poasl2.vendor_site_id is null
484: and nvl(poasl2.item_id, -99) = nvl(poasl1.item_id, -99)
485: and nvl(poasl2.category_id, -99) = nvl(poasl1.category_id, -99)

Line 492: DELETE from po_asl_attributes poasl

488:
489: -- delete the approved_list_entry if the new vendor_id would make the
490: -- record a duplicate.
491:
492: DELETE from po_asl_attributes poasl
493: WHERE vendor_id = p_dup_vendor_id
494: AND vendor_site_id is null
495: AND exists
496: ( select vendor_id

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

498: where vendor_id = p_dup_vendor_id
499: and nvl(end_date_active, sysdate+1) <= sysdate) ;
500:
501: IF (PO_LOG.d_stmt) THEN
502: PO_LOG.stmt(d_module, d_progress, 'updated PO_ASL_ATTRIBUTES');
503: END IF;
504:
505:
506: -- Prepare message name

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

503: END IF;
504:
505:
506: -- Prepare message name
507: FND_MESSAGE.SET_NAME('PO','PO_ASL_ATTRIBUTES');
508: IF SQL%FOUND THEN
509: x_return_status := FND_API.G_RET_STS_SUCCESS;
510: l_row_count := SQL%ROWCOUNT;
511: ELSE