APPS.FND_NET_SERVICES dependencies on FND_TNS_LISTENERS

Line 1062: from fnd_tns_listeners a

1058: alias_set_name => l_internal_alias_set_name
1059: );
1060: select a.Listener_GUID
1061: into l_Listener_GUID
1062: from fnd_tns_listeners a
1063: where a.Server_GUID = l_Server_Guid
1064: and a.Listener_Name = ServerName;
1065:
1066: -- Register Listener Ports

Line 1861: from fnd_tns_listeners a

1857: );
1858:
1859: select a.Listener_GUID
1860: into l_Listener_GUID
1861: from fnd_tns_listeners a
1862: where a.Server_GUID = l_Server_Guid
1863: and a.Listener_Name = fnd_app_system.C_APPS_LISTENER_ID ||
1864: '_' || ServerName;
1865:

Line 2017: fnd_tns_listener_ports c, fnd_tns_listeners d

2013: as
2014: cursor c1 is select d.listener_name,c.port,
2015: a.sequence_number,a.failover,a.load_balance
2016: from fnd_tns_alias_address_lists a, fnd_tns_alias_addresses b,
2017: fnd_tns_listener_ports c, fnd_tns_listeners d
2018: where a.Tns_Alias_Description_Guid = p_Tns_Alias_Description_Guid
2019: and a.Tns_Alias_Address_List_Guid =
2020: b.Tns_Alias_Address_List_Guid
2021: and b.listener_port_guid = c.listener_port_guid

Line 2637: fnd_tns_listeners c

2633:
2634: cursor c2(p_System_GUID raw, p_ServerName varchar2) is
2635: select a.Server_GUID,b.PRI_ORACLE_HOME,c.listener_guid
2636: from fnd_system_server_map a, fnd_app_servers b,
2637: fnd_tns_listeners c
2638: where a.System_GUID = p_System_GUID
2639: and a.Server_GUID = b.Server_GUID
2640: and b.name = p_ServerName
2641: and b.server_type = fnd_app_system.C_DB_SERVER_TYPE

Line 2723: delete from fnd_tns_listeners a

2719:
2720: delete from fnd_tns_listener_ports a
2721: where a.Listener_GUID = f_server.Listener_GUID;
2722:
2723: delete from fnd_tns_listeners a
2724: where a.Listener_GUID = f_server.Listener_GUID;
2725:
2726: end if;
2727:

Line 2787: fnd_tns_listeners c

2783: cursor c2(p_System_GUID raw, p_ServerName varchar2) is
2784: select a.Server_GUID,b.PRI_ORACLE_HOME,c.listener_guid,
2785: b.APPL_TOP_GUID,b.AUX_ORACLE_HOME
2786: from fnd_system_server_map a, fnd_app_servers b,
2787: fnd_tns_listeners c
2788: where a.System_GUID = p_System_GUID
2789: and a.Server_GUID = b.Server_GUID
2790: and b.name = p_ServerName
2791: and b.server_type = fnd_app_system.C_APP_SERVER_TYPE

Line 2886: delete from fnd_tns_listeners a

2882:
2883: delete from fnd_tns_listener_ports a
2884: where a.Listener_GUID = f_server.Listener_GUID;
2885:
2886: delete from fnd_tns_listeners a
2887: where a.Listener_GUID = f_server.Listener_GUID;
2888:
2889: end if;
2890: