APPS.AP_SUPPLIER_INFO_PKG dependencies on AP_SUPPLIERS

Line 30: * First check if the vendor_id exists in ap_suppliers.

26: * to FALSE
27: *
28: * Logic :
29: * 1) Validation check and query string formulation
30: * First check if the vendor_id exists in ap_suppliers.
31: * If vendor_site_id is available then
32: * a) check if it is valid
33: * b) append it to site query string
34: * c) If vendor_contact_id is available then

Line 108: FROM ap_suppliers

104: o_success := TRUE;
105:
106: SELECT count(1)
107: INTO l_check_vid
108: FROM ap_suppliers
109: WHERE vendor_id = i_vendor_id;
110:
111: IF l_check_vid = 0 THEN
112: o_success := FALSE;

Line 213: FROM ap_suppliers

209: END IF;
210:
211: SELECT *
212: INTO o_supplier_info.supp_rec
213: FROM ap_suppliers
214: WHERE vendor_id = i_vendor_id;
215:
216: OPEN c_site FOR l_site_sel || l_site_where ;
217: LOOP

Line 299: TYPE t_supplier_tab IS TABLE OF ap_suppliers%ROWTYPE

295: )
296: IS
297: TYPE t_site_refcur IS REF CURSOR;
298: TYPE t_contact_refcur IS REF CURSOR;
299: TYPE t_supplier_tab IS TABLE OF ap_suppliers%ROWTYPE
300: INDEX BY BINARY_INTEGER;
301: TYPE t_site_tab IS TABLE OF ap_supplier_sites_all%ROWTYPE
302: INDEX BY BINARY_INTEGER;
303:

Line 307: FROM ap_suppliers

303:
304: CURSOR c_supplier
305: IS
306: SELECT *
307: FROM ap_suppliers
308: WHERE vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;
309:
310: c_site t_site_refcur;
311: c_contact t_contact_refcur;

Line 337: FROM ap_suppliers

333: END IF;
334:
335: SELECT count(1)
336: INTO l_check_vid
337: FROM ap_suppliers
338: WHERE vendor_id BETWEEN i_from_vendor_id AND i_to_vendor_id;
339:
340: IF l_check_vid = 0 THEN
341: o_success := FALSE;