DBA Data[Home] [Help]

APPS.CZ_ADMIN dependencies on V$SESSION

Line 165: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE='CZIMPORT';

161: FUNCTION SPX_IMPORTSESSIONS RETURN INTEGER IS
162: nRet INTEGER;
163: BEGIN
164: BEGIN
165: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE='CZIMPORT';
166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: nRet:=0;
169: END;

Line 200: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE like 'CZ_SYNC%';

196: FUNCTION SPX_PUBLISHSESSIONS RETURN INTEGER IS
197: nRet INTEGER;
198: BEGIN
199: BEGIN
200: SELECT 1 INTO nRet FROM V$SESSION WHERE MODULE like 'CZ_SYNC%';
201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN
203: nRet:=0;
204: END;