APPS.CS_KB_CONC_PROG_PKG dependencies on V$PARAMETER

Line 214: FROM v$parameter

210: -- 4321268
211: -- Fetch the correct paremeters to calculate max. parallel workers.
212: CURSOR get_param_value(p_name IN varchar2) IS
213: SELECT to_number(nvl(VALUE, 0))
214: FROM v$parameter
215: WHERE name = lower(p_name);
216:
217: l_cpu_count NUMBER;
218: l_thread_per_cpu NUMBER;

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

226: OPEN get_param_value('parallel_threads_per_cpu');
227: FETCH get_param_value INTO l_thread_per_cpu;
228: CLOSE get_param_value;
229:
230: -- SELECT to_number(nvl(VALUE, 0)) INTO l_worker FROM v$parameter
231: -- WHERE NAME = 'job_queue_processes';
232: l_worker := l_cpu_count * l_thread_per_cpu;
233: --4321268
234: RETURN l_worker;