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 204: l_state ap_supplier_sites_all.state%type;

200: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_Supplier_Sites';
201: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
202:
203: --
204: l_state ap_supplier_sites_all.state%type;
205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;

Line 205: l_province ap_supplier_sites_all.province%type;

201: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
202:
203: --
204: l_state ap_supplier_sites_all.state%type;
205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;

Line 206: l_county ap_supplier_sites_all.county%type;

202:
203: --
204: l_state ap_supplier_sites_all.state%type;
205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;

Line 207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;

203: --
204: l_state ap_supplier_sites_all.state%type;
205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;

Line 208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;

204: l_state ap_supplier_sites_all.state%type;
205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;

Line 209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;

205: l_province ap_supplier_sites_all.province%type;
206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;

Line 210: l_city ap_supplier_sites_all.city%type;

206: l_county ap_supplier_sites_all.county%type;
207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;

Line 211: l_zip ap_supplier_sites_all.zip%type;

207: l_tca_sync_city ap_supplier_sites_all.tca_sync_city%type;
208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;

Line 212: l_country ap_supplier_sites_all.country%type;

208: l_tca_sync_zip ap_supplier_sites_all.tca_sync_zip%type;
209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;

Line 213: l_address_style ap_supplier_sites_all.address_style%type;

209: l_tca_sync_country ap_supplier_sites_all.tca_sync_country%type;
210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;

Line 214: l_language ap_supplier_sites_all.language%type;

210: l_city ap_supplier_sites_all.city%type;
211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;

Line 215: l_address1 ap_supplier_sites_all.address_line1%type;

211: l_zip ap_supplier_sites_all.zip%type;
212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;

Line 216: l_address2 ap_supplier_sites_all.address_line2%type;

212: l_country ap_supplier_sites_all.country%type;
213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333

Line 217: l_address3 ap_supplier_sites_all.address_line3%type;

213: l_address_style ap_supplier_sites_all.address_style%type;
214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333
221:

Line 218: l_address4 ap_supplier_sites_all.address_line4%type;

214: l_language ap_supplier_sites_all.language%type;
215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333
221:
222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;

Line 219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;

215: l_address1 ap_supplier_sites_all.address_line1%type;
216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333
221:
222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
223:

Line 220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333

216: l_address2 ap_supplier_sites_all.address_line2%type;
217: l_address3 ap_supplier_sites_all.address_line3%type;
218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333
221:
222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
223:
224:

Line 222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;

218: l_address4 ap_supplier_sites_all.address_line4%type;
219: l_address_line_alt ap_supplier_sites_all.address_lines_alt%type;
220: l_last_update_date ap_supplier_sites_all.last_update_date%type; -- B# 7646333
221:
222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
223:
224:
225: l_duns_number ap_supplier_sites_all.duns_number%type;
226:

Line 225: l_duns_number ap_supplier_sites_all.duns_number%type;

221:
222: l_check_vendor_site_id ap_supplier_sites_all.vendor_site_id%type;
223:
224:
225: l_duns_number ap_supplier_sites_all.duns_number%type;
226:
227: BEGIN
228:
229: -- Initialize API return status to success

Line 314: FROM ap_supplier_sites_all

310: -- bug 8723400 starts
311: IF (x_vendor_site_id is not NULL) THEN
312: SELECT vendor_site_id
313: INTO l_check_vendor_site_id
314: FROM ap_supplier_sites_all
315: WHERE location_id = x_location_id
316: AND vendor_site_id = x_vendor_site_id
317: AND rownum = 1;
318: ELSE

Line 321: FROM ap_supplier_sites_all

317: AND rownum = 1;
318: ELSE
319: SELECT vendor_site_id
320: INTO l_check_vendor_site_id
321: FROM ap_supplier_sites_all
322: WHERE location_id = x_location_id
323: AND rownum = 1;
324: END IF;
325: -- bug 8723400 ends

Line 350: UPDATE ap_supplier_sites_all

346: -- The columns at the site level that fall into this category are
347: -- state, province and county.
348: --
349:
350: UPDATE ap_supplier_sites_all
351: SET tca_sync_state = nvl(tca_sync_state,state),
352: tca_sync_county = nvl(tca_sync_county,county),
353: tca_sync_province = nvl(tca_sync_province,province)
354: WHERE location_id = x_location_id;

Line 362: UPDATE ap_supplier_sites_all

358: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||
359: '.'||l_procedure_name, l_log_msg);
360: END IF;
361:
362: UPDATE ap_supplier_sites_all
363: SET state = l_state,
364: province = l_province,
365: county = l_county,
366: tca_sync_city = l_tca_sync_city,

Line 383: UPDATE ap_supplier_sites_all

379: WHERE location_id = x_location_id;
380:
381: --bug 8723400 starts
382: IF (x_vendor_site_id is not NULL) THEN
383: UPDATE ap_supplier_sites_all
384: SET last_update_date = SYSDATE -- B# 7646333
385: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
386: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
387: WHERE location_id = x_location_id

Line 390: UPDATE ap_supplier_sites_all

386: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
387: WHERE location_id = x_location_id
388: AND vendor_site_id = l_check_vendor_site_id;
389: ELSE
390: UPDATE ap_supplier_sites_all
391: SET last_update_date = SYSDATE -- B# 7646333
392: ,LAST_UPDATED_BY = FND_GLOBAL.user_id -- B# 7646333
393: ,last_update_login = FND_GLOBAL.LOGIN_ID -- B# 7646333
394: WHERE location_id = x_location_id;

Line 441: UPDATE ap_supplier_sites_all

437: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||
438: '.'||l_procedure_name, l_log_msg);
439: END IF;
440:
441: UPDATE ap_supplier_sites_all
442: SET duns_number = l_duns_number
443: WHERE party_site_id = x_party_site_id
444: AND EXISTS (SELECT 'Site Exists'
445: FROM ap_supplier_sites_all a

Line 445: FROM ap_supplier_sites_all a

441: UPDATE ap_supplier_sites_all
442: SET duns_number = l_duns_number
443: WHERE party_site_id = x_party_site_id
444: AND EXISTS (SELECT 'Site Exists'
445: FROM ap_supplier_sites_all a
446: WHERE a.party_site_id = x_party_site_id);
447:
448: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
449: l_log_msg := 'After Update of Site Attributes for : '|| x_party_site_id;