APPS.FND_NET_SERVICES dependencies on FND_DATABASE_SERVICES

Line 166: from fnd_database_services a

162: -- Get db_guid
163:
164: select a.Db_Guid
165: into l_db_guid
166: from fnd_database_services a
167: where a.Db_Service_Guid = l_root_desc.Db_Service_Guid;
168:
169: -- Is it a valid service ?
170:

Line 173: from fnd_database_services a

169: -- Is it a valid service ?
170:
171: select count(*)
172: into l_valid_service
173: from fnd_database_services a
174: where a.Db_Guid = l_db_guid
175: and a.Service_Name = p_Service_Name;
176:
177: -- Is it a valid Instance ?

Line 184: from fnd_database_instances a, fnd_database_services b,

180: then
181:
182: select count(*)
183: into l_valid_instance
184: from fnd_database_instances a, fnd_database_services b,
185: fnd_db_service_members c
186: where a.db_guid = l_db_guid
187: and a.Instance_Name = p_Instance_name
188: and a.db_guid = b.db_guid

Line 798: from fnd_database_services a,fnd_database_instances b

794: and f.sequence_number <> 0;
795:
796: cursor c5(p_db_guid raw,p_instance_guid raw,p_service_name varchar2)
797: is select a.service_name,b.instance_name
798: from fnd_database_services a,fnd_database_instances b
799: where a.db_guid = p_db_guid
800: and b.db_guid = p_db_guid
801: and ( b.Instance_Guid <> p_instance_guid
802: or ( b.Instance_Guid = p_instance_guid and

Line 1007: from fnd_database_services a

1003: end if;
1004:
1005: select a.db_service_guid
1006: into l_db_service_guid
1007: from fnd_database_services a
1008: where a.db_guid = l_db_guid
1009: and a.Service_name = ServiceName;
1010:
1011: fnd_app_system.register_service_Members

Line 1387: from fnd_database_services a

1383: and b.db_guid = a.db_guid;
1384:
1385: cursor c2(p_db_guid raw) is
1386: select a.db_service_guid
1387: from fnd_database_services a
1388: where a.db_guid = p_db_guid ;
1389:
1390: cursor c3(p_alias_name varchar2,p_alias_set_guid raw,p_alias_type varchar2) is
1391: select a.tns_alias_guid,a.alias_type

Line 2055: from fnd_database_services a

2051:
2052: procedure show_servicename(p_DB_Service_GUID raw)
2053: as
2054: cursor c1 is select a.service_name
2055: from fnd_database_services a
2056: where a.DB_Service_GUID = p_DB_Service_GUID;
2057: begin
2058:
2059: for f_service in c1 loop

Line 2077: from fnd_database_services a, fnd_database_instances b,

2073: procedure show_service_instance(p_DB_Service_GUID raw,p_instance_guid raw)
2074: as
2075: cursor c1 is select a.service_name,b.Instance_Name,b.Instance_Number,
2076: c.instance_type
2077: from fnd_database_services a, fnd_database_instances b,
2078: fnd_db_service_members c
2079: where a.DB_Service_GUID = p_DB_Service_GUID
2080: and b.Instance_Guid = p_instance_guid
2081: and a.Db_Service_Guid = c.Db_Service_Guid

Line 2310: from fnd_database_services

2306: l_sid2 varchar2(50);
2307:
2308: cursor c5(p_db_guid raw)
2309: is select DB_Service_GUID,db_guid,Service_Name,Description
2310: from fnd_database_services
2311: where db_guid = p_db_guid;
2312:
2313: cursor c6(p_db_name varchar2,p_server_guid raw) is
2314: select a.TNS_ALIAS_GUID

Line 2743: delete from fnd_database_services a

2739:
2740: delete from fnd_sids a
2741: where a.sid_guid = f_instance.sid_guid;
2742:
2743: delete from fnd_database_services a
2744: where a.db_guid = f_instance.db_guid
2745: and not exists ( select b.instance_guid
2746: from fnd_db_service_members b
2747: where b.db_service_guid = a.db_service_guid );