APPS.EDW_PUSH_DOWN_DIMS dependencies on EDW_PUSH_DOWN_DIMS

Line 1: package body EDW_PUSH_DOWN_DIMS AS

1: package body EDW_PUSH_DOWN_DIMS AS
2: /*$Header: EDWPSDNB.pls 115.15 2003/11/06 00:56:50 vsurendr ship $*/
3:
4: function push_down_all_levels(
5: p_dim_name varchar2,

Line 342: write_to_log_file_n('EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS('''||g_dim_name||''','||

338: l_number_jobs:=l_number_jobs+1;
339: l_job_id(l_number_jobs):=null;
340: l_log_file:='LOG_'||g_dim_id||'_PD';
341: if g_debug then
342: write_to_log_file_n('EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS('''||g_dim_name||''','||
343: ''''||l_log_file||''','''||l_input_table||''','||l_number_jobs||','||
344: l_ok_low_end(i)||','||l_ok_high_end(i)||','''||l_job_status_table||''');');
345: end if;
346: begin

Line 367: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS('''||g_dim_name||''','||

363: if l_job_id(l_number_jobs)<=0 then
364: l_try_serial:=true;
365: end if;
366: else
367: DBMS_JOB.SUBMIT(l_job_id(l_number_jobs),'EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS('''||g_dim_name||''','||
368: ''''||l_log_file||''','''||l_input_table||''','||l_number_jobs||','||
369: l_ok_low_end(i)||','||l_ok_high_end(i)||','''||l_job_status_table||''');');
370: commit;--this commit is very imp
371: if g_debug then

Line 389: EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS(

385: if g_debug then
386: write_to_log_file_n('Attempt serial load');
387: end if;
388: l_job_id(l_number_jobs):=0-l_number_jobs;
389: EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS(
390: l_errbuf,
391: l_retcode,
392: g_dim_name,
393: l_log_file,

Line 3344: l_exe_file_name:='EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS';

3340: l_parameter EDW_OWB_COLLECTION_UTIL.varcharTableType;
3341: l_parameter_value_set EDW_OWB_COLLECTION_UTIL.varcharTableType;
3342: l_number_parameters number;
3343: Begin
3344: l_exe_file_name:='EDW_PUSH_DOWN_DIMS.PUSH_DOWN_ALL_LEVELS';
3345: l_parameter(1):='p_dim_name';
3346: l_parameter_value_set(1):='FND_CHAR240';
3347: l_parameter(2):='p_log_file';
3348: l_parameter_value_set(2):='FND_CHAR240';

Line 3379: END EDW_PUSH_DOWN_DIMS;

3375: write_to_log_file_n('Error in create_conc_program '||g_status_message);
3376: return false;
3377: End;
3378:
3379: END EDW_PUSH_DOWN_DIMS;