APPS.FND_NET_SERVICES dependencies on DBMS_OUTPUT

Line 2028: dbms_output.put_line ( fmtline('SeqNo',8) ||

2024: begin
2025:
2026: for f_listener1 in c1 loop
2027:
2028: dbms_output.put_line ( fmtline('SeqNo',8) ||
2029: fmtline('Lsrn Name',30) ||
2030: fmtline('Lsrn Port',20) ||
2031: fmtline('Fov',4) ||
2032: fmtline('Bal',4)

Line 2035: dbms_output.put_line ( fmtuline(8) || fmtuline(30) || fmtuline(20) ||

2031: fmtline('Fov',4) ||
2032: fmtline('Bal',4)
2033: );
2034:
2035: dbms_output.put_line ( fmtuline(8) || fmtuline(30) || fmtuline(20) ||
2036: fmtuline(4) || fmtuline(4) );
2037:
2038: dbms_output.put_line ( fmtline(f_listener1.sequence_number,8) ||
2039: fmtline(f_listener1.listener_name,30)||

Line 2038: dbms_output.put_line ( fmtline(f_listener1.sequence_number,8) ||

2034:
2035: dbms_output.put_line ( fmtuline(8) || fmtuline(30) || fmtuline(20) ||
2036: fmtuline(4) || fmtuline(4) );
2037:
2038: dbms_output.put_line ( fmtline(f_listener1.sequence_number,8) ||
2039: fmtline(f_listener1.listener_name,30)||
2040: fmtline(f_listener1.port,20) ||
2041: fmtline(f_listener1.Failover,4) ||
2042: fmtline(f_listener1.Load_Balance,4)

Line 2059: dbms_output.put_line ( fmtline('Service Name',30) );

2055: begin
2056:
2057: for f_service in c1 loop
2058:
2059: dbms_output.put_line ( fmtline('Service Name',30) );
2060:
2061: dbms_output.put_line ( fmtuline(30));
2062:
2063: dbms_output.put_line ( fmtline(f_service.service_name,30) );

Line 2061: dbms_output.put_line ( fmtuline(30));

2057: for f_service in c1 loop
2058:
2059: dbms_output.put_line ( fmtline('Service Name',30) );
2060:
2061: dbms_output.put_line ( fmtuline(30));
2062:
2063: dbms_output.put_line ( fmtline(f_service.service_name,30) );
2064:
2065: end loop;

Line 2063: dbms_output.put_line ( fmtline(f_service.service_name,30) );

2059: dbms_output.put_line ( fmtline('Service Name',30) );
2060:
2061: dbms_output.put_line ( fmtuline(30));
2062:
2063: dbms_output.put_line ( fmtline(f_service.service_name,30) );
2064:
2065: end loop;
2066:
2067: end;

Line 2085: dbms_output.put_line ( fmtline('Service Name',20) ||

2081: begin
2082:
2083: for f_service in c1 loop
2084:
2085: dbms_output.put_line ( fmtline('Service Name',20) ||
2086: fmtline('Instance Name',20) ||
2087: fmtline('Instance Number',15)||
2088: fmtline('10g-Pref/Ava',15) );
2089:

Line 2090: dbms_output.put_line ( fmtuline(20) || fmtuline(20) || fmtuline(15) ||

2086: fmtline('Instance Name',20) ||
2087: fmtline('Instance Number',15)||
2088: fmtline('10g-Pref/Ava',15) );
2089:
2090: dbms_output.put_line ( fmtuline(20) || fmtuline(20) || fmtuline(15) ||
2091: fmtuline(15) );
2092:
2093: dbms_output.put_line ( fmtline(f_service.service_name,20) ||
2094: fmtline(f_service.Instance_Name,20) ||

Line 2093: dbms_output.put_line ( fmtline(f_service.service_name,20) ||

2089:
2090: dbms_output.put_line ( fmtuline(20) || fmtuline(20) || fmtuline(15) ||
2091: fmtuline(15) );
2092:
2093: dbms_output.put_line ( fmtline(f_service.service_name,20) ||
2094: fmtline(f_service.Instance_Name,20) ||
2095: fmtline(f_service.Instance_Number,15) ||
2096: fmtline(f_service.instance_type,15) );
2097:

Line 2125: dbms_output.put_line('>>>>');

2121: order by c.sequence_number;
2122:
2123: begin
2124:
2125: dbms_output.put_line('>>>>');
2126:
2127: dbms_output.put_line ( fmtline('TNS Info for ' || p_info ,50) );
2128:
2129: dbms_output.put_line ( fmtuline(50) );

Line 2127: dbms_output.put_line ( fmtline('TNS Info for ' || p_info ,50) );

2123: begin
2124:
2125: dbms_output.put_line('>>>>');
2126:
2127: dbms_output.put_line ( fmtline('TNS Info for ' || p_info ,50) );
2128:
2129: dbms_output.put_line ( fmtuline(50) );
2130:
2131: for f_tns_alias in c1 loop

Line 2129: dbms_output.put_line ( fmtuline(50) );

2125: dbms_output.put_line('>>>>');
2126:
2127: dbms_output.put_line ( fmtline('TNS Info for ' || p_info ,50) );
2128:
2129: dbms_output.put_line ( fmtuline(50) );
2130:
2131: for f_tns_alias in c1 loop
2132:
2133: dbms_output.put_line ( fmtline('Alias Name',20) ||

Line 2133: dbms_output.put_line ( fmtline('Alias Name',20) ||

2129: dbms_output.put_line ( fmtuline(50) );
2130:
2131: for f_tns_alias in c1 loop
2132:
2133: dbms_output.put_line ( fmtline('Alias Name',20) ||
2134: fmtline('Type',20) ||
2135: fmtline('Fov',4) ||
2136: fmtline('Bal',4) ||
2137: fmtline('Alias Set Name',26) ||

Line 2141: dbms_output.put_line ( fmtuline(20) ||

2137: fmtline('Alias Set Name',26) ||
2138: fmtline('Set Type',10)
2139: );
2140:
2141: dbms_output.put_line ( fmtuline(20) ||
2142: fmtuline(20) ||
2143: fmtuline(4) ||
2144: fmtuline(4) ||
2145: fmtuline(26) ||

Line 2149: dbms_output.put_line

2145: fmtuline(26) ||
2146: fmtuline(10)
2147: );
2148:
2149: dbms_output.put_line
2150: ( fmtline(f_tns_alias.alias_name,20) ||
2151: fmtline(f_tns_alias.Alias_Type,20) ||
2152: fmtline(f_tns_alias.Failover,4) ||
2153: fmtline(f_tns_alias.Load_Balance,4) ||

Line 2160: dbms_output.put_line ( fmtline('SeqNo',8) ||

2156: );
2157:
2158: for f_desc in c2 loop
2159:
2160: dbms_output.put_line ( fmtline('SeqNo',8) ||
2161: fmtline('Fov',4) ||
2162: fmtline('Bal',4) ||
2163: fmtline('SrvName',16) ||
2164: fmtline('InstName',16)

Line 2167: dbms_output.put_line ( fmtuline(8 ) ||

2163: fmtline('SrvName',16) ||
2164: fmtline('InstName',16)
2165: );
2166:
2167: dbms_output.put_line ( fmtuline(8 ) ||
2168: fmtuline(4) ||
2169: fmtuline(4) ||
2170: fmtuline(16) ||
2171: fmtuline(16)

Line 2174: dbms_output.put_line

2170: fmtuline(16) ||
2171: fmtuline(16)
2172: );
2173:
2174: dbms_output.put_line
2175: ( fmtline(f_desc.sequence_number,8) ||
2176: fmtline(f_desc.Failover,4) ||
2177: fmtline(f_desc.Load_Balance,4) ||
2178: fmtline(f_desc.service_name,16) ||

Line 2325: dbms_output.put_line('>>>');

2321: l_tns_db_alias raw(16);
2322:
2323: begin
2324:
2325: dbms_output.put_line('>>>');
2326: dbms_output.put_line('>>> Show Instance');
2327: dbms_output.put_line('>>>');
2328:
2329: for f_instance in c1 loop

Line 2326: dbms_output.put_line('>>> Show Instance');

2322:
2323: begin
2324:
2325: dbms_output.put_line('>>>');
2326: dbms_output.put_line('>>> Show Instance');
2327: dbms_output.put_line('>>>');
2328:
2329: for f_instance in c1 loop
2330:

Line 2327: dbms_output.put_line('>>>');

2323: begin
2324:
2325: dbms_output.put_line('>>>');
2326: dbms_output.put_line('>>> Show Instance');
2327: dbms_output.put_line('>>>');
2328:
2329: for f_instance in c1 loop
2330:
2331: for f_sid in c4(f_instance.sid_guid) loop

Line 2337: dbms_output.put_line

2333: l_sid2 := f_sid.sid;
2334:
2335: end loop;
2336:
2337: dbms_output.put_line
2338: (
2339: fmtline('Inst Name',10) ||
2340: fmtline('Inst No', 8) ||
2341: fmtline('Config',10) ||

Line 2347: dbms_output.put_line

2343: fmtline('InterCnt',15) ||
2344: fmtline('SID',10)
2345: );
2346:
2347: dbms_output.put_line
2348: (
2349: fmtuline(10) ||
2350: fmtuline( 8) ||
2351: fmtuline(10) ||

Line 2357: dbms_output.put_line

2353: fmtuline(15) ||
2354: fmtuline(10)
2355: );
2356:
2357: dbms_output.put_line
2358: (
2359: fmtline(f_instance.Instance_Name,10) ||
2360: fmtline(f_instance.Instance_Number, 8) ||
2361: fmtline(f_instance.Configuration,10) ||

Line 2381: dbms_output.put_line ( fmtline('DB Name',10) ||

2377: end loop;
2378:
2379: l_db_name := f_database.db_name;
2380:
2381: dbms_output.put_line ( fmtline('DB Name',10) ||
2382: fmtline('Domain',20) ||
2383: fmtline('Cluster',8) ||
2384: fmtline('Version',10) ||
2385: fmtline('Assgn',10)

Line 2388: dbms_output.put_line ( fmtuline(10) ||

2384: fmtline('Version',10) ||
2385: fmtline('Assgn',10)
2386: );
2387:
2388: dbms_output.put_line ( fmtuline(10) ||
2389: fmtuline(20) ||
2390: fmtuline(8) ||
2391: fmtuline(10) ||
2392: fmtuline(10)

Line 2395: dbms_output.put_line

2391: fmtuline(10) ||
2392: fmtuline(10)
2393: );
2394:
2395: dbms_output.put_line
2396: ( fmtline(f_database.db_name,10) ||
2397: fmtline(f_database.db_domain,20) ||
2398: fmtline(f_database.Is_rac_db, 8) ||
2399: fmtline(f_database.Version,10) ||

Line 2415: dbms_output.put_line ( fmtline('Service Name',20) ||

2411: from fnd_db_service_members a
2412: where a.db_service_guid = f_service.db_service_guid
2413: and a.Instance_Guid = f_instance.Instance_Guid ;
2414:
2415: dbms_output.put_line ( fmtline('Service Name',20) ||
2416: fmtline('Description',30) ||
2417: fmtline('Member',10)
2418: );
2419:

Line 2420: dbms_output.put_line ( fmtuline(20) ||

2416: fmtline('Description',30) ||
2417: fmtline('Member',10)
2418: );
2419:
2420: dbms_output.put_line ( fmtuline(20) ||
2421: fmtuline(30) ||
2422: fmtuline(10)
2423: );
2424:

Line 2425: dbms_output.put_line

2421: fmtuline(30) ||
2422: fmtuline(10)
2423: );
2424:
2425: dbms_output.put_line
2426: ( fmtline(f_service.Service_Name,20) ||
2427: fmtline(f_service.Description,30) ||
2428: fmtline(l_service_member,10)
2429: );

Line 2473: dbms_output.enable(1000000);

2469: l_nodeRec fnd_nodes%rowtype;
2470:
2471: begin
2472:
2473: dbms_output.enable(1000000);
2474:
2475: for f_app_rec in c1 loop
2476:
2477: dbms_output.put_line

Line 2477: dbms_output.put_line

2473: dbms_output.enable(1000000);
2474:
2475: for f_app_rec in c1 loop
2476:
2477: dbms_output.put_line
2478: (
2479: fmtline('System Name',15) ||
2480: fmtline('Version',15) ||
2481: fmtline('Owner',20) ||

Line 2485: dbms_output.put_line

2481: fmtline('Owner',20) ||
2482: fmtline('CSI Number',15)
2483: );
2484:
2485: dbms_output.put_line
2486: (
2487: fmtuline(15) ||
2488: fmtuline(15) ||
2489: fmtuline(20) ||

Line 2493: dbms_output.put_line

2489: fmtuline(20) ||
2490: fmtuline(15)
2491: );
2492:
2493: dbms_output.put_line
2494: (
2495: fmtline(f_app_rec.name,15) ||
2496: fmtline(f_app_rec.version,15) ||
2497: fmtline(f_app_rec.owner,20) ||

Line 2509: dbms_output.put_line('>');

2505: ' where a.node_id = :v1 '
2506: into l_nodeRec
2507: using f_server.node_id;
2508:
2509: dbms_output.put_line('>');
2510:
2511: dbms_output.put_line
2512: (
2513: fmtline('Server Name',20) ||

Line 2511: dbms_output.put_line

2507: using f_server.node_id;
2508:
2509: dbms_output.put_line('>');
2510:
2511: dbms_output.put_line
2512: (
2513: fmtline('Server Name',20) ||
2514: fmtline('Internal',10) ||
2515: fmtline('Type',10) ||

Line 2521: dbms_output.put_line( fmtuline(20) ||

2517: fmtline('Host',10) ||
2518: fmtline('Domain',15)
2519: );
2520:
2521: dbms_output.put_line( fmtuline(20) ||
2522: fmtuline(10) ||
2523: fmtuline(10) ||
2524: fmtuline(10) ||
2525: fmtuline(10) ||

Line 2528: dbms_output.put_line

2524: fmtuline(10) ||
2525: fmtuline(10) ||
2526: fmtuline(15) );
2527:
2528: dbms_output.put_line
2529: (
2530: fmtline(f_server.name,20) ||
2531: fmtline(f_server.internal,10) ||
2532: fmtline(f_server.server_type,10) ||

Line 2547: dbms_output.put_line('>>');

2543: then
2544:
2545: for f_appl_top in c3(f_server.appl_top_guid) loop
2546:
2547: dbms_output.put_line('>>');
2548:
2549: dbms_output.put_line ( fmtline('App Name|Path',20) ||
2550: fmtline('Shared',10) );
2551:

Line 2549: dbms_output.put_line ( fmtline('App Name|Path',20) ||

2545: for f_appl_top in c3(f_server.appl_top_guid) loop
2546:
2547: dbms_output.put_line('>>');
2548:
2549: dbms_output.put_line ( fmtline('App Name|Path',20) ||
2550: fmtline('Shared',10) );
2551:
2552: dbms_output.put_line ( fmtuline(20) || fmtuline(10) );
2553:

Line 2552: dbms_output.put_line ( fmtuline(20) || fmtuline(10) );

2548:
2549: dbms_output.put_line ( fmtline('App Name|Path',20) ||
2550: fmtline('Shared',10) );
2551:
2552: dbms_output.put_line ( fmtuline(20) || fmtuline(10) );
2553:
2554: dbms_output.put_line ( fmtline(f_appl_top.name,20) ||
2555: fmtline(f_appl_top.shared,10) );
2556: dbms_output.put_line( f_appl_top.path );

Line 2554: dbms_output.put_line ( fmtline(f_appl_top.name,20) ||

2550: fmtline('Shared',10) );
2551:
2552: dbms_output.put_line ( fmtuline(20) || fmtuline(10) );
2553:
2554: dbms_output.put_line ( fmtline(f_appl_top.name,20) ||
2555: fmtline(f_appl_top.shared,10) );
2556: dbms_output.put_line( f_appl_top.path );
2557:
2558: end loop;

Line 2556: dbms_output.put_line( f_appl_top.path );

2552: dbms_output.put_line ( fmtuline(20) || fmtuline(10) );
2553:
2554: dbms_output.put_line ( fmtline(f_appl_top.name,20) ||
2555: fmtline(f_appl_top.shared,10) );
2556: dbms_output.put_line( f_appl_top.path );
2557:
2558: end loop;
2559: end if;
2560:

Line 2563: dbms_output.put_line('>>');

2559: end if;
2560:
2561: for f_o_home in c4(f_server.pri_oracle_home) loop
2562:
2563: dbms_output.put_line('>>');
2564:
2565: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2566: fmtline('Version',15) ||
2567: fmtline('Description',30) );

Line 2565: dbms_output.put_line ( fmtline('Home Name|Path',20) ||

2561: for f_o_home in c4(f_server.pri_oracle_home) loop
2562:
2563: dbms_output.put_line('>>');
2564:
2565: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2566: fmtline('Version',15) ||
2567: fmtline('Description',30) );
2568:
2569: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));

Line 2569: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));

2565: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2566: fmtline('Version',15) ||
2567: fmtline('Description',30) );
2568:
2569: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));
2570:
2571: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2572: fmtline(f_o_home.version,15) ||
2573: fmtline(f_o_home.Description,30) );

Line 2571: dbms_output.put_line ( fmtline(f_o_home.name,20) ||

2567: fmtline('Description',30) );
2568:
2569: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));
2570:
2571: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2572: fmtline(f_o_home.version,15) ||
2573: fmtline(f_o_home.Description,30) );
2574: dbms_output.put_line( f_o_home.path );
2575:

Line 2574: dbms_output.put_line( f_o_home.path );

2570:
2571: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2572: fmtline(f_o_home.version,15) ||
2573: fmtline(f_o_home.Description,30) );
2574: dbms_output.put_line( f_o_home.path );
2575:
2576: end loop;
2577:
2578: if ( f_server.aux_oracle_home is not null )

Line 2583: dbms_output.put_line('>>');

2579: then
2580:
2581: for f_o_home in c4(f_server.aux_oracle_home) loop
2582:
2583: dbms_output.put_line('>>');
2584:
2585: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2586: fmtline('Version',15) ||
2587: fmtline('Description',30) );

Line 2585: dbms_output.put_line ( fmtline('Home Name|Path',20) ||

2581: for f_o_home in c4(f_server.aux_oracle_home) loop
2582:
2583: dbms_output.put_line('>>');
2584:
2585: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2586: fmtline('Version',15) ||
2587: fmtline('Description',30) );
2588:
2589: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));

Line 2589: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));

2585: dbms_output.put_line ( fmtline('Home Name|Path',20) ||
2586: fmtline('Version',15) ||
2587: fmtline('Description',30) );
2588:
2589: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));
2590:
2591: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2592: fmtline(f_o_home.version,15) ||
2593: fmtline(f_o_home.Description,30) );

Line 2591: dbms_output.put_line ( fmtline(f_o_home.name,20) ||

2587: fmtline('Description',30) );
2588:
2589: dbms_output.put_line (fmtuline(20) || fmtuline(15) || fmtuline(30));
2590:
2591: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2592: fmtline(f_o_home.version,15) ||
2593: fmtline(f_o_home.Description,30) );
2594: dbms_output.put_line( f_o_home.path );
2595:

Line 2594: dbms_output.put_line( f_o_home.path );

2590:
2591: dbms_output.put_line ( fmtline(f_o_home.name,20) ||
2592: fmtline(f_o_home.version,15) ||
2593: fmtline(f_o_home.Description,30) );
2594: dbms_output.put_line( f_o_home.path );
2595:
2596: end loop;
2597: end if;
2598: