APPS.EDW_DERIVED_FACT_COLLECT dependencies on DBMS_JOB

Line 484: DBMS_JOB.SUBMIT(l_job_id(i),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT_MULTI_THREAD('''||

480: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT_MULTI_THREAD('''||g_fact_name||''','||
481: g_fact_id||','''||l_log_file||''','''||l_input_table(i)||''','''||l_ilog(i)||''','''||l_dlog(i)||''','''||
482: l_pre_hook||''','''||l_post_hook||''','''||g_thread_type||''');');
483: end if;
484: DBMS_JOB.SUBMIT(l_job_id(i),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT_MULTI_THREAD('''||
485: g_fact_name||''','||g_fact_id||','''||l_log_file||''','''||l_input_table(i)||''','''||
486: l_ilog(i)||''','''||l_dlog(i)||''','''||l_pre_hook||''','''||l_post_hook||''','''||
487: g_thread_type||''');');
488: l_job_status(i):='R';

Line 1025: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT_MULTI_THREAD('''||

1021: l_try_serial:=true;
1022: end if;
1023: commit;--commit only after updating the inp table
1024: else
1025: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT_MULTI_THREAD('''||
1026: g_fact_name||''','||g_fact_id||','''||l_log_file||''','''||l_input_table(i)||''','''||
1027: l_ilog(i)||''','''||l_dlog(i)||''','''||l_pre_hook||''','''||l_post_hook||''','''||g_thread_type||
1028: ''');');
1029: l_job_status(l_number_jobs):='R';

Line 1044: write_to_log_file_n('Error launching dbms job '||sqlerrm||'. Attempting serial load'||

1040: commit;--commit only after updating the inp table
1041: end if;
1042: exception when others then
1043: if g_debug then
1044: write_to_log_file_n('Error launching dbms job '||sqlerrm||'. Attempting serial load'||
1045: get_time);
1046: end if;
1047: l_try_serial:=true;
1048: end;