1796: and a.path = AuxOracleHomePath;
1797:
1798: select a.appl_top_guid
1799: into l_Appl_Top_Guid
1800: from fnd_appl_tops a
1801: where a.node_id = l_node_id
1802: and a.path = ApplTopPath;
1803:
1804: -- Register Server
2459: order by a.node_id,a.Internal,a.Server_type,a.name;
2460:
2461: cursor c3(p_appl_top_guid raw)
2462: is select name,Path,Shared
2463: from fnd_appl_tops
2464: where appl_top_guid = p_appl_top_guid;
2465:
2466: cursor c4(p_oracle_home_id raw)
2467: is select name,Path,Version,Description
2828: end if;
2829:
2830: if ( f_server.appl_top_guid is not null )
2831: then
2832: delete from fnd_appl_tops a
2833: where a.appl_top_guid = f_server.appl_top_guid
2834: and not exists ( select b.name
2835: from fnd_app_servers b
2836: where b.appl_top_guid = f_server.appl_top_guid