APPS.FND_NET_SERVICES dependencies on FND_TNS_ALIAS_SETS

Line 418: from fnd_tns_aliases a, fnd_tns_alias_sets b

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

Line 743: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

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

Line 744: l_internal_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

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

Line 782: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

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

Line 1030: from fnd_tns_alias_sets a

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

Line 1043: from fnd_tns_alias_sets a

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

Line 1216: fnd_tns_alias_set_usage c,fnd_tns_alias_sets d,

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

Line 1408: fnd_tns_alias_sets c, fnd_app_servers d,

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

Line 1669: l_public_alias_set_name fnd_tns_alias_sets.TNS_Alias_set_Name%type;

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

Line 1838: from fnd_tns_alias_sets a

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

Line 2110: from fnd_tns_aliases a,fnd_tns_alias_sets b

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

Line 2986: delete from fnd_tns_alias_sets a

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