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.IEM_DBLINK_PVT dependencies on ALL_DB_LINKS

Line 139: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);

135:
136: select CONCAT(l_iem_server_rec.service_name, '@appsto_oo') into l_glname from DUAL;
137:
138: l_search_string := l_iem_server_rec.service_name || '%' || '@appsto_oo';
139: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
140:
141: if (l_link_count <> 0) then
142: l_statement1 := 'DROP DATABASE LINK ' || l_glname;
143: end if;

Line 158: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);

154:
155: select CONCAT(l_iem_server_rec.service_name, '@appsto_ora') into l_glname from DUAL;
156:
157: l_search_string := l_iem_server_rec.service_name || '%' || '@appsto_ora';
158: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_string);
159:
160: if (l_link_count <> 0) then
161: l_statement1 := 'DROP DATABASE LINK ' || l_glname;
162: end if;

Line 248: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
245: -- database link creation cannot be rolled back, it must be dropped manually
246: WHEN link_not_correct THEN
247:
248: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
249:
250: if l_count <> 0 then
251: l_v_id := DBMS_SQL.OPEN_CURSOR;
252: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 265: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

261: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
262:
263: WHEN db_name_invalid_a THEN
264:
265: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
266:
267: if l_count <> 0 then
268: l_v_id := DBMS_SQL.OPEN_CURSOR;
269: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 281: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

277: FND_MSG_PUB.Add;
278: x_return_status := FND_API.G_RET_STS_ERROR ;
279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
280: WHEN db_name_invalid THEN
281: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
282:
283: if l_count <> 0 then
284: l_v_id := DBMS_SQL.OPEN_CURSOR;
285: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 297: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

293: FND_MSG_PUB.Add;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
296: WHEN db_name_invalid_spc THEN
297: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
298:
299: if l_count <> 0 then
300: l_v_id := DBMS_SQL.OPEN_CURSOR;
301: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 315: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
312:
313: WHEN glname_invalid THEN
314:
315: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
316:
317: if l_count <> 0 then
318: l_v_id := DBMS_SQL.OPEN_CURSOR;
319: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 331: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

327: FND_MSG_PUB.Add;
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330: WHEN login_denied THEN
331: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
332:
333: if l_count <> 0 then
334: l_v_id := DBMS_SQL.OPEN_CURSOR;
335: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 348: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
346:
347: WHEN password_invalid THEN
348: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
349:
350: if l_count <> 0 then
351: l_v_id := DBMS_SQL.OPEN_CURSOR;
352: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 365: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363:
364: WHEN user_invalid THEN
365: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
366:
367: if l_count <> 0 then
368: l_v_id := DBMS_SQL.OPEN_CURSOR;
369: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 400: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
398:
399: WHEN protocol_invalid THEN
400: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
401:
402: if l_count <> 0 then
403: l_v_id := DBMS_SQL.OPEN_CURSOR;
404: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 416: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

412: FND_MSG_PUB.Add;
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
415: WHEN sid_invalid THEN
416: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
417:
418: if l_count <> 0 then
419: l_v_id := DBMS_SQL.OPEN_CURSOR;
420: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 432: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

428: FND_MSG_PUB.Add;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
431: WHEN tns_no_listener THEN
432: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
433:
434: if l_count <> 0 then
435: l_v_id := DBMS_SQL.OPEN_CURSOR;
436: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 448: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

444: FND_MSG_PUB.Add;
445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
447: WHEN host_invalid THEN
448: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
449:
450: if l_count <> 0 then
451: l_v_id := DBMS_SQL.OPEN_CURSOR;
452: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 465: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
463:
464: WHEN host_invalid1 THEN
465: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
466:
467: if l_count <> 0 then
468: l_v_id := DBMS_SQL.OPEN_CURSOR;
469: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 482: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

478: x_return_status := FND_API.G_RET_STS_ERROR ;
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
480:
481: WHEN db_conn_desc_invalid THEN
482: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
483:
484: if l_count <> 0 then
485: l_v_id := DBMS_SQL.OPEN_CURSOR;
486: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 499: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

495: x_return_status := FND_API.G_RET_STS_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
500:
501: if l_count <> 0 then
502: l_v_id := DBMS_SQL.OPEN_CURSOR;
503: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 516: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
517:
518: if l_count <> 0 then
519: l_v_id := DBMS_SQL.OPEN_CURSOR;
520: l_statement := 'DROP DATABASE LINK '||l_glname;

Line 537: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);

533: -- bugfixed for #1921152 Aug 6, 2001
534:
535: -- if SQLCODE <> -06561 then -- invalid user and password
536:
537: select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
538:
539: if l_count <> 0 then
540: l_v_id := DBMS_SQL.OPEN_CURSOR;
541: l_statement := 'DROP DATABASE LINK '||l_glname;