APPS.BSC_AW_MD_API dependencies on BSC_AW_MD_WRAPPER

Line 37: bsc_aw_md_wrapper.mark_kpi_recreate(p_kpi);

33: End;
34:
35: procedure mark_kpi_recreate(p_kpi varchar2) is
36: Begin
37: bsc_aw_md_wrapper.mark_kpi_recreate(p_kpi);
38: Exception when others then
39: log_n('Exception in mark_kpi_recreate '||sqlerrm);
40: raise;
41: End;

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 66: bsc_aw_md_wrapper.drop_dim(p_dim_name);

62:
63: procedure drop_dim(p_dim_name varchar2) is
64: Begin
65: clear_all_cache;
66: bsc_aw_md_wrapper.drop_dim(p_dim_name);
67: clear_all_cache;
68: Exception when others then
69: log_n('Exception in drop_dim '||sqlerrm);
70: 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 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 146: bsc_aw_md_wrapper.dimension_r

142: End;
143:
144: /*
145: here we convert from one format to the other, from bsc_aw_adapter_dim.dimension_r to
146: bsc_aw_md_wrapper.dimension_r
147: */
148: procedure create_dim_objects(
149: p_dimension bsc_aw_adapter_dim.dimension_r
150: ) is

Line 152: bsc_aw_md_wrapper.create_dim(p_dimension);

148: procedure create_dim_objects(
149: p_dimension bsc_aw_adapter_dim.dimension_r
150: ) is
151: Begin
152: bsc_aw_md_wrapper.create_dim(p_dimension);
153: clear_all_cache;
154: Exception when others then
155: log_n('Exception in create_dim_objects '||sqlerrm);
156: raise;

Line 184: bsc_aw_md_wrapper.drop_kpi(p_kpi);

180:
181: procedure drop_kpi(p_kpi varchar2) is
182: Begin
183: clear_all_cache;
184: bsc_aw_md_wrapper.drop_kpi(p_kpi);
185: clear_all_cache;
186: Exception when others then
187: log_n('Exception in drop_kpi '||sqlerrm);
188: raise;

Line 229: bsc_aw_md_wrapper.create_calendar(p_calendar);

225: End;
226:
227: procedure create_calendar(p_calendar bsc_aw_calendar.calendar_r) is
228: Begin
229: bsc_aw_md_wrapper.create_calendar(p_calendar);
230: clear_all_cache;
231: Exception when others then
232: log_n('Exception in create_calendar '||sqlerrm);
233: raise;

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 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 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 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 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 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 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 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 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 482: bsc_aw_md_wrapper.create_kpi(p_kpi);

478: End;
479:
480: procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r) is
481: Begin
482: bsc_aw_md_wrapper.create_kpi(p_kpi);
483: clear_all_cache;
484: Exception when others then
485: log_n('Exception in create_kpi '||sqlerrm);
486: raise;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 1207: bsc_aw_md_wrapper.create_workspace(p_name);

1203:
1204: -----------------------------
1205: procedure create_workspace(p_name varchar2) is
1206: Begin
1207: bsc_aw_md_wrapper.create_workspace(p_name);
1208: Exception when others then
1209: log_n('Exception in create_workspace '||sqlerrm);
1210: raise;
1211: End;

Line 1216: bsc_aw_md_wrapper.drop_workspace(p_name);

1212:
1213: procedure drop_workspace(p_name varchar2) is
1214: Begin
1215: clear_all_cache;
1216: bsc_aw_md_wrapper.drop_workspace(p_name);
1217: clear_all_cache;
1218: Exception when others then
1219: log_n('Exception in create_workspace '||sqlerrm);
1220: raise;

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 1270: bsc_aw_md_wrapper.update_olap_object(p_object,p_object_type,p_parent_object,p_parent_object_type,

1266: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);
1267: bsc_aw_utility.parse_parameter_values(p_match_values,',',l_match_values);
1268: bsc_aw_utility.parse_parameter_values(p_set_columns,',',l_set_columns);
1269: bsc_aw_utility.parse_parameter_values(p_set_values,'^',l_set_values);
1270: bsc_aw_md_wrapper.update_olap_object(p_object,p_object_type,p_parent_object,p_parent_object_type,
1271: l_match_columns,l_match_values,l_set_columns,l_set_values);
1272: --invalidate cache
1273: clear_all_cache;
1274: Exception when others then

Line 1311: bsc_aw_md_wrapper.update_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,

1307: bsc_aw_utility.parse_parameter_values(p_match_columns,',',l_match_columns);
1308: bsc_aw_utility.parse_parameter_values(p_match_values,',',l_match_values);
1309: bsc_aw_utility.parse_parameter_values(p_set_columns,',',l_set_columns);
1310: bsc_aw_utility.parse_parameter_values(p_set_values,'^',l_set_values);
1311: bsc_aw_md_wrapper.update_olap_object_relation(p_object,p_object_type,p_relation_type,p_parent_object,p_parent_object_type,
1312: l_match_columns,l_match_values,l_set_columns,l_set_values);
1313: clear_all_cache;
1314: Exception when others then
1315: log_n('Exception in update_olap_object_relation '||sqlerrm);

Line 1330: bsc_aw_md_wrapper.insert_olap_object(p_object,p_object_type,p_olap_object,p_olap_object_type,p_parent_object,p_parent_object_type,p_property1);

1326: p_property1 varchar2
1327: ) is
1328: Begin
1329: /*insert has no cache invalidation */
1330: bsc_aw_md_wrapper.insert_olap_object(p_object,p_object_type,p_olap_object,p_olap_object_type,p_parent_object,p_parent_object_type,p_property1);
1331: Exception when others then
1332: log_n('Exception in insert_olap_object '||sqlerrm);
1333: raise;
1334: End;

Line 1348: bsc_aw_md_wrapper.insert_olap_object_relation(p_object,p_object_type,p_relation_object,p_relation_object_type,p_relation_type,

1344: p_property1 varchar2
1345: ) is
1346: Begin
1347: /*insert has no cache invalidation */
1348: bsc_aw_md_wrapper.insert_olap_object_relation(p_object,p_object_type,p_relation_object,p_relation_object_type,p_relation_type,
1349: p_parent_object,p_parent_object_type,p_property1);
1350: Exception when others then
1351: log_n('Exception in insert_olap_object_relation '||sqlerrm);
1352: raise;

Line 1367: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table','0','change vector','base table change vector',

1363: l_cv_value number;
1364: Begin
1365: l_cv_value:=get_bt_change_vector(p_base_table);
1366: if l_cv_value is null then --create entry
1367: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table','0','change vector','base table change vector',
1368: p_base_table,'base table',null);
1369: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table',null,'current period','base table current period',
1370: p_base_table,'base table',null);
1371: end if;

Line 1369: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table',null,'current period','base table current period',

1365: l_cv_value:=get_bt_change_vector(p_base_table);
1366: if l_cv_value is null then --create entry
1367: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table','0','change vector','base table change vector',
1368: p_base_table,'base table',null);
1369: bsc_aw_md_wrapper.insert_olap_object_relation(p_base_table,'base table',null,'current period','base table current period',
1370: p_base_table,'base table',null);
1371: end if;
1372: clear_all_cache;
1373: Exception when others then

Line 1381: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table change vector',null,null,p_base_table,'base table');

1377:
1378: procedure drop_bt_change_vector(p_base_table varchar2) is
1379: Begin
1380: clear_all_cache;
1381: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table change vector',null,null,p_base_table,'base table');
1382: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table current period',null,null,p_base_table,'base table');
1383: clear_all_cache;
1384: Exception when others then
1385: log_n('Exception in drop_bt_change_vector '||sqlerrm);

Line 1382: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table current period',null,null,p_base_table,'base table');

1378: procedure drop_bt_change_vector(p_base_table varchar2) is
1379: Begin
1380: clear_all_cache;
1381: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table change vector',null,null,p_base_table,'base table');
1382: bsc_aw_md_wrapper.delete_olap_object_relation(p_base_table,'base table','base table current period',null,null,p_base_table,'base table');
1383: clear_all_cache;
1384: Exception when others then
1385: log_n('Exception in drop_bt_change_vector '||sqlerrm);
1386: raise;

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 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 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 1588: bsc_aw_md_wrapper.analyze_md_tables;

1584: End;
1585:
1586: procedure analyze_md_tables is
1587: Begin
1588: bsc_aw_md_wrapper.analyze_md_tables;
1589: Exception when others then
1590: log_n('Exception in analyze_md_tables '||sqlerrm);
1591: raise;
1592: End;

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 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 1627: bsc_aw_md_wrapper.set_context('AW');

1623:
1624: -----------------------------
1625: procedure init_all is
1626: Begin
1627: bsc_aw_md_wrapper.set_context('AW');
1628: g_debug:=bsc_aw_utility.g_debug;
1629: Exception when others then
1630: null;
1631: End;