eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_AW_MD_API dependencies on BSC_OLAP_OBJECT

Line 9: get_bsc_olap_object(p_dimension,'dimension',p_dimension,'dimension',g_olap_object);

5: p_dimension varchar2
6: )return boolean is
7: Begin
8: g_olap_object.delete;
9: get_bsc_olap_object(p_dimension,'dimension',p_dimension,'dimension',g_olap_object);
10: if g_olap_object.count>0 then
11: return true;
12: else
13: return false;

Line 26: get_bsc_olap_object_relation(null,null,'dimension kpi',p_dim_name,'dimension',g_olap_object_relation);

22: p_kpi_list out nocopy dbms_sql.varchar2_table
23: ) is
24: Begin
25: g_olap_object_relation.delete;
26: get_bsc_olap_object_relation(null,null,'dimension kpi',p_dim_name,'dimension',g_olap_object_relation);
27: for i in 1..g_olap_object_relation.count loop
28: p_kpi_list(i):=g_olap_object_relation(i).relation_object;
29: end loop;
30: Exception when others then

Line 48: p_objects out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb,

44: returns the name of the olap objects that need to be dropped from aw
45: */
46: procedure get_dim_olap_objects(
47: p_dim_name varchar2,
48: p_objects out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb,
49: p_type varchar2
50: ) is
51: --
52: Begin

Line 54: get_bsc_olap_object(null,null,p_dim_name,'dimension',p_objects);

50: ) is
51: --
52: Begin
53: if p_type='all' then
54: get_bsc_olap_object(null,null,p_dim_name,'dimension',p_objects);
55: else
56: get_bsc_olap_object(null,p_type,p_dim_name,'dimension',p_objects);
57: end if;
58: Exception when others then

Line 56: get_bsc_olap_object(null,p_type,p_dim_name,'dimension',p_objects);

52: Begin
53: if p_type='all' then
54: get_bsc_olap_object(null,null,p_dim_name,'dimension',p_objects);
55: else
56: get_bsc_olap_object(null,p_type,p_dim_name,'dimension',p_objects);
57: end if;
58: Exception when others then
59: log_n('Exception in get_dim_olap_objects '||sqlerrm);
60: raise;

Line 106: l_oo_dim bsc_aw_md_wrapper.bsc_olap_object_tb;

102: given a dim level, find the CC dim
103: note>>> this only returns the latest un-corrected dim. used in BSCAWAKB.pls, BSCAWLDB.pls
104: */
105: procedure get_dim_for_level(p_level varchar2,p_dim out nocopy varchar2) is
106: l_oo_dim bsc_aw_md_wrapper.bsc_olap_object_tb;
107: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
108: Begin
109: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
110: --there can multiple dim in l_oo_level. only 1 is un-corrected

Line 107: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;

103: note>>> this only returns the latest un-corrected dim. used in BSCAWAKB.pls, BSCAWLDB.pls
104: */
105: procedure get_dim_for_level(p_level varchar2,p_dim out nocopy varchar2) is
106: l_oo_dim bsc_aw_md_wrapper.bsc_olap_object_tb;
107: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
108: Begin
109: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
110: --there can multiple dim in l_oo_level. only 1 is un-corrected
111: for i in 1..l_oo_level.count loop

Line 109: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);

105: procedure get_dim_for_level(p_level varchar2,p_dim out nocopy varchar2) is
106: l_oo_dim bsc_aw_md_wrapper.bsc_olap_object_tb;
107: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
108: Begin
109: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
110: --there can multiple dim in l_oo_level. only 1 is un-corrected
111: for i in 1..l_oo_level.count loop
112: if l_oo_level(i).parent_object_type='dimension' then
113: l_oo_dim.delete;

Line 114: get_bsc_olap_object(l_oo_level(i).parent_object,'dimension',l_oo_level(i).parent_object,'dimension',l_oo_dim);

110: --there can multiple dim in l_oo_level. only 1 is un-corrected
111: for i in 1..l_oo_level.count loop
112: if l_oo_level(i).parent_object_type='dimension' then
113: l_oo_dim.delete;
114: get_bsc_olap_object(l_oo_level(i).parent_object,'dimension',l_oo_level(i).parent_object,'dimension',l_oo_dim);
115: if nvl(bsc_aw_utility.get_parameter_value(l_oo_dim(1).property1,'corrected',','),'N')='N' then
116: p_dim:=l_oo_dim(1).object;
117: return;
118: end if;

Line 130: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;

126: /*
127: given a dim level, find all CC dims
128: */
129: procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table) is
130: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
131: Begin
132: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
133: --there can multiple dim in l_oo_level. only 1 is un-corrected
134: for i in 1..l_oo_level.count loop

Line 132: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);

128: */
129: procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table) is
130: l_oo_level bsc_aw_md_wrapper.bsc_olap_object_tb;
131: Begin
132: get_bsc_olap_object(p_level,'dimension level',null,null,l_oo_level);
133: --there can multiple dim in l_oo_level. only 1 is un-corrected
134: for i in 1..l_oo_level.count loop
135: if l_oo_level(i).parent_object_type='dimension' then
136: p_dim(p_dim.count+1):=l_oo_level(i).parent_object;

Line 169: get_bsc_olap_object(p_dim_level,'dimension level',null,null,g_olap_object);

165: ) return number is
166: l_position number;
167: Begin
168: g_olap_object.delete;
169: get_bsc_olap_object(p_dim_level,'dimension level',null,null,g_olap_object);
170: l_position:=bsc_aw_utility.get_parameter_value(g_olap_object(1).property1,'position',',');
171: if l_position is null then
172: return null;
173: else

Line 199: get_bsc_olap_object(null,null,p_kpi,'kpi',g_olap_object);

195: ) is
196: Begin
197: g_olap_object.delete;
198: if p_type='all' then
199: get_bsc_olap_object(null,null,p_kpi,'kpi',g_olap_object);
200: else
201: get_bsc_olap_object(null,p_type,p_kpi,'kpi',g_olap_object);
202: end if;
203: for i in 1..g_olap_object.count loop

Line 201: get_bsc_olap_object(null,p_type,p_kpi,'kpi',g_olap_object);

197: g_olap_object.delete;
198: if p_type='all' then
199: get_bsc_olap_object(null,null,p_kpi,'kpi',g_olap_object);
200: else
201: get_bsc_olap_object(null,p_type,p_kpi,'kpi',g_olap_object);
202: end if;
203: for i in 1..g_olap_object.count loop
204: if g_olap_object(i).olap_object_type is not null then
205: p_objects(p_objects.count+1).object_name:=g_olap_object(i).olap_object;

Line 244: --get_bsc_olap_object(p_dim.dim_name,'dimension',null,null,g_olap_object);

240: procedure get_dim_properties(p_dim in out nocopy bsc_aw_adapter_kpi.dim_r) is
241: l_property bsc_aw_utility.value_tb;
242: Begin
243: g_olap_object.delete;
244: --get_bsc_olap_object(p_dim.dim_name,'dimension',null,null,g_olap_object);
245: get_bsc_olap_object(null,null,p_dim.dim_name,'dimension',g_olap_object);
246: for i in 1..g_olap_object.count loop
247: if g_olap_object(i).object=p_dim.dim_name and g_olap_object(i).object_type='dimension' then
248: if g_olap_object(i).olap_object_type='concat dimension' then

Line 245: get_bsc_olap_object(null,null,p_dim.dim_name,'dimension',g_olap_object);

241: l_property bsc_aw_utility.value_tb;
242: Begin
243: g_olap_object.delete;
244: --get_bsc_olap_object(p_dim.dim_name,'dimension',null,null,g_olap_object);
245: get_bsc_olap_object(null,null,p_dim.dim_name,'dimension',g_olap_object);
246: for i in 1..g_olap_object.count loop
247: if g_olap_object(i).object=p_dim.dim_name and g_olap_object(i).object_type='dimension' then
248: if g_olap_object(i).olap_object_type='concat dimension' then
249: p_dim.concat:='Y';

Line 281: get_bsc_olap_object(null,null,p_calendar.aw_dim,'dimension',g_olap_object);

277: procedure get_calendar_properties(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r) is
278: l_property bsc_aw_utility.value_tb;
279: Begin
280: g_olap_object.delete;
281: get_bsc_olap_object(null,null,p_calendar.aw_dim,'dimension',g_olap_object);
282: for i in 1..g_olap_object.count loop
283: if g_olap_object(i).object=p_calendar.aw_dim and g_olap_object(i).object_type='dimension' then
284: p_calendar.calendar:=bsc_aw_utility.get_parameter_value(g_olap_object(i).property1,'calendar',',');
285: elsif g_olap_object(i).object_type='relation' then

Line 310: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

306: bsc metadata will only contain the latest info
307: note>>>this loads parent child without reference to level groups
308: */
309: procedure get_dim_parent_child(p_dim varchar2,p_parent_child out nocopy bsc_aw_adapter_dim.dim_parent_child_tb) is
310: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
311: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
312: Begin
313: l_oo.delete;
314: get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);

Line 311: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

307: note>>>this loads parent child without reference to level groups
308: */
309: procedure get_dim_parent_child(p_dim varchar2,p_parent_child out nocopy bsc_aw_adapter_dim.dim_parent_child_tb) is
310: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
311: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
312: Begin
313: l_oo.delete;
314: get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
315: for i in 1..l_oo.count loop

Line 314: get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);

310: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
311: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
312: Begin
313: l_oo.delete;
314: get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
315: for i in 1..l_oo.count loop
316: l_oor.delete;
317: get_bsc_olap_object_relation(l_oo(i).object,l_oo(i).object_type,'parent level',p_dim,'dimension',l_oor);
318: for j in 1..l_oor.count loop

Line 317: get_bsc_olap_object_relation(l_oo(i).object,l_oo(i).object_type,'parent level',p_dim,'dimension',l_oor);

313: l_oo.delete;
314: get_bsc_olap_object(null,'dimension level',p_dim,'dimension',l_oo);
315: for i in 1..l_oo.count loop
316: l_oor.delete;
317: get_bsc_olap_object_relation(l_oo(i).object,l_oo(i).object_type,'parent level',p_dim,'dimension',l_oor);
318: for j in 1..l_oor.count loop
319: p_parent_child(p_parent_child.count+1).child_level:=l_oor(j).object;
320: p_parent_child(p_parent_child.count).parent_level:=l_oor(j).relation_object;
321: p_parent_child(p_parent_child.count).child_fk:=bsc_aw_utility.get_parameter_value(l_oor(j).property1,'fk',',');

Line 330: procedure get_bsc_olap_object(

326: log_n('Exception in get_dim_parent_child '||sqlerrm);
327: raise;
328: End;
329:
330: procedure get_bsc_olap_object(
331: p_object varchar2,
332: p_type varchar2,
333: p_parent_object varchar2,
334: p_parent_type varchar2,

Line 335: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

331: p_object varchar2,
332: p_type varchar2,
333: p_parent_object varchar2,
334: p_parent_type varchar2,
335: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
336: ) is
337: --
338: l_cache_found varchar2(20);
339: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

Line 339: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

335: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
336: ) is
337: --
338: l_cache_found varchar2(20);
339: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
340: Begin
341: l_cache_found:=get_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
342: if l_cache_found='N' then
343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);

Line 341: l_cache_found:=get_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);

337: --
338: l_cache_found varchar2(20);
339: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
340: Begin
341: l_cache_found:=get_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
342: if l_cache_found='N' then
343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
345: end if;

Line 343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);

339: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
340: Begin
341: l_cache_found:=get_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
342: if l_cache_found='N' then
343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
345: end if;
346: p_bsc_olap_object:=l_bsc_olap_object;
347: Exception when others then

Line 344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);

340: Begin
341: l_cache_found:=get_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
342: if l_cache_found='N' then
343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
345: end if;
346: p_bsc_olap_object:=l_bsc_olap_object;
347: Exception when others then
348: log_n('Exception in get_bsc_olap_object '||sqlerrm);

Line 346: p_bsc_olap_object:=l_bsc_olap_object;

342: if l_cache_found='N' then
343: bsc_aw_md_wrapper.get_bsc_olap_object(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
345: end if;
346: p_bsc_olap_object:=l_bsc_olap_object;
347: Exception when others then
348: log_n('Exception in get_bsc_olap_object '||sqlerrm);
349: raise;
350: End;

Line 348: log_n('Exception in get_bsc_olap_object '||sqlerrm);

344: add_oo_cache(p_object,p_type,p_parent_object,p_parent_type,l_bsc_olap_object);
345: end if;
346: p_bsc_olap_object:=l_bsc_olap_object;
347: Exception when others then
348: log_n('Exception in get_bsc_olap_object '||sqlerrm);
349: raise;
350: End;
351:
352: function get_oo_cache(

Line 357: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

353: p_object varchar2,
354: p_type varchar2,
355: p_parent_object varchar2,
356: p_parent_type varchar2,
357: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
358: ) return varchar2 is
359: --
360: l_cache_found varchar2(20);
361: Begin

Line 368: if g_oo_cache(i).bsc_olap_object.count > 0 then

364: if nvl(g_oo_cache(i).object,'^')=nvl(p_object,'^')
365: and nvl(g_oo_cache(i).object_type,'^')=nvl(p_type,'^')
366: and nvl(g_oo_cache(i).parent_object,'^')=nvl(p_parent_object,'^')
367: and nvl(g_oo_cache(i).parent_object_type,'^')=nvl(p_parent_type,'^') then
368: if g_oo_cache(i).bsc_olap_object.count > 0 then
369: p_bsc_olap_object:=g_oo_cache(i).bsc_olap_object;
370: l_cache_found:='Y';
371: end if;
372: exit;

Line 369: p_bsc_olap_object:=g_oo_cache(i).bsc_olap_object;

365: and nvl(g_oo_cache(i).object_type,'^')=nvl(p_type,'^')
366: and nvl(g_oo_cache(i).parent_object,'^')=nvl(p_parent_object,'^')
367: and nvl(g_oo_cache(i).parent_object_type,'^')=nvl(p_parent_type,'^') then
368: if g_oo_cache(i).bsc_olap_object.count > 0 then
369: p_bsc_olap_object:=g_oo_cache(i).bsc_olap_object;
370: l_cache_found:='Y';
371: end if;
372: exit;
373: end if;

Line 386: p_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb

382: p_object varchar2,
383: p_type varchar2,
384: p_parent_object varchar2,
385: p_parent_type varchar2,
386: p_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb
387: ) is
388: --
389: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
390: Begin

Line 389: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

385: p_parent_type varchar2,
386: p_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb
387: ) is
388: --
389: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
390: Begin
391: l_bsc_olap_object:=p_bsc_olap_object;
392: g_oo_cache(g_oo_cache.count+1).object:=p_object;
393: g_oo_cache(g_oo_cache.count).object_type:=p_type;

Line 391: l_bsc_olap_object:=p_bsc_olap_object;

387: ) is
388: --
389: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
390: Begin
391: l_bsc_olap_object:=p_bsc_olap_object;
392: g_oo_cache(g_oo_cache.count+1).object:=p_object;
393: g_oo_cache(g_oo_cache.count).object_type:=p_type;
394: g_oo_cache(g_oo_cache.count).parent_object:=p_parent_object;
395: g_oo_cache(g_oo_cache.count).parent_object_type:=p_parent_type;

Line 396: g_oo_cache(g_oo_cache.count).bsc_olap_object:=l_bsc_olap_object;

392: g_oo_cache(g_oo_cache.count+1).object:=p_object;
393: g_oo_cache(g_oo_cache.count).object_type:=p_type;
394: g_oo_cache(g_oo_cache.count).parent_object:=p_parent_object;
395: g_oo_cache(g_oo_cache.count).parent_object_type:=p_parent_type;
396: g_oo_cache(g_oo_cache.count).bsc_olap_object:=l_bsc_olap_object;
397: Exception when others then
398: log_n('Exception in add_oo_cache '||sqlerrm);
399: raise;
400: End;

Line 402: procedure get_bsc_olap_object_relation(

398: log_n('Exception in add_oo_cache '||sqlerrm);
399: raise;
400: End;
401:
402: procedure get_bsc_olap_object_relation(
403: p_object varchar2,
404: p_object_type varchar2,
405: p_relation_type varchar2,
406: p_parent_object varchar2,

Line 408: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

404: p_object_type varchar2,
405: p_relation_type varchar2,
406: p_parent_object varchar2,
407: p_parent_object_type varchar2,
408: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
409: ) is
410: --
411: l_cache_found varchar2(20);
412: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

Line 412: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

408: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
409: ) is
410: --
411: l_cache_found varchar2(20);
412: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
413: Begin
414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
415: if l_cache_found='N' then
416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,

Line 414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);

410: --
411: l_cache_found varchar2(20);
412: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
413: Begin
414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
415: if l_cache_found='N' then
416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
417: l_bsc_olap_object_relation);
418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);

Line 416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,

412: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
413: Begin
414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
415: if l_cache_found='N' then
416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
417: l_bsc_olap_object_relation);
418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
419: end if;
420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;

Line 417: l_bsc_olap_object_relation);

413: Begin
414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
415: if l_cache_found='N' then
416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
417: l_bsc_olap_object_relation);
418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
419: end if;
420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;
421: Exception when others then

Line 418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);

414: l_cache_found:=get_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
415: if l_cache_found='N' then
416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
417: l_bsc_olap_object_relation);
418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
419: end if;
420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;
421: Exception when others then
422: log_n('Exception in get_bsc_olap_object_relation '||sqlerrm);

Line 420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;

416: bsc_aw_md_wrapper.get_bsc_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
417: l_bsc_olap_object_relation);
418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
419: end if;
420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;
421: Exception when others then
422: log_n('Exception in get_bsc_olap_object_relation '||sqlerrm);
423: raise;
424: End;

Line 422: log_n('Exception in get_bsc_olap_object_relation '||sqlerrm);

418: add_oor_cache(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,l_bsc_olap_object_relation);
419: end if;
420: p_bsc_olap_object_relation:=l_bsc_olap_object_relation;
421: Exception when others then
422: log_n('Exception in get_bsc_olap_object_relation '||sqlerrm);
423: raise;
424: End;
425:
426: function get_oor_cache(

Line 432: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

428: p_object_type varchar2,
429: p_relation_type varchar2,
430: p_parent_object varchar2,
431: p_parent_object_type varchar2,
432: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
433: ) return varchar2 is
434: --
435: l_cache_found varchar2(20);
436: Begin

Line 444: if g_oor_cache(i).bsc_olap_object_relation.count > 0 then

440: and nvl(g_oor_cache(i).object_type,'^')=nvl(p_object_type,'^')
441: and nvl(g_oor_cache(i).relation_type,'^')=nvl(p_relation_type,'^')
442: and nvl(g_oor_cache(i).parent_object,'^')=nvl(p_parent_object,'^')
443: and nvl(g_oor_cache(i).parent_object_type,'^')=nvl(p_parent_object_type,'^') then
444: if g_oor_cache(i).bsc_olap_object_relation.count > 0 then
445: p_bsc_olap_object_relation:=g_oor_cache(i).bsc_olap_object_relation;
446: l_cache_found:='Y';
447: end if;
448: exit;

Line 445: p_bsc_olap_object_relation:=g_oor_cache(i).bsc_olap_object_relation;

441: and nvl(g_oor_cache(i).relation_type,'^')=nvl(p_relation_type,'^')
442: and nvl(g_oor_cache(i).parent_object,'^')=nvl(p_parent_object,'^')
443: and nvl(g_oor_cache(i).parent_object_type,'^')=nvl(p_parent_object_type,'^') then
444: if g_oor_cache(i).bsc_olap_object_relation.count > 0 then
445: p_bsc_olap_object_relation:=g_oor_cache(i).bsc_olap_object_relation;
446: l_cache_found:='Y';
447: end if;
448: exit;
449: end if;

Line 463: p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb

459: p_object_type varchar2,
460: p_relation_type varchar2,
461: p_parent_object varchar2,
462: p_parent_object_type varchar2,
463: p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
464: ) is
465: --
466: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
467: Begin

Line 466: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

462: p_parent_object_type varchar2,
463: p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
464: ) is
465: --
466: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
467: Begin
468: l_bsc_olap_object_relation:=p_bsc_olap_object_relation;
469: g_oor_cache(g_oor_cache.count+1).object:=p_object;
470: g_oor_cache(g_oor_cache.count).object_type:=p_object_type;

Line 468: l_bsc_olap_object_relation:=p_bsc_olap_object_relation;

464: ) is
465: --
466: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
467: Begin
468: l_bsc_olap_object_relation:=p_bsc_olap_object_relation;
469: g_oor_cache(g_oor_cache.count+1).object:=p_object;
470: g_oor_cache(g_oor_cache.count).object_type:=p_object_type;
471: g_oor_cache(g_oor_cache.count).relation_type:=p_relation_type;
472: g_oor_cache(g_oor_cache.count).parent_object:=p_parent_object;

Line 474: g_oor_cache(g_oor_cache.count).bsc_olap_object_relation:=l_bsc_olap_object_relation;

470: g_oor_cache(g_oor_cache.count).object_type:=p_object_type;
471: g_oor_cache(g_oor_cache.count).relation_type:=p_relation_type;
472: g_oor_cache(g_oor_cache.count).parent_object:=p_parent_object;
473: g_oor_cache(g_oor_cache.count).parent_object_type:=p_parent_object_type;
474: g_oor_cache(g_oor_cache.count).bsc_olap_object_relation:=l_bsc_olap_object_relation;
475: Exception when others then
476: log_n('Exception in add_oor_cache '||sqlerrm);
477: raise;
478: End;

Line 499: get_bsc_olap_object_relation(p_kpi,'kpi','kpi dimension',p_kpi,'kpi',g_olap_object_relation);

495: p_dim_list out nocopy dbms_sql.varchar2_table
496: ) is
497: Begin
498: g_olap_object_relation.delete;
499: get_bsc_olap_object_relation(p_kpi,'kpi','kpi dimension',p_kpi,'kpi',g_olap_object_relation);
500: for i in 1..g_olap_object_relation.count loop
501: p_dim_list(i):=g_olap_object_relation(i).relation_object;
502: end loop;
503: Exception when others then

Line 516: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

512: ) is
513: --
514: l_periodicity dbms_sql.varchar2_table;
515: l_periodicity_type dbms_sql.varchar2_table;
516: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
518: Begin
519: --get the relation name
520: l_oo.delete;

Line 517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

513: --
514: l_periodicity dbms_sql.varchar2_table;
515: l_periodicity_type dbms_sql.varchar2_table;
516: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
518: Begin
519: --get the relation name
520: l_oo.delete;
521: get_bsc_olap_object(p_dim_set.calendar.aw_dim,'dimension',p_dim_set.calendar.aw_dim,'dimension',l_oo);

Line 521: get_bsc_olap_object(p_dim_set.calendar.aw_dim,'dimension',p_dim_set.calendar.aw_dim,'dimension',l_oo);

517: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
518: Begin
519: --get the relation name
520: l_oo.delete;
521: get_bsc_olap_object(p_dim_set.calendar.aw_dim,'dimension',p_dim_set.calendar.aw_dim,'dimension',l_oo);
522: get_calendar_properties(p_dim_set.calendar);
523: --from bsc olap metadata, get the properties of the periodicities
524: l_oo.delete;
525: get_bsc_olap_object(null,'dimension level',p_dim_set.calendar.aw_dim,'dimension',l_oo);

Line 525: get_bsc_olap_object(null,'dimension level',p_dim_set.calendar.aw_dim,'dimension',l_oo);

521: get_bsc_olap_object(p_dim_set.calendar.aw_dim,'dimension',p_dim_set.calendar.aw_dim,'dimension',l_oo);
522: get_calendar_properties(p_dim_set.calendar);
523: --from bsc olap metadata, get the properties of the periodicities
524: l_oo.delete;
525: get_bsc_olap_object(null,'dimension level',p_dim_set.calendar.aw_dim,'dimension',l_oo);
526: for i in 1..l_oo.count loop
527: l_periodicity(i):=null;
528: l_periodicity_type(i):=null;
529: l_periodicity(i):=bsc_aw_utility.get_parameter_value(l_oo(i).property1,'periodicity',',');

Line 554: get_bsc_olap_object_relation(null,null,'parent level',p_dim_set.calendar.aw_dim,'dimension',l_olap_object_relation);

550: --
551: --fill parent child info
552: l_olap_object_relation.delete;
553: p_dim_set.calendar.parent_child.delete;
554: get_bsc_olap_object_relation(null,null,'parent level',p_dim_set.calendar.aw_dim,'dimension',l_olap_object_relation);
555: for i in 1..l_olap_object_relation.count loop
556: p_dim_set.calendar.parent_child(p_dim_set.calendar.parent_child.count+1).parent_dim_name:=l_olap_object_relation(i).relation_object;
557: p_dim_set.calendar.parent_child(p_dim_set.calendar.parent_child.count).child_dim_name:=l_olap_object_relation(i).object;
558: p_dim_set.calendar.parent_child(p_dim_set.calendar.parent_child.count).parent:=to_number(

Line 574: get_bsc_olap_object(p_kpi,'kpi',p_kpi,'kpi',g_olap_object);

570: )return boolean is
571:
572: Begin
573: g_olap_object.delete;
574: get_bsc_olap_object(p_kpi,'kpi',p_kpi,'kpi',g_olap_object);
575: if g_olap_object.count>0 then
576: return true;
577: else
578: return false;

Line 587: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

583: End;
584:
585: procedure get_kpi_dimset(
586: p_kpi varchar2,
587: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
588: ) is
589: Begin
590: get_bsc_olap_object(null,'kpi dimension set',p_kpi,'kpi',p_bsc_olap_object);
591: Exception when others then

Line 590: get_bsc_olap_object(null,'kpi dimension set',p_kpi,'kpi',p_bsc_olap_object);

586: p_kpi varchar2,
587: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
588: ) is
589: Begin
590: get_bsc_olap_object(null,'kpi dimension set',p_kpi,'kpi',p_bsc_olap_object);
591: Exception when others then
592: log_n('Exception in get_kpi_dimset '||sqlerrm);
593: raise;
594: End;

Line 599: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

595:
596: --only Actual dimset not targets
597: procedure get_kpi_dimset_actual(
598: p_kpi varchar2,
599: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
600: ) is
601: --
602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
603: Begin

Line 602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

598: p_kpi varchar2,
599: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
600: ) is
601: --
602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
603: Begin
604: get_kpi_dimset(p_kpi,l_bsc_olap_object);
605: for i in 1..l_bsc_olap_object.count loop
606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then

Line 604: get_kpi_dimset(p_kpi,l_bsc_olap_object);

600: ) is
601: --
602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
603: Begin
604: get_kpi_dimset(p_kpi,l_bsc_olap_object);
605: for i in 1..l_bsc_olap_object.count loop
606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then
607: p_bsc_olap_object(p_bsc_olap_object.count+1):=l_bsc_olap_object(i);
608: end if;

Line 605: for i in 1..l_bsc_olap_object.count loop

601: --
602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
603: Begin
604: get_kpi_dimset(p_kpi,l_bsc_olap_object);
605: for i in 1..l_bsc_olap_object.count loop
606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then
607: p_bsc_olap_object(p_bsc_olap_object.count+1):=l_bsc_olap_object(i);
608: end if;
609: end loop;

Line 606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then

602: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
603: Begin
604: get_kpi_dimset(p_kpi,l_bsc_olap_object);
605: for i in 1..l_bsc_olap_object.count loop
606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then
607: p_bsc_olap_object(p_bsc_olap_object.count+1):=l_bsc_olap_object(i);
608: end if;
609: end loop;
610: Exception when others then

Line 607: p_bsc_olap_object(p_bsc_olap_object.count+1):=l_bsc_olap_object(i);

603: Begin
604: get_kpi_dimset(p_kpi,l_bsc_olap_object);
605: for i in 1..l_bsc_olap_object.count loop
606: if bsc_aw_utility.get_parameter_value(l_bsc_olap_object(i).property1,'dim set type',',')='actual' then
607: p_bsc_olap_object(p_bsc_olap_object.count+1):=l_bsc_olap_object(i);
608: end if;
609: end loop;
610: Exception when others then
611: log_n('Exception in get_kpi_dimset_actual '||sqlerrm);

Line 622: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

618: procedure get_dimset_base_table(
619: p_kpi varchar2,
620: p_dimset varchar2,
621: p_base_table_type varchar2,--"base table dim set"
622: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
623: ) is
624: Begin
625: g_olap_object_relation.delete;
626: --get full relations for the kpi. then find out the base tables for the dimset

Line 627: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',g_olap_object_relation);

623: ) is
624: Begin
625: g_olap_object_relation.delete;
626: --get full relations for the kpi. then find out the base tables for the dimset
627: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',g_olap_object_relation);
628: if p_base_table_type is not null then
629: for i in 1..g_olap_object_relation.count loop
630: if g_olap_object_relation(i).object_type='base table' and g_olap_object_relation(i).relation_type=p_base_table_type
631: and g_olap_object_relation(i).relation_object=p_dimset then

Line 655: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

651: procedure get_base_table_dimset(
652: p_kpi varchar2,
653: p_base_table varchar2,
654: p_base_table_type varchar2,--"base table dim set"
655: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
656: ) is
657: Begin
658: g_olap_object_relation.delete;
659: --get full relations for the kpi. then find out the dimsets for the base table

Line 660: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',g_olap_object_relation);

656: ) is
657: Begin
658: g_olap_object_relation.delete;
659: --get full relations for the kpi. then find out the dimsets for the base table
660: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',g_olap_object_relation);
661: if p_base_table_type is not null then
662: for i in 1..g_olap_object_relation.count loop
663: if g_olap_object_relation(i).object_type='base table' and g_olap_object_relation(i).relation_type=p_base_table_type
664: and g_olap_object_relation(i).object=p_base_table then

Line 687: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

683: p_dimset varchar2,
684: p_measure out nocopy bsc_aw_adapter_kpi.measure_tb
685: ) is
686: --
687: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
688: l_values bsc_aw_utility.value_tb;
689: l_property varchar2(2000);
690: Begin
691: get_bsc_olap_object_relation(p_dimset,'kpi dimension set','dim set measure',p_kpi,'kpi',l_olap_object_relation);

Line 691: get_bsc_olap_object_relation(p_dimset,'kpi dimension set','dim set measure',p_kpi,'kpi',l_olap_object_relation);

687: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
688: l_values bsc_aw_utility.value_tb;
689: l_property varchar2(2000);
690: Begin
691: get_bsc_olap_object_relation(p_dimset,'kpi dimension set','dim set measure',p_kpi,'kpi',l_olap_object_relation);
692: --l_agg_formula:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'agg formula',',');
693: for i in 1..l_olap_object_relation.count loop
694: p_measure(p_measure.count+1).measure:=l_olap_object_relation(i).relation_object;
695: p_measure(p_measure.count).measure_type:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'measure type',',');

Line 718: --cannot change get_parameter_value to scanning bsc_olap_object even though bsc_olap_object has the cube and fcst cube etc

714: for j in 1..l_values.count loop
715: p_measure(p_measure.count).agg_formula.measures(p_measure(p_measure.count).agg_formula.measures.count+1):=l_values(j).parameter;
716: end loop;
717: end if;
718: --cannot change get_parameter_value to scanning bsc_olap_object even though bsc_olap_object has the cube and fcst cube etc
719: --in bsc_olap_object, we cannot know which measure belongs to which dimset
720: p_measure(p_measure.count).cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'cube',',');
721: p_measure(p_measure.count).fcst_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'fcst cube',',');
722: p_measure(p_measure.count).countvar_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'countvar cube',',');

Line 719: --in bsc_olap_object, we cannot know which measure belongs to which dimset

715: p_measure(p_measure.count).agg_formula.measures(p_measure(p_measure.count).agg_formula.measures.count+1):=l_values(j).parameter;
716: end loop;
717: end if;
718: --cannot change get_parameter_value to scanning bsc_olap_object even though bsc_olap_object has the cube and fcst cube etc
719: --in bsc_olap_object, we cannot know which measure belongs to which dimset
720: p_measure(p_measure.count).cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'cube',',');
721: p_measure(p_measure.count).fcst_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'fcst cube',',');
722: p_measure(p_measure.count).countvar_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'countvar cube',',');
723: p_measure(p_measure.count).display_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'display cube',',');

Line 759: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

755: p_dimset_name varchar2,
756: p_dimset out nocopy bsc_aw_adapter_kpi.dim_set_r
757: ) is
758: --
759: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
760: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
761: l_num number;
762: Begin
763: --get all properties of the kpi. then loop through

Line 760: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

756: p_dimset out nocopy bsc_aw_adapter_kpi.dim_set_r
757: ) is
758: --
759: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
760: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
761: l_num number;
762: Begin
763: --get all properties of the kpi. then loop through
764: get_bsc_olap_object(p_dimset_name,'kpi dimension set',p_kpi,'kpi',l_olap_object);

Line 764: get_bsc_olap_object(p_dimset_name,'kpi dimension set',p_kpi,'kpi',l_olap_object);

760: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
761: l_num number;
762: Begin
763: --get all properties of the kpi. then loop through
764: get_bsc_olap_object(p_dimset_name,'kpi dimension set',p_kpi,'kpi',l_olap_object);
765: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
766: p_dimset.dim_set_name:=p_dimset_name;
767: --dimset properties
768: p_dimset.dim_set:=bsc_aw_utility.get_parameter_value(l_olap_object(1).property1,'dim set',',');

Line 765: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

761: l_num number;
762: Begin
763: --get all properties of the kpi. then loop through
764: get_bsc_olap_object(p_dimset_name,'kpi dimension set',p_kpi,'kpi',l_olap_object);
765: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
766: p_dimset.dim_set_name:=p_dimset_name;
767: --dimset properties
768: p_dimset.dim_set:=bsc_aw_utility.get_parameter_value(l_olap_object(1).property1,'dim set',',');
769: p_dimset.dim_set_type:=bsc_aw_utility.get_parameter_value(l_olap_object(1).property1,'dim set type',',');

Line 825: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

821: p_dimset_name varchar2,
822: p_partition_template out nocopy bsc_aw_adapter_kpi.partition_template_tb,
823: p_composite out nocopy bsc_aw_adapter_kpi.composite_tb) is
824: --
825: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
826: Begin
827: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
828: for i in 1..l_olap_object_relation.count loop
829: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set partition template' then

Line 827: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

823: p_composite out nocopy bsc_aw_adapter_kpi.composite_tb) is
824: --
825: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
826: Begin
827: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
828: for i in 1..l_olap_object_relation.count loop
829: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set partition template' then
830: p_partition_template(p_partition_template.count+1).template_name:=l_olap_object_relation(i).relation_object;
831: p_partition_template(p_partition_template.count).template_type:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,

Line 871: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

867: p_kpi varchar2,
868: p_dimset_name varchar2,
869: p_cube_set out nocopy bsc_aw_adapter_kpi.cube_set_tb) is
870: --
871: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
872: Begin
873: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
874: for i in 1..l_olap_object_relation.count loop
875: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set cube set' then

Line 873: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

869: p_cube_set out nocopy bsc_aw_adapter_kpi.cube_set_tb) is
870: --
871: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
872: Begin
873: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
874: for i in 1..l_olap_object_relation.count loop
875: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set cube set' then
876: p_cube_set(p_cube_set.count+1).cube_set_name:=l_olap_object_relation(i).relation_object;
877: p_cube_set(p_cube_set.count).cube_set_type:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'cube set type',',');

Line 903: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

899: p_cube_set_name varchar2,
900: p_cube_type varchar2,
901: p_cube out nocopy bsc_aw_adapter_kpi.cube_r) is
902: --
903: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
904: Begin
905: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
906: for i in 1..l_olap_object_relation.count loop
907: if l_olap_object_relation(i).object=p_cube_set_name and l_olap_object_relation(i).relation_type=p_cube_type then

Line 905: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

901: p_cube out nocopy bsc_aw_adapter_kpi.cube_r) is
902: --
903: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
904: Begin
905: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
906: for i in 1..l_olap_object_relation.count loop
907: if l_olap_object_relation(i).object=p_cube_set_name and l_olap_object_relation(i).relation_type=p_cube_type then
908: p_cube.cube_name:=l_olap_object_relation(i).relation_object;
909: p_cube.cube_type:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'cube type',',');

Line 935: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

931: p_dim out nocopy bsc_aw_adapter_kpi.dim_tb,
932: p_std_dim out nocopy bsc_aw_adapter_kpi.dim_tb
933: ) is
934: --
935: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
936: Begin
937: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
938: for i in 1..l_olap_object_relation.count loop
939: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set dim' then

Line 937: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

933: ) is
934: --
935: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
936: Begin
937: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
938: for i in 1..l_olap_object_relation.count loop
939: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set dim' then
940: p_dim(p_dim.count+1).dim_name:=l_olap_object_relation(i).relation_object;
941: get_kpi_dimset_dim_md(p_kpi,p_dimset_name,p_dim(p_dim.count),l_olap_object_relation(i).relation_type,

Line 958: bsc_olap_object we do not know which limit cube is tied to which dim

954: /*
955: given a dim, get the properties and levels
956: p_dim.dim_name is known
957: p_dim.limit_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'limit cube',',') is reqd since in
958: bsc_olap_object we do not know which limit cube is tied to which dim
959:
960: zero code is stored at the dim level, not at the dim level
961: p_level_type is "dim set dim level"
962: */

Line 971: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

967: p_dim_type varchar2,
968: p_level_type varchar2
969: ) is
970: --
971: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
972: l_oor_zero_code bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
973: l_oor_rec_level bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
974: l_index number;
975: Begin

Line 972: l_oor_zero_code bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

968: p_level_type varchar2
969: ) is
970: --
971: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
972: l_oor_zero_code bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
973: l_oor_rec_level bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
974: l_index number;
975: Begin
976: get_dim_properties(p_dim);--property,rec,multi level,leven name dim

Line 973: l_oor_rec_level bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

969: ) is
970: --
971: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
972: l_oor_zero_code bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
973: l_oor_rec_level bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
974: l_index number;
975: Begin
976: get_dim_properties(p_dim);--property,rec,multi level,leven name dim
977: --get the levels

Line 979: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

975: Begin
976: get_dim_properties(p_dim);--property,rec,multi level,leven name dim
977: --get the levels
978: --limit cube=kpi_3014_2_BSC_CCDIM_100.limit.bool,agg map=aggmap_BSC_CCDIM_100_2_3014
979: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
980: for i in 1..l_olap_object_relation.count loop
981: if l_olap_object_relation(i).relation_type=p_dim_type
982: and l_olap_object_relation(i).relation_object=p_dim.dim_name and l_olap_object_relation(i).object=p_dimset_name then
983: p_dim.limit_cube:=bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'limit cube',',');

Line 1015: get_bsc_olap_object_relation(p_dim.levels(l_index).level_name,'dimension level','zero code level',p_dim.dim_name,'dimension',l_oor_zero_code);

1011: /*nvl(Y) for zero_aggregated for backward compatibility */
1012: p_dim.levels(l_index).zero_code:=nvl(bsc_aw_utility.get_parameter_value(l_olap_object_relation(i).property1,'zero code',','),'N'); --Y or N
1013: if p_dim.levels(l_index).zero_code='Y' then
1014: l_oor_zero_code.delete;
1015: get_bsc_olap_object_relation(p_dim.levels(l_index).level_name,'dimension level','zero code level',p_dim.dim_name,'dimension',l_oor_zero_code);
1016: p_dim.levels(l_index).zero_code_level:=l_oor_zero_code(1).relation_object;
1017: end if;
1018: if p_dim.recursive='Y' then
1019: l_oor_rec_level.delete;

Line 1020: get_bsc_olap_object_relation(p_dim.levels(l_index).level_name,'dimension level','recursive parent level',p_dim.dim_name,'dimension',l_oor_rec_level);

1016: p_dim.levels(l_index).zero_code_level:=l_oor_zero_code(1).relation_object;
1017: end if;
1018: if p_dim.recursive='Y' then
1019: l_oor_rec_level.delete;
1020: get_bsc_olap_object_relation(p_dim.levels(l_index).level_name,'dimension level','recursive parent level',p_dim.dim_name,'dimension',l_oor_rec_level);
1021: p_dim.levels(l_index).rec_parent_level:=l_oor_rec_level(1).relation_object;
1022: end if;
1023: end if;
1024: end loop;

Line 1027: get_bsc_olap_object_relation(null,null,'parent level',p_dim.dim_name,'dimension',l_olap_object_relation);

1023: end if;
1024: end loop;
1025: --
1026: l_olap_object_relation.delete;
1027: get_bsc_olap_object_relation(null,null,'parent level',p_dim.dim_name,'dimension',l_olap_object_relation);
1028: for i in 1..l_olap_object_relation.count loop
1029: --we add the parent child relation if both the parent and the child are levels of the kpi
1030: if is_level_in_dim(p_dim,l_olap_object_relation(i).relation_object) and
1031: is_level_in_dim(p_dim,l_olap_object_relation(i).object) then

Line 1065: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

1061: p_dimset_name varchar2,
1062: p_calendar out nocopy bsc_aw_adapter_kpi.calendar_r
1063: ) is
1064: --
1065: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1066: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1067: l_index number;
1068: Begin
1069: --dim set calendar

Line 1066: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

1062: p_calendar out nocopy bsc_aw_adapter_kpi.calendar_r
1063: ) is
1064: --
1065: l_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1066: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1067: l_index number;
1068: Begin
1069: --dim set calendar
1070: --

Line 1071: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);

1067: l_index number;
1068: Begin
1069: --dim set calendar
1070: --
1071: get_bsc_olap_object_relation(null,null,null,p_kpi,'kpi',l_olap_object_relation);
1072: for i in 1..l_olap_object_relation.count loop
1073: if l_olap_object_relation(i).object=p_dimset_name and l_olap_object_relation(i).relation_type='dim set calendar' then
1074: p_calendar.aw_dim:=l_olap_object_relation(i).relation_object;
1075: get_calendar_properties(p_calendar);

Line 1084: get_bsc_olap_object(p_calendar.aw_dim,'dimension',p_calendar.aw_dim,'dimension',l_olap_object);

1080: exit;
1081: end if;
1082: end loop;
1083: --get the level name dim
1084: get_bsc_olap_object(p_calendar.aw_dim,'dimension',p_calendar.aw_dim,'dimension',l_olap_object);
1085: get_calendar_properties(p_calendar);
1086: --get the periodicities
1087: --remember...for periodicities, lowest level is not periodicity(1). its indicated by the property lowest level only
1088: for i in 1..l_olap_object_relation.count loop

Line 1106: get_bsc_olap_object_relation(null,null,'parent level',p_calendar.aw_dim,'dimension',l_olap_object_relation);

1102: end loop;
1103: --load the periodicity relations
1104: l_olap_object_relation.delete;
1105: p_calendar.parent_child.delete;
1106: get_bsc_olap_object_relation(null,null,'parent level',p_calendar.aw_dim,'dimension',l_olap_object_relation);
1107: for i in 1..l_olap_object_relation.count loop
1108: if is_periodicity_in_dim(p_calendar,l_olap_object_relation(i).relation_object) and
1109: is_periodicity_in_dim(p_calendar,l_olap_object_relation(i).object) then
1110: p_calendar.parent_child(p_calendar.parent_child.count+1).parent_dim_name:=l_olap_object_relation(i).relation_object;

Line 1168: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

1164:
1165: /*input is the kpi name. all other metadata is populated
1166: */
1167: procedure get_kpi(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r) is
1168: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1169: l_dim_set varchar2(300);
1170: Begin
1171: --get kpi properties
1172: if g_debug then

Line 1175: get_bsc_olap_object(p_kpi.kpi,'kpi',p_kpi.kpi,'kpi',l_oo);

1171: --get kpi properties
1172: if g_debug then
1173: log('In get_kpi '||p_kpi.kpi);
1174: end if;
1175: get_bsc_olap_object(p_kpi.kpi,'kpi',p_kpi.kpi,'kpi',l_oo);
1176: if l_oo.count=0 then
1177: log('Could not find kpi info');
1178: raise bsc_aw_utility.g_exception;
1179: end if;

Line 1224: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

1220: raise;
1221: End;
1222:
1223: function check_workspace(p_workspace_name varchar2) return varchar2 is
1224: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1225: Begin
1226: get_bsc_olap_object(p_workspace_name,'aw workspace','BSC','APPS',l_olap_object);
1227: if l_olap_object.count>0 then
1228: return 'Y';

Line 1226: get_bsc_olap_object(p_workspace_name,'aw workspace','BSC','APPS',l_olap_object);

1222:
1223: function check_workspace(p_workspace_name varchar2) return varchar2 is
1224: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1225: Begin
1226: get_bsc_olap_object(p_workspace_name,'aw workspace','BSC','APPS',l_olap_object);
1227: if l_olap_object.count>0 then
1228: return 'Y';
1229: else
1230: return 'N';

Line 1390: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

1386: raise;
1387: End;
1388:
1389: function get_bt_change_vector(p_base_table varchar2) return number is
1390: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1391: Begin
1392: get_bsc_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',l_bsc_olap_object_relation);
1393: if l_bsc_olap_object_relation.count=0 then
1394: return null;

Line 1392: get_bsc_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',l_bsc_olap_object_relation);

1388:
1389: function get_bt_change_vector(p_base_table varchar2) return number is
1390: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1391: Begin
1392: get_bsc_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',l_bsc_olap_object_relation);
1393: if l_bsc_olap_object_relation.count=0 then
1394: return null;
1395: else
1396: return to_number(l_bsc_olap_object_relation(1).relation_object);

Line 1393: if l_bsc_olap_object_relation.count=0 then

1389: function get_bt_change_vector(p_base_table varchar2) return number is
1390: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1391: Begin
1392: get_bsc_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',l_bsc_olap_object_relation);
1393: if l_bsc_olap_object_relation.count=0 then
1394: return null;
1395: else
1396: return to_number(l_bsc_olap_object_relation(1).relation_object);
1397: end if;

Line 1396: return to_number(l_bsc_olap_object_relation(1).relation_object);

1392: get_bsc_olap_object_relation(p_base_table,'base table','base table change vector',p_base_table,'base table',l_bsc_olap_object_relation);
1393: if l_bsc_olap_object_relation.count=0 then
1394: return null;
1395: else
1396: return to_number(l_bsc_olap_object_relation(1).relation_object);
1397: end if;
1398: Exception when others then
1399: log_n('Exception in get_bt_change_vector '||sqlerrm);
1400: raise;

Line 1404: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

1400: raise;
1401: End;
1402:
1403: function get_bt_current_period(p_base_table varchar2) return varchar2 is
1404: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1405: Begin
1406: get_bsc_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',l_bsc_olap_object_relation);
1407: if l_bsc_olap_object_relation.count=0 then
1408: return null;

Line 1406: get_bsc_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',l_bsc_olap_object_relation);

1402:
1403: function get_bt_current_period(p_base_table varchar2) return varchar2 is
1404: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1405: Begin
1406: get_bsc_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',l_bsc_olap_object_relation);
1407: if l_bsc_olap_object_relation.count=0 then
1408: return null;
1409: else
1410: return l_bsc_olap_object_relation(1).relation_object;

Line 1407: if l_bsc_olap_object_relation.count=0 then

1403: function get_bt_current_period(p_base_table varchar2) return varchar2 is
1404: l_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1405: Begin
1406: get_bsc_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',l_bsc_olap_object_relation);
1407: if l_bsc_olap_object_relation.count=0 then
1408: return null;
1409: else
1410: return l_bsc_olap_object_relation(1).relation_object;
1411: end if;

Line 1410: return l_bsc_olap_object_relation(1).relation_object;

1406: get_bsc_olap_object_relation(p_base_table,'base table','base table current period',p_base_table,'base table',l_bsc_olap_object_relation);
1407: if l_bsc_olap_object_relation.count=0 then
1408: return null;
1409: else
1410: return l_bsc_olap_object_relation(1).relation_object;
1411: end if;
1412: Exception when others then
1413: log_n('Exception in get_bt_current_period '||sqlerrm);
1414: raise;

Line 1438: given a bsc_olap_object_relation_tb and a relation type, get all the relation objects

1434: raise;
1435: End;
1436:
1437: /*
1438: given a bsc_olap_object_relation_tb and a relation type, get all the relation objects
1439: */
1440: procedure get_relation_object(
1441: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,
1442: p_relation_type varchar2,

Line 1441: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,

1437: /*
1438: given a bsc_olap_object_relation_tb and a relation type, get all the relation objects
1439: */
1440: procedure get_relation_object(
1441: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,
1442: p_relation_type varchar2,
1443: p_relation_object in out nocopy dbms_sql.varchar2_table
1444: ) is
1445: Begin

Line 1469: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

1465: /*
1466: for a dim, load the dimension_r structure
1467: */
1468: procedure get_dim_md(p_dim_name varchar2,p_dimension out nocopy bsc_aw_adapter_dim.dimension_r) is
1469: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1470: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1471: l_lg_index bsc_aw_utility.number_table; --level group
1472: l_rl_index bsc_aw_utility.number_table;--rec level
1473: l_lg varchar2(200);

Line 1470: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

1466: for a dim, load the dimension_r structure
1467: */
1468: procedure get_dim_md(p_dim_name varchar2,p_dimension out nocopy bsc_aw_adapter_dim.dimension_r) is
1469: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1470: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
1471: l_lg_index bsc_aw_utility.number_table; --level group
1472: l_rl_index bsc_aw_utility.number_table;--rec level
1473: l_lg varchar2(200);
1474: l_default_lg_name varchar2(200);

Line 1477: get_bsc_olap_object(null,null,p_dim_name,'dimension',l_oo);

1473: l_lg varchar2(200);
1474: l_default_lg_name varchar2(200);
1475: l_level_name_dim varchar2(300);
1476: Begin
1477: get_bsc_olap_object(null,null,p_dim_name,'dimension',l_oo);
1478: get_bsc_olap_object_relation(null,null,null,p_dim_name,'dimension',l_oor);
1479: l_default_lg_name:=bsc_aw_adapter_dim.get_default_lg_name;
1480: --dim properties
1481: p_dimension.dim_name:=p_dim_name;

Line 1478: get_bsc_olap_object_relation(null,null,null,p_dim_name,'dimension',l_oor);

1474: l_default_lg_name varchar2(200);
1475: l_level_name_dim varchar2(300);
1476: Begin
1477: get_bsc_olap_object(null,null,p_dim_name,'dimension',l_oo);
1478: get_bsc_olap_object_relation(null,null,null,p_dim_name,'dimension',l_oor);
1479: l_default_lg_name:=bsc_aw_adapter_dim.get_default_lg_name;
1480: --dim properties
1481: p_dimension.dim_name:=p_dim_name;
1482: for i in 1..l_oo.count loop

Line 1576: get_bsc_olap_object(null,'dimension',p_dimension.level_groups(i).levels(j).level_name,'dimension',l_oo);

1572: --get the snowflake info also
1573: for i in 1..p_dimension.level_groups.count loop
1574: for j in 1..p_dimension.level_groups(i).levels.count loop
1575: l_oo.delete;
1576: get_bsc_olap_object(null,'dimension',p_dimension.level_groups(i).levels(j).level_name,'dimension',l_oo);
1577: p_dimension.level_groups(i).levels(j).relation_name:=bsc_aw_utility.get_parameter_value(l_oo(1).property1,'relation name',',');
1578: p_dimension.level_groups(i).levels(j).level_name_dim:=bsc_aw_utility.get_parameter_value(l_oo(1).property1,'level name dim',',');
1579: end loop;
1580: end loop;

Line 1595: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

1591: raise;
1592: End;
1593:
1594: function get_upgrade_version return number is
1595: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1596: Begin
1597: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);
1598: if l_oo.count>0 then
1599: return to_number(l_oo(1).olap_object);

Line 1597: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);

1593:
1594: function get_upgrade_version return number is
1595: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1596: Begin
1597: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);
1598: if l_oo.count>0 then
1599: return to_number(l_oo(1).olap_object);
1600: else
1601: return 0;

Line 1609: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

1605: raise;
1606: End;
1607:
1608: procedure set_upgrade_version(p_version number) is
1609: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1610: Begin
1611: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);
1612: if l_oo.count>0 then
1613: update_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',

Line 1611: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);

1607:
1608: procedure set_upgrade_version(p_version number) is
1609: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1610: Begin
1611: bsc_aw_md_api.get_bsc_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',l_oo);
1612: if l_oo.count>0 then
1613: update_olap_object('bsc aw version','bsc aw version','bsc aw version','bsc aw version',
1614: null,null,'olap_object,olap_object_type',bsc_aw_utility.g_upgrade_version||'^bsc aw version');
1615: else /*first time*/