APPS.FND_NET_SERVICES dependencies on FND_TNS_LISTENERS

Line 1064: from fnd_tns_listeners a

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

Line 1863: from fnd_tns_listeners a

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

Line 2019: fnd_tns_listener_ports c, fnd_tns_listeners d

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

Line 2639: fnd_tns_listeners c

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

Line 2725: delete from fnd_tns_listeners a

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

Line 2789: fnd_tns_listeners c

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

Line 2888: delete from fnd_tns_listeners a

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