DBA Data[Home] [Help]

APPS.FND_ADG_MANAGE dependencies on FND_ADG_COMMIT_WAIT

Line 438: from fnd_adg_commit_wait a

434: begin
435:
436: select a.commit_count
437: into l_commit_count
438: from fnd_adg_commit_wait a
439: where a.session_id = G_SLAVE_SESSION_ID;
440:
441: exception
442: when no_data_found

Line 463: update fnd_adg_commit_wait a

459: raise_rpc_exec_error(p_rpcDescriptor,'increment_commit_count',
460: 'G_SLAVE_SESSION_ID is null!');
461: end if;
462:
463: update fnd_adg_commit_wait a
464: set a.commit_count = a.commit_count + 1
465: where a.session_id = G_SLAVE_SESSION_ID;
466:
467: if ( sql%notfound ) -- first time?

Line 469: insert into fnd_adg_commit_wait(session_id,commit_count)

465: where a.session_id = G_SLAVE_SESSION_ID;
466:
467: if ( sql%notfound ) -- first time?
468: then
469: insert into fnd_adg_commit_wait(session_id,commit_count)
470: values (G_SLAVE_SESSION_ID,0);
471: end if;
472:
473: -- debug_dump_state;

Line 538: from fnd_adg_commit_wait a

534: begin
535:
536: select a.commit_count
537: into l_commit_count
538: from fnd_adg_commit_wait a
539: where a.session_id = G_SLAVE_SESSION_ID;
540:
541: exception
542: when no_data_found