APPS.CZ_MIGRATE dependencies on V$SESSION

Line 147: FOR c_running IN (SELECT action FROM v$session WHERE module IN (

143: END;
144:
145: --Check for other running migration/setup sessions.
146:
147: FOR c_running IN (SELECT action FROM v$session WHERE module IN (
148: 'CZMIGRATION',
149: 'CZ_PB_MGR',
150: 'CZ_MODEL_MIGRATION',
151: 'CZIMPORT',

Line 334: FOR c_running IN (SELECT action FROM v$session WHERE module IN (

330: END;
331:
332: --Check for other running migration/setup sessions.
333:
334: FOR c_running IN (SELECT action FROM v$session WHERE module IN (
335: 'CZMIGRATION',
336: 'CZ_PB_MGR',
337: 'CZ_MODEL_MIGRATION',
338: 'CZIMPORT',

Line 517: OPEN l_src_sessn_cur FOR 'SELECT count(*) FROM v$session@'||dbLinkName|| ' t where t.module = ''PUBLISH_MODEL''';

513: --
514:
515: ----check if a pub sync or publishing process is running on the instance
516: ----from which the data is being migrated.
517: OPEN l_src_sessn_cur FOR 'SELECT count(*) FROM v$session@'||dbLinkName|| ' t where t.module = ''PUBLISH_MODEL''';
518: LOOP
519: FETCH l_src_sessn_cur INTO srcPbSessionCnt;
520: EXIT WHEN l_src_sessn_cur%NOTFOUND;
521: IF (srcPbSessionCnt > 0) THEN