[Home] [Help]
435:
436:
437: SELECT COUNT(*)
438: INTO l_count
439: FROM po_vendors
440: WHERE (p_vendor_id IS NULL OR p_vendor_id = ap_null_num OR vendor_id <> p_vendor_id) --bug7023543
441: AND employee_id = p_employee_id;
442:
443: IF l_count > 0 THEN
518:
519: x_valid := TRUE;
520:
521: --open issue 1 with manoj regarding whether the vendor name
522: --will even be denormalized into po_vendors
523:
524: -- Added following if condition for bug 6775797
525:
526: IF ((p_vendor_type_lookup_code IS NOT NULL AND
568: x_valid := TRUE;
569:
570: SELECT COUNT(*)
571: INTO l_count
572: FROM po_vendors
573: WHERE (p_vendor_id IS NULL OR vendor_id <> p_vendor_id)
574: AND segment1 = p_segment1;
575:
576: IF l_count = 0 THEN
783:
784: x_valid := TRUE;
785:
786: --open issue 1 with manoj regarding whether the vendor name
787: --will even be denormalized into po_vendors
788:
789: -- Added following if condition for bug 6775797
790:
791: IF ((p_vendor_type_lookup_code IS NOT NULL AND
1889: SELECT hl.location_id, hps.party_site_id
1890: INTO x_location_id, p_party_site_id
1891: FROM HZ_Locations hl,
1892: HZ_Party_Sites hps,
1893: po_vendors pv,
1894: fnd_languages fl
1895: WHERE nvl(upper(hl.country), 'dummy') =
1896: nvl(upper(p_country), 'dummy') AND
1897: nvl(upper(hl.address1), 'dummy') =
3598:
3599: IF (l_val_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3600:
3601: -- Select all the values needed to pass to update_row
3602: -- from PO_VENDORS
3603: SELECT
3604: decode(l_vendor_rec.allow_awt_flag,
3605: ap_null_char, NULL,
3606: nvl(l_vendor_rec.allow_awt_flag, allow_awt_flag))
4103: ,l_vendor_rec.withholding_status_lookup_code
4104: ,l_vendor_rec.women_owned_flag
4105: ,l_vendor_rec.pay_awt_group_id -- bug7561758
4106: ,l_rowid
4107: FROM po_vendors
4108: WHERE vendor_id = p_vendor_id;
4109:
4110: ap_vendors_pkg.update_row(
4111: p_vendor_rec => l_vendor_rec,
4897: END IF;
4898: */
4899:
4900: ------------------------------------------------------------------------
4901: l_debug_info := 'Call to Check Duplicate Vendor Number in PO_VENDORS';
4902: ------------------------------------------------------------------------
4903: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
4905: l_api_name,l_debug_info);
6879: l_def_org_id NUMBER;
6880: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
6881: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
6882:
6883: -- variables for retrieving defaults from PO_VENDORS
6884: l_rowid VARCHAR2(255);
6885: l_vendor_site_id NUMBER;
6886: l_vendor_site_code VARCHAR2(255);
6887: l_purchasing_site_flag VARCHAR2(255);
7296: x_calling_sequence => null);
7297:
7298: -- Retrieve defaults from the vendor master
7299:
7300: /* Bug 7155121 Modified the below select to get values from both ap_system_parameters_all and po_vendors*/
7301:
7302: SELECT nvl(pv.terms_date_basis, asp.terms_date_basis) -- Bug#7506443
7303: , pv.pay_group_lookup_code
7304: , pv.payment_priority
7347: , l_exclude_freight_from_disc
7348: , l_party_id
7349: , l_vendor_type_lookup_code
7350: , l_sup_awt_flag
7351: FROM po_vendors pv,
7352: ap_system_parameters_all asp
7353: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
7354: AND asp.org_id=l_def_org_id;
7355:
13628:
13629: SELECT party_id, 'PAYABLES_DISB'
13630: INTO ext_payee_rec.payee_party_id,
13631: ext_payee_rec.payment_function
13632: FROM Po_Vendors
13633: WHERE vendor_id = site_rec.vendor_id;
13634:
13635: /* Calling IBY Payee Validation API */
13636: IBY_DISBURSEMENT_SETUP_PUB.Validate_External_Payee