eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_APP_SYSTEM dependencies on FND_DATABASES

Line 325: l_rec fnd_databases%rowtype;

321: Version varchar2,
322: db_guid raw default null
323: )
324: as
325: l_rec fnd_databases%rowtype;
326: l_insert boolean := false;
327: begin
328:
329: l_rec.db_guid := db_guid;

Line 342: from fnd_databases a

338: begin
339:
340: select a.db_guid
341: into l_rec.db_guid
342: from fnd_databases a
343: where a.db_name = l_rec.db_name
344: and a.db_domain= l_rec.db_domain;
345:
346: exception

Line 355: insert into fnd_databases

351:
352: if ( l_insert )
353: then
354:
355: insert into fnd_databases
356: (db_guid,DB_Name,DB_Domain,Default_TNS_Alias_Guid,Is_Rac_db,
357: Version,
358: last_updated_by,last_update_date,last_update_login,
359: creation_date,created_by

Line 367: update fnd_databases a

363: l_rec.Is_Rac_db,l_rec.Version,
364: 1,sysdate,0,sysdate,1 );
365: else
366:
367: update fnd_databases a
368: set a.db_name = nvl(l_rec.db_Name,a.db_name),
369: a.db_domain =nvl(l_rec.db_domain,a.db_domain),
370: a.Default_TNS_Alias_Guid =
371: nvl(l_rec.Default_TNS_Alias_Guid,a.Default_TNS_Alias_Guid),

Line 391: l_db_domain fnd_databases.db_domain%TYPE;

387: )
388: as
389: l_rec fnd_database_assignments%rowtype;
390: l_insert boolean := false;
391: l_db_domain fnd_databases.db_domain%TYPE;
392: l_db_name fnd_databases.db_name%TYPE;
393: l_count number;
394:
395: begin

Line 392: l_db_name fnd_databases.db_name%TYPE;

388: as
389: l_rec fnd_database_assignments%rowtype;
390: l_insert boolean := false;
391: l_db_domain fnd_databases.db_domain%TYPE;
392: l_db_name fnd_databases.db_name%TYPE;
393: l_count number;
394:
395: begin
396:

Line 403: from fnd_databases a

399: l_rec.assignment := assignment;
400:
401: select a.db_guid
402: into l_rec.db_guid
403: from fnd_databases a
404: where a.db_name = l_db_name
405: and a.db_domain = l_db_domain;
406:
407: begin

Line 463: l_db_name fnd_databases.db_name%type;

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
466:
467: l_db_name := db_name;

Line 464: l_db_domain fnd_databases.db_domain%type;

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
466:
467: l_db_name := db_name;
468: l_db_domain := db_domain;

Line 484: from fnd_databases a

480: l_rec.Interconnect_name := Interconnect_name;
481:
482: select a.db_guid
483: into l_rec.db_guid
484: from fnd_databases a
485: where a.db_name = l_db_name
486: and a.db_domain = l_db_domain;
487:
488: if ( l_rec.Instance_Guid is null )

Line 618: l_db_name fnd_databases.db_name%type;

614: )
615: as
616: l_rec fnd_database_services%rowtype;
617: l_insert boolean := false;
618: l_db_name fnd_databases.db_name%type;
619: l_db_domain fnd_databases.db_domain%type;
620:
621: begin
622:

Line 619: l_db_domain fnd_databases.db_domain%type;

615: as
616: l_rec fnd_database_services%rowtype;
617: l_insert boolean := false;
618: l_db_name fnd_databases.db_name%type;
619: l_db_domain fnd_databases.db_domain%type;
620:
621: begin
622:
623: l_rec.DB_Service_GUID := DB_Service_GUID;

Line 633: from fnd_databases a

629: begin
630:
631: select a.db_guid
632: into l_rec.db_guid
633: from fnd_databases a
634: where a.db_name = l_db_name
635: and a.db_domain= l_db_domain;
636:
637: end;

Line 690: l_db_name fnd_databases.db_name%type;

686: )
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

Line 692: l_db_domain fnd_databases.db_domain%type;

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:
696: l_rec.db_service_guid := db_service_guid;

Line 704: from fnd_databases a

700: l_instance_name := instance_name;
701:
702: select a.db_guid
703: into l_rec.db_guid
704: from fnd_databases a
705: where a.db_name = l_db_name
706: and a.db_domain = l_db_domain;
707:
708: begin