APPS.BSC_AW_CALENDAR dependencies on BSC_OLAP_OBJECT

Line 539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

535:
536: /*given a calendar name, it reads cal info from olap metadata. NOTE...not all info is read
537: */
538: procedure get_calendar(p_calendar_name varchar2,p_calendar out nocopy calendar_r) is
539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);

Line 540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

536: /*given a calendar name, it reads cal info from olap metadata. NOTE...not all info is read
537: */
538: procedure get_calendar(p_calendar_name varchar2,p_calendar out nocopy calendar_r) is
539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);
544: --

Line 542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);

538: procedure get_calendar(p_calendar_name varchar2,p_calendar out nocopy calendar_r) is
539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);
544: --
545: p_calendar.dim_name:=p_calendar_name;
546: for i in 1..l_oo.count loop

Line 543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);

539: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
540: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
541: Begin
542: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar_name,'dimension',l_oo);
543: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar_name,'dimension',l_oor);
544: --
545: p_calendar.dim_name:=p_calendar_name;
546: for i in 1..l_oo.count loop
547: if l_oo(i).object=p_calendar_name and l_oo(i).object_type='dimension' then

Line 760: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

756: */
757: function check_calendar_loaded(p_calendar number) return varchar2 is
758: --
759: l_dim varchar2(300);
760: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
761: Begin
762: l_dim:=get_calendar_name(p_calendar);
763: bsc_aw_md_api.get_bsc_olap_object(l_dim,'dimension',l_dim,'dimension',l_bsc_olap_object);
764: if l_bsc_olap_object(1).operation_flag is not null and l_bsc_olap_object(1).operation_flag='loaded' then

Line 763: bsc_aw_md_api.get_bsc_olap_object(l_dim,'dimension',l_dim,'dimension',l_bsc_olap_object);

759: l_dim varchar2(300);
760: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
761: Begin
762: l_dim:=get_calendar_name(p_calendar);
763: bsc_aw_md_api.get_bsc_olap_object(l_dim,'dimension',l_dim,'dimension',l_bsc_olap_object);
764: if l_bsc_olap_object(1).operation_flag is not null and l_bsc_olap_object(1).operation_flag='loaded' then
765: return 'Y';
766: else
767: return 'N';

Line 764: if l_bsc_olap_object(1).operation_flag is not null and l_bsc_olap_object(1).operation_flag='loaded' then

760: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
761: Begin
762: l_dim:=get_calendar_name(p_calendar);
763: bsc_aw_md_api.get_bsc_olap_object(l_dim,'dimension',l_dim,'dimension',l_bsc_olap_object);
764: if l_bsc_olap_object(1).operation_flag is not null and l_bsc_olap_object(1).operation_flag='loaded' then
765: return 'Y';
766: else
767: return 'N';
768: end if;

Line 803: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

799: l_max number;
800: --
801: l_pgm varchar2(300);
802: l_dim varchar2(300);
803: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
804: l_stmt varchar2(3000);
805: Begin
806: --
807: open c1;

Line 813: l_bsc_olap_object.delete;

809: close c1;
810: --
811: l_dim:=get_calendar_name(p_calendar);
812: --purge_calendar(p_calendar); there is no need to purge the calendar when loading it
813: l_bsc_olap_object.delete;
814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);
815: for i in 1..l_bsc_olap_object.count loop
816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then
817: l_pgm:=l_bsc_olap_object(i).object;

Line 814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);

810: --
811: l_dim:=get_calendar_name(p_calendar);
812: --purge_calendar(p_calendar); there is no need to purge the calendar when loading it
813: l_bsc_olap_object.delete;
814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);
815: for i in 1..l_bsc_olap_object.count loop
816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then
817: l_pgm:=l_bsc_olap_object(i).object;
818: exit;

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

811: l_dim:=get_calendar_name(p_calendar);
812: --purge_calendar(p_calendar); there is no need to purge the calendar when loading it
813: l_bsc_olap_object.delete;
814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);
815: for i in 1..l_bsc_olap_object.count loop
816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then
817: l_pgm:=l_bsc_olap_object(i).object;
818: exit;
819: end if;

Line 816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then

812: --purge_calendar(p_calendar); there is no need to purge the calendar when loading it
813: l_bsc_olap_object.delete;
814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);
815: for i in 1..l_bsc_olap_object.count loop
816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then
817: l_pgm:=l_bsc_olap_object(i).object;
818: exit;
819: end if;
820: end loop;

Line 817: l_pgm:=l_bsc_olap_object(i).object;

813: l_bsc_olap_object.delete;
814: bsc_aw_md_api.get_bsc_olap_object(null,'dml program',l_dim,'dimension',l_bsc_olap_object);
815: for i in 1..l_bsc_olap_object.count loop
816: if l_bsc_olap_object(i).olap_object_type='dml program initial load' then
817: l_pgm:=l_bsc_olap_object(i).object;
818: exit;
819: end if;
820: end loop;
821: l_stmt:='call '||l_pgm||'(''01 01 '||l_min||''',''01 01 '||l_max||''')';

Line 829: --update bsc_olap_object saying operation_flag='loaded'

825: bsc_aw_dbms_aw.execute(l_stmt);
826: if g_debug then
827: log('Finished '||bsc_aw_utility.get_time);
828: end if;
829: --update bsc_olap_object saying operation_flag='loaded'
830: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','loaded');
831: Exception when others then
832: log_n('Exception in load_calendar '||sqlerrm);
833: raise;

Line 855: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

851:
852: procedure purge_calendar(p_calendar number) is
853: --
854: l_dim varchar2(300);
855: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
856: Begin
857: l_dim:=get_calendar_name(p_calendar);
858: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_olap_object);
859: --

Line 858: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_olap_object);

854: l_dim varchar2(300);
855: l_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
856: Begin
857: l_dim:=get_calendar_name(p_calendar);
858: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_olap_object);
859: --
860: for i in 1..l_olap_object.count loop
861: if l_olap_object(i).object_type='aw time dim level' then
862: bsc_aw_dbms_aw.execute('maintain '||l_olap_object(i).object||' delete all');

Line 871: --update bsc_olap_object saying operation_flag='purged'

867: if l_olap_object(i).object_type='dimension level' then
868: bsc_aw_dbms_aw.execute('maintain '||l_olap_object(i).object||' delete all');
869: end if;
870: end loop;
871: --update bsc_olap_object saying operation_flag='purged'
872: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','purged');
873: Exception when others then
874: log_n('Exception in purge_calendar '||sqlerrm);
875: raise;

Line 924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

920: check to see if the olap metadata and the current calendar metadata are in sync
921: right now, see if there are new periodicities or dropped periodicities
922: */
923: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2) is
924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);

Line 925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

921: right now, see if there are new periodicities or dropped periodicities
922: */
923: procedure correct_calendar(p_calendar calendar_r,p_recreate out nocopy varchar2) is
924: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
925: l_oor bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
926: l_periodicities dbms_sql.varchar2_table;
927: l_olap_periodicities dbms_sql.varchar2_table;
928: l_level_name_dim varchar(200);
929: l_olap_periodicity_dim dbms_sql.varchar2_table;

Line 933: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar.dim_name,'dimension',l_oo);

929: l_olap_periodicity_dim dbms_sql.varchar2_table;
930: l_pc parent_child_tb;
931: --
932: Begin
933: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar.dim_name,'dimension',l_oo);
934: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar.dim_name,'dimension',l_oor);
935: if l_oo.count=0 then
936: return;
937: end if;

Line 934: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar.dim_name,'dimension',l_oor);

930: l_pc parent_child_tb;
931: --
932: Begin
933: bsc_aw_md_api.get_bsc_olap_object(null,null,p_calendar.dim_name,'dimension',l_oo);
934: bsc_aw_md_api.get_bsc_olap_object_relation(null,null,null,p_calendar.dim_name,'dimension',l_oor);
935: if l_oo.count=0 then
936: return;
937: end if;
938: for i in 1..p_calendar.periodicity.count loop

Line 1018: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

1014:
1015: --p_object_type is null or all or dml program
1016: procedure drop_calendar_objects(p_calendar_name varchar2,p_object_type varchar2,p_affected_kpi out nocopy dbms_sql.varchar2_table) is
1017: --
1018: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1019: l_flag dbms_sql.varchar2_table;
1020: Begin
1021: --first drop all dependent kpi ... if needed
1022: if p_object_type is null or p_object_type='all' then

Line 1028: bsc_aw_md_api.get_bsc_olap_object(null,p_object_type,p_calendar_name,'dimension',l_bsc_olap_object);

1024: for i in 1..p_affected_kpi.count loop
1025: bsc_aw_adapter_kpi.drop_kpi_objects(p_affected_kpi(i));
1026: end loop;
1027: end if;
1028: bsc_aw_md_api.get_bsc_olap_object(null,p_object_type,p_calendar_name,'dimension',l_bsc_olap_object);
1029: --order : drop all relations, variables etc, drop concat dim, then all others
1030: for i in 1..l_bsc_olap_object.count loop
1031: l_flag(i):='N';
1032: end loop;

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

1026: end loop;
1027: end if;
1028: bsc_aw_md_api.get_bsc_olap_object(null,p_object_type,p_calendar_name,'dimension',l_bsc_olap_object);
1029: --order : drop all relations, variables etc, drop concat dim, then all others
1030: for i in 1..l_bsc_olap_object.count loop
1031: l_flag(i):='N';
1032: end loop;
1033: if l_bsc_olap_object.count>0 then
1034: for i in 1..l_bsc_olap_object.count loop

Line 1033: if l_bsc_olap_object.count>0 then

1029: --order : drop all relations, variables etc, drop concat dim, then all others
1030: for i in 1..l_bsc_olap_object.count loop
1031: l_flag(i):='N';
1032: end loop;
1033: if l_bsc_olap_object.count>0 then
1034: for i in 1..l_bsc_olap_object.count loop
1035: if l_flag(i)='N' and (l_bsc_olap_object(i).olap_object_type ='relation' or l_bsc_olap_object(i).olap_object_type ='variable') then
1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1037: l_flag(i):='Y';

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

1030: for i in 1..l_bsc_olap_object.count loop
1031: l_flag(i):='N';
1032: end loop;
1033: if l_bsc_olap_object.count>0 then
1034: for i in 1..l_bsc_olap_object.count loop
1035: if l_flag(i)='N' and (l_bsc_olap_object(i).olap_object_type ='relation' or l_bsc_olap_object(i).olap_object_type ='variable') then
1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1037: l_flag(i):='Y';
1038: end if;

Line 1035: if l_flag(i)='N' and (l_bsc_olap_object(i).olap_object_type ='relation' or l_bsc_olap_object(i).olap_object_type ='variable') then

1031: l_flag(i):='N';
1032: end loop;
1033: if l_bsc_olap_object.count>0 then
1034: for i in 1..l_bsc_olap_object.count loop
1035: if l_flag(i)='N' and (l_bsc_olap_object(i).olap_object_type ='relation' or l_bsc_olap_object(i).olap_object_type ='variable') then
1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1037: l_flag(i):='Y';
1038: end if;
1039: end loop;

Line 1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

1032: end loop;
1033: if l_bsc_olap_object.count>0 then
1034: for i in 1..l_bsc_olap_object.count loop
1035: if l_flag(i)='N' and (l_bsc_olap_object(i).olap_object_type ='relation' or l_bsc_olap_object(i).olap_object_type ='variable') then
1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1037: l_flag(i):='Y';
1038: end if;
1039: end loop;
1040: for i in 1..l_bsc_olap_object.count loop

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

1036: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1037: l_flag(i):='Y';
1038: end if;
1039: end loop;
1040: for i in 1..l_bsc_olap_object.count loop
1041: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='concat dimension' then
1042: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1043: l_flag(i):='Y';
1044: end if;

Line 1041: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='concat dimension' then

1037: l_flag(i):='Y';
1038: end if;
1039: end loop;
1040: for i in 1..l_bsc_olap_object.count loop
1041: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='concat dimension' then
1042: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1043: l_flag(i):='Y';
1044: end if;
1045: end loop;

Line 1042: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

1038: end if;
1039: end loop;
1040: for i in 1..l_bsc_olap_object.count loop
1041: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='concat dimension' then
1042: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1043: l_flag(i):='Y';
1044: end if;
1045: end loop;
1046: for i in 1..l_bsc_olap_object.count loop

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

1042: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1043: l_flag(i):='Y';
1044: end if;
1045: end loop;
1046: for i in 1..l_bsc_olap_object.count loop
1047: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='dimension' then
1048: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1049: l_flag(i):='Y';
1050: end if;

Line 1047: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='dimension' then

1043: l_flag(i):='Y';
1044: end if;
1045: end loop;
1046: for i in 1..l_bsc_olap_object.count loop
1047: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='dimension' then
1048: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1049: l_flag(i):='Y';
1050: end if;
1051: end loop;

Line 1048: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

1044: end if;
1045: end loop;
1046: for i in 1..l_bsc_olap_object.count loop
1047: if l_flag(i)='N' and l_bsc_olap_object(i).olap_object_type='dimension' then
1048: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1049: l_flag(i):='Y';
1050: end if;
1051: end loop;
1052: --all other objects

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

1049: l_flag(i):='Y';
1050: end if;
1051: end loop;
1052: --all other objects
1053: for i in 1..l_bsc_olap_object.count loop
1054: if l_flag(i)='N' then
1055: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1056: l_flag(i):='Y';
1057: end if;

Line 1055: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);

1051: end loop;
1052: --all other objects
1053: for i in 1..l_bsc_olap_object.count loop
1054: if l_flag(i)='N' then
1055: bsc_aw_utility.delete_aw_object(l_bsc_olap_object(i).olap_object);
1056: l_flag(i):='Y';
1057: end if;
1058: end loop;
1059: end if;

Line 1295: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

1291: we cannot update a relation before a dim. so when we get locks, we first get dim, then relations, then variables
1292: */
1293: procedure get_calendar_objects_to_lock(p_calendar number,p_lock_objects out nocopy dbms_sql.varchar2_table) is
1294: l_dim varchar2(300);
1295: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1296: l_objects dbms_sql.varchar2_table;
1297: Begin
1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);

Line 1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);

1295: l_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
1296: l_objects dbms_sql.varchar2_table;
1297: Begin
1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);
1300: for i in 1..l_bsc_olap_object.count loop
1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;

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

1296: l_objects dbms_sql.varchar2_table;
1297: Begin
1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);
1300: for i in 1..l_bsc_olap_object.count loop
1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;
1304: end loop;

Line 1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then

1297: Begin
1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);
1300: for i in 1..l_bsc_olap_object.count loop
1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;
1304: end loop;
1305: for i in 1..l_bsc_olap_object.count loop

Line 1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;

1298: l_dim:=get_calendar_name(p_calendar);
1299: bsc_aw_md_api.get_bsc_olap_object(null,null,l_dim,'dimension',l_bsc_olap_object);
1300: for i in 1..l_bsc_olap_object.count loop
1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;
1304: end loop;
1305: for i in 1..l_bsc_olap_object.count loop
1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then

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

1301: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='dimension' then
1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;
1304: end loop;
1305: for i in 1..l_bsc_olap_object.count loop
1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then
1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1308: end if;
1309: end loop;

Line 1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then

1302: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1303: end if;
1304: end loop;
1305: for i in 1..l_bsc_olap_object.count loop
1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then
1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1308: end if;
1309: end loop;
1310: for i in 1..l_bsc_olap_object.count loop

Line 1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;

1303: end if;
1304: end loop;
1305: for i in 1..l_bsc_olap_object.count loop
1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then
1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1308: end if;
1309: end loop;
1310: for i in 1..l_bsc_olap_object.count loop
1311: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='variable' then

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

1306: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='relation' then
1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1308: end if;
1309: end loop;
1310: for i in 1..l_bsc_olap_object.count loop
1311: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='variable' then
1312: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1313: end if;
1314: end loop;

Line 1311: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='variable' then

1307: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1308: end if;
1309: end loop;
1310: for i in 1..l_bsc_olap_object.count loop
1311: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='variable' then
1312: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1313: end if;
1314: end loop;
1315: --there are no limit cubes here like dim.?

Line 1312: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;

1308: end if;
1309: end loop;
1310: for i in 1..l_bsc_olap_object.count loop
1311: if l_bsc_olap_object(i).olap_object_type is not null and l_bsc_olap_object(i).olap_object_type='variable' then
1312: l_objects(l_objects.count+1):=l_bsc_olap_object(i).olap_object;
1313: end if;
1314: end loop;
1315: --there are no limit cubes here like dim.?
1316: --

Line 1373: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;

1369: raise;
1370: End;
1371:
1372: procedure reimplement_all_calendars is
1373: l_oo bsc_aw_md_wrapper.bsc_olap_object_tb;
1374: l_calendar dbms_sql.number_table;
1375: l_year number;
1376: l_cal_id number;
1377: Begin

Line 1378: bsc_aw_md_api.get_bsc_olap_object(null,'dimension',null,'dimension',l_oo);

1374: l_calendar dbms_sql.number_table;
1375: l_year number;
1376: l_cal_id number;
1377: Begin
1378: bsc_aw_md_api.get_bsc_olap_object(null,'dimension',null,'dimension',l_oo);
1379: for i in 1..l_oo.count loop
1380: if instr(l_oo(i).property1,'dimension type=time')>0 then
1381: /*5017796. see if this calendar is still a valid implemented calendar in BSC */
1382: l_cal_id:=null;