APPS.POS_VENDOR_PUB_PKG dependencies on AP_SUPPLIERS

Line 330: from ap_suppliers

326: l_count number;
327: begin
328: select count(*)
329: into l_count
330: from ap_suppliers
331: where upper(vendor_name) like upper(p_vendor_name)
332: AND nvl(VENDOR_TYPE_LOOKUP_CODE,'nonemp') <> 'EMPLOYEE';
333:
334: return l_count;

Line 448: l_segment1 AP_SUPPLIERS.SEGMENT1%TYPE;

444: l_party_usage_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
445:
446: /* Bug No: 8973060.
447: Added following varirables to build the message with bind variables.*/
448: l_segment1 AP_SUPPLIERS.SEGMENT1%TYPE;
449: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
450: l_vendor_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
451: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
452: event_id Number;

Line 449: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;

445:
446: /* Bug No: 8973060.
447: Added following varirables to build the message with bind variables.*/
448: l_segment1 AP_SUPPLIERS.SEGMENT1%TYPE;
449: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
450: l_vendor_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
451: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
452: event_id Number;
453: BEGIN

Line 450: l_vendor_name AP_SUPPLIERS.VENDOR_NAME%TYPE;

446: /* Bug No: 8973060.
447: Added following varirables to build the message with bind variables.*/
448: l_segment1 AP_SUPPLIERS.SEGMENT1%TYPE;
449: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
450: l_vendor_name AP_SUPPLIERS.VENDOR_NAME%TYPE;
451: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
452: event_id Number;
453: BEGIN
454:

Line 486: from ap_suppliers

482: Added following code to build messages with bind variables.*/
483:
484: select segment1, vendor_name, party_id, vendor_id
485: INTO l_segment1, l_vendor_name, l_party_id, l_vendor_id
486: from ap_suppliers
487: where upper(vendor_name) like upper(p_vendor_rec.vendor_name);
488:
489: fnd_message.set_name('POS','POS_HT_SP_DUP_VENDOR');
490: fnd_message.set_token('VENDOR_NAME',l_vendor_name);

Line 1567: from ap_suppliers where vendor_id = p_vendor_id;

1563:
1564: -- BUG 5926560
1565: if p_last_update_date is not NULL then
1566: select last_update_date into l_last_update_date
1567: from ap_suppliers where vendor_id = p_vendor_id;
1568: if l_last_update_date > p_last_update_date then
1569: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SUPPLIER_ROW');
1570: x_return_status := 'E';
1571: return;