APPS.AP_SUPPLIER_INFO_PKG dependencies on PO_VENDOR_CONTACTS

Line 76: l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';

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 = '
78: || to_char(i_vendor_id);
79: l_site_indx NUMBER;
80: l_contact_indx NUMBER;

Line 143: FROM po_vendor_contacts

139:
140: IF i_vendor_contact_id IS NOT NULL THEN
141: SELECT count(1)
142: INTO l_check_vcid
143: FROM po_vendor_contacts
144: WHERE vendor_id = i_vendor_id
145: AND vendor_site_id = i_vendor_site_id
146: AND vendor_contact_id = i_vendor_contact_id;
147:

Line 166: FROM po_vendor_contacts

162: ELSE
163: IF i_vendor_contact_id IS NOT NULL THEN
164: SELECT count(1)
165: INTO l_check_vcid
166: FROM po_vendor_contacts
167: WHERE vendor_id = i_vendor_id
168: AND vendor_contact_id = i_vendor_contact_id;
169:
170: IF l_check_vcid = 0 THEN

Line 182: || 'FROM PO_VENDOR_CONTACTS '

178: ELSE
179: l_site_where := l_site_where
180: || ' AND vendor_site_id IN ( '
181: || 'SELECT vendor_site_id '
182: || 'FROM PO_VENDOR_CONTACTS '
183: || 'WHERE vendor_contact_id = '
184: || to_char( i_vendor_contact_id ) || ' )' ;
185:
186: l_contact_where := l_contact_where

Line 317: l_contact_sel VARCHAR2(1000) := 'SELECT * FROM po_vendor_contacts ';

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;
320: l_site_indx NUMBER;
321: l_contact_indx NUMBER;