APPS.EDW_SUMMARY_COLLECT dependencies on DBMS_JOB

Line 370: DBMS_JOB.SUBMIT(id,'test_pack_2.run_pack;')

366: if g_status then
367: /*
368: we will go for active polling. this main session will sleep for g_sleep_time and then
369: wake up and check the status of each of the jobs. If they are done, we can then proceed.
370: DBMS_JOB.SUBMIT(id,'test_pack_2.run_pack;')
371: */
372: l_number_jobs:=0;
373: l_temp_conc_name:='Sub-Proc Dim-'||g_dim_id;
374: l_temp_conc_short_name:='CONC_DIM_'||g_dim_id||'_CONC';

Line 414: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_SUMMARY_COLLECT.COLLECT_DIMENSION('''||p_dim_name||''','||

410: if l_job_id(l_number_jobs)<=0 then
411: l_try_serial:=true;
412: end if;
413: else
414: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_SUMMARY_COLLECT.COLLECT_DIMENSION('''||p_dim_name||''','||
415: ''''||l_input_table||''','||l_number_jobs||','||l_ok_low_end(j)||','||
416: l_ok_high_end(j)||');');
417: commit;--this commit is very imp
418: if g_debug then

Line 724: --g_job_id is not the dbms_job job_id. its just an identifier. goes from 1..n

720: g_dim_name:=p_dim_name;
721: EDW_OWB_COLLECTION_UTIL.init_all(g_dim_name||'_'||g_job_id,null,'bis.edw.loader');
722: write_to_log_file_n('In COLLECT_DIMENSION. p_dim_name='||p_dim_name||', p_table_name='||p_table_name||
723: ', p_job_id='||p_job_id||', p_ok_low_end='||p_ok_low_end||', p_ok_high_end='||p_ok_high_end||get_time);
724: --g_job_id is not the dbms_job job_id. its just an identifier. goes from 1..n
725: /*need to open log file
726: this wont be conc manager log file
727: */
728: if COLLECT_DIMENSION(p_table_name,p_ok_low_end,p_ok_high_end)=false then