APPS.FND_APP_SYSTEM dependencies on FND_APP_SERVERS

Line 204: l_rec fnd_app_servers%rowtype;

200: Pri_Oracle_Home raw,
201: Aux_Oracle_Home raw,
202: Server_GUID raw default null )
203: as
204: l_rec fnd_app_servers%rowtype;
205: l_insert boolean := false;
206:
207: begin
208:

Line 224: from fnd_app_servers a

220: begin
221:
222: select a.Server_GUID
223: into l_rec.Server_GUID
224: from fnd_app_servers a
225: where a.name = l_rec.name;
226:
227: exception
228: when no_data_found then

Line 236: insert into fnd_app_servers

232:
233: if ( l_insert )
234: then
235:
236: insert into fnd_app_servers
237: (Server_GUID,name,Node_Id,Internal,Appl_Top_Guid,
238: Server_type,Pri_Oracle_Home,Aux_Oracle_Home,
239: last_updated_by,last_update_date,last_update_login,
240: creation_date,created_by

Line 249: update fnd_app_servers a

245: l_rec.Aux_Oracle_Home,
246: 1,sysdate,0,sysdate,1 );
247: else
248:
249: update fnd_app_servers a
250: set a.name = nvl(l_rec.Name,a.name),
251: a.node_id = nvl(l_rec.Node_Id,a.Node_Id),
252: a.internal = nvl(l_rec.internal,a.internal),
253: a.Appl_Top_Guid = nvl(l_rec.Appl_Top_Guid,a.Appl_Top_Guid),

Line 793: l_server_name fnd_app_servers.name%type;

789: )
790: as
791: l_rec fnd_tns_listeners%rowtype;
792: l_insert boolean := false;
793: l_server_name fnd_app_servers.name%type;
794: l_tns_alias_name fnd_tns_aliases.alias_name%type;
795: l_alias_set_guid fnd_tns_alias_sets.tns_alias_set_guid%type;
796: l_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;
797:

Line 808: from fnd_app_servers a

804: l_alias_set_name := alias_set_name;
805:
806: select a.server_guid
807: into l_rec.server_guid
808: from fnd_app_servers a
809: where a.name = l_server_name;
810:
811: select a.tns_alias_set_guid
812: into l_alias_set_guid