eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_DERIVED_FACT_FACT_COLLECT dependencies on EDW_DERIVED_FACT_FACT_COLLECT

Line 1: package body EDW_DERIVED_FACT_FACT_COLLECT AS

1: package body EDW_DERIVED_FACT_FACT_COLLECT AS
2: /*$Header: EDWFFCLB.pls 120.1 2006/05/12 02:51:06 vsurendr ship $*/
3:
4: /*
5: entry point for conc processes

Line 162: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.collect_fact done for '||

158: if COLLECT_FACT('ALL')=false then
159: return false;
160: end if;
161: if g_debug then
162: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.collect_fact done for '||
163: g_src_object||' to '||g_fact_name||'. Time '||get_time);
164: end if;
165: else
166: if EDW_OWB_COLLECTION_UTIL.update_derv_fact_input_table(

Line 214: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''ILOG'','''||g_fact_name||''','||

210: l_job_id(l_number_jobs):=null;
211: l_ilog:=g_ilog_name||'_'||l_number_jobs||'_IL';
212: l_dlog:=g_dlog_name||'_'||l_number_jobs||'_DL';
213: if g_debug then
214: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''ILOG'','''||g_fact_name||''','||
215: ''''||p_input_table||''','||l_number_jobs||','||l_log_low_end(j)||','||l_log_high_end(j)||','''||
216: l_ilog||''','''||l_dlog||''','''||g_log_file||''','''||g_thread_type||''');');
217: end if;
218: begin

Line 246: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''ILOG'','''||

242: l_try_serial:=true;
243: end if;
244: commit;--this commit is very imp
245: else
246: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''ILOG'','''||
247: g_fact_name||''','||''''||p_input_table||''','||l_number_jobs||','||l_log_low_end(j)||','||
248: l_log_high_end(j)||','''||l_ilog||''','''||l_dlog||''','''||g_log_file||''','''||g_thread_type||''');');
249: if g_debug then
250: write_to_log_file_n('Job '||l_job_id(l_number_jobs)||' launched '||get_time);

Line 275: EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(

271: if EDW_OWB_COLLECTION_UTIL.update_inp_table_jobid(p_input_table,l_job_id(l_number_jobs))=false then
272: return false;
273: end if;
274: commit;--this commit is very imp
275: EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(
276: l_errbuf,
277: l_retcode,
278: 'ILOG',
279: g_fact_name,

Line 332: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''DLOG'','''||g_fact_name||''','||

328: l_job_id(l_number_jobs):=null;
329: l_ilog:=g_ilog_name||'_'||l_number_jobs||'_IL';
330: l_dlog:=g_dlog_name||'_'||l_number_jobs||'_DL';
331: if g_debug then
332: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''DLOG'','''||g_fact_name||''','||
333: ''''||p_input_table||''','||l_number_jobs||','||l_log_low_end(j)||','||l_log_high_end(j)||','''||
334: l_ilog||''','''||l_dlog||''','''||g_log_file||''','''||g_thread_type||''');');
335: end if;
336: begin

Line 364: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''DLOG'','''||

360: l_try_serial:=true;
361: end if;
362: commit;--this commit is very imp
363: else
364: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(''DLOG'','''||
365: g_fact_name||''','||''''||p_input_table||''','||l_number_jobs||','||l_log_low_end(j)||','||
366: l_log_high_end(j)||','''||l_ilog||''','''||l_dlog||''','''||g_log_file||''','''||g_thread_type||''');');
367: if g_debug then
368: write_to_log_file_n('Job '||l_job_id(l_number_jobs)||' launched '||get_time);

Line 393: EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(

389: if EDW_OWB_COLLECTION_UTIL.update_inp_table_jobid(p_input_table,l_job_id(l_number_jobs))=false then
390: return false;
391: end if;
392: commit;--this commit is very imp
393: EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT(
394: l_errbuf,
395: l_retcode,
396: 'DLOG',
397: g_fact_name,

Line 945: write_to_log_file_n('In EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT'||get_time);

941: g_dbms_job_id:=-1;
942: /*
943: g_load_mode is BU-DELETE when inc dim changes are propogated to derived/summary facts
944: */
945: write_to_log_file_n('In EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT'||get_time);
946: if g_debug then
947: write_to_log_file('g_collection_size='||g_collection_size);
948: write_to_log_file('g_parallel='||g_parallel);
949: write_to_log_file('g_bis_owner='||g_bis_owner);

Line 1015: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.collect_fact done for '||

1011: if post_fact_load_hook(g_fact_name,g_src_object)=false then
1012: return false;
1013: end if;
1014: end if;
1015: write_to_log_file_n('EDW_DERIVED_FACT_FACT_COLLECT.collect_fact done for '||
1016: g_src_object||' to '||g_fact_name||'. Time '||get_time);
1017: p_ins_rows_processed :=g_ins_rows_processed;
1018: return true;
1019: Exception when others then

Line 5428: l_exe_file_name:='EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT';

5424: l_parameter EDW_OWB_COLLECTION_UTIL.varcharTableType;
5425: l_parameter_value_set EDW_OWB_COLLECTION_UTIL.varcharTableType;
5426: l_number_parameters number;
5427: Begin
5428: l_exe_file_name:='EDW_DERIVED_FACT_FACT_COLLECT.COLLECT_FACT';
5429: l_parameter(1):='p_mode';
5430: l_parameter_value_set(1):='FND_CHAR240';
5431: l_parameter(2):='p_fact_name';
5432: l_parameter_value_set(2):='FND_CHAR240';