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_WRAPPER

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 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 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 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 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 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 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 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 1435: bsc_aw_md_wrapper.init_all;

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;
1439: end if;