APPS.AP_SUPPLIER_INFO_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 66: TYPE t_site_tab IS TABLE OF ap_supplier_sites_all%ROWTYPE

62: )
63: IS
64: TYPE t_site_refcur IS REF CURSOR;
65: TYPE t_contact_refcur IS REF CURSOR;
66: TYPE t_site_tab IS TABLE OF ap_supplier_sites_all%ROWTYPE
67: INDEX BY BINARY_INTEGER;
68:
69: c_site t_site_refcur;
70: c_contact t_contact_refcur;

Line 73: l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';

69: c_site t_site_refcur;
70: c_contact t_contact_refcur;
71: l_site_tab t_site_tab;
72: l_contact_tab t_contacts_tab;
73: l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';
74: l_site_where VARCHAR2(1000) := ' WHERE vendor_id = '
75: || to_char(i_vendor_id);
76: l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';
77: l_contact_where VARCHAR2(1000) := ' WHERE vendor_id = '

Line 122: FROM ap_supplier_sites_all

118: ELSE
119: IF i_vendor_site_id IS NOT NULL THEN
120: SELECT count(1)
121: INTO l_check_vsid
122: FROM ap_supplier_sites_all
123: WHERE vendor_id = i_vendor_id
124: AND vendor_site_id = i_vendor_site_id;
125:
126: IF l_check_vsid = 0 THEN

Line 301: TYPE t_site_tab IS TABLE OF ap_supplier_sites_all%ROWTYPE

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:
304: CURSOR c_supplier
305: IS

Line 315: l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';

311: c_contact t_contact_refcur;
312: l_supplier_tab t_supplier_tab;
313: l_site_tab t_site_tab;
314: l_contact_tab t_contacts_tab;
315: l_site_sel VARCHAR2(1000) := 'SELECT * FROM ap_supplier_sites_all ';
316: l_site_where VARCHAR2(1000) := ' WHERE vendor_id = ' ;
317: l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';
318: l_contact_where VARCHAR2(1000) := ' WHERE vendor_id = ' ;
319: l_supplier_indx NUMBER;