APPS.CS_KB_CONC_PROG_PKG dependencies on V$PARAMETER

Line 243: FROM v$parameter

239: -- 4321268
240: -- Fetch the correct paremeters to calculate max. parallel workers.
241: CURSOR get_param_value(p_name IN varchar2) IS
242: SELECT to_number(nvl(VALUE, 0))
243: FROM v$parameter
244: WHERE name = lower(p_name);
245:
246: l_cpu_count NUMBER;
247: l_thread_per_cpu NUMBER;

Line 259: -- SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter

255: OPEN get_param_value('parallel_threads_per_cpu');
256: FETCH get_param_value INTO l_thread_per_cpu;
257: CLOSE get_param_value;
258:
259: -- SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter
260: -- WHERE NAME = 'job_queue_processes';
261: l_worker := l_cpu_count * l_thread_per_cpu;
262: --4321268
263: RETURN l_worker;