DBA Data[Home] [Help]

APPS.FND_APP_SYSTEM dependencies on FND_DATABASE_ASSIGNMENTS

Line 389: l_rec fnd_database_assignments%rowtype;

385: assignment varchar2,
386: db_domain varchar2
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;

Line 411: from fnd_database_assignments a

407: begin
408:
409: select a.db_guid
410: into l_rec.db_guid
411: from fnd_database_assignments a
412: where a.db_guid = l_rec.db_guid
413: and a.assignment = l_rec.assignment;
414:
415: exception

Line 423: insert into fnd_database_assignments

419:
420: if ( l_insert )
421: then
422:
423: insert into fnd_database_assignments
424: (db_guid,assignment,
425: last_updated_by,last_update_date,last_update_login,
426: creation_date,created_by
427: )

Line 432: update fnd_database_assignments a

428: values ( l_rec.db_guid,l_rec.assignment,
429: 1,sysdate,0,sysdate,1 );
430: else
431:
432: update fnd_database_assignments a
433: set a.assignment = nvl(l_rec.assignment,a.assignment),
434: a.last_update_date = SYSDATE,
435: a.last_updated_by = 1
436: where a.db_guid = l_rec.db_guid