APPS.ICX_SUPP_CUSTOM dependencies on PO_VENDORS

Line 27: from PO_VENDORS

23: l_vendor_id number;
24:
25: cursor existing_supplier is
26: select count(*)
27: from PO_VENDORS
28: where upper(vendor_name) = upper(p_supplier);
29:
30: begin
31:

Line 40: from PO_VENDORS

36: if l_existing_supplier = 1
37: then
38: select vendor_id
39: into l_vendor_id
40: from PO_VENDORS
41: where upper(vendor_name) = upper(p_supplier);
42: elsif l_existing_supplier = 0 or l_existing_supplier is null
43: then
44: l_vendor_id := 0;

Line 63: -- p_supplier_id - Primary to PO_VENDORS, only valid if greater than 0

59: --
60: -- PARAMETERS
61: -- p_username - Requestor's preferred web account user name
62: -- e.g. jdoe
63: -- p_supplier_id - Primary to PO_VENDORS, only valid if greater than 0
64: -- p_email_address - Email address supplier by requestor
65: -- p_new_username - web account user name including set domain name
66: -- e.g. jdoe@oracle (@oracle is the doamin name)
67: -- NOTES