APPS.EDW_SUMMARY_COLLECT dependencies on EDW_SUMMARY_COLLECT

Line 1: package body EDW_SUMMARY_COLLECT AS

1: package body EDW_SUMMARY_COLLECT AS
2: /*$Header: EDWSCOLB.pls 120.0 2005/05/31 18:10:44 appldev noship $*/
3:
4: --MAIN ACCESS POINT
5: procedure collect_dimension_main(

Line 391: write_to_log_file_n('EDW_SUMMARY_COLLECT.COLLECT_DIMENSION('''||p_dim_name||''','||

387: for j in 1..l_ok_end_count loop
388: l_number_jobs:=l_number_jobs+1;
389: l_job_id(l_number_jobs):=null;
390: if g_debug then
391: write_to_log_file_n('EDW_SUMMARY_COLLECT.COLLECT_DIMENSION('''||p_dim_name||''','||
392: ''''||l_input_table||''','||l_number_jobs||','||l_ok_low_end(j)||','||
393: l_ok_high_end(j)||');');
394: end if;
395: begin

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 436: EDW_SUMMARY_COLLECT.COLLECT_DIMENSION(

432: if g_debug then
433: write_to_log_file_n('Attempt serial load');
434: end if;
435: l_job_id(l_number_jobs):=0-l_number_jobs;
436: EDW_SUMMARY_COLLECT.COLLECT_DIMENSION(
437: l_errbuf,
438: l_retcode,
439: p_dim_name,
440: l_input_table,

Line 7413: l_exe_file_name:='EDW_SUMMARY_COLLECT.COLLECT_DIMENSION';

7409: l_parameter EDW_OWB_COLLECTION_UTIL.varcharTableType;
7410: l_parameter_value_set EDW_OWB_COLLECTION_UTIL.varcharTableType;
7411: l_number_parameters number;
7412: Begin
7413: l_exe_file_name:='EDW_SUMMARY_COLLECT.COLLECT_DIMENSION';
7414: l_parameter(1):='p_dim_name';
7415: l_parameter_value_set(1):='FND_CHAR240';
7416: l_parameter(2):='p_table_name';
7417: l_parameter_value_set(2):='FND_CHAR240';

Line 7524: END EDW_SUMMARY_COLLECT;

7520: write_to_log_file_n('Error in insert_L_ilog_parallel_dd '||g_status_message);
7521: return false;
7522: End;
7523:
7524: END EDW_SUMMARY_COLLECT;