APPS.EDW_ANALYZE_OBJECT dependencies on EDW_OWB_COLLECTION_UTIL

Line 12: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');

8: g_mode:=p_mode;
9: if g_mode is null then
10: g_mode:=0;--ltc and star 1 is lstg only
11: end if;
12: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');
13: EDW_OWB_COLLECTION_UTIL.set_debug(true);
14: init_all;
15: if analyze_dimension(p_dim_name)=false then
16: Retcode:='2';

Line 13: EDW_OWB_COLLECTION_UTIL.set_debug(true);

9: if g_mode is null then
10: g_mode:=0;--ltc and star 1 is lstg only
11: end if;
12: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');
13: EDW_OWB_COLLECTION_UTIL.set_debug(true);
14: init_all;
15: if analyze_dimension(p_dim_name)=false then
16: Retcode:='2';
17: Errbuf:=g_status_message;

Line 35: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');

31: g_mode:=p_mode;
32: if g_mode is null then
33: g_mode:=0;--fact 1 is fstg only
34: end if;
35: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');
36: EDW_OWB_COLLECTION_UTIL.set_debug(true);
37: init_all;
38: if analyze_fact(p_fact_name)=false then
39: Retcode:='2';

Line 36: EDW_OWB_COLLECTION_UTIL.set_debug(true);

32: if g_mode is null then
33: g_mode:=0;--fact 1 is fstg only
34: end if;
35: EDW_OWB_COLLECTION_UTIL.init_all('ANALYZE_OBJECTS',null,'bis.edw.analyze_object');
36: EDW_OWB_COLLECTION_UTIL.set_debug(true);
37: init_all;
38: if analyze_fact(p_fact_name)=false then
39: Retcode:='2';
40: Errbuf:=g_status_message;

Line 113: l_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;

109: function analyze_dims return boolean is
110: l_stmt varchar2(4000);
111: TYPE CurTyp IS REF CURSOR;
112: cv CurTyp;
113: l_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
114: l_ltc_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
115: l_ltc_number number;
116: Begin
117: write_to_log_file_n('In analyze_dims');

Line 114: l_ltc_long EDW_OWB_COLLECTION_UTIL.varcharTableType;

110: l_stmt varchar2(4000);
111: TYPE CurTyp IS REF CURSOR;
112: cv CurTyp;
113: l_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;
114: l_ltc_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
115: l_ltc_number number;
116: Begin
117: write_to_log_file_n('In analyze_dims');
118: for i in 1..g_number_dim loop

Line 160: l_lstg EDW_OWB_COLLECTION_UTIL.varcharTableType;

156: function analyze_dims_lstg return boolean is
157: l_stmt varchar2(4000);
158: TYPE CurTyp IS REF CURSOR;
159: cv CurTyp;
160: l_lstg EDW_OWB_COLLECTION_UTIL.varcharTableType;
161: l_lstg_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
162: l_lstg_number number;
163: Begin
164: for i in 1..g_number_dim loop

Line 161: l_lstg_long EDW_OWB_COLLECTION_UTIL.varcharTableType;

157: l_stmt varchar2(4000);
158: TYPE CurTyp IS REF CURSOR;
159: cv CurTyp;
160: l_lstg EDW_OWB_COLLECTION_UTIL.varcharTableType;
161: l_lstg_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
162: l_lstg_number number;
163: Begin
164: for i in 1..g_number_dim loop
165: l_stmt:='select lstg.name,lstg.long_name '||

Line 312: EDW_OWB_COLLECTION_UTIL.analyze_table_stats(p_object);

308:
309:
310: procedure analyze_table(p_object varchar2) is
311: Begin
312: EDW_OWB_COLLECTION_UTIL.analyze_table_stats(p_object);
313: Exception when others then
314: write_to_log_file_n('Error in analyze_table '||sqlerrm);
315: End;
316:

Line 324: EDW_OWB_COLLECTION_UTIL.set_parallel(g_parallel);

320: g_number_dim:=0;
321: g_number_fact:=0;
322: g_parallel:=fnd_profile.value('EDW_PARALLEL');
323: write_to_log_file_n('g_parallel='||g_parallel);
324: EDW_OWB_COLLECTION_UTIL.set_parallel(g_parallel);
325: Exception when others then
326: g_status:=false;
327: g_status_message:='Error in init_all '||sqlerrm;
328: write_to_log_file_n(g_status_message);

Line 341: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);

337: End;
338:
339: procedure write_to_log_file(p_message varchar2) is
340: begin
341: EDW_OWB_COLLECTION_UTIL.write_to_log_file(p_message);
342: Exception when others then
343: null;
344: End;
345:

Line 356: EDW_OWB_COLLECTION_UTIL.write_to_out_file(p_message);

352: End;
353:
354: procedure write_to_out_file(p_message varchar2) is
355: begin
356: EDW_OWB_COLLECTION_UTIL.write_to_out_file(p_message);
357: Exception when others then
358: null;
359: End;
360: