APPS.POS_VENDOR_UTIL_PKG dependencies on AP_SUPPLIERS

Line 38: from ap_suppliers

34: BEGIN
35: -- Correct the name first and then correct the ID
36: select vendor_name
37: into l_new_vendor_name
38: from ap_suppliers
39: where vendor_id = p_vendor_id;
40:
41: -- We are not comparing the supplier name as this information
42: -- might not be reliable ( could have different spelling).

Line 82: FROM ap_suppliers

78: RETURN NUMBER IS
79: l_party_id NUMBER;
80: CURSOR l_cur IS
81: SELECT party_id
82: FROM ap_suppliers
83: WHERE vendor_id = p_vendor_id;
84: BEGIN
85: OPEN l_cur;
86: FETCH l_cur INTO l_party_id;

Line 100: -- Get the vendor id (as in AP_SUPPLIERS table ) for a given

96: CLOSE l_cur;
97: RETURN l_party_id;
98: END get_party_id_for_vendor;
99:
100: -- Get the vendor id (as in AP_SUPPLIERS table ) for a given
101: -- user name ( as in FND_USER table)
102: FUNCTION get_po_vendor_id_for_user(p_username IN VARCHAR2)
103: RETURN NUMBER
104: IS

Line 145: FROM ak_web_user_sec_attr_values akw, ap_suppliers pv

141: l_number NUMBER;
142:
143: CURSOR l_vendor_cur IS
144: SELECT akw.number_value
145: FROM ak_web_user_sec_attr_values akw, ap_suppliers pv
146: WHERE akw.web_user_id = p_user_id
147: AND akw.attribute_code = 'ICX_SUPPLIER_ORG_ID'
148: AND akw.attribute_application_id = 177
149: AND akw.number_value = pv.vendor_id

Line 170: (select vendor_id from ap_suppliers

166: AND akw.attribute_code = 'ICX_SUPPLIER_SITE_ID'
167: AND akw.attribute_application_id = 177
168: AND akw.number_value = pvs.vendor_site_id
169: AND pvs.vendor_id NOT IN
170: (select vendor_id from ap_suppliers
171: start with vendor_id = l_root_vendor_id
172: connect by prior vendor_id = parent_vendor_id
173: )
174: AND ROWNUM < 2;

Line 188: from ap_suppliers

184: (SELECT vendor_site_id
185: FROM ap_supplier_sites_all
186: WHERE vendor_id in
187: (select vendor_id
188: from ap_suppliers
189: start with vendor_id = l_root_vendor_id
190: connect by prior vendor_id = parent_vendor_id
191: )
192: )

Line 237: -- Return Y if p_vendor_name already exists in ap_suppliers

233: RETURN 'Y';
234:
235: END validate_user_setup;
236:
237: -- Return Y if p_vendor_name already exists in ap_suppliers
238: -- Note: this api does case insensitive check
239: FUNCTION vendor_name_exist (p_vendor_name IN VARCHAR2) RETURN VARCHAR2
240: IS
241: CURSOR l_cur IS

Line 243: FROM ap_suppliers

239: FUNCTION vendor_name_exist (p_vendor_name IN VARCHAR2) RETURN VARCHAR2
240: IS
241: CURSOR l_cur IS
242: SELECT 1
243: FROM ap_suppliers
244: WHERE Upper(vendor_name) = Upper(p_vendor_name);
245: l_number NUMBER;
246: BEGIN
247: OPEN l_cur;