eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_TCA_SUPPLIER_SYNC_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 199: l_state ap_supplier_sites_all.state%type;

195: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_Supplier_Sites';
196: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
197:
198: --
199: l_state ap_supplier_sites_all.state%type;
200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;

Line 200: l_province ap_supplier_sites_all.province%type;

196: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
197:
198: --
199: l_state ap_supplier_sites_all.state%type;
200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;

Line 201: l_county ap_supplier_sites_all.county%type;

197:
198: --
199: l_state ap_supplier_sites_all.state%type;
200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;

Line 202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;

198: --
199: l_state ap_supplier_sites_all.state%type;
200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;

Line 203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;

199: l_state ap_supplier_sites_all.state%type;
200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;

Line 204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;

200: l_province ap_supplier_sites_all.province%type;
201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;

Line 205: l_city ap_supplier_sites_all.city%type;

201: l_county ap_supplier_sites_all.county%type;
202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;

Line 206: l_zip ap_supplier_sites_all.zip%type;

202: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;

Line 207: l_country ap_supplier_sites_all.country%type;

203: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;

Line 208: l_address_style ap_supplier_sites_all.address_style%type;

204: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;

Line 209: l_language ap_supplier_sites_all.language%type;

205: l_city ap_supplier_sites_all.city%type;
206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;

Line 210: l_address1 ap_supplier_sites_all.address_line1%type;

206: l_zip ap_supplier_sites_all.zip%type;
207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;

Line 211: l_address2 ap_supplier_sites_all.address_line2%type;

207: l_country ap_supplier_sites_all.country%type;
208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
215:

Line 212: l_address3 ap_supplier_sites_all.address_line3%type;

208: l_address_style ap_supplier_sites_all.address_style%type;
209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
215:
216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;

Line 213: l_address4 ap_supplier_sites_all.address_line4%type;

209: l_language ap_supplier_sites_all.language%type;
210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
215:
216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
217:

Line 214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;

210: l_address1 ap_supplier_sites_all.address_line1%type;
211: l_address2 ap_supplier_sites_all.address_line2%type;
212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
215:
216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
217:
218:

Line 216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;

212: l_address3 ap_supplier_sites_all.address_line3%type;
213: l_address4 ap_supplier_sites_all.address_line4%type;
214: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
215:
216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
217:
218:
219: l_duns_number ap_supplier_sites_all.duns_number%type;
220:

Line 219: l_duns_number ap_supplier_sites_all.duns_number%type;

215:
216: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
217:
218:
219: l_duns_number ap_supplier_sites_all.duns_number%type;
220:
221: BEGIN
222:
223: -- Initialize API return status to success

Line 304: FROM ap_supplier_sites_all

300:
301: BEGIN
302: SELECT vendor_site_id
303: INTO l_check_vendor_site_id
304: FROM ap_supplier_sites_all
305: WHERE location_id = x_location_id
306: AND rownum = 1;
307: EXCEPTION
308: WHEN OTHERS THEN

Line 331: UPDATE ap_supplier_sites_all

327: -- The columns at the site level that fall into this category are
328: -- state, province and county.
329: --
330:
331: UPDATE ap_supplier_sites_all
332: SET tca_sync_state = nvl(tca_sync_state,state),
333: tca_sync_county = nvl(tca_sync_county,county),
334: tca_sync_province = nvl(tca_sync_province,province)
335: WHERE location_id = x_location_id;

Line 343: UPDATE ap_supplier_sites_all

339: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||
340: '.'||l_procedure_name, l_log_msg);
341: END IF;
342:
343: UPDATE ap_supplier_sites_all
344: SET state = l_state,
345: province = l_province,
346: county = l_county,
347: tca_sync_city = l_tca_sync_city,

Line 405: UPDATE ap_supplier_sites_all

401: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||
402: '.'||l_procedure_name, l_log_msg);
403: END IF;
404:
405: UPDATE ap_supplier_sites_all
406: SET duns_number = l_duns_number
407: WHERE party_site_id = x_party_site_id
408: AND EXISTS (SELECT 'Site Exists'
409: FROM ap_supplier_sites_all a

Line 409: FROM ap_supplier_sites_all a

405: UPDATE ap_supplier_sites_all
406: SET duns_number = l_duns_number
407: WHERE party_site_id = x_party_site_id
408: AND EXISTS (SELECT 'Site Exists'
409: FROM ap_supplier_sites_all a
410: WHERE a.party_site_id = x_party_site_id);
411:
412: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
413: l_log_msg := 'After Update of Site Attributes for : '|| x_party_site_id;