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_CALENDAR dependencies on BSC_AW_MD_API

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 714: bsc_aw_md_api.delete_calendar(p_calendar);

710: End;
711:
712: procedure create_calendar_metadata(p_calendar calendar_r) is
713: Begin
714: bsc_aw_md_api.delete_calendar(p_calendar);
715: bsc_aw_md_api.create_calendar(p_calendar);
716: Exception when others then
717: log_n('Exception in create_calendar_metadata '||sqlerrm);
718: raise;

Line 715: bsc_aw_md_api.create_calendar(p_calendar);

711:
712: procedure create_calendar_metadata(p_calendar calendar_r) is
713: Begin
714: bsc_aw_md_api.delete_calendar(p_calendar);
715: bsc_aw_md_api.create_calendar(p_calendar);
716: Exception when others then
717: log_n('Exception in create_calendar_metadata '||sqlerrm);
718: raise;
719: End;

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 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 830: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','loaded');

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;
834: End;

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 872: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','purged');

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;
876: End;

Line 884: if bsc_aw_md_api.is_dim_present(p_calendar.dim_name) then

880: p_recreate out nocopy varchar2,
881: p_affected_kpi out nocopy dbms_sql.varchar2_table) is
882: --
883: Begin
884: if bsc_aw_md_api.is_dim_present(p_calendar.dim_name) then
885: --check to see if the calendar matches the calendar in the olap metadata
886: if bsc_aw_utility.get_parameter_value('RECREATE CALENDAR')='Y' then
887: if g_debug then
888: log('RECREATE CALENDAR specified. Drop and recreate');

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 1023: bsc_aw_md_api.get_kpi_for_dim(p_calendar_name,p_affected_kpi);

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
1023: bsc_aw_md_api.get_kpi_for_dim(p_calendar_name,p_affected_kpi);
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;

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 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 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;

Line 1409: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','empty');

1405: log('Reimplement calendar '||p_calendar_id||bsc_aw_utility.get_time);
1406: end if;
1407: create_calendar(p_calendar_id,l_affected_kpi);
1408: l_dim:=get_calendar_name(p_calendar_id);
1409: bsc_aw_md_api.update_olap_object(l_dim,'dimension',l_dim,'dimension',null,null,'operation_flag','empty');
1410: Exception when others then
1411: log_n('Exception in reimplement_all_calendars '||sqlerrm);
1412: raise;
1413: End;

Line 1434: bsc_aw_md_api.init_all;

1430: g_debug:=false;
1431: end if;
1432: bsc_aw_utility.init_all(g_debug);
1433: bsc_aw_dbms_aw.init_all;
1434: bsc_aw_md_api.init_all;
1435: bsc_aw_md_wrapper.init_all;
1436: bsc_aw_bsc_metadata.init_all;
1437: bsc_metadata.init_all;
1438: bsc_aw_management.init_all;