APPS.EDW_ALL_COLLECT dependencies on EDW_PUSH_DOWN_DIMS

Line 473: --inside EDW_PUSH_DOWN_DIMS.push_down_all_levels we see which all levels need push down

469: end if;
470:
471: insert_into_load_progress_nd(g_load_pk,g_object_name,g_object_id,'Push Down Levels',sysdate,null,'LEVEL',
472: 'DIMENSION','PD10','I');
473: --inside EDW_PUSH_DOWN_DIMS.push_down_all_levels we see which all levels need push down
474: if EDW_PUSH_DOWN_DIMS.push_down_all_levels(g_object_name,
475: l_levels,
476: l_child_level_number,
477: l_child_levels,

Line 474: if EDW_PUSH_DOWN_DIMS.push_down_all_levels(g_object_name,

470:
471: insert_into_load_progress_nd(g_load_pk,g_object_name,g_object_id,'Push Down Levels',sysdate,null,'LEVEL',
472: 'DIMENSION','PD10','I');
473: --inside EDW_PUSH_DOWN_DIMS.push_down_all_levels we see which all levels need push down
474: if EDW_PUSH_DOWN_DIMS.push_down_all_levels(g_object_name,
475: l_levels,
476: l_child_level_number,
477: l_child_levels,
478: l_child_fk,

Line 505: errbuf:='FINISH push_down_all_levels WITH ERROR '||EDW_PUSH_DOWN_DIMS.g_status_message;

501: g_trace,
502: g_read_cfig_options,
503: g_stg_join_nl
504: ) =false then
505: errbuf:='FINISH push_down_all_levels WITH ERROR '||EDW_PUSH_DOWN_DIMS.g_status_message;
506: retcode:='2';
507: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'PD10','U');
508: return_with_error(g_load_pk,'LOG');
509: return;

Line 1476: EDW_PUSH_DOWN_DIMS.drop_ilog;

1472: FND_LOG.LEVEL_STATEMENT);
1473: end if;
1474: --if there is push down, drop the ilogs
1475: if g_dim_push_down then
1476: EDW_PUSH_DOWN_DIMS.drop_ilog;
1477: end if;
1478: Exception when others then
1479: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Error in clean up',FND_LOG.LEVEL_ERROR);
1480: End;