DBA Data[Home] [Help]

APPS.FND_EXEC_MIG_CMDS dependencies on V$SESSION

Line 238: FROM v$session

234: /*
235: -- Initial Enqueue only if no Sequential process is running.
236: SELECT COUNT(1)
237: INTO l_cnt
238: FROM v$session
239: WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
240: AND status <> 'KILLED';
241: if l_cnt > 0 then
242: l_enqueue := 'N';

Line 357: FROM v$session

353: WHEN OTHERS THEN
354: if p_exec_mode = 'P' then
355: SELECT COUNT(1)
356: INTO l_cnt
357: FROM v$session
358: WHERE module = 'TS_MIGRATE_SEQUENTIAL_OBJECTS'
359: AND status <> 'KILLED';
360: if l_cnt = 0 then
361: if sqlcode = -25228 then

Line 885: from v$session

881: where object_type IN ('ENABLE_TRIGGER', 'ENABLE_CONSTRAINT', 'START_QUEUE', 'ENABLE_POLICY');
882:
883: cursor proc_csr IS
884: select 1
885: from v$session
886: /* where module in ('TS_MIGRATE_SEQUENTIAL_OBJECTS', 'TS_MIGRATE_PARALLEL_OBJECTS') */
887: where module in
888: ('TS_MIGRATE_SEQUENTIAL_OBJECTS',
889: 'TS_MIGRATE_PARALLEL_OBJECTS',