[Home] [Help]
893: );
894:
895: select a.Oracle_Home_Id
896: into l_Oracle_Home_Id
897: from fnd_oracle_homes a
898: where a.node_id = l_node_id
899: and a.path = OracleHomePath;
900:
901: -- Register Server
1784: -- Get Home Ids
1785:
1786: select a.Oracle_Home_Id
1787: into l_Pri_Oracle_Home_Id
1788: from fnd_oracle_homes a
1789: where a.node_id = l_node_id
1790: and a.path = PriOracleHomePath;
1791:
1792: select a.Oracle_Home_Id
1790: and a.path = PriOracleHomePath;
1791:
1792: select a.Oracle_Home_Id
1793: into l_Aux_Oracle_Home_Id
1794: from fnd_oracle_homes a
1795: where a.node_id = l_node_id
1796: and a.path = AuxOracleHomePath;
1797:
1798: select a.appl_top_guid
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
2468: from fnd_oracle_homes
2469: where oracle_home_id = p_oracle_home_id;
2470:
2471: l_nodeRec fnd_nodes%rowtype;
2472:
2662: for f_system in c1(SystemName) loop
2663:
2664: for f_server in c2(f_system.System_Guid,ServerName) loop
2665:
2666: delete from fnd_oracle_homes a
2667: where a.oracle_home_id = f_server.pri_oracle_home
2668: and not exists ( select b.name
2669: from fnd_app_servers b
2670: where ( b.pri_oracle_home
2798: for f_system in c1(SystemName) loop
2799:
2800: for f_server in c2(f_system.System_Guid,ServerName) loop
2801:
2802: delete from fnd_oracle_homes a
2803: where a.oracle_home_id = f_server.pri_oracle_home
2804: and not exists ( select b.name
2805: from fnd_app_servers b
2806: where ( b.pri_oracle_home
2812: );
2813:
2814: if ( f_server.aux_oracle_home is not null )
2815: then
2816: delete from fnd_oracle_homes a
2817: where a.oracle_home_id = f_server.aux_oracle_home
2818: and not exists ( select b.name
2819: from fnd_app_servers b
2820: where ( b.pri_oracle_home