[Home] [Help]
891: );
892:
893: select a.Oracle_Home_Id
894: into l_Oracle_Home_Id
895: from fnd_oracle_homes a
896: where a.node_id = l_node_id
897: and a.path = OracleHomePath;
898:
899: -- Register Server
1782: -- Get Home Ids
1783:
1784: select a.Oracle_Home_Id
1785: into l_Pri_Oracle_Home_Id
1786: from fnd_oracle_homes a
1787: where a.node_id = l_node_id
1788: and a.path = PriOracleHomePath;
1789:
1790: select a.Oracle_Home_Id
1788: and a.path = PriOracleHomePath;
1789:
1790: select a.Oracle_Home_Id
1791: into l_Aux_Oracle_Home_Id
1792: from fnd_oracle_homes a
1793: where a.node_id = l_node_id
1794: and a.path = AuxOracleHomePath;
1795:
1796: select a.appl_top_guid
2462: where appl_top_guid = p_appl_top_guid;
2463:
2464: cursor c4(p_oracle_home_id raw)
2465: is select name,Path,Version,Description
2466: from fnd_oracle_homes
2467: where oracle_home_id = p_oracle_home_id;
2468:
2469: l_nodeRec fnd_nodes%rowtype;
2470:
2660: for f_system in c1(SystemName) loop
2661:
2662: for f_server in c2(f_system.System_Guid,ServerName) loop
2663:
2664: delete from fnd_oracle_homes a
2665: where a.oracle_home_id = f_server.pri_oracle_home
2666: and not exists ( select b.name
2667: from fnd_app_servers b
2668: where ( b.pri_oracle_home
2796: for f_system in c1(SystemName) loop
2797:
2798: for f_server in c2(f_system.System_Guid,ServerName) loop
2799:
2800: delete from fnd_oracle_homes a
2801: where a.oracle_home_id = f_server.pri_oracle_home
2802: and not exists ( select b.name
2803: from fnd_app_servers b
2804: where ( b.pri_oracle_home
2810: );
2811:
2812: if ( f_server.aux_oracle_home is not null )
2813: then
2814: delete from fnd_oracle_homes a
2815: where a.oracle_home_id = f_server.aux_oracle_home
2816: and not exists ( select b.name
2817: from fnd_app_servers b
2818: where ( b.pri_oracle_home