DBA Data[Home] [Help]

APPS.FND_APP_SYSTEM dependencies on FND_DATABASE_SERVICES

Line 616: l_rec fnd_database_services%rowtype;

612: Description varchar2,
613: db_service_guid raw default null
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:

Line 645: from fnd_database_services a

641: begin
642:
643: select a.db_service_guid
644: into l_rec.db_service_guid
645: from fnd_database_services a
646: where a.db_guid = l_rec.db_guid
647: and a.Service_Name = l_rec.Service_Name;
648:
649: exception

Line 658: insert into fnd_database_services

654:
655: if ( l_insert )
656: then
657:
658: insert into fnd_database_services
659: (DB_Service_GUID,db_guid,Service_Name,Description,
660: last_updated_by,last_update_date,last_update_login,
661: creation_date,created_by
662: )

Line 668: update fnd_database_services a

664: l_rec.Description,
665: 1,sysdate,0,sysdate,1 );
666: else
667:
668: update fnd_database_services a
669: set a.Service_Name = nvl(l_rec.Service_Name,a.Service_Name),
670: a.Description = nvl(l_rec.Description,a.Description),
671: a.last_update_date = SYSDATE,
672: a.last_updated_by = 1