APPS.FND_APP_SYSTEM dependencies on FND_DB_SERVICE_MEMBERS

Line 688: l_rec fnd_db_service_members%rowtype;

684: db_service_guid raw default null,
685: db_domain varchar2
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;

Line 724: from fnd_db_service_members a

720: begin
721:
722: select a.db_service_guid
723: into l_rec.db_service_guid
724: from fnd_db_service_members a
725: where a.DB_GUID = l_rec.DB_GUID
726: and a.Instance_Guid = l_rec.Instance_Guid;
727:
728: exception

Line 744: from fnd_db_service_members a

740: begin
741:
742: select a.db_service_guid
743: into l_rec.db_service_guid
744: from fnd_db_service_members a
745: where a.db_service_guid = l_rec.db_service_guid
746: and a.Instance_Guid = l_rec.Instance_Guid;
747:
748: exception

Line 759: insert into fnd_db_service_members

755:
756: if ( l_insert )
757: then
758:
759: insert into fnd_db_service_members
760: (db_service_guid,DB_GUID,Instance_Guid,instance_type,
761: last_updated_by,last_update_date,last_update_login,
762: creation_date,created_by
763: )

Line 769: update fnd_db_service_members a

765: l_rec.instance_type,
766: 1,sysdate,0,sysdate,1 );
767: else
768:
769: update fnd_db_service_members a
770: set a.DB_GUID = nvl(l_rec.DB_GUID,a.DB_GUID),
771: a.Instance_Guid = nvl(l_rec.Instance_Guid,a.Instance_Guid),
772: a.instance_type = nvl(l_rec.instance_type,a.instance_type),
773: a.last_update_date = SYSDATE,