APPS.FND_NET_SERVICES dependencies on DBMS_OUTPUT

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2151: dbms_output.put_line

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

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

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

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

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

Line 2176: dbms_output.put_line

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

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

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

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

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

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

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

Line 2339: dbms_output.put_line

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

Line 2349: dbms_output.put_line

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

Line 2359: dbms_output.put_line

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

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

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

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

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

Line 2397: dbms_output.put_line

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

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

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

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

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

Line 2427: dbms_output.put_line

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

Line 2475: dbms_output.enable(1000000);

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

Line 2479: dbms_output.put_line

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

Line 2487: dbms_output.put_line

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

Line 2495: dbms_output.put_line

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

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

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

Line 2513: dbms_output.put_line

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

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

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

Line 2530: dbms_output.put_line

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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