DBA Data[Home] [Help]

APPS.FND_APP_SYSTEM dependencies on FND_SYSTEM_SERVER_MAP

Line 270: l_rec fnd_system_server_map%rowtype;

266:
267: procedure register_servermap ( Server_GUID raw,
268: System_Guid raw )
269: as
270: l_rec fnd_system_server_map%rowtype;
271: l_insert boolean := false;
272:
273: begin
274:

Line 282: from fnd_system_server_map a

278: begin
279:
280: select a.Server_GUID,a.System_Guid
281: into l_rec.Server_GUID,l_rec.System_Guid
282: from fnd_system_server_map a
283: where a.Server_GUID = l_rec.Server_GUID
284: and a.System_Guid = l_rec.System_Guid;
285:
286: exception

Line 294: insert into fnd_system_server_map

290:
291: if ( l_insert )
292: then
293:
294: insert into fnd_system_server_map
295: (Server_GUID,System_Guid,
296: last_updated_by,last_update_date,last_update_login,
297: creation_date,created_by
298: )

Line 303: update fnd_system_server_map a

299: values ( l_rec.Server_GUID,l_rec.System_Guid,1,sysdate,0,sysdate,1 );
300:
301: else
302:
303: update fnd_system_server_map a
304: set a.Server_GUID = nvl(l_rec.Server_GUID,a.Server_GUID),
305: a.System_Guid = nvl(l_rec.System_Guid,a.System_Guid),
306: a.last_update_date = SYSDATE,
307: a.last_updated_by = 1