APPS.EDW_CLEAN_OBJECT dependencies on EDW_OWB_COLLECTION_UTIL

Line 19: EDW_OWB_COLLECTION_UTIL.setup_conc_program_log(g_object_name);

15: retcode:='2';
16: return;
17: end if;
18: g_truncate_stg:=p_truncate_stg;
19: EDW_OWB_COLLECTION_UTIL.setup_conc_program_log(g_object_name);
20: write_to_log_file('g_object_name='||g_object_name||',g_truncate_stg='||g_truncate_stg);
21: init_all;
22: if is_dimension(g_object_name) then
23: if clean_up_dimension(g_object_name)=false then

Line 65: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');

61: l_table_owner varchar2(30); --bug#4905343
62: l_level_tag varchar2(30); --bug#4905343
63: Begin
64: g_dim:=p_dim;
65: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
66: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_dim);
67:
68: l_level_tag:='_LTC';
69:

Line 66: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_dim);

62: l_level_tag varchar2(30); --bug#4905343
63: Begin
64: g_dim:=p_dim;
65: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
66: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_dim);
67:
68: l_level_tag:='_LTC';
69:
70: l_stmt:='select syn.table_owner '||

Line 183: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(p_message);

179: End;
180:
181: procedure write_to_log_file(p_message varchar2) is
182: Begin
183: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n(p_message);
184: Exception when others then
185: null;
186: End;
187:

Line 231: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');

227: TYPE CurTyp IS REF CURSOR;
228: cv CurTyp;
229: l_owner varchar2(400);
230: Begin
231: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
232: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(p_fact);
233: l_stmt:='select rel.name from edw_tables_md_v rel,edw_pvt_map_properties_md_v map,edw_facts_md_v tgt '||
234: 'where tgt.fact_name=:a and map.primary_target=tgt.fact_id '||
235: 'and rel.elementid=map.primary_source ';

Line 232: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(p_fact);

228: cv CurTyp;
229: l_owner varchar2(400);
230: Begin
231: g_bis_owner:=EDW_OWB_COLLECTION_UTIL.get_db_user('BIS');
232: g_dim_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(p_fact);
233: l_stmt:='select rel.name from edw_tables_md_v rel,edw_pvt_map_properties_md_v map,edw_facts_md_v tgt '||
234: 'where tgt.fact_name=:a and map.primary_target=tgt.fact_id '||
235: 'and rel.elementid=map.primary_source ';
236: write_to_log_file(l_stmt);

Line 240: g_fact_snplog :=EDW_OWB_COLLECTION_UTIL.get_table_snapshot_log(p_fact);

236: write_to_log_file(l_stmt);
237: open cv for l_stmt using p_fact;
238: fetch cv into g_fstg_table;
239: close cv;
240: g_fact_snplog :=EDW_OWB_COLLECTION_UTIL.get_table_snapshot_log(p_fact);
241: g_fact_dlog:=EDW_OWB_COLLECTION_UTIL.get_log_for_table(p_fact,'Delete Log');
242: if g_fact_dlog is null then
243: g_fact_dlog:=g_bis_owner||'.'||substr(g_object_name,1,26)||'DLG';
244: else

Line 241: g_fact_dlog:=EDW_OWB_COLLECTION_UTIL.get_log_for_table(p_fact,'Delete Log');

237: open cv for l_stmt using p_fact;
238: fetch cv into g_fstg_table;
239: close cv;
240: g_fact_snplog :=EDW_OWB_COLLECTION_UTIL.get_table_snapshot_log(p_fact);
241: g_fact_dlog:=EDW_OWB_COLLECTION_UTIL.get_log_for_table(p_fact,'Delete Log');
242: if g_fact_dlog is null then
243: g_fact_dlog:=g_bis_owner||'.'||substr(g_object_name,1,26)||'DLG';
244: else
245: l_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_fact_dlog);

Line 245: l_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_fact_dlog);

241: g_fact_dlog:=EDW_OWB_COLLECTION_UTIL.get_log_for_table(p_fact,'Delete Log');
242: if g_fact_dlog is null then
243: g_fact_dlog:=g_bis_owner||'.'||substr(g_object_name,1,26)||'DLG';
244: else
245: l_owner:=EDW_OWB_COLLECTION_UTIL.get_table_owner(g_fact_dlog);
246: g_fact_dlog:=l_owner||'.'||g_fact_dlog;
247: end if;
248: g_fact_ilog:=g_bis_owner||'.'||substr(p_fact,1,26)||'OK';
249: l_stmt:='select distinct cube_src.fact_id||''_''||cube.fact_id from edw_facts_md_v cube,edw_facts_md_v cube_src, '||