DBA Data[Home] [Help]

APPS.CZ_PB_SYNC_UTIL dependencies on V$SESSION

Line 202: l_module_name v$session.module%TYPE;

198: ------------------------------------------------------
199: -- Verifies if there is another sync or a publishing session running
200: FUNCTION check_process RETURN VARCHAR2
201: IS
202: l_module_name v$session.module%TYPE;
203: BEGIN
204: SELECT module INTO l_module_name
205: FROM v$session
206: WHERE module IN ('CZ_PB_SYNC', 'CZ_PB_MGR');

Line 205: FROM v$session

201: IS
202: l_module_name v$session.module%TYPE;
203: BEGIN
204: SELECT module INTO l_module_name
205: FROM v$session
206: WHERE module IN ('CZ_PB_SYNC', 'CZ_PB_MGR');
207: RETURN l_module_name;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN