APPS.FND_NET_SERVICES dependencies on FND_TNS_ALIAS_SETS

Line 420: from fnd_tns_aliases a, fnd_tns_alias_sets b

416: if ( l_tns_alias_guid is null )
417: then
418: select a.tns_alias_guid
419: into l_tns_alias_guid
420: from fnd_tns_aliases a, fnd_tns_alias_sets b
421: where b.tns_alias_set_name = p_alias_set_name
422: and b.tns_alias_set_guid = a.alias_set_guid
423: and a.alias_name = p_alias_name;
424: end if;

Line 745: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

741: l_tns_sid_alias raw(16);
742:
743: l_tns_alias_set_guid_pub raw(16);
744: l_tns_alias_set_guid_int raw(16);
745: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
746: l_internal_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
747:
748: l_listener_port_guid raw(16);
749:

Line 746: l_internal_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

742:
743: l_tns_alias_set_guid_pub raw(16);
744: l_tns_alias_set_guid_int raw(16);
745: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
746: l_internal_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
747:
748: l_listener_port_guid raw(16);
749:
750: l_instRec fnd_database_instances%rowtype;

Line 784: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

780: cursor c4(p_system_guid raw)
781: is select f.Tns_Alias_Description_Guid,
782: e.alias_name,d.tns_alias_set_name
783: from fnd_system_server_map a, fnd_app_servers b,
784: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,
785: fnd_tns_aliases e, fnd_tns_alias_descriptions f
786: where a.System_GUID = p_System_Guid
787: and a.Server_GUID = b.Server_GUID
788: and b.server_type = fnd_app_system.C_DB_SERVER_TYPE

Line 1032: from fnd_tns_alias_sets a

1028: Alias_set_type => fnd_app_system.C_ALIAS_SET_NAME_PUB );
1029:
1030: select a.tns_alias_set_guid
1031: into l_tns_alias_set_guid_pub
1032: from fnd_tns_alias_sets a
1033: where a.tns_alias_set_name = l_public_alias_set_name;
1034:
1035: fnd_app_system.register_aliasset_usage
1036: ( tns_alias_set_guid => l_tns_alias_set_guid_pub,

Line 1045: from fnd_tns_alias_sets a

1041: Alias_set_type => fnd_app_system.C_ALIAS_SET_NAME_INT );
1042:
1043: select a.tns_alias_set_guid
1044: into l_tns_alias_set_guid_int
1045: from fnd_tns_alias_sets a
1046: where a.tns_alias_set_name = l_internal_alias_set_name;
1047:
1048: fnd_app_system.register_aliasset_usage
1049: ( tns_alias_set_guid => l_tns_alias_set_guid_int,

Line 1218: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

1214:
1215: select count(*)
1216: into l_db_alias_exists
1217: from fnd_system_server_map a, fnd_app_servers b,
1218: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,
1219: fnd_tns_aliases e
1220: where a.System_GUID = l_System_Guid
1221: and a.Server_GUID = b.Server_GUID
1222: and b.server_type = fnd_app_system.C_DB_SERVER_TYPE

Line 1410: fnd_tns_alias_sets c, fnd_app_servers d,

1406:
1407: cursor c5(p_System_Guid raw,p_alias_name varchar2,p_alias_type varchar2) is
1408: select e.Tns_Alias_Guid,e.Alias_Type
1409: from fnd_system_server_map a,fnd_tns_alias_set_usage b,
1410: fnd_tns_alias_sets c, fnd_app_servers d,
1411: fnd_tns_aliases e
1412: where a.system_guid = p_System_Guid
1413: and a.server_guid = b.server_guid
1414: and b.tns_alias_set_guid = c.tns_alias_set_guid

Line 1671: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

1667:
1668: l_auto_create_aliases boolean := false;
1669:
1670: l_tns_alias_set_guid_pub raw(16);
1671: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;
1672:
1673: l_fndfs_tns_alias raw(16);
1674: l_fndsm_tns_alias raw(16);
1675: l_fndfs_sid_alias raw(16);

Line 1840: from fnd_tns_alias_sets a

1836: Alias_set_type => fnd_app_system.C_ALIAS_SET_NAME_PUB );
1837:
1838: select a.tns_alias_set_guid
1839: into l_tns_alias_set_guid_pub
1840: from fnd_tns_alias_sets a
1841: where a.tns_alias_set_name = l_public_alias_set_name;
1842:
1843: fnd_app_system.register_aliasset_usage
1844: ( tns_alias_set_guid => l_tns_alias_set_guid_pub,

Line 2112: from fnd_tns_aliases a,fnd_tns_alias_sets b

2108: cursor c1 is select a.alias_name,a.Alias_Type,
2109: a.Failover,a.Load_Balance,
2110: b.tns_alias_set_name,
2111: b.tns_alias_set_type
2112: from fnd_tns_aliases a,fnd_tns_alias_sets b
2113: where a.tns_alias_guid = p_tns_alias_guid
2114: and a.alias_set_guid = b.tns_alias_set_guid;
2115:
2116: cursor c2 is select c.tns_alias_description_guid,

Line 2988: delete from fnd_tns_alias_sets a

2984: end loop;
2985:
2986: end if;
2987:
2988: delete from fnd_tns_alias_sets a
2989: where a.tns_alias_set_guid
2990: in ( select b.tns_alias_set_guid
2991: from fnd_tns_alias_set_usage b
2992: where b.server_guid = f_server.server_guid );