DBA Data[Home] [Help]

APPS.BIS_BUSINESS_VIEWS_CATALOG_OA dependencies on DUAL

Line 305: -- select USERENV('SESSIONID') into pv_session_id from dual;

301:
302: -- IF (ICX_SEC.validateSession) THEN
303: l_user_id := ICX_SEC.getID(icx_sec.PV_USER_ID);
304:
305: -- select USERENV('SESSIONID') into pv_session_id from dual;
306:
307: select FND_GLOBAL.user_id into gv_user_id from dual;
308:
309:

Line 307: select FND_GLOBAL.user_id into gv_user_id from dual;

303: l_user_id := ICX_SEC.getID(icx_sec.PV_USER_ID);
304:
305: -- select USERENV('SESSIONID') into pv_session_id from dual;
306:
307: select FND_GLOBAL.user_id into gv_user_id from dual;
308:
309:
310: -- ****************************************************************
311: -- Transfer the individual words from the input box into

Line 311: -- Transfer the individual words from the input box into

307: select FND_GLOBAL.user_id into gv_user_id from dual;
308:
309:
310: -- ****************************************************************
311: -- Transfer the individual words from the input box into
312: -- a plsql table after cleaning and validating the entries
313:
314: l_length := LENGTH( p_keywords );
315: -- ONLY if there are any words entered then do the processing