DBA Data[Home] [Help]

APPS.CZ_PB_SYNC_UTIL dependencies on V$SESSION

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

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

Line 203: FROM v$session

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