APPS.FND_APP_SYSTEM dependencies on FND_DATABASE_INSTANCES

Line 461: l_rec fnd_database_instances%rowtype;

457: Instance_Guid raw default null,
458: db_domain varchar2
459: )
460: as
461: l_rec fnd_database_instances%rowtype;
462: l_insert boolean := false;
463: l_db_name fnd_databases.db_name%type;
464: l_db_domain fnd_databases.db_domain%type;
465: begin

Line 494: from fnd_database_Instances a

490: begin
491:
492: select a.db_guid,a.Instance_Guid
493: into l_rec.db_guid,l_rec.Instance_Guid
494: from fnd_database_Instances a
495: where a.db_guid = l_rec.db_guid
496: and a.Instance_Name = l_rec.Instance_Name;
497:
498: exception

Line 507: insert into fnd_database_instances

503:
504: if ( l_insert )
505: then
506:
507: insert into fnd_database_instances
508: (db_guid,Instance_Guid,Instance_Name,Instance_Number,Sid_GUID,
509: Sid,
510: Default_TNS_Alias_GUID,Server_GUID,Local_Listener_Alias,
511: Remote_Listener_Alias,Configuration,Description,

Line 527: update fnd_database_instances a

523: l_rec.Configuration,l_rec.Description,l_rec.Interconnect_name,
524: 1,sysdate,0,sysdate,1 );
525: else
526:
527: update fnd_database_instances a
528: set a.Instance_Name = nvl(l_rec.Instance_Name,a.Instance_Name),
529: a.Instance_Number = nvl(l_rec.Instance_Number,a.Instance_Number),
530: a.Sid_GUID = nvl(l_rec.Sid_GUID,a.Sid_GUID),
531: a.Sid = nvl(l_rec.Sid,a.Sid),

Line 691: l_instance_name fnd_database_instances.instance_name%type;

687: as
688: l_rec fnd_db_service_members%rowtype;
689: l_insert boolean := false;
690: l_db_name fnd_databases.db_name%type;
691: l_instance_name fnd_database_instances.instance_name%type;
692: l_db_domain fnd_databases.db_domain%type;
693:
694: begin
695:

Line 712: from fnd_database_instances a

708: begin
709:
710: select instance_guid
711: into l_rec.instance_guid
712: from fnd_database_instances a
713: where a.db_guid = l_rec.db_guid
714: and a.instance_name = l_instance_name;
715:
716: end;